Hi,
My name is Florin and i am a database applications developer.
I've read the project description several times and came up with a simple and user friendly solution for your application that will do the following:
- manage customers (optional, but could be nice to have if, in the future, you would like to add a discount feature for regular customers);
- manage products (add, search, update, remove-only in specific cases);
- manage orders (add, update, remove-the order will not be deleted, just not taken into consideration in reports);
- display reports (many orders can be added along with the requested ones, like: best sold product in a date range, etc..).
- optional - i can add an user management module and a login screen for the app.
I've built a couple of projects like this in the past, i have one running in my store in Romania, so:
- orders starting from #1 each day will not be a problem, this is possible;
- products: the system will know which ones are sold per QTY and which per KG;
- there will be NO direct table editing as this not recommended, the application will provide a way for record update from the interface.
I would like to send a demo to you, if that's ok with you, just let me know, and maybe we can talk further. Also, i can adjust my bid if it seems high.
Thank you for your time.
Florin