I would like a database created. At the moment I am using a simple excel spreadsheet but need something more automated.
I receive a data dump whenever requested of all our products from our wholesaler that tells me how many units are left.
I input this in my excel spreadsheet and it calculates how many were sold from last time I got the information etc.
So ideally I would like this automated so I don't have to create new formulas all the time and just add the new totals and the figures are automatically calculated for me, with an option also to choose reports per time duration specified.
I will need to also be able to add new products when needed and change the order to the wholesalers data dump list order.
This can be an on going project for the person chosen to do the work, as I am sure I would whant more functions added as time goes by.