Craft Fair Inventory Tracker: What to Count Before, During, and After a Show

A craft fair inventory tracker should answer one question after the bins are unpacked: what happened to every item you brought? Record what you packed, what reached the display, what sold, what was removed for another reason, and what returned. Then compare those movements with payment records and event costs.

Paper, a spreadsheet, or an app can work. Choose the tool you can keep accurate during a rush, and add software only when it removes work.

Choose the right counting unit: quantities, unique items, or both

Before making a craft fair inventory sheet, decide what one row represents.

Track quantities when units are interchangeable, such as 24 bars of the same lavender soap at the same price and cost. Track unique items when each piece has a different cost, price, or identity, as with original art or one-of-a-kind jewelry. Use both methods when your booth combines repeatable products and unique work.

Quantity tracking is faster; unique-item tracking preserves item-level costs and sales. Use only the detail your team can maintain.

For each product or unique item, record at least:

• SKU or item ID
• Clear product name or description
• Unit cost entered using your consistent costing method
• Regular price
• Quantity packed for the show
• Quantity displayed or available at opening
• Quantity sold
• Quantity damaged, sampled, gifted, or otherwise removed
• Quantity returned to studio or storage
• Actual sale amount when discounts or bundles change the total

For handmade products, unit cost might include materials, labor, and allocated overhead. Document your method and apply it consistently; no tracker can discover actual costs from a product name.

Treat each show as a temporary selling location

Keep one master catalog and treat each event—such as Riverfront Craft Fair — Aug 25—as a temporary selling location. Track inventory moving from studio or storage to the event, then to sales, removals, returns, or the next location.

This prevents the event list and studio count from disagreeing without a record of which is current. The same principle applies across booths and storage; see How to Track Inventory Across Multiple Antique Mall Booths for a broader location workflow.

Before the show: count what is actually packed

A production plan is not a packing count. Count the sellable units physically placed in containers and record exceptions before departure.

A practical craft show inventory template can use these columns:

“Displayed at opening” plus “reserve” should equal the stock available at the event. If a box is left behind or something breaks in transit, record it rather than changing the packed count.

Before closing each container:

• Confirm that each counted unit is finished, labeled, and sellable.
• Separate display-only props, testers, and samples from sellable stock.
• Record packed quantities by SKU or each unique item ID.
• Label the container so helpers can replenish the right display.
• Note any stock intended for another booth, order, or event.
• Save a paper or phone-accessible copy for setup.

At the venue, record exceptions such as transit damage, forgotten boxes, samples, or transfers. Your opening event quantity is what actually became available for sale.

During the show: capture sales without slowing the line

Choose a normal sales method and a simpler fallback before the doors open.

Option 1: Use a paper tally

A printed craft fair inventory list is fast and device-free. Mark each unit beside its SKU or cross off each unique item ID. Keep one designated sheet rather than several scraps held by different helpers.

Option 2: Use itemized checkout records

If your checkout system records products and variants, its item counts can support reconciliation. Test it before the show and ensure helpers choose the actual product. Generic custom-amount transactions preserve payment totals but lose inventory detail. Unless you have verified an integration, expect to reconcile or transfer sales manually.

Option 3: Record each sale in an inventory tracker

A phone-friendly craft show inventory tracker app can keep items, locations, and manually entered sales together. Test the number of taps, device setup, and connection needs. Do not assume barcode support, point-of-sale syncing, or offline operation unless the tool explicitly provides it.

Your rush-hour fallback

When the normal workflow becomes too slow, capture the minimum information needed to reconstruct the sale:

• SKU or unique item ID
• Quantity
• Actual amount collected if it differs from the regular price
• Payment type or transaction reference when useful
• A short reason for a discount, bundle, exchange, or comp

A preprinted tally sheet and pen make a good fallback even if your primary system is digital. When the line clears, enter the pending records. Assign one person to do this, and mark each tally as transferred so it is not entered twice.

Never “fix” inventory later by inventing sales to make the ending count match. A discrepancy is information. Preserve it until you can compare your tally, payment record, and physical stock.

Keep units moved separate from money collected

Inventory movement and revenue are related but distinct. If three $6 cards sell through a three-for-$15 offer, record three units sold and $15 collected—not one generic bundle unless it is intentionally stocked with consistent component handling.

Apply the same discipline to exceptions:

• Discount: preserve the regular price and record the actual sale amount.
• Exchange: return the original item to available inventory only if sellable, then record the replacement leaving.
• Damage: remove the unit with a damage reason, not as a sale.
• Sample or gift: record the removal reason and no sales revenue.
• Refund: preserve the original sale and clearly record the refund and resulting inventory status.

This explains why units moved may not equal revenue divided by regular price.

After the show: count before mixing stock back in

Count remaining stock while it is separate from studio inventory. Once it is mixed with items that never left, reconciliation becomes much harder.

Use this equation for every SKU or item group:

Opening event quantity − units sold − documented non-sale removals = expected returned quantity

Then compare expected returns with the physical returned count:

Physical returned quantity − expected returned quantity = inventory difference

