Struggling to find what to google here, so might just be looking for the wrong thing.
Up until now, I have two variants for each product - single or case (6 singles). We manually create the order on the backend from the order placed but we want to connect these two together.
The backend system just works with singles though, so I need to record a case as 6x single SKUs, which is the most common way we sell to this market.
Essentially is there a way to create a variant that is actually just x of the single SKU? E.g. 2x cases and 1x single = 13 singles in the order.
You would bundle up the 6 pack against the single SKU. We designed our bundle app for this scenario. We have two options:
Inventory is calculated based on the component inventory value. So in your case if a single sells we recalculate how many 6 packs can be made and adjust inventory accordingly.
When an order for a bundle comes through we actually modify the order post purchase and display the component SKU so the 6 pack would show as 6 x single item. This makes it easier to fulfill.
Let me know if you need help in testing and setting up.