Inventory management app

Hi fellow bubblers, i am building an accountancy app and i am facing this problem. How do i make sure any time an article is sold its quantity in the stocks reduces proportionately? :sweat_smile:

Hi there,

You need to keep track of the quantity within your database, I’m sure you figured that part out. After that you will need to find a way to add or substract whenever a change happens, i.e. a someone buys from the particular stock.

Now we know that, we need to start adding workflows. Your first workflow would be something like ‘Make changes to stock’ 'This stock’s amount - 1 with the conditional statement of ‘only when’ 'current user has bought the stock equals to ‘yes’. Same workflow would apply vica versa to adding quantity back to the database.

Hope this makes sense, if not I would recommend creating a simple todo list where you can add and remove tasks from the basket. This will help you on your development journey.

p.s. NICAA template might be useful for you to get started.

Good luck!

1 Like

I created an example inventory (super simple) app that shows this.

2 Likes

Thanks very very much!

1 Like

Hi Vega,
Is it possible you could you also give me permission to view this example inventory app?

2 Likes

Hi! @vega.andrew
I am looking to make a similar application, communicating from convenience store POS systems to Bubble app to help monitor inventory for my clients in between our physical inventory counts (where we would correct any discrepencies)

May i have access to the app above?