Keep one master inventory list, treat every place you sell as pulling from it, and lower your online quantities before an in-person event. Most overselling happens because Etsy, a craft fair table and any other shop each keep their own count, and nothing updates the others unless you do. A notebook or a simple spreadsheet is enough for most small shops; software starts to make sense once you have many products on several channels.
Why it goes wrong
Overselling usually comes down to one of these:
- Separate counts. Etsy knows how many of an item you listed. It doesn't know you sold three at Saturday's market unless you tell it.
- In-person sales that never get recorded. At a busy table, it's easy to take payment and move on without writing anything down.
- One-of-a-kind items listed everywhere. If a single item is live on Etsy while it's sitting on your fair table, it can sell twice in the same hour.
- Updating later. Even with good notes, a gap of a day or two between the fair and updating your listings is enough for an online order to come in.
When you oversell, you have to cancel an order and refund the buyer, which frustrates them and costs you time.
A system that works for small shops
You don't need special software. You need one place where the true count lives, and a habit of updating it.
The master list
Use a spreadsheet or a notebook with one row per product (or per variation, like size or color). These columns cover most makers:
| Column | What goes in it |
|---|---|
| Item | Name, plus size or color if relevant |
| On hand | How many you physically have, finished and ready |
| Listed on Etsy | The quantity currently set on the listing |
| At event | How many are packed for the next fair |
| Sold | Running total, with the date and channel |
| Notes | Materials to reorder, items in progress |
The rule is simple: "On hand" is the truth. Your Etsy quantity should never be higher than what's on hand minus what's set aside for an event.
The routine
- Every time you finish a batch, add it to "On hand", then raise the Etsy quantity if you want those items online.
- Every time an online order comes in, subtract it from "On hand". Keep in mind that Etsy only knows about sales made on Etsy, so anything you sell elsewhere has to come off your Etsy quantities by hand, or through the Square sync described below.
- Every time you sell anywhere else, whether at a fair, through a message or in a friend's shop, subtract it from "On hand" and lower the Etsy quantity to match.
- Once a week, count a few items on the shelf and compare them with the list. Small errors are easier to fix than big ones.
Etsy's Create a Listing help page lists quantity in the price and inventory section of each listing, and you can edit a listing at any time.
Before, during, and after a craft fair
In-person events are where most makers get caught out. This checklist closes the gaps.
Before the fair
- Decide what's going. Pick the items you're bringing and write the count in the "At event" column.
- Lower your Etsy quantities. Set each listing's quantity to what's on hand minus what's going to the fair. If everything you have of an item is going, set the quantity to 0 or deactivate that listing for the weekend.
- Handle one-of-a-kinds. If a unique piece is coming with you, take it off Etsy. See the next section.
- Pack a tally sheet. A printed list of what you brought, with space to tick off each sale.
A note on how these Etsy tools behave, from Etsy's help pages:
- Deactivating a listing removes it from your shop page so buyers can't purchase it. It stays in Shop Manager, and you can reactivate it later. Deactivating doesn't pause the listing's four-month period. If it expires while inactive, Etsy asks you to renew it for $0.20 before you can reactivate it (How to Deactivate a Listing).
- Vacation Mode pauses your whole shop: listings are removed from search and can't be bought, while buyers can still visit your shop and message you. It's meant for when you're away or catching up, so it's usually more than you need for one weekend event (How to Manage Vacation Mode).
For a single fair, adjusting quantities or deactivating the specific listings you're bringing is usually the smaller, safer change.
During the fair
- Tick each sale on your tally sheet as it happens, even if the table is busy. A quick mark is enough.
- If someone wants something you didn't bring, take their details and sell it to them later, rather than promising stock you haven't checked.
- If an online order comes in during the event for something on your table, check your list before you ship.
After the fair
- Count what came home. Compare it with what you brought and your tally sheet. Any difference is either an unrecorded sale or a miscount, so sort it out now.
- Update the master list. Subtract fair sales from "On hand" and clear the "At event" column.
- Update Etsy the same day. Raise quantities back up for items that came home, and reactivate any listings you switched off.
- Record sales for your books. Fair sales are income like any other. Keep your tally sheet and card-reader records with your other sales records (see taxes for online sellers). In-person sales may also mean collecting sales tax yourself, which Etsy doesn't handle for sales off its platform; see sales tax for marketplace sellers.
One-of-a-kind items
Unique pieces need stricter handling, because there's no spare to fall back on.
- One place at a time. A one-of-a-kind item should be live in only one place. If it's going to a fair, deactivate the Etsy listing before you leave, and reactivate it if the piece comes home.
- Note where it is. Add a location to its row ("Etsy", "Market Sat 14th", "Consignment at Main St shop") so you always know.
- Consignment. If a piece is sitting in someone else's shop, it shouldn't also be live on Etsy unless you've agreed how that shop will tell you when it sells.
Made-to-order items
Items you make after an order comes in are easier, because you aren't selling from a fixed stock. The limit is your time, not a shelf count. Two things help:
- Set a realistic processing time. Etsy lets you set processing time in processing profiles, and for made-to-order or custom items it should include the time it takes to make the item (How to Set Processing Times).
- Watch your materials. For made-to-order items, the "On hand" column is really your supplies. Track the materials that limit how many you can make.
Etsy's in-person selling option
Etsy has an option for in-person sales through Square, set up from the Sales Channels area of Shop Manager by choosing "Sell in person" and signing up for, or linking, a Square account (the account itself is free). According to Etsy's help page, when you sell a synced item in person, your online inventory adjusts in real time.
The page also notes:
- Syncing from Square back to Etsy isn't supported, so changes you make in Square don't reach Etsy.
- Only physical item listings sync, and there's a limit of 250 variations.
- Etsy doesn't charge an extra fee on synced items sold through Square. Items sold through Square that aren't synced with your listings carry a $0.20 fee per transaction.
- Square charges its own payment processing fees on in-person sales.
If you use it, check that the sync is actually working before your first event, and keep your tally sheet anyway as a backup.
When to pay for inventory software
A manual list works well for a small catalog on one or two channels. Software that connects your sales channels starts to earn its cost when several of these are true:
- You have dozens of products, or many variations.
- You sell on three or more channels at once.
- You're overselling more than occasionally, despite a routine.
- Updating quantities by hand takes a noticeable chunk of your week.
Whatever you choose, check how it handles in-person sales and one-of-a-kind items before you commit, and test it on a few listings first.
What to do next
- Set up a master list today with the columns above, starting with your best sellers.
- Before your next fair, lower or zero your Etsy quantities for what you're bringing, and pack a tally sheet.
- If you're deciding where else to sell, compare platforms in where should I sell?, or weigh an own store in Shopify vs Etsy.
- Browse more guides for Etsy sellers.