How to Track Custom Etsy Orders When You Have 30+ Per Week

If you're running a custom Etsy shop and starting to feel like your production system is held together with sticky notes and dread, this guide is for you. We're going to walk through exactly how serious custom sellers organize their daily production — what works at low volume, what breaks at high volume, and the specific signals that tell you it's time to change your approach.

Etsy is the largest marketplace in the world for handmade and custom goods, with over 5.6 million active sellers as of 2024. About 30% of sales come from personalized or custom items — meaning roughly 1.6 million sellers are making something different for every order. But Etsy itself was built for inventory-based selling. The orders page wasn't designed for sellers who need to read each order, parse personalization details, and physically make each item.

This guide is the practical reality of how shops in five common verticals — embroidery, jewelry, candles, laser engraving, and custom apparel — actually keep up.

The breaking point: when spreadsheets stop working

Almost every custom Etsy shop starts the same way. You get your first few orders. You make them, you ship them, and you remember the details easily because there are only a handful. Then you grow. The orders multiply. The personalization details get harder to track. You build a spreadsheet. The spreadsheet works for a while.

Then, eventually, the spreadsheet breaks.

The signs are consistent across crafts. You start spending 20-30 minutes per day just updating your sheet. You miss a rush order because it was buried in a long list. You re-read the same order three times to figure out what goes on which item. You ship the wrong item because you copy-pasted from the wrong row. The spreadsheet hasn't gotten worse — your volume has gotten higher, and the spreadsheet was never designed to scale.

Here's the question that matters: what's actually the right system at your specific volume?

What works at each volume tier

The principle that actually matters: one row per item, not one row per order

The single most important shift for custom shops is restructuring around individual items, not orders. Here's what that means in practice.

Say a buyer orders a set of 6 custom candles, each with a different scent and a different label. Or a set of 12 engraved cutting boards, each with a different family name. The Etsy order page shows you one order with personalization that reads something like:

If you track this as one row in a spreadsheet, you're staring at a wall of text every time you check that order. You can't mark item #4 as done without checking off "the whole order." You can't tell at a glance how far through the set you are. If you get interrupted halfway through, you can't resume cleanly.

The fix is to break each multi-item order into individual checkbox rows — one row for item #1, one for item #2, and so on through item #6. Each row has its own personalization. Each row gets checked off as that specific item is finished. This single change is the difference between a system that scales and one that breaks at volume.

What this looks like for different verticals

The "one row per item" principle applies across every made-to-order vertical, but what each row contains differs by craft.

Embroidery and custom apparel

Each row should contain: blank type (the specific shirt or sweatshirt model), color, size, personalization text or design, and thread color. For monogram orders especially, the order matters — "MJS" with initial size emphasis is different from "S in the middle, smaller M and J on either side." Track the structure, not just the letters.

Jewelry and engraving

Each row should contain: metal type (sterling silver, 14k gold fill, etc.), chain or band length, personalization text or date, font choice, and finish. Jewelry orders often have a proof or approval step before production — track whether the proof has been sent and approved separately from the make/polish/ship steps.

Candles, soap, and bath

The grouping unit is the batch, not the individual unit — most candle makers pour multiple candles in one batch. The row structure should be: scent, vessel size, label text, color, and batch identifier. If you're pouring 20 candles in one batch where 8 are for one customer and 12 are for three other customers, you need to know which finished candles go to which orders.

Laser and wood engraving

Each row should contain: material type and size (12x18 maple, 8x10 acrylic, etc.), personalization text, font, and finish. The bottleneck for most laser shops is machine time and material setup — grouping orders by material to minimize material changes is the production efficiency unlock.

Pet products

Each row should contain: pet name, breed or size, item type and color, and any additional personalization. Pet orders often have emotional weight buyers care about deeply, which means double-checking spellings and details before production is especially important.

How experienced sellers actually do it day-to-day

Below is the workflow that recurs most often among sellers running 30+ custom orders per week, based on common patterns from seller communities and operational discussions across crafts. Specific implementations vary, but the structure is consistent.

1. Morning sync. First thing in the workday, pull all open orders into the production system. This is automatic if you're using a tool that reads Etsy directly; manual if you're in a spreadsheet.
2. Sort by ship date. The most urgent orders rise to the top. Anything shipping today gets visually flagged in red or moved to a "make today" section.
3. Group by craft pattern. Orders are physically batched by what makes them efficient to produce together. Embroidery shops group by blank color and thread color. Candle makers group by scent. Laser shops group by material.
4. Make in sequence. Each item gets made and checked off individually. The system shows the personalization detail right next to the checkbox so there's no ambiguity about what to make.
5. End-of-day check. Confirm that what was finished matches what's marked done in the system. Catch any drift before it becomes a shipping error.

The crucial structural difference between this workflow and a chaotic one is that the production system is visible — you can see what's done, what's left, and what's urgent at a single glance. Spreadsheets struggle with this because they're text-heavy. Production-specific tools handle it because they're designed around the production visibility problem.

The free template — and when you'll outgrow it

If you're not yet at 30 orders per week, a well-built Google Sheets template will hold you for a while. The structure should be:

• One sheet per active period (the current week, or a "Today" / "This Week" / "Future" split)
• One row per item being made, not per order
• Columns for buyer name, item type, personalization detail, material/color/scent, ship date, and status (a checkbox or dropdown)
• Conditional formatting that highlights ship-today rows in red
• A "completed today" archive sheet so you can see what was finished, not just what's pending

That template will get you to about 20 orders per week before maintenance becomes painful. Beyond that point, the math changes — if you're spending 30 minutes per day on data entry to keep the sheet current, you're losing 2.5 hours per week on administration that should be production time.

When to switch to an automated tool

The specific moment to switch isn't about volume in the abstract — it's about cost. Whatever you charge per item, do this math: how many hours per week are you currently spending on order organization? Multiply that by what your time is worth (most makers should value their time at $25-50/hour at minimum). If that monthly cost exceeds the cost of a tool that automates the work, the tool pays for itself.

For a shop running 30 orders per week, spreadsheet maintenance typically costs 3-5 hours per week. At $30/hour that's $90-150 per week of unpaid labor going into administration. A tool like ShopFlow costs $12.99/month or $129/year — meaning even a 30-minute weekly time savings recoups the cost.

What ShopFlow does differently

ShopFlow is a Chrome extension built specifically for the post-sale production problem in custom Etsy shops. It reads your Etsy orders page automatically — no copy-paste, no manual entry — and uses two systems called SmartParse and ShopIQ to turn each order into a production checklist:

• SmartParse reads every order automatically and extracts the personalization details. It splits multi-item orders into individual checkbox rows. It identifies materials, colors, sizes, fonts, scents, and special instructions from buyer notes.
• ShopIQ learns your specific shop over time. Each time you correct a parse, ShopIQ permanently improves SmartParse's understanding of your listings. Most shops reach near-perfect parsing accuracy within a week of use.

The result: instead of spending 30 minutes a day updating a spreadsheet, you open ShopFlow and your production sheet is already organized. Ship dates flagged. Personalization parsed. Ready to make.

Frequently asked questions

The bottom line

Custom Etsy shops break in predictable ways at predictable volumes. The signs are universal: you're spending too much time updating your tracking system, you're losing rush orders in the noise, and you're occasionally shipping the wrong item because the personalization wasn't visible at the point of production.

The fix isn't a better spreadsheet. It's a system designed for where you actually are now — built around individual items rather than orders, surfacing ship dates visually, and removing the manual data entry that takes 20-30 minutes a day. For shops at the 30+ orders per week threshold, a tool built specifically for the post-sale production problem is the realistic answer.