Setting Up Inventory for Etsy and Shopify — A Maker's Guide to Getting It Right From the Start
Before you sync a single listing, you need to get your product setup right. Here's how to structure SKUs, recipes, and inventory so both platforms stay accurate.
Most guides on managing inventory across Etsy and Shopify start at the sync step. Connect the platforms, pick a direction, flip a switch. But the makers who end up frustrated — the ones still getting oversells three months later, still not trusting their stock numbers — almost always have the same root problem.
Their product setup was wrong before they started.
Inventory sync only works as well as the data it has to work with. If your SKUs don’t match, if your Shopify product variants don’t map cleanly to your Etsy listings, if your recipes are inconsistent — the sync will reflect that chaos right back at you. Garbage in, garbage out.
This guide covers what to sort out before you start syncing, and how to set up your products, SKUs, and recipes so that managing inventory across both channels is actually manageable.
Why Most Etsy and Shopify Inventory Problems Start Before the Sync
The oversell happens on a Tuesday. You sold your last soy wax candle on Shopify at 10am. By 10:04am, the same candle sold on Etsy. Your sync tool wasn’t fast enough — or wasn’t running at all — and now you’re issuing a refund and writing an apology.
The tempting conclusion: the sync broke. The real problem: you were running on untracked inventory in Shopify, and your Etsy listing had no quantity limit set.
Sync tools are not magic. They take whatever your inventory numbers say and push them to the right places. If your numbers are wrong, or if Shopify’s “inventory tracking” setting is turned off for a product, or if Etsy and Shopify are using different names for the same variant — the sync has nothing useful to work with.
Getting your setup right means you’re not patching holes after every oversell. It means the sync has clean, accurate data to push.
The SKU Problem — And How to Fix It
A SKU (Stock Keeping Unit) is just a unique code for a product or variant. Every item you sell should have one. That sounds obvious. But a surprising number of Etsy sellers have never set a SKU — Etsy doesn’t require them — and Shopify sellers often let Shopify auto-generate them without thinking about cross-platform consistency.
Here’s why this matters for multi-channel inventory: sync tools match products across platforms using SKUs. If your Shopify listing for “Lavender Soy Candle — 8oz” has the SKU CAND-LAV-8 and your Etsy listing for the same product has no SKU at all (or a different one), those two listings are invisible to each other. The sync can’t connect them. Stock updates don’t flow.
The fix: a consistent SKU system before you sync
You don’t need a sophisticated naming convention. You need a consistent one. Something like:
[PRODUCT TYPE]-[VARIANT 1]-[VARIANT 2]- So:
CAND-LAV-8(candle, lavender, 8oz),CAND-LAV-4(4oz),SOAP-OAT-BAR(soap, oatmeal, bar)
Before you connect Etsy and Shopify to any inventory system:
- Open your Etsy listings and assign a SKU to every active product and variant
- Open your Shopify products and assign matching SKUs to every corresponding listing
- Where a product exists on both platforms, the SKU must be identical — character for character
This is a one-time project. It’s tedious. But once it’s done, every future sync has a clean anchor to work from.
Shopify Inventory Tracking Settings — The Hidden Problem
Shopify has a product-level setting called “Track quantity.” When it’s on, Shopify monitors how many units you have and will stop accepting orders when you hit zero (if you choose). When it’s off, Shopify lets customers buy the product indefinitely — no stock limit, no deduction.
For handmade sellers who make products in batches, “Track quantity” should be on for everything you sell. If it’s off, your sync tool has no quantity to read or update. You’ll keep selling units you don’t have.
The issue is that some Shopify themes and onboarding flows default to inventory not tracked, especially for new product listings. So a maker who listed 20 candle variants and didn’t check each one might have a mix: some tracked, some not.
How to audit your Shopify inventory tracking settings
- In Shopify admin, go to Products
- Click into each product and scroll to the Inventory section
- Check that “Track quantity” is enabled
- Set your actual stock quantity — not 0, not blank
If you’ve been selling with “Track quantity” off, you’ll need to reconcile your real stock count before turning it on. Count what you actually have, enter that number, then enable tracking. From that point on, the sync has real numbers to work with.
How Etsy and Shopify Handle Variants Differently
This is where things get technically fiddly — and where a lot of multi-channel headaches originate.
Shopify variants are structured as nested attributes. A candle might have a Size variant (4oz, 8oz, 16oz) and a Scent variant (Lavender, Eucalyptus, Vanilla). Shopify creates a separate inventory entry for each combination: Lavender/4oz, Lavender/8oz, Eucalyptus/4oz, and so on.
Etsy doesn’t work the same way. Etsy uses “variations,” but it’s less structured. You can add Size and Scent as variations, but how they’re displayed and how inventory is tracked differs. Etsy also limits the complexity of variation combinations.
The practical result: if you’ve built your Shopify product with clean variant structure but listed on Etsy with a looser setup — or vice versa — mapping one to the other becomes a guessing game for sync tools.
Getting your variants to align
- Name your variants the same way on both platforms. If Shopify calls it “8oz” then Etsy should too. “8 oz,” “Eight Ounce,” and “8OZ” are three different things to a system looking for a match.
- Use consistent capitalisation and formatting. Syncing is case-sensitive in many tools.
- If a product doesn’t actually have variants on one platform, it shouldn’t have them on the other either. Keep the structure parallel.
This is also where SKUs do the heavy lifting — a matching SKU across both platforms overrides naming inconsistencies. But consistent naming helps you catch problems when they happen.
Setting Up Recipes So Your Materials Stay Accurate Across Both Channels
Here’s something most Etsy-Shopify inventory guides skip entirely: the material tracking problem.
Shopify tracks finished product inventory. Etsy tracks finished product inventory. Neither platform has any awareness of what you used to make those finished products. When your candle sells on Shopify, Shopify deducts one candle from your finished goods count. But it doesn’t know you used 180ml of soy wax, 30ml of fragrance oil, and one wick to make it.
For makers, this is the gap that causes stockouts at the materials level. You look at your finished goods count and think you have plenty. But your soy wax ran out three days ago and you haven’t noticed because no one’s tracking it.
The solution is recipe-based inventory tracking. When you log a manufacture run — say, you made 20 candles — a recipe tells your inventory system exactly what materials were consumed. When orders come in from Etsy or Shopify, the system knows what finished goods to decrement. And when finished goods get low, you can see it coming because you also know your material levels.
Craftybase handles this through its recipe feature. You define a recipe for each product — what materials it uses, what quantities — and every manufacturing run and every sale is tracked against that recipe. It doesn’t matter if the order came from Etsy or Shopify. Both channels feed into the same materials inventory, giving you an accurate picture of what you have to work with.
This is the part that sync-only tools miss. They’ll keep your finished product counts accurate across channels. But they can’t tell you that you’re about to run out of fragrance oil, or that you need to make 15 more candles before the weekend.
What Happens When Shopify Inventory Settings Conflict With Etsy Listings
Scenario: you’ve set your Shopify product to “Continue selling when out of stock.” You did this because you take pre-orders on Shopify. But your Etsy listing has a hard quantity cap.
Now a sale comes through on Shopify — the system accepts it (because of the pre-order setting). The sync tries to update Etsy. But Etsy sees the quantity would drop below zero and refuses the update, or caps it at zero. Your two platforms are now disagreeing about what’s in stock.
Or the reverse: Etsy auto-renews listings when you sell through (which it does by default). A sale on Etsy consumes your last unit. Etsy renews the listing. Your sync reads the renewed listing as “still active” and doesn’t update Shopify. Shopify still shows stock.
These conflicts aren’t bugs in the sync — they’re platform behaviour mismatches that create edge cases sync tools have to navigate. The way to avoid them:
Turn off “continue selling when out of stock” in Shopify unless you’re genuinely running a pre-order programme with separate workflow management.
Review Etsy’s auto-renew settings. For low-quantity listings (under 10 units), consider whether auto-renew is serving you. If you have one handmade item left and Etsy auto-renews after it sells, you’re relying entirely on the sync being fast enough to prevent the next sale.
Set up safety stock buffers. Don’t list 10 candles as “10 available.” List them as 8. That two-unit buffer buys you time when platforms temporarily disagree.
Log stock in one place first. Your inventory system — not Etsy, not Shopify — should be where you update quantities after a manufacture run. Let the sync push those numbers out to both platforms. If you’re editing quantities directly in Etsy or Shopify and hoping the other updates accordingly, you’re working against how the system is designed.
Building Your Multi-Channel Inventory in the Right Order
Setup order matters. Here’s a sequence that avoids the most common problems:
Step 1: Audit and assign SKUs. Go through every active listing on both platforms. Assign matching SKUs before you do anything else.
Step 2: Turn on inventory tracking in Shopify. Every product, every variant. Enter your actual stock counts.
Step 3: Match your variant structure. Make sure variant names, capitalisation, and structure align between platforms for every product that exists on both.
Step 4: Set up your recipes. For every product you make yourself, define the recipe — what materials, what quantities. This is where material-level tracking kicks in.
Step 5: Enter accurate opening stock. In your inventory system, enter your real material quantities and your real finished goods counts. Don’t approximate. This is your baseline.
Step 6: Connect your channels. Connect Etsy and Shopify to your inventory system and let the initial sync happen. Watch for mismatches — they’ll surface quickly as listings that didn’t find a match.
Step 7: Run a test order. Place a small test order on one channel and verify that the other channel’s quantity decremented. This is your sanity check before you go live.
This sequence works because you’re building clean data before you introduce automation. Sync tools amplify whatever state they find — clean data gets kept clean, messy data gets messier faster.
Frequently Asked Questions
Do my SKUs have to match exactly between Etsy and Shopify?
Yes — SKUs must match character for character for sync tools to connect the same product across platforms. A difference in capitalisation, spacing, or punctuation will cause a mismatch. Before connecting Etsy and Shopify to any inventory system, go through every listing on both platforms and verify the SKUs are identical. It's a tedious one-time project, but it's what makes everything downstream work reliably.
What does "track quantity" in Shopify mean and why does it matter for Etsy sellers?
"Track quantity" is a Shopify product setting that tells Shopify to monitor how many units you have. When it's off, Shopify accepts unlimited orders regardless of stock. For Etsy sellers adding Shopify as a second channel, this setting must be turned on for every product — otherwise sync tools have no quantity to read, update, or push. Many sellers discover too late that some products were set to "not tracked" from the start, which is why an audit before syncing is so important.
Why doesn't tracking finished products in Shopify and Etsy tell me when I'm about to run out of materials?
Neither Shopify nor Etsy tracks what goes into your products — they only track finished goods. If you sell a candle on Shopify, Shopify deducts one candle. It has no idea you used 180ml of soy wax, 30ml of fragrance oil, and a wick to make it. Recipe-based inventory tracking closes this gap — you define what each product is made from, and every sale or manufacturing run updates your material levels automatically. Craftybase does this across both Etsy and Shopify orders in one system.
What causes Shopify and Etsy inventory to get out of sync even when I have an integration running?
The most common causes are mismatched SKUs (so the integration can't connect the same product on both platforms), Shopify products with "track quantity" turned off, Etsy auto-renew creating a renewed listing after a sell-through that the sync misreads as active stock, and manual quantity edits made directly in one platform that override the sync. Fix the underlying setup issues — SKUs, tracking settings, variant naming — and most sync problems go away on their own.
How does Craftybase handle inventory for makers selling on both Etsy and Shopify?
Craftybase connects to both Etsy and Shopify simultaneously, importing orders from both channels into one system. It tracks both finished product inventory and raw material inventory through recipes — so when a candle sells on either platform, both your finished goods count and your material levels update accordingly. Stock Push then keeps your Etsy and Shopify listings accurate from that one source of truth. COGS is calculated across all orders in one report, regardless of which channel the sale came from.
Should I set up my inventory in Shopify or Etsy first, or in a separate system?
Set it up in a separate inventory system — not Etsy, not Shopify. Your sales channels are display windows, not your source of truth. Enter your actual stock in a dedicated system like Craftybase, then let that system push quantities to both platforms. If you manage stock directly in Etsy or Shopify and rely on the other to follow, you're one manual edit away from a desync. One system owns the numbers; both channels display them.
Getting the Setup Right Once
Multi-channel inventory doesn’t have to be complicated. But it does have to be set up correctly — and that means doing the SKU work, turning on tracking in Shopify, aligning your variant names, and getting your recipes into a system that can actually use them.
The makers who do this upfront rarely have to think about it again. The ones who skip it spend months chasing desync problems that all trace back to the same root causes.
If you’re ready to connect Etsy and Shopify with proper recipe-based tracking — so your material levels update every time a sale comes in from either channel — Craftybase’s free trial is the place to start. No spreadsheets. No manual reconciliation. Just accurate inventory across both channels.
