My store is mainly focused on selling packs of trading cards. Sealed boxes contain 30 packs.
I sell both sealed boxes and groups of individual packs broken out of the sealed boxes. Variations are as follows:
-Sealed Box (30 packs)
-5 Pack Bundle
-10 Pack Bundle
Is it possible to have the management of this inventory be automated? For example, if either the 5 pack or 10 pack bundle goes out of stock then it will remove 1 sealed box from inventory and apply the appropriate quantity of bundles (1 sealed box would make three 10 pack bundles or six 5 pack bundles).
I understand that I can just have the boxes inventoried as 30 packs and manage it like that however, I would prefer to have these inventories separate. I would like maintain having a box inventory and a pack inventory independent of each other.
Right now managing the inventory manually is possible but time consuming and is not an efficient or effective especially as sales volume increases.
If there is nothing of this nature already available, what would be the difficulty in coding it myself? What would I require (software etc.) to do so? I am willing to put in the time to learn.
Any advice or help would be greatly appreciated. Thanks!
Hi @magikartcards
You can create bundles with Stock Hero Material Inventory to manage the inventory of your individual packs, and bundles.
Here is how to do it:
- Create Shopify Products for Individual Packs
- If you have 5 Sealed Boxes in inventory, you can adjust inventory of individual packs to 150 packs (5 x 30)
- Create Shopify Products for your 5 Packs and 10 Packs
- Create Bundles in StockHero Material Inventory for your 5 Packs and 10 Packs
- This will adjust inventory of Individual Packs when orders are place and fulfilled
- The inventory of your 5 Packs and 10 Packs will be adjusted based on availability of your Individual Pack
- 150 Individual Packs will mean 30 packs of 5 and 15 packs of 10
If this is helpful, please hit Like and Mark it as solution!
Cheers!
As stated previously, I would like the Sealed box inventory and pack inventory to be independent of each other. As I am selling both sealed boxes and packs. I do not want to classify the box inventory as 30 packs. Thank you though.
Many eCommerce platforms like Shopify or WooCommerce support apps or plugins that can handle bundled inventory and automatically sync inventory levels between parent products (sealed boxes) and child products (packs and bundles). These systems can:
- Deduct one sealed box from inventory when a bundle is sold.
- Automatically calculate how many bundles (e.g., 5-pack, 10-pack) can be made from available sealed boxes.
Recommended Solutions:- Amazon MCF by WebBee: This app integrates with platforms like Shopify and automates inventory management for multi-channel fulfillment. It supports features like bundling, inventory sync across products, and fulfillment through Amazon’s MCF network. For your case, it can track sealed boxes and individual packs, updating inventory as bundles or boxes are sold.
Hi @magikartcards ,
I understand your requirement here this can be easily done by our app Profit Bundles. Where you can define the relationship between multipacks i.e parent products and child items and this app will be able to do relationship based inventory syncing.
For example, you can define a 5-pack in the app where the composition of the multipack is 5 single units. Inventory syncing in this scenario would work as follows:
-
Initially, let’s assume there are a total of 500 single units available. In this case, the 5-pack inventory would be 100, and the single unit inventory would be 500.
-
If a 5-pack unit gets sold, the 5-pack inventory would be reduced by 1, from 100 to 99, and the single unit inventory would be reduced from 500 to 495.
-
Now If a single unit gets sold, the single unit inventory will drop from 495 to 494, while the 5-pack inventory will reduce from 99 to 98 (as this is the maximum feasible value).
-
To clarify further, let’s assume another order comes for an individual unit. The single unit inventory will drop from 494 to 493, while the 5-pack inventory will remain the same at 98.
Here is the guide for creating a multipack in profit bundles app. Please go through this guide, and if you encounter any problems, let us know.
This does not seem to allow me to transfer box inventory to pack inventory. I want the inventory of boxes to be independent from the packs and amounts be transferred between the different products as needed. Thank you though!
Hi @magikartcards
I recommend Easify Inventory Sync for this. It allows you to create a separate inventory for individual packs and bundle them with each of your variants, so when a bundle sells, the correct number of packs is deducted from the total inventory automatically. No manual updates needed. Here’s how to do it:
1. Create a Base Product: Create individual pack for inventory tracking, with a quantity representing your total inventory (e.g., 1000 items). This product will be a Draft and won’t be visible in the storefront.
2. Set Up Bundle Groups: Use the app to create Bundle groups that connect your Base product with your boxes, 5-pack and 10-pack variants. Here’s how to set up a bundle group for your product:
- Master Product: Your box variant
- Component Product: The Base product you created, with the Quantity per Bundle set to 30
For 5-pack:
- Master Product: Your 5-pack variant
- Component Product: The Base product you created, with the Quantity per Bundle set to 5
3. Do the same with 10-pack variant
4. How it works:
- The inventory for box, 5-pack and 10-pack will be automatically calculated based on the Base product’s inventory.
- When 1 box is purchased, the Base product inventory will be reduced by 30. The app will then recalculate the available quantities for your box, 5-pack and 10-pack variants based on the updated Base product inventory, ensuring accurate inventory tracking.
I hope this answer helps solve the problem. If you need further assistance, feel free to reach out to Easify anytime! 