I’m working on a project where the variants for a product represent different set quantities of the base product.
Base = 1 x Product
Variant 1 = 50 x product
Variant 2 = 500 x product
Obviously, in Shopify each variant has its own SKU and inventory levels. The store needs to make it so the variant is really just a bundle representation of X amount of the product (still needs to have a product ID like a variant would, because in shipping we need to rectify weight/dimensions for that particular variant bundle), also the variant would need to remove that X amount from the primary products inventory level, which is also not how variants traditionally work.
So order comes through the ERP, and it looks like “MainProductSKU x 50” for a variant 1 order, not “Variant1SKU x 1”.
Anybody know of any apps that could help achieve this unique issue? Thank you!!
This is a common issue for our users where they have a master stock product which is then linked to multiple other products like multipack variations. The way to manage inventory is to kit each product or variation that uses the master SKU. There are 3 points to consider:
Inventory Management
Our app lets you connect up products to correct SKUs and we then update their inventory based on the component stock level.
Order Fulfilment
When you sell one of the variations the master stock level won’t reduce automatically. What our app does is update the order post purchase by replacing the order line with the master SKU as order line which then reduces that stock. This then feeds into point 1 above where it updates all linked products. This process also allows you to fulfil your order correctly as we remove the bundle line.
Bulk Set Up
If you are dealing with variations there are a lot to go through and set up so rather than doing them one by one we offer a bulk CSV file upload solution to automate the process and reduce the time it takes to set up. This also lets you update products easier if you ever need to change them.
In terms of SKUs you would need to set unique ones for the multipacks so correct mapping is maintained to the master SKU.
If you need help in setting up and testing please get in touch. You can also find our guide here.
Once your order comes in, Simple Bundles will break down the bundle into its individual SKUs and deduct the appropriate quantity from your inventory. The bundle quantity is also determined based on the quantity of their individual SKUs to ensure that you never oversell. Please let me know if you have any questions!