Bulk-to-Retail Tracking

[abi_28]

I receive 1L items from my supplier in boxes of 10, which I then resell in 3L, 5L, and 200ml sizes. How should I set up my stock management for this?

[Hanna]

Welcome to Loyverse Abi!

In this case, create a 1L item as the primary stock for the 1Box, 3L, 5L, and 200ml items, and enable the track stock toggle. 

After saving the main item, create a new item for the 3L. Activate 'Composite' and 'Use Production'; in the quantity field, enter 3 to deduct three 1L items for every 3L unit produced.

Follow the same setup for the 5L and 1Box items. In the quantity field, enter 5 for the 5L item and 10 for the 1Box item. When these are sold, the corresponding units will be automatically deducted from the 1L base stock.

For the 200ml item, follow the same method but enter 0.2 in the quantity field (since 200 / 1000 = 0.200). This configuration allows you to sell five 200ml units from a single 1L juice.

As you can see, the cost was automatically calculated based on the cost of 1L juice. 

 

To manage the stocks, you need to use the purchase order feature from the Advanced Inventory Management. 

1. When you receive stock from your supplier in boxes, simply create a Purchase Order (PO) for the 'Box' item. Enter the number of boxes received and click 'Receive' to update your available stock.

Once the boxes are recorded, proceed to disassemble the box stock into 1L units. These units will then be available for use in your 3L, 5L, and 200ml composite items.

Now that the 1L base item is in stock, you can generate inventory for the 3L, 5L and Box variants. For the 200ml items, whenever you process a sale on the POS, the stock will be automatically deducted from the 1L item.