Перейти к содержимому
Меню
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Этот вопрос был отмечен
1 Ответить
542 Представления

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?

Аватар
Отменить
Лучший ответ

Step-by-Step Implementation

Step 1: Create a Single Product with Variants

  1. Create a Product: Create a single product for "Booster Packs" and set it as a "Storable Product".
  2. Add Variants:
    • Create a variant for "Single Booster Pack".
    • Create a variant for "Box of Booster Packs".

Step 2: Set Up a Bill of Materials (BOM)

  1. Create a BOM:
    • Go to Manufacturing > Products > Bill of Materials.
    • Create a new BOM for the "Box of Booster Packs".
    • Set the product as "Box of Booster Packs" and add 24 units of "Single Booster Pack" as components.
  2. Configure the BOM:
    • Ensure that the BOM is set to "Manufacture" when you need to create a box from individual packs.
    • This will allow you to track the relationship between the box and the individual packs.

Step 3: Automate Stock Adjustments

  1. Use Odoo's Inventory Adjustments:
    • When you sell a box, Odoo will automatically deduct 24 booster packs from inventory based on the BOM.
    • When you sell a single booster pack, you can either manually adjust the stock or automate this process.
  2. Custom Automation (Optional):
    • If you want to automate the stock adjustment further, consider using Odoo Studio or custom development to create automated actions that adjust stock levels based on sales.

Step 4: Manage Sales Orders

  1. Sales Orders:
    • When a customer purchases a box, Odoo will automatically reduce the stock of booster packs by 24.
    • When a customer purchases a single booster pack, it will reduce the stock of that variant accordingly.
  2. Reporting:
    • Use Odoo's reporting features to track sales and inventory levels for both variants.

Additional Considerations

  • Inventory Valuation: Ensure that your inventory valuation method is set correctly (FIFO, LIFO, etc.) to reflect the true cost of goods sold.
  • Stock Alerts: Set up low stock alerts for both variants to ensure you can replenish stock in a timely manner.
  • Training: Train your staff on the new process to ensure smooth operations.

Conclusion

By using product variants and a BOM, you can effectively manage the inventory of booster packs and boxes in Odoo 18. This approach minimizes manual adjustments and helps maintain accurate stock levels, making it easier to manage your trading card game products. If you need further customization or automation, consider consulting with an Odoo expert or developer

it's an assumption ,you can try it


Аватар
Отменить
Related Posts Ответы Просмотры Активность
3
авг. 24
2153
0
авг. 21
2239
2
мар. 15
8529
1
дек. 24
2610
1
дек. 24
1430