How can I track inventory for products of various sizes and packaging?

I have searched high and low to figure the following out. I have a product that comes in mutliple sizes, and each size can be packaged in two ways. How would I track the inventory for just the product in that size and not the packaging?

For instance: Product A in size 1 packaged in a Bag. Or Product A size 1 packaged in a Box. If I add each size and packaging to the options, then it breaks up the inventory as Size 1/Bag and Size 1/Box. I don’t want to split up the inventory since I have the same number of Size 1 available whether it is in a bag or box.

Hi

In this scenario you would need to use one of these products as your main inventoried SKU and the other is mapped to it. As Shopify doesn’t have a native bundling solution you can use a bundle app to map the second product to the primary.

Our bundle app has 2 main features that work in the background so no theme edits require and would help you in this set up:

1. Inventory Management

**Bundleup **lets you connect up your second product to the primary and it then updates the inventory based on the primary stock level. So if your scenario if the box sells the bag would also update as its component is the box SKU.

2. Order Fulfilment

When you sell one of the bundles say the box set then the bag stock level won’t reduce automatically. What Bundleup does is update the order post purchase by replacing the order line with the component SKUs as order lines which then reduces stock. This then feeds into point 1 above where it updates all linked products. You may not need this but if you do it might also be beneficial to set a component as a box or bag if that helps with fulfilment.

We also offer a bulk csv file upload option so it is quicker to map all your gift sets to correct SKUs.

If you need help in setting up and testing please get in touch. You can also find our guide here:

https://help.channelup.com.au/hc/en-us/articles/900004620086

Regards

Tom

I’m not quite sure that is what I’m looking for. I don’t want the item separated as a new bundled item. I currently have Product A with 6 variants of sizes. I need a way to add packaging options box or bag, but have the inventory deduct from Size 1 no matter what packaging is chosen. If I add packaging as another option/variant, then it will look like Size 1/box and Size 1/bag. This does not allow me to track inventory per the component of Size 1. Product A is the parent, but the size holds the SKU. I hope that makes sense. My listing is as follows for instance:

Product: A (Main Product)

Option/Variant: Size 1-Size 6

(each size has its own SKU)

-Each size can be packaged in a bag or a box. This is where my trouble is.

Our bundle app works in background so the buyer doesn’t see anything to what you have already set up.

In your case you have 2 options depending on how the box/bag inventory is handled.

  1. If the box and bag are inventory items then you would set them up as unique SKUs along with the product with all your sizes but not make them available to your webstore. These then act as your inventory SKUs. You then set up your variations like:

Size1/box - bundle of Size 1 and box

Size1/bag - bundle of Size 1 and bag

When these sell we convert the order into the inventoried items post purchase.

  1. If the box and bag are not inventoried you could just use one of the variations and not need separate inventory SKUs as per point 1. You then set up like:

Size1/box

Size1/bag - bundle of Size 1/box

Here you manage your size 1 inventory in the first variation and the bag one will update according to the box variation stock.

Hi Jlconsoer,

Hope you were able to figure this out between July and now, but if not I have a potential solution for you. From what I understand you want each of Product A’s various sizes (size 1 through 6) to be tracked only based on their size and not whether they’re packed in a bag or a box. I am currently Beta Testing my app PackPal that adds the packaging to the order based on the items inside AFTER the order is placed as it’s own line item. PackPal uses a sophisticated packing algorithm to determine which package would fit your order best, and can even expand ‘bags’ (poly/bubble mailers).

The one clarification I think would be helpful for you to make is why would an item be shipped in the bag vs the box? Are all these items prepackaged for shipping already or does it work for the packaging to be decided at the time of the order based on the smallest package that fits all the items?