Hi!
We are trying to achieve a stock update for all of our products but we're facing some problems.
Currently we sell trading card games booster packs and boxes but right now we sell them as "single" booster packs 1 by 1.
Since we want to sell this online, the current way to do it is selling the whole box online and people buy it by the full price.
This however means we need to have two different products.
Right now we have setup two products, lets say:
Box of booster packs (contains 24 booster packs) - current stock 4.
Booster packs (1 single pack) - current stock 96, since we have 4 boxes of 24.
A user makes a purchase in the store physically, we have to open 1 box to provide him the packs, so we sold 1 booster pack.
Now we have 95 booster packs, but we dont have 4 boxes, we have now 3 boxes, since we had to open it to sell a single booster.
After that another user makes a purchase online of 1 box of booster packs, he pays it and creates the purchase on the web.
Now we have 2 boxes, but in count of packs we have 71 since we substracted the 24 packs from the box that we have sold online.
This is a hell to do it manually since we should manage two different stocks for "somewhat" the same product.
For extra info, we are currently using Odoo Online which recently upgraded to Odoo 18.
How could we find a solution for our problem?