Get in Touch

When you're the maker, the shipper, and the inventory manager all at once.

Running a handmade business alone means your inventory system has to work with you, not against you. It needs to be fast to update, easy to read under pressure, and forgiving when you forget to update it for three days.

A solo maker in her early 30s working alone in a small organized studio, surrounded by handmade products, a laptop open to a spreadsheet, and shipping supplies on a wooden worktable

The system has to fit between making and shipping

Inventory management advice is often written for businesses with a dedicated person whose job is inventory. You are not that person. You're the person who makes the products, photographs them, lists them, packs them, ships them, answers customer messages, and somewhere in there updates a spreadsheet.

This means the system has to be genuinely fast. If updating your inventory takes more than two minutes after an order, you won't do it consistently. And inconsistency is where oversells live.

We write about systems designed for this constraint. Not theoretically efficient systems. Systems that work when you have twelve minutes between a batch coming out of the kiln and the mail carrier arriving.

What makes an inventory system work for one person

01

One place to look

Your phone, your laptop, your tablet, and your desktop all need to show the same number. This means cloud-based. Google Sheets works well here because it syncs automatically and you can access it from any device. The moment your spreadsheet lives on only one computer, it stops working as a system.

02

Update immediately or not at all

The inventory update that happens "later" often doesn't happen. Build your habit around updating the sheet the moment you fulfill an order, not after you've packed everything. Two minutes now prevents an oversell conversation tomorrow. The habit matters more than the system design.

03

Conservative quantities on all platforms

If you have 10 units, list 8 on Etsy and 8 on Shopify. The 2-unit buffer gives you time to update. It means the collision window, the period where both platforms could sell the same unit, is smaller. Some makers use a 10% or 15% buffer. The right number depends on how fast your items sell and how reliably you update.

04

Know your riskiest items

Not all items carry equal oversell risk. An item with 2 units left that sells quickly on both platforms is high risk. An item with 40 units that sells slowly is low risk. Spend your update attention on the high-risk items. Check those quantities more often. Update those first.

November and December change everything about how your system behaves

A system that works fine in July may fail completely in November. Not because you built it wrong, but because the volume of orders per hour is different. What took two minutes to update in July takes six minutes in November because there are three orders to process, not one.

We think about Q4 inventory management for solopreneurs as having two distinct phases. Before November 15th, you're in production mode. You're making things, building stock, and your update cadence can be daily. After November 15th, you shift to protection mode. You're updating immediately, checking quantities multiple times per day, and being more aggressive about lowering platform quantities to give yourself buffer.

The transition between these phases is worth planning consciously. It doesn't happen automatically.

Production Mode

Focus on making stock. Update inventory daily. Platform quantities can lag slightly. The risk is low because you're adding units faster than you're selling them.

Protection Mode

Stop making new items. Focus on accurate quantities. Update immediately after every order. Lower platform quantities conservatively. The risk is high because you're depleting stock faster than you can make it.

What you can build your system with right now

Google Sheets

Free, cloud-synced, accessible from any device, shareable with a partner or helper. Formulas can calculate available quantities automatically. Works well as a central source of truth.

Google Sheets Mobile App

The mobile version lets you update inventory from your phone immediately after packing an order. You don't need to be at a computer. This is important for update speed and consistency.

Etsy and Shopify Email Notifications

Both platforms can send you an email for every order. These emails serve as prompts. When the email arrives, you update the sheet. The email is the trigger, not the memory.

A Weekly Review Habit

Once a week, do a physical count of your most popular items and compare it to your sheet. This catches drift before it becomes a problem. It takes fifteen minutes and prevents the kind of surprises that ruin a Saturday morning.

See these principles in action with actual numbers.

The real-number examples section walks through specific scenarios with the kind of detail that makes the abstract concrete. Quantities, timings, decisions, and outcomes.

See Real Examples

Worked inventory scenarios for multi-platform makers, with real math.

Have a question? Reach out