Online Database
- or -
Post a project like this£150(approx. $187)
- Posted:
- Proposals: 7
- Remote
- #731799
- Expired
Responsive Website | | Flash | Logo Designing | Wordpress | Magento | PHP | MySql | ASP.net | MsSql | Jquery | Ajax | CSS | HTML5 | AWS
Mumbai
ASP.Net Developer, Graphics, Animations, Singer, Songwriter and Music Composer
Khobar
Researcher, Data base building, Lead generation, E Mail database, Data Entry, Research base writing, Market Research,
Bay Minette
138824256409337085550406650995742383837804
Description
Experience Level: Expert
Estimated project duration: 1 - 2 weeks
General information for the business: We Sell On-line and to other companies
Description of requirements/functionality: i need a database which we can access from a website. we drop ship our products on behalf of up to 10 clients. each client have their own customers.
we already use a software (not ours) which is called commerce interface platform. this is with one client and they send us all their customer details through that. they have given us access with username and password to access and download the orders so we can ship them. i want something similar to this.
each time i sign a contract with a client for a product i want to enter this in the databse software and add the products for that contract (example; I sign a contract001 with client001, contract001 has products, Product01, Product02 and Product03 and add Sell price which my client sells for but i also need Cost price which i need back from my client after giving them commission for each product with sku code for the product which i will use from my existing product list).
when ever i receive an order for this contract i want to add the customer order details that my client sends me so this will include (customer name, address, postcode, tel, email, voucher code, product, courier, tracking, notes) please note a voucher code can only be used once to place an order so i don't want the system to accept a duplicate voucher code.
i want to be able to add details in individually as well as upload a csv file for my new orders.
so the above information is used to add new orders. i also want to use the same information in case a customer decides to return the item to us for a refund so i need to generate a report to see how many refunds were processed for contract001
I need the databse to perofrm a seach on all customer table and order details including client and contract etc.
Financial side of the database
I also want the database to show me the total Sale figure and Cost figure (both these are important so we can invoice our clients)
This part is important. According to the above information were we can see the cost we will invoice our client from our own existing system but i want to enter the figure in this database and i want it to show me how much i have invoiced them for and how much is the outstanding balance that they owe me) apart from this i want to add the money that i have received from my client so basically i can keep track how much payment they have made to us for each and every contract and overall as well for each client and all clients combined)
I think i have provided the full information. If there is anything missing i can provide this. Our company logo and other details can be provided later.
CMS and Admin requirements: I already have a domain www.buyerempire.com so we can use this.
the online databse will need a username and password to login and i should have all credentials.
Extra notes: need this done asap. price negotiable depending on the experience. i welcome any suggestions that we can use to improve the system. i want to trial test it before i pay you. i would need to see some examples of anything similar work.
Description of requirements/functionality: i need a database which we can access from a website. we drop ship our products on behalf of up to 10 clients. each client have their own customers.
we already use a software (not ours) which is called commerce interface platform. this is with one client and they send us all their customer details through that. they have given us access with username and password to access and download the orders so we can ship them. i want something similar to this.
each time i sign a contract with a client for a product i want to enter this in the databse software and add the products for that contract (example; I sign a contract001 with client001, contract001 has products, Product01, Product02 and Product03 and add Sell price which my client sells for but i also need Cost price which i need back from my client after giving them commission for each product with sku code for the product which i will use from my existing product list).
when ever i receive an order for this contract i want to add the customer order details that my client sends me so this will include (customer name, address, postcode, tel, email, voucher code, product, courier, tracking, notes) please note a voucher code can only be used once to place an order so i don't want the system to accept a duplicate voucher code.
i want to be able to add details in individually as well as upload a csv file for my new orders.
so the above information is used to add new orders. i also want to use the same information in case a customer decides to return the item to us for a refund so i need to generate a report to see how many refunds were processed for contract001
I need the databse to perofrm a seach on all customer table and order details including client and contract etc.
Financial side of the database
I also want the database to show me the total Sale figure and Cost figure (both these are important so we can invoice our clients)
This part is important. According to the above information were we can see the cost we will invoice our client from our own existing system but i want to enter the figure in this database and i want it to show me how much i have invoiced them for and how much is the outstanding balance that they owe me) apart from this i want to add the money that i have received from my client so basically i can keep track how much payment they have made to us for each and every contract and overall as well for each client and all clients combined)
I think i have provided the full information. If there is anything missing i can provide this. Our company logo and other details can be provided later.
CMS and Admin requirements: I already have a domain www.buyerempire.com so we can use this.
the online databse will need a username and password to login and i should have all credentials.
Extra notes: need this done asap. price negotiable depending on the experience. i welcome any suggestions that we can use to improve the system. i want to trial test it before i pay you. i would need to see some examples of anything similar work.
Muhammad R.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
20%
Last project
18 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies