Free Craft Fair Inventory Sheet (template)

What is in the sheet

Column	What goes in it
Product	The item name
SKU	Your product code
Price	Selling price per unit
Qty brought	How many you packed for the fair
Qty sold	Fill in as you sell, or tally at the end
Qty left	Brought minus sold
Revenue	Sold times price
Notes	Restock reminders, best sellers

Qty left is Qty brought minus Qty sold, and Revenue is Qty sold times Price. In Google Sheets or Excel you can make those two columns formulas so they total themselves.

Where a sheet stops helping

A sheet is a great way to run a single market day. It falls short the moment you also sell online. The stall does not know what Etsy sold, and Etsy does not know what the stall sold, so your counts drift and you oversell. That is the exact problem covered in how to stop overselling on Etsy.

Stockria keeps one stock count across your markets and your online channels. It works offline at the stall, so you can sell with no signal, then syncs to Etsy, Shopify, Square, and Amazon when you reconnect. Your Saturday market no longer leaves your online listings selling stock that is already in someone else's bag. Start free for up to 250 items, or see the makers and Etsy sellers guide.

Frequently asked questions

What should a craft fair inventory sheet track?

At minimum: each product, its price, how many you brought, how many sold, how many are left, and the revenue. That lets you reconcile your cash at the end of the day, see your best and worst sellers, and know exactly what to restock before the next market.

How do I use this template?

Download the CSV and open it in Google Sheets or Excel. Replace the example rows with your products and the quantities you are bringing. As you sell, update Qty sold, or tally it at the end of the day. Qty left is brought minus sold, and Revenue is sold times price. In a spreadsheet you can turn those two into formulas.

Is the craft fair inventory sheet free?

Yes, free to download with no signup. A sheet is a great start. The catch is that it does not update your online stock, so if you also sell on Etsy or your own site, you can still oversell. Stockria works offline at the fair and syncs your counts to every channel when you reconnect.

Can I track markets and my online store together?

That is exactly where a spreadsheet stops helping. Stockria keeps one stock count synced across your markets and your online channels (Etsy, Shopify, Square, Amazon), works offline at the stall, and updates everywhere once you are back online, so a market sale cannot leave your Etsy listing selling stock that is gone.