Dear sir/madam
I am willing to help you with your problem. I am willing to develop for you a Microsoft Access database, which will be accessable through windows only (for the moment and if you like we can later on develop it as a web solution). We will add it to your google drive so you can access it wherever you are.
As i saw in your description, we need to create a few tables:
- table 1 will be for the products (with ingredient)
- rhe other table will be used to tract the sales (through searches we will provide the profits and the costs)
- one table will be created for tracking the inventory and sales.
Overall we will need to follow two things (money, income-cost-profit) and ingredients (stocks, in, out, sales).
we will develop form to access adecvate reports, which later on will be export and be accessed through google sheets.
Waiting for your response so we can further discuss this project details.
Best regards Petar Pejkovski