How to share inventory between Shopify variants and pack sizes that use the same materials
Track the materials, not the variants: give each variant a recipe, take orders out of a shared pool, and see which orders and products you can still make.
· 8 min read
This post answers
How do I share inventory between Shopify variants and pack sizes that use the same materials?
To share inventory between Shopify variants and pack sizes that use the same materials, track the materials instead of the variants. Give each variant a recipe — how much of each material one unit uses — and when an order comes in, take that recipe out of a shared stock of materials. Then you can see, from what’s left, which open orders you can actually make and how many more of each variant you could make before something runs out. Shopify’s built-in inventory doesn’t do this, because it counts stock per variant. You can track materials in a spreadsheet, or use a tool like SkuFestra built for shared material pools.
The problem: variants don’t run out — materials do
A Shopify seller of custom-painted items described this problem on r/shopify. Their products came in about 1,760 possible variations, but what actually limited them was how much they could make: around 100 orders a week. On top of that, they were copying order details out by hand, because their customization app didn’t export the information they needed.
Another version of the same problem is common in food, cosmetics and candle shops: several package sizes all drawing on one ingredient. A 250 g bag and a 1 kg bag of the same coffee aren’t separate stock; they’re the same beans.
In both cases, the number that matters isn’t “how many of variant X do I have?” It’s “how much of each material do I have, and what can I make with it?”
Why per-variant stock doesn’t fit
Shopify tracks inventory per variant (and per location). That’s perfect for finished goods sitting on a shelf. For made-to-order and mixed-size products, it causes three problems:
- You have to guess a stock number for every variant. With hundreds or thousands of combinations, that’s not realistic, so many shops turn off tracking or set a big number.
- Variants don’t know they share materials. Selling a large candle should also reduce how many small candles you can make, because they use the same wax.
- Nothing tells you which orders you can’t fill until you reach your workbench and run out.
The example: a small candle shop
The rest of this post uses SkuFestra’s sample shop: a candle maker selling cedar and lavender candles in 8oz and 16oz jars, plus a gift duo. Its materials:
| Material | Opening stock | Warn at |
|---|---|---|
| Soy wax | 12.5 kg | 6 kg |
| Fragrance oil – Cedar | 900 ml | 200 ml |
| Fragrance oil – Lavender | 400 ml | 200 ml |
| Cotton wick | 150 | 40 |
| Amber jar 8oz | 40 | 15 |
| Amber jar 16oz | 12 | 20 |
| Gift box | 15 | 10 |
And the recipes — what one unit uses:
| Product | Uses |
|---|---|
| Cedar candle – 8oz | 0.2 kg wax, 18 ml cedar oil, 1 wick, 1 8oz jar |
| Cedar candle – 16oz | 0.4 kg wax, 36 ml cedar oil, 2 wicks, 1 16oz jar |
| Lavender candle – 8oz | 0.2 kg wax, 18 ml lavender oil, 1 wick, 1 8oz jar |
| Lavender candle – 16oz | 0.4 kg wax, 36 ml lavender oil, 2 wicks, 1 16oz jar |
| Gift duo | one cedar 8oz + one lavender 8oz + 1 gift box |
Both sizes of both scents draw on the same wax and wicks; both scents in a size share the same jars.
The open orders, oldest first: #1001 (2 × cedar 8oz), #1002 (4 × lavender 16oz), #1003 (1 gift duo), #1004 (6 × cedar 16oz), #1005 (1 × a fig candle the shop hasn’t set up yet), #1006 (3 × lavender 16oz and 1 × cedar 8oz) and #1007 (2 × cedar 16oz).
Method 1: the spreadsheet
Step 1 — a materials tab. One row per material: name, unit, on hand.
Step 2 — a recipe tab. One row per product per material: SKU, material, quantity per unit. A bundle gets rows for everything inside it — the gift duo needs 0.4 kg of wax (two candles’ worth), 18 ml of each oil, 2 wicks, 2 small jars and a box.
Step 3 — an orders tab. Copy in each order’s line items: order number, SKU, quantity. If customers personalise products, copy those details too, into whatever columns you use.
Step 4 — work out usage. For each order line, multiply quantity by the recipe (a SUMIFS per material works), then total by material and subtract from on hand. In the example, the 16oz jars are the problem: #1002, #1004, #1006 and #1007 need 4 + 6 + 3 + 2 = 15 jars, and there are 12.
Step 5 — decide which orders you can make. Go through orders oldest first and take materials as you go. #1002 and #1004 use 10 of the 12 jars, leaving 2, so #1006, which needs 3, can’t be made. #1007 only needs 2, so it can.
It works, but every new order means re-copying rows, and every recipe change means hunting through formulas. The order details are retyped by hand — which is the part the seller on Reddit was trying to get away from.
Method 2: SkuFestra
SkuFestra does the same bookkeeping as the spreadsheet, without the copying.
1. Add your materials. Name, unit, opening stock and a “warn at” level. After that, stock only changes through logged adjustments — received, used or wasted, or a stock count that sets the number outright. Each one is recorded with the amount, the new balance, an optional note and who made it, so the Stock history page is a full audit log.
2. Add products and their recipes. Enter each SKU as it appears on your orders and list the materials one unit uses. A bundle is a product made of other products, plus any materials of its own, like the gift box. Bundles can contain other bundles, and SkuFestra refuses to save a bundle that would end up containing itself.
3. Import orders. Upload a CSV with one row per line item, using Shopify’s column names (Name, Created at, Lineitem sku, Lineitem quantity) or similar ones you map yourself. Customization fields come from a combined column of Name: value pairs, or from separate columns such as Engraving or Font, or both. As each order is imported, its materials are taken out of the shared pool. Importing a file again skips orders you already have. Lines with an SKU that isn’t set up yet (the fig candle in #1005) are listed so you can set that SKU up. One click then applies it, and those lines take their materials too.
4. Read the capacity report. The Capacity page goes through open orders oldest first and labels each one:
- Can fulfil — #1001, #1002, #1003, #1004 and #1007.
- Not enough stock — #1006, with the exact shortage: it “needs 3 each Amber jar 16oz, only 2 each left after older orders”. A blocked order doesn’t hold back stock, which is why the smaller #1007 behind it can still go ahead.
- SKU not set up — #1005.
Next to it, the materials list shows the 16oz jars at −3 (marked Short), and soy wax and lavender oil as Low: 5.5 kg of wax against a 6 kg warning level, and 130 ml of lavender oil against 200 ml.
5. See what you can still make. From the stock left after every open order, SkuFestra shows how many more of each product you could make, and which material runs out first:
| Product | Can still make | Limited by |
|---|---|---|
| Cedar candle – 8oz | 27 | Soy wax |
| Lavender candle – 8oz | 7 | Fragrance oil – Lavender |
| Gift duo | 7 | Fragrance oil – Lavender |
| Cedar candle – 16oz | 0 | Amber jar 16oz |
| Lavender candle – 16oz | 0 | Amber jar 16oz |
That’s the “around 100 orders a week” question answered from your actual stock. Here, the 16oz jars are the thing to reorder first; lavender oil is next.
6. Export the customization report. The Orders page shows one row per line item, with every customization field in its own column — Custom label, Font, Ribbon, Card message and so on — filterable by open, shipped or cancelled. Download it as a CSV (there’s an Excel version too) and you have a production sheet without retyping a single order.
7. Ship or cancel. Mark shipped closes an order. Cancel returns its materials to stock and records that in the history.
Limits
- No live Shopify sync yet. Orders come in by CSV upload, and SkuFestra doesn’t update stock numbers in your Shopify store.
- Stock is taken when an order is imported, not when it ships. Shipping an order doesn’t change stock; cancelling an open one does.
- The customization report needs the data in your file. SkuFestra turns the customization fields it finds into columns. If your customization app doesn’t put them in any export, they won’t be there to flatten.
- It doesn’t order materials for you. Low-stock warnings tell you what’s running out; buying more is up to you.
How this compares with other options
Shopify’s own inventory is the right tool if you sell finished stock, one item per variant. The Shopify App Store also has plenty of inventory apps, and some handle bundles, bills of materials or raw-material tracking with a live Shopify connection. If you need stock pushed back to Shopify in real time, that’s worth looking for. Compare their current features and pricing on their own listings.
SkuFestra is focused on three things for made-to-order shops: shared material pools, a capacity report that tells you which orders you can make and what runs out first, and an order report with every customization field in its own column.
Try it
You can load the candle shop above with one click and see the recipes, the blocked order and the “can still make” numbers for yourself, then set up your own materials and import a week of orders. Start a 14-day free trial of SkuFestra; after the trial it’s $49 a month.
Frequently asked questions
- Does SkuFestra sync with Shopify automatically?
- Not yet. Orders come in by CSV upload, and SkuFestra doesn't change the stock numbers in your Shopify store. It keeps its own count of materials and tells you what you can make from them.
- When are materials taken out of stock — when the order comes in or when it ships?
- When the order is imported. Marking an order as shipped doesn't change stock, because the materials were already counted. Cancelling an open order puts its materials back, and that's recorded in the stock history.
- Can stock go negative?
- Yes, on purpose. If you import more orders than your materials cover, the material goes below zero and shows as Short, and the newest orders that can't be covered show as "Not enough stock" with exactly what's missing.
- How do bundles and gift sets work?
- A bundle is a product made of other products, plus any materials of its own such as a gift box. When a bundle is ordered, SkuFestra takes the materials for every product inside it, as well as the bundle's own packaging.
- Where does the customization report get its data?
- From the orders file you upload. SkuFestra reads customization fields from a combined column of "Name: value" pairs and/or from separate columns such as Engraving or Font, and turns every field into its own column in the report. The fields have to be in the file you import.