How can I automate inventory for products sold in packs, boxes, and cases?

LoriF1101
Visitor
1 0 0

We are a retail brick and mortar store with eComm. I'm needing to find a way to automate our inventory. My dilemma... We sell products which are sold in Packs, Boxes, & Cases. I've not been able to find a way or app to help. To be honest, not even sure if this exists.

 

Example:

  • Product A:
    • Pack contains 5 widgets
    • Box contains 20 packs
    • Case contains 12 boxes

In the perfect world, I'm looking for something that when the product is setup in Shopify, the number of packs/boxes and number of boxes/case are entered. When inventory is received, it will be received as cases. The system will then handle putting each qty into the appropriate qty bucket along with appropriate cost for each.

 

What I need is something that when 'Product A' sells 13 boxes, it will automatically deduct 1 case and 1 box from inventory. The system/app would take the remaining boxes from the partial case sold and put it into the box qty. Based on the example above,  11 boxes would be put into box qty. I'm sure this question will be asked... There are no discounts for "the more you purchase the more you save" so typical bundle apps are not a good fit for us.  

 

Currently, we receive product based on the number of boxes. When items sell we have to "pack out" boxes. Using the example above, if George purchases 15 packs then Fred purchases 6 packs, I have to complete a stock adjustment to pack out the box. Our problem is that when we are busy we do not have time to stop and complete a stock adjustment (deducting 1 box and adding 20 packs to inventory & adjustment cost if necessary), which means an online customer may be able to "purchase" a box we do not have in-stock because a pack out was not performed yet. 

Replies 2 (2)

Ugurcan
Shopify Expert
336 6 34

The best way to achieve this is to replace your quantity input with some custom code. The inventory will still be treated as individual items but if a box and case ordered, 13 items will be deducted from the inventory.

For example if you enter 100 into inventory for product A, you will be able to sell 20 packs or 5 boxes or 8 cases The code can calculate and display the available packs, boxes or cases to the customer.

Pasilobus, Inc - Shopify Experts -- www.pasilobus.com - Fast, efficient apps that do not slow down your store, Stellar support & Premier Services

jam_chan
Shopify Partner
895 23 176

I believe you would need an inventory app to create linkages between your products. Assuming your products, box, pack, box are all products in the inventory. When product A is purchased, the app will automatically deduct the inventory of the linked products.

BYOB - Build Your Own Bundles, SPO - SEO App to research keywords & edit social link preview