How Much Inventory to Bring to a Craft Fair

How Much Inventory to Bring to a Craft Fair (Use Last Fair's Numbers)

How much inventory to bring to a craft fair depends on past sales, the products that moved, and what you can carry. Plan each item’s count.

By · Editorial policy

Published · 8 min read

How Much Inventory to Bring to a Craft Fair (Use Last Fair's Numbers)

For how much inventory to bring to a craft fair, start with sales from a similar event. Split the total by product, then check what you can carry. At your first event, choose a manageable quantity and record what happens.

Work out the count by product. A total of 60 pieces can still be a poor plan. You may pack too many slow movers and run short on the item people ask for. Separate display stock from the boxes underneath.

If you already sell at fairs, a stock spreadsheet for small sellers can hold the brought, sold, and returned counts in one place. This guide shows a practical way to build the next event's list from the previous one.

In Short

  • Start with sales from a similar event, when available.
  • Split the total by product using your own sales mix.
  • Set a carry and display limit for each product.
  • Keep reserve pieces separate from the table count.
  • Count what comes home and write down what sold out.

Craft fair stock: a simple planning formula

A craft fair stock plan is a product-by-product count for one event. Start with this formula: next fair quantity = expected sales from a comparable event + reserve you can carry and replenish. If you have no comparable event, use a modest first-event quantity you can make and transport. Record it as an estimate, not a forecast.

Field What to enter Why it belongs
Event Name, date, and type of fair Lets you compare similar days later
Product One row for each design or variant Keeps the mix visible
Brought Units packed for the event Sets the starting count
Sold Units sold at the event Shows this event's sell-through
Returned Units physically counted after the fair Checks the movement
Sold out Time or point when none remained Signals a possible missed quantity
Next quantity Expected sales plus a chosen reserve Makes the next packing choice explicit

Use a reconciliation check too: brought = sold + returned + other recorded changes. “Other” can include a damaged piece, a sample, or a gift. Write the reason beside it. If the totals do not match, check the sale notes and the box before using the result to plan another event.

Sell-through is the share of the quantity brought that you sold. Calculate it per product as units sold divided by units brought. Keep that result with the event record, because a single total hides which products moved.

This formula gives you a starting point from your own event record. Attendance and product mix can still change, so check the event details and your carrying limit before packing.

A simple illustration showing past fair tally cards leading to grouped products and separate display and reserve stock

The fair weekend, worked through

In this worked example, a maker packs 60 pieces for a fair, sells 37, and brings 23 home. The arithmetic balances: 60 packed equals 37 sold plus 23 returned. On Monday, the maker enters the 37 sales in the tally sheet and keeps the 23 remaining pieces in the stock count. These are illustrative figures, not a customer result.

That total helps with the next fair, but it does not answer which designs sold. The maker needs a row for each product or variant. Suppose the 60 pieces were candles, soap bars, and gift sets. A single total of 37 sales hides which group accounted for them, so the tally should split sales by those product rows.

The example does not assign a product mix or demand pattern. Record each product on its own row. If one candle scent sold out while a gift set barely moved, the next packing list can reflect that instead of repeating the same mix.

Before assigning a new quantity, count what is already finished and ready to sell. Then check the supplies and production time required for any additional pieces. A product that looks popular can still be a poor last-minute batch if the ingredients, curing time, or packing materials are not available.

Sales tab showing a log where each fair sale can be recorded by product and place

How to choose quantities for each product

The table below gives a decision rule for turning last fair's results into a packing count. It uses the event record first, then adjusts for a clear reason such as a sellout, a different event format, or a practical carrying limit.

What your record shows Next fair choice Check before packing
A product sold steadily and stock remained Start near the units sold, then choose a small reserve if useful Can you carry and store the reserve?
A product sold out before closing Consider a modest increase for a similar event Could the event or audience differ?
Many units came home Bring fewer, or leave the item off this event's list Is it seasonal or suited to a different fair?
No sales record exists Pick a small test quantity you can afford to bring back How will you record each sale?
A product is bulky or fragile Set a firm transport limit Can it be protected and displayed safely?

A sold-out item is a clue, not proof that every extra piece would have sold. Record when it ran out and whether shoppers asked for it afterward. If the item sold out close to closing, the next quantity may stay near the old count. If it was gone early and the event was similar, a small increase is easier to explain.

When stock came home, look at the product and the event before cutting the quantity. A slow item may fit a different season or audience. If it takes valuable space and has no clear reason to return, leave it at home and give that space to a product with stronger evidence.

Shopify's craft fair planning guide recommends giving more room to stronger sellers and less to slow movers. Use that as a prompt to check your own sales record, rather than borrowing another seller's product ranking or a universal percentage.

Set a display count and a reserve count

The display count is what goes on the table. The reserve count is what stays packed for restocking. Separate counts show whether the table is ready and how much stock sits in the boxes. They also make it easier to spot more reserve than you can move or manage.

For each product, write three quantities: total available, display quantity, and reserve quantity. The display plus reserve should not exceed the total you have ready. If a product needs careful handling, decide how many pieces can sit out safely and keep the rest protected.

Etsy's craft fair packing advice covers inventory alongside display and event supplies. Its spring show preparation checklist also recommends reviewing leftover stock and using previous event sales when planning. A separate reserve count makes those checks easier to do with your own products.

Some events run for more than one day. If so, count the reserve before each day and record sales at the end of each day. Do not treat stock left in a vehicle or storage area as available until you have checked access and the event's rules.

Stock by Place view showing quantities separated between a home location and a market location

A packing list you can improve after each fair

Build the list around products, not boxes. One product row can hold the quantity you plan to take, the number for the display, and the reserve count. Add a note when the quantity comes from a past event or a first-fair estimate.

  1. Choose a comparable event. Compare a one-day indoor fair with another similar day when possible. Note differences in season, length, or event type.
  2. Count ready stock. Separate finished pieces from supplies you could use for another batch. Do not count materials as sellable products.
  3. Split by product. Keep sizes, scents, colours, or designs on different rows when you count them separately.
  4. Set limits. Record the display space, transport capacity, and any product handling needs that constrain the quantity.
  5. Pack the reserve separately. Label each box or container with its contents so you can find the right item without unpacking everything.
  6. Record sales and returns. At pack-down, count the pieces that came back and note damage, samples, and sellouts.
  7. Update the next plan. Keep the event record. Change only the product quantities for which you have a clear reason.

Etsy's before-the-show worksheet suggests reviewing existing stock and materials before producing more, and organizing containers with a list of contents. That is also a useful final check: use what is already ready before you plan another batch.

For a simple printable record, use this inventory count sheet. If you need the underlying item and movement fields first, the inventory spreadsheet guide explains how an item list and sales entries work together.

When this method needs a fresh starting point

Past sales help when the events are reasonably comparable. A new venue, season, event length, or product line can change the mix. Mark that change beside the new plan so you do not treat last year's count as a reliable match without checking it.

If this is your first fair, you have no fair sales to use. Choose quantities that fit the products you can finish, carry, and display. Keep the choice small enough that bringing it home remains manageable. The first fair gives you a record for the next decision.

A count also cannot prevent a product from selling faster than expected. It tells you what you brought, what you sold, and what remains. If you sell at the fair and online at the same time, record each sale yourself. The Ultimate Inventory Tracker has no online shop or till connection and does not scan barcodes.

How the Ultimate Inventory Tracker handles fair stock

The Ultimate Inventory Tracker (by Cosmo Suite: one Google Sheets and Excel file, 12 tabs, $9 once) has Products, Sales, Transfers, Adjustments, and stock by place. You can log the quantity moved to a market, record each sale, and count what comes back. The file shows the entries you make; you still need to log or paste each sale.

The Google Sheets and Excel inventory file includes a sample copy and a clean copy. Use the sample to see how its rows are arranged, then decide whether the fields fit your fair routine. The file does not connect to an online shop or a till, and it does not scan barcodes. The About page identifies the publisher, and the editorial policy explains how the site checks its content.

If you already have a process that records each event, keep using it. If your counts drift between fairs, a stock tracker can keep item counts and movement entries together. The inventory count sheet can help you record what comes home.

Frequently asked questions

How much inventory should I bring to a craft fair?

Start with sales from a similar event. Split the units by product using the mix that sold before. Add a small reserve only for items you can carry and replenish. At your first fair, record what sells and comes home.

How do I estimate stock for my first craft fair?

Choose a quantity you can make, carry, and display without disrupting regular orders. Pick a few product groups and write down why you chose each amount. Treat the first fair as a baseline. Record units brought, sold, and returned for your next plan.

Should I bring all my products to a craft fair?

Bring products that suit the event, your display, and your transport limit. Slow or bulky items can make packing harder. If the organizer allows it, take a sample or product card for anything you cannot carry. Accept custom orders only when you can fulfill them.

How much extra stock should I bring?

No extra-stock percentage fits every seller. Use past sell-through and note when an item sold out. Add reserve when your record supports it and you can carry it safely. Keep reserve separate from display stock.

What should I record after a craft fair?

Record units brought, sold, and returned. Note any damage, samples, and items that sold out. Check that brought stock minus sold units and other recorded changes equals what came home. Keep the event and date with the record so you can compare it with a similar fair.

Can a spreadsheet track stock at a craft fair and online?

Yes. A spreadsheet can hold the stock and sales entries you make. The Ultimate Inventory Tracker does not connect to an online shop or a till, and it does not scan barcodes. You log or paste each sale, then record what went to the fair and came back.

Sources

  1. Etsy Seller Handbook: What to Bring to a Craft Fair
  2. Etsy Seller Handbook: How to Get Ready for Spring Craft Shows
  3. Shopify: How to Sell at a Craft Fair in 2026

Ultimate Inventory Tracker

Ready for the Ultimate Inventory Tracker?

Log each sale, purchase and batch once. One stock file you own, pay once.

Get instant access
Ultimate Inventory Tracker