Skip to content
SLC

Craft Fair Inventory Planner

Turn your sales target and product mix into the number of units to bring for each product. Everything uses your numbers — this doesn't predict what will sell.

Your event

The total sales you're planning for, before sales tax. Use your own goal, or a figure from Should I Book This Craft Fair? or Market Day Breakdown.

Your product mix

Add each product you'll bring and the share of your sales target you're planning it to make up. The shares should add up to 100%.

0% allocated

Adds two optional fields to each product. Turning this off hides them and leaves them out of the results; your entries are kept.

Product 1

Product 1 details

One row per item as you sell it. A bundle or set gets its own row at its bundle price.

Price per unit as you'll sell it at the event.

The part of your target you're planning this product to bring in.

—

Product 2

Product 2 details

One row per item as you sell it. A bundle or set gets its own row at its bundle price.

Price per unit as you'll sell it at the event.

The part of your target you're planning this product to bring in.

—

Product 3

Product 3 details

One row per item as you sell it. A bundle or set gets its own row at its bundle price.

Price per unit as you'll sell it at the event.

The part of your target you're planning this product to bring in.

—

Your inventory plan

Plan not started

Add each product's share of your sales target. The shares should add up to 100%.

Start with your sales target, then add your products and their shares.

Units planned so far

—

Planned units are based on the target and shares you entered, rounded up to whole units. They aren't a forecast of what will sell.

All calculations are estimates based on average platform fees. Real profits may vary depending on category, ads, and shipping.

Free worksheet for your next step

Use this worksheet to turn material costs and time into a real price.

  • TrackerHandmade

    Handmade Inventory Tracker

    A printable, fill-in-by-hand tracker for raw-material inventory, work in progress and finished goods, with supply reorder planning, recorded inventory cost valuation, stock movement, a monthly review and inventory planning. Recorded cost value is kept separate from retail value: in the worked example, raw materials at $460, work in progress at $120 and finished goods at $980 give a total recorded inventory cost value of $1,560, while the finished-goods retail value of $1,794 is a separate measure that must not be added to recorded cost value. The illustrative sell-through of 337 units sold ÷ 490 available = 68.8% applies only when the period and unit basis are consistent, and the corrected reorder example identifies three supplies below their reorder thresholds. Examples are teaching assumptions, not current supplier prices, standard reorder thresholds, financial benchmarks, tax rates or guaranteed outcomes.

    Open the tracker →
  • ChecklistHandmade

    Craft Fair Packing Checklist

    A printable packing and setup checklist for craft fairs, maker markets and holiday markets — pack, set up, open and pack down without relying on memory.

    Open the checklist →
  • PlannerHandmade

    Craft Fair Profit Planner

    A printable, fill-in-by-hand planner with 13 planning sections for event budgeting and booth costs, inventory planning, product pricing, sales goals, break-even calculations and estimated event profit. Prepare for event day, review actual results after the fair and choose your next actions. Worked examples are teaching assumptions, not current marketplace fee rates, universal benchmarks or guaranteed outcomes.

    Open the planner →

How to use this calculator

  1. Enter your numbers in each field above — the calculator updates instantly as you type, so there's nothing to submit.
  2. Use your real figures when you have them, or sensible estimates while you're planning. If a field doesn't apply, leave it at zero.
  3. Compare the results, then change one input at a time to see how each lever (price, cost, fees, volume) moves the outcome.

Formula

Allocated sales = sales target × share ÷ 100 · Planned units = allocated sales ÷ selling price, rounded up to a whole unit · Units to bring = planned units + any extra units you add · Still to prepare = units to bring − units already ready (never below 0)

Worked example

Example numbers: sales target $1,000. Earrings $25 at a 40% share, mugs $30 at 30%, prints $15 at 30%.

  1. Earrings: $1,000 × 40% = $400; $400 ÷ $25 = 16 exactly → 16 units
  2. Mugs: $1,000 × 30% = $300; $300 ÷ $30 = 10 exactly → 10 units
  3. Prints: $1,000 × 30% = $300; $300 ÷ $15 = 20 exactly → 20 units

Answer: 46 planned units in total for these example numbers: 16 earrings, 10 mugs and 20 prints

How it works

You enter one sales target for the event and split it across your products as shares. Each product's share of the target is divided by its price and rounded up, because you can't bring part of a product. The shares are never rescaled: if they add up to less or more than 100%, the plan still calculates and says so.

If you turn on the stock comparison, you can enter how many units of each product are already ready, plus any extra units you choose to bring. The planner then shows how many more you'd need to make for this plan.

How to interpret your results

  • Dollar values are shown per sale, per order, or per item unless a result is explicitly labelled monthly, weekly, or daily.
  • Percentages (margin, ROI, conversion rate) are easier to compare across products and price points than raw dollars — use them when you benchmark.
  • A positive result means you're ahead after the costs and fees you entered. A negative result means the current numbers don't work — change a lever (raise price, cut a cost, lower ad spend) and recalculate.
  • Treat the output as a planning estimate, not a guarantee. Fees, taxes, and conversion rates shift over time — re-run the numbers whenever a key input changes.

Common mistakes

  • Leaving the shares short of 100% and reading the total as the whole plan.
  • Entering a bundle's components as separate rows instead of giving the bundle its own row at its bundle price.
  • Treating blank ready units as zero — leave the field blank if you're not sure, and enter 0 only when none are ready.

Related Guides

Go deeper with plain-English guides on the same topic.

FAQ

Does this tell me how much will sell?
No. It turns the sales target and shares you enter into whole units. It can't predict what people will buy.
Where does my sales target come from?
It's your own number. If you don't have one, Should I Book This Craft Fair? shows what an event would need to sell to reach your profit target, and Market Day Breakdown projects a day from the sales you expect.
What does "share of your sales target" mean?
It's the part of your target, in dollars, you're planning a product to make up. Example numbers: with a $1,000 target, a 40% share allocates $400 of the target to that product.
Why are units rounded up?
You can't bring part of a product, so each quantity rounds up to the next whole unit. Because each product rounds separately, the planned value can be higher than the sales amount allocated to it. The breakdown shows the allocation, whole-unit quantity and resulting value.
How do bundles work here?
Give each bundle or set its own row at its bundle price — its units are bundles. This planner does not expand bundles into their component items. If a bundle uses products you also sell individually, account for the components needed for those bundles in your own stock records or Handmade Inventory Tracker so the same physical stock is not accidentally counted twice. To check a bundle's price, use the Product Bundle Calculator.
How is this different from the Handmade Inventory Tracker?
This plans quantities for one event before it happens. The Inventory Tracker is an ongoing record of your materials and stock.

Why trust this calculator?

This tool uses standard mathematical formulas and commonly accepted calculation methods, shown openly in the Formula section above so you can verify the math yourself. Results are estimates based on the information you enter and do not account for every individual circumstance. For important financial, tax, legal, medical, or business decisions, please double-check with a qualified professional before acting on the numbers.

What to calculate next

Make sure each product's price covers its costs before you prepare more stock.

Related calculators

You may also find these tools helpful.

Related Guides

Related Calculators

Recommended Downloads

Continue Learning