Etsy Order Tracker Spreadsheet: The Pipeline From Sale to Shipped, Plus Low-Stock Reorder Points

An Etsy order rarely goes wrong at the sale. It goes wrong three days later, when you sit down to cut the next batch of orders and discover you're two metres short of the chain half of them need — or when a buyer messages asking where their package is and you have to scroll back through Etsy's order list to remember whether you actually shipped it. Etsy's dashboard is built to process a sale and print a label. It was never built to be your production log or your stockroom. An order tracker spreadsheet fills both gaps with one sheet for orders and one for the materials behind them, tied together by a couple of formulas that do the watching for you.

Why Etsy's own dashboard isn't enough for inventory

Shop Manager can track a quantity per listing, if you turn that feature on and keep it current. What it can't do is see underneath the listing to the raw materials. If one spool of chain, one blank pendant, or one bag of clay feeds a dozen different listings, Etsy has no concept of that shared material running low — it only knows about each listing's quantity in isolation, and most sellers don't even maintain that number accurately once a listing has variations. There's no reorder point, no low-stock flag, and nothing that tells you "you're about to run out of the thing six of your listings depend on." That's a materials-level view, and it lives in a separate sheet, not in Etsy's order system.

The order pipeline: from sale to shipped

Keep the order log to one row per order, with seven columns:

Status is what turns a flat list into something you can act on. Each of the five stages is editable from a settings list rather than hard-coded, and that same list feeds a status breakdown on the Dashboard — a running count of how many orders sit at each stage, updated automatically as you fill in the log. Rows also pick up a light highlight based on Status: Issue orders get one color so they're impossible to scroll past, and Dispatched or Delivered orders get another so a finished order visually recedes from the list of things still needing attention.

One status slot is treated as your "finished" stage by the Dashboard's Open Orders count — by default, that's Delivered. Whatever you rename it to, keep one status meaning "done," because the Open Orders formula works by counting everything that isn't blank and isn't that status. That includes Issue orders, deliberately: a problem order hasn't shipped successfully, so it still counts as open even though it's flagged separately for attention.

Say you've logged 40 orders this month: 25 are marked Delivered, and the other 15 are split across Received, In Progress, Dispatched, and Issue. Open Orders reads 40 minus 25, which is 15 — the exact number of orders still needing something from you, without counting a single row by hand. Open the sheet on a Saturday morning and that one number tells you whether you're caught up or behind before you've read a single line of the log.

Materials and stock levels: the Inventory tab

The Inventory tab is a separate, shorter log — one row per material or SKU, five columns: Item / SKU, Materials on Hand, Reorder Level, Reorder Flag, and Notes. Materials on Hand is the only number you update by hand as you use stock or receive a delivery. Reorder Level is a threshold you set once per material, based on how fast you go through it and how long a reorder takes to arrive. Reorder Flag is a formula: if Materials on Hand is below Reorder Level, it returns REORDER; otherwise it returns OK.

Take a concrete case: a material with 12 units on hand and a reorder level set at 20. Twelve is below twenty, so the flag reads REORDER the moment you type in that "12" — no separate check, no remembering to look. Rows flagged REORDER also pick up a highlight color on the Inventory tab, and the Dashboard's Low-Stock Items tile counts them, so a shop with sixty materials logged can see in one number whether anything needs reordering today.

The number worth getting right is the reorder level itself, because the formula only does what you tell it to. Set it too low — say, at zero or one — and you'll get the flag after you're already out, which defeats the point. A better rule of thumb: multiply your typical weekly usage of that material by how many weeks your supplier actually takes to deliver a reorder, and set the level a little above that. If you use roughly five units a week and restocking takes two weeks, ten units is close to where the flag should trip — not the point where you've already run out mid-order.

What this pipeline doesn't do

Worth being direct about the edges, because it's easy to assume a spreadsheet with formulas in it is doing more than it is. This tracker doesn't sync with Etsy's API — every order and every stock change is something you type in, not something that arrives automatically. It doesn't generate purchase orders or place a reorder for you; REORDER is a flag you read, not an action the sheet takes. It doesn't watch the Postage Deadline column and warn you as a date approaches — that column is a place to record the deadline, not a system that tracks it against today's date. And it doesn't process payments, print labels, or scan barcodes. It's a log with two formulas doing real work — a status-based open-order count and a stock-level comparison — sitting on top of data you keep current by hand.

For a shop running a handful of listings and a manageable materials list, that's usually plenty: cheaper and simpler than inventory software, and it tells you exactly what it's built to tell you. If you're weighing whether the numbers behind a sale actually work — what a listing nets after Etsy's fees — the Etsy fee calculator runs that from your price and cost inputs. For the broader question of tracking materials and true product cost across a handmade business, the handmade business inventory tracking guide goes deeper on costing, and the Etsy shop bookkeeping routine covers the monthly numbers this order and inventory log feeds into.