Good morning everyone:
I need to create an app that allows to manage inventory of a product (in my case they are appliances). Here’s how I have set up my database:
This first picture is the data type “Appliance Catalogue” which saves the information of the different types of appliances that I am selling.
This second picture is the data type “Appliances inventory” which saves every specific appliance from every type of appliances that I have to sell.
To give you an example, imagine that I have a fridge type A in the appliance catalogue database and that I display that catalogue in the catalogue page for users to buy it. But in fact, I have 3 fridges type A that I can sell, which are stores in the appliance inventory database. I need to keep track of where every item is so I know if it is sent etc. Every item in the appliance inventory database has associated an item in the appliance catalogue database. So appliance catalogue to appliance inventory is a 1-many relationship and appliance inventory to appliance catalogue is a 1-1 relationship.
Here is my catalogue page:
From there, a user selects with the dropdown in the right upper corner how many of each type he wants to buy and by clicking in a confirm button the workflow associates the quantity selected with the amount of appliance inventory of each type and associates to each appliance inventory item the user. Again, an example. If I select X amount of fridge A, the workflow should look in the inventory database for appliance with the same name as the appliance catalogue and associate X amount of them to the current user.
I guess this is a simple stock managing feature and that every ecommerce must to do it this way.
Cannot wait to hearing your responses