How to track your Etsy inventory without spreadsheets taking over your life
A practical, no-nonsense system for Etsy sellers — written by someone who runs a shop and got tired of guessing.
Johannes Tebbert, founder of Findig
·
6 min read
You start with a tidy spreadsheet. Then you add a colour. Then a size. Then a bundle. Six months later you're scrolling through forty rows trying to remember whether you have three of the blue ones left — or whether you already sold those last week.
I know the feeling, because I lived it. I run a small Etsy shop, I'm not an Excel wizard, and I kept overselling things I didn't know had run out. This is the system I wish I'd had at the start — written so it works whether you sell jewellery, candles, prints, or anything else Etsy allows.
Why Etsy inventory is harder than it looks
Etsy does have a built-in quantity field per listing. So why isn't that enough?
Because real shops have variations. One listing might be one product to a buyer, but to you it's six different physical things — three colours times two sizes — each with its own stock. Etsy's quantity counter doesn't always map cleanly to what's actually sitting on your shelf, especially once you have bundles, made-to-order items, or the same component shared across listings.
That leaves every growing seller fighting the same two problems:
Overselling
You sell something you can't actually ship — and now you're scrambling, apologising, or refunding.
Blind restocking
You don't know what to make next, so you over-produce what doesn't sell and run out of your bestseller at the worst time.
Track the physical thing, not the listing
The single most important shift: stop tracking "Listing X" and start tracking the actual physical thing.
"Blue – Large" is a unit of stock. "Red – Small" is a different unit of stock. If your tracking lumps them together, you'll always be guessing. Whatever method you use, make sure each variation a buyer can choose maps to its own count.
Decide what one sale consumes
A sale rarely removes just one thing. Selling a gift set might consume three separate items. Selling any order at all consumes packaging — a box, a thank-you card, a polymailer.
Write down, for each product, the list of things one sale uses up. This is your recipe. It feels tedious once, but it's what turns "I sold something" into "I now have one fewer box, one fewer card, and one fewer Blue-Large."
Deduct on sale, not at the end of the week
Most oversells happen in the gap between "order came in" and "I updated my sheet." If you reconcile weekly, that gap is a week wide.
The fix is to deduct stock at the moment of sale. With a manual spreadsheet that means a small daily habit. With software it happens automatically the instant Etsy reports the order — which is the main reason sellers eventually graduate off spreadsheets.
Watch real profit, not revenue
Inventory and profit are the same conversation. A product can be your bestseller by volume and still lose you money once you subtract Etsy's fees, payment processing, shipping, and materials.
Before you decide what to restock, know your real margin per item.
Let your numbers tell you what to make next
Once you're tracking stock per variation and you know what sells, restocking stops being a guess. You make more of what's moving, before it hits zero — and you stop tying up cash and shelf space in things that just sit there.
Spreadsheet or software?
A spreadsheet is the right place to start. It's free, it's yours, and it teaches you what you actually need. Use the free template and the habit from Step 3 and you'll be ahead of most shops.
You'll know it's time for software when the daily-update habit becomes the thing you dread — usually somewhere past a few orders a day, or once bundles and shared components make the maths error-prone.
That's the itch I built Findig to scratch. It syncs your Etsy orders automatically, deducts stock by variation the moment something sells (so you can't oversell), shows your real profit after every fee, and tells you what to make next based on actual demand. It's hosted in Germany, it never modifies your shop, and it's free during the private beta (affordable paid plans are planned after). If you're tool-shopping, start with my honest roundup of the best Etsy inventory software, or jump straight to a head-to-head: vs Craftybase, vs Inventora, or vs Sumtracker.
The whole system, in five lines
- Track the real physical thing — each variation has its own count.
- Know what one sale consumes — products and packaging.
- Deduct the moment a sale lands, not weekly.
- Judge products by real profit after every fee, not revenue.
- Restock from your numbers, before you hit zero.
Get that right and inventory stops being the part of your shop you're scared of.
Want the spreadsheet done for you?
Findig is free while it's in early access, and I onboard every new shop personally. There are a limited number of beta spots — I read every application and reply within 48 hours.
Apply for a beta spot →