Databas with excel import
- or -
Post a project like this3444
$$
- Posted:
- Proposals: 8
- Remote
- #615632
- Awarded
Description
Experience Level: Intermediate
General information for the business: stock control for bars.
Database management system (DBMS): MySQL
Description of requirements/functionality: Hi looking in to setting up an database to handle my stock control and sale if it is not to expensive.
What I need.
- Data base that can import from excel reports and calculate sales in other units
- incoming stock ( will be filed in staff based on delivery notes)
- Filed for outgoing stock ( stock that has been moved away will be filed in by staff )
- calculate what the stock level is : Sales - incoming stock - outgoing stock
The sales numbers from the excel sheets are coming in different unit compered to order units expl
Sales 1 pint stock and order unit is in keg 50 L =88 pints
need to be able to change
Have attached expl of excel sheets from our till system that needs to be imported.
C D E F
are the columns that the database need to work with
Web based system
I am sure u have Q so just let me know
Cheers
Mike
Extra notes:
Database management system (DBMS): MySQL
Description of requirements/functionality: Hi looking in to setting up an database to handle my stock control and sale if it is not to expensive.
What I need.
- Data base that can import from excel reports and calculate sales in other units
- incoming stock ( will be filed in staff based on delivery notes)
- Filed for outgoing stock ( stock that has been moved away will be filed in by staff )
- calculate what the stock level is : Sales - incoming stock - outgoing stock
The sales numbers from the excel sheets are coming in different unit compered to order units expl
Sales 1 pint stock and order unit is in keg 50 L =88 pints
need to be able to change
Have attached expl of excel sheets from our till system that needs to be imported.
C D E F
are the columns that the database need to work with
Web based system
I am sure u have Q so just let me know
Cheers
Mike
Extra notes:
Mike C.
100% (8)Projects Completed
11
Freelancers worked with
11
Projects awarded
40%
Last project
7 Mar 2016
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