For the candles in the table:

• Opening event quantity: 18
• Units sold: 11
• Tester given away: 1
• Expected return: 6
• Physical return: 6
• Difference: 0

If only five candles return, investigate the difference while the show is fresh. Check for an unrecorded cash sale, breakage, a gift, a misplaced unit, a duplicate tally, or an opening-count error. Note any final adjustment rather than changing sales to force a zero. Keep returned sellable stock separate from returned damaged stock.

Reconcile inventory with revenue

A zero inventory difference does not prove the revenue record is complete. Compare the closeout with each payment source:

1. Total recorded sale amounts by payment type.
2. Compare card sales with the payment processor or checkout report.
3. Compare expected cash with counted cash after removing the starting float.
4. Review discounts, refunds, exchanges, tips, tax collected, and payment fees separately where applicable.
5. Investigate mismatches without changing item records prematurely.

Processor deposits may be lower than card revenue because fees were withheld. Tax collected may not be business income, and tips do not correspond to inventory. The goal is to explain differences with documented transactions, using definitions appropriate to your business and professional accounting or tax advice when needed.

Calculate the event result using recorded costs

Gross sales show activity, not whether a show was financially worthwhile. Separate the relevant layers:

This example is illustrative, not a benchmark or profit promise. The $545 is only the amount remaining after listed costs—not automatically tax net profit or take-home pay. Labor, preparation, overhead, insurance, taxes, damage, and other expenses may still be excluded.

Track damage explicitly. Two broken mugs with an entered cost of $11 each produced no revenue but still represent $22 of product cost. Record labor and travel time too. Two events can leave the same amount after listed costs while requiring very different effort.

For a fuller framework separating sales, cost of goods, fees, and profit, read How to Calculate Your Real Profit Selling at Antique Malls. The examples focus on antique malls, but the distinctions apply to craft events.

Use the closeout to improve the next packing list

Calculate sell-through consistently:

Units sold ÷ opening event quantity = unit sell-through rate

Opening with 10 blue mugs and selling 7 gives a 70% unit sell-through rate for that event. It does not prove you should always pack more: weather, attendance, placement, season, price, and stockouts all matter. Compare similar events over time.

Ask:

• Which products sold out early, and at what time?
• Which products contributed the most dollars after their entered unit costs?
• Which products occupied display space but had little customer interest?
• Which price points led to purchases or bundles?
• What did customers request that was unavailable?
• Which products were damaged or difficult to transport?
• Did discounts increase units moved while leaving an acceptable amount after costs?
• Was the event worth its fee, travel, and time based on the information recorded?

Use history to guide stocking and pricing, not to predict demand or guarantee sales.

Printable sheet, spreadsheet, or app?

A printable craft fair inventory sheet is fast, resilient, and easy to share with a helper, but requires totaling or transfer later. A spreadsheet can calculate expected returns and compare events; use one master product table with event movement and cost records, protect formulas, and design the event view for the device or page you will use.

A craft show inventory tracker app may reduce duplicate entry when it connects items, temporary locations, entered costs, manually recorded sales, fees, and reports. Evaluate the actual workflow rather than assumed integrations or features.

The right choice is the lightest system that produces a reliable closeout. A completed sheet beats an elaborate app abandoned at noon.

Craft fair inventory checklist

Before the show

• Decide whether each product is quantity-tracked or uniquely tracked.
• Create a named temporary location for the event.
• Enter or confirm each item's cost and regular price.
• Count the sellable stock physically packed.
• Separate props, testers, samples, and damaged goods.
• Label reserve containers by product or category.
• Print or save the craft show inventory template.
• Put the rush-hour tally sheet and pen where every helper can find them.

During the show

• Record every sale by SKU, item ID, or product quantity.
• Record actual amounts for discounts and bundles.
• Keep damage, gifts, samples, exchanges, and transfers separate from sales.
• Use the fallback tally when the normal workflow slows the line.
• Transfer fallback entries once the rush ends and mark them complete.

After the show

• Count stock before returning it to studio inventory.
• Separate returned sellable stock from damaged stock.
• Reconcile opening, sold, non-sale removals, and returned quantities.
• Compare recorded revenue with card, cash, and other payment records.
• Record booth fees, payment fees, travel, supplies, damage, and other known event costs.
• Note unexplained differences instead of inventing a balancing sale.
• Review sell-through, amount remaining after recorded costs, and time required.
• Transfer remaining stock to its next real location.
• Use the findings to prepare the next packing list.

If you want to keep the core item, location, sale, fee, and cost records behind this workflow in one purpose-built system, MaxIMS can keep item inventory, seller-entered true-cost inputs, selling locations and location fees, manually recorded sales, and profitability based on recorded information together. It does not discover costs, sync live point-of-sale sales, guarantee that every cost was recorded, recommend prices, predict demand, promise offline or barcode workflows, or guarantee profit.

Start with the checklist. If paper or a spreadsheet provides dependable counts and a timely closeout, keep it. If maintaining separate records has become the problem, review the MaxIMS features and current plan limits to decide whether it fits your process.