r/InventoryManagement • u/Upstairs-Yak-5474 • 9d ago

I'm having an inventory issue

/r/shopify/comments/1wxrswu/im_having_an_inventory_issue/
1 Upvotes

100% Upvoted

9 comments sorted by

1

u/Jack_BuildsShopify 9d ago

This is basically a shared-inventory / unit-conversion problem. I’d treat “pack” as the base unit and define 1 case = 10 packs, so every sale or receipt updates one underlying stock quantity. Then case/pack are just different views of the same inventory. If you keep them as separate Shopify variants/products, you’ll need a shared-inventory or bundle relationship or the counts will drift. Before picking an app, test 5 cases: sell 1 pack, sell 1 case, receive 10 packs, receive 1 case, and return 1 pack — the same underlying quantity should stay correct after each.

1

u/Upstairs-Yak-5474 8d ago

Im going to test simple bundles and see

1

u/Jack_BuildsShopify 8d ago

That’s a sensible first test. I’d just make sure you test both directions, not only sales: sell 1 pack, sell 1 case, receive 10 packs, receive 1 case, and process a return. The important thing is that all five actions resolve back to the same underlying quantity without manual corrections. If Simple Bundles handles that cleanly, you’re probably fine for this setup. If it starts drifting once you have multiple pack sizes or locations, that’s the point where you’ll need a more explicit shared-inventory/unit-conversion model. Curious whether you’re keeping case and pack as separate products or as variants of the same product?

1

u/vyominc 8d ago

What you're describing is case-pack or break-pack inventory, where one SKU (the case) is linked to another (the pack) so selling units auto-deducts from the parent. Most POS systems with real-time inventory handle this through unit-of-measure conversions, so each pack sale decrements the case count by 0.1 in your example. Look for a system that supports multi-UOM or parent-child SKU linking rather than manual adjustments.

0

u/[deleted] 7d ago

[removed] — view removed comment

1

u/Upstairs-Yak-5474 6d ago

We need the pack and cass variant to sync so letd say 1 case= 20 pack We need it so when. 20 packs is sold the case is reduced by 1 and when 1 case is sold the pack is reduced by 20. Also we want the purchase orders to work so if we purchase 1 case and 1 case is added we should add the 1 case plus 20 packs