You've spent the whole week making things. Now it's the night before the fair, and you're staring at a table full of finished pieces wondering if you made too many, not enough, or just the wrong mix entirely.

That question has a real answer, and this guide shows you how to find it using AI, even if numbers aren't your thing.

Why Craft Fair Inventory Math Trips Up Even Experienced Sellers

Most makers track inventory in their head or on scraps of paper. That works fine until you're selling at five shows a season across different cities, weather conditions, and crowd sizes.

The problem isn't a lack of effort. It's that craft fair demand depends on too many moving pieces at once: foot traffic, season, price point, booth location, and even how the sun hits your table. Nobody can hold all of that in their head and produce an accurate number.

Add in the fact that most makers are also the designer, the production line, the bookkeeper, and the person loading the car at 5 a.m., and it's easy to see why inventory planning ends up being a rushed guess rather than a real process. You're not being careless. You simply don't have the hours in the week to build a forecasting model from scratch every time a new show comes up.

That's exactly the kind of repetitive, data-heavy task that AI tools are built to handle well. You already have the raw material sitting in your notebook, your Square dashboard, or your Etsy order history. What's been missing is a fast way to turn that raw material into a number you can trust before you start packing boxes.

Small business owners are increasingly turning to AI tools to track inventory, analyze cash flow, and manage day-to-day finances alongside the creative side of running a shop. Inventory forecasting is a near-perfect fit for that approach. It's repetitive, it's math-heavy, and it improves the more data you feed it.

How Much Inventory Do You Actually Need for a Craft Fair?

Before you touch any AI tool, you need three numbers from your own history:

1. Average units sold per show. Look at your last three to five events and total up units sold, not revenue.
2. Booth traffic estimate. Some fairs publish attendance figures. If not, use last year's numbers for the same event.
3. Sell-through rate. This is units sold divided by units brought. A healthy target for most makers is 60 to 80 percent.

Here's the basic formula AI tools will help you apply per product:

Recommended stock = (Average sold per show x Seasonal adjustment) + Safety buffer

A seasonal adjustment might be 1.3 for a big holiday market and 0.8 for a small local pop-up. The safety buffer is usually 10 to 15 percent of your average, just enough to cover a surprise good day without leaving you buried in leftovers.

Once you know these three numbers, an AI assistant can multiply this out across dozens of products in seconds, something that would normally take you an hour with a calculator and a headache.

This matters more than it might seem at first. Most makers sell a mix of products with very different sell-through patterns. Your signature item might move at 90 percent sell-through every single time, while a newer line hovers around 30 percent. Averaging everything together hides that gap and leads to the same overpacking and underpacking mistakes you're trying to fix. Calculating stock per product, rather than as one lump number for your whole booth, is the single biggest shift that makes this system actually work.

Setting Up an AI-Powered Inventory Spreadsheet (Step by Step)

You don't need anything fancy. Google Sheets or Excel plus a free ChatGPT or Claude account is enough to start.

Step 1: Build your raw data sheet

Create one row per product per show. Keep the columns simple:

Column	What goes here
Product	Item name or SKU
Show	Name and date of the event
Brought	Units you packed
Sold	Units actually sold
Price	Retail price per unit
Cost	Your cost to make one unit

Step 2: Export it in a format AI can read

Save the sheet as a CSV. This is the format most AI tools parse cleanest. A few rows might look like this:

Product,Show,Brought,Sold,Price,Cost
Ceramic Mug,Spring Market,20,17,28,9
Ceramic Mug,Summer Fair,25,24,28,9
Beaded Earrings,Spring Market,40,22,18,4

Step 3: Upload it to your AI assistant

Paste the CSV directly into the chat, or upload the file if your tool supports it. From there, you're not doing math anymore. You're asking questions.

The Exact AI Prompts That Calculate Booth Inventory for You

This is where most beginners get stuck: they know AI can help, but they don't know what to type. Here are prompts you can copy directly and adjust to your products.

For a basic recommendation:

Here is my sales history from the last four craft fairs as a CSV.
For each product, calculate:
1. Average sell-through rate
2. Recommended units to bring to a similar-sized show
3. Which products are consistently underpacked or overpacked

Show the results in a table sorted by sell-through rate, highest first.

For seasonal shows:

This upcoming show is a holiday market, roughly 40% larger than my
average events based on past attendance. Adjust my recommended
inventory numbers up accordingly, and flag any product where I
don't have enough historical data to make a confident estimate.

For pricing and stock together:

Based on my cost and price columns, calculate profit margin per
product. Then tell me which three products I should prioritize
packing more of if I only have room for 300 total units in my car.

These prompts work because they give the AI a clear task, the data it needs, and the output format you want. Vague requests like "help me with my inventory" produce vague answers. Specific requests produce numbers you can actually act on.

How to Price and Restock Using AI Sales Data

Inventory and pricing are connected, even though most beginners treat them separately. If a product sells out at every single show, that's not just a packing problem, it might be priced too low.

Ask your AI assistant to flag any product with a sell-through rate above 95 percent across multiple shows. That's usually a signal you have room to raise the price without hurting demand.

On the flip side, products that consistently sell under 40 percent might need a price drop, a display change, or simply less inventory brought to future events. This kind of pattern spotting is exactly what AI is good at, since it's just comparing numbers across rows faster than you could by hand.

A simple restock rule you can build into your prompt:

If sell-through > 90%: increase next order by 20%
If sell-through 60-90%: keep quantity the same
If sell-through < 40%: reduce quantity by 25% or retire the item

Paste that rule into your AI chat along with fresh sales data after every show, and you'll have an updated packing list within a minute or two.

Marketplaces are leaning the same direction. When OpenAI rolled out in-chat checkout for Etsy sellers, Etsy's stock jumped as investors bet that AI-driven shopping would send more buyers straight to handmade sellers. That doesn't change your booth math directly, but it's a sign that pairing your craft business with AI tools, whether for sales or for inventory, is becoming the norm rather than the exception.

Spreadsheet vs AI Assistant vs Dedicated App: Which Should You Use?

There isn't one right answer here. It depends on how many products and shows you're managing.

Method	Best for	Setup time	Monthly cost
Manual spreadsheet	Under 15 products, 1-2 shows a month	30 minutes	Free
Spreadsheet + AI prompts	15-60 products, weekly shows	1-2 hours	Free to $20
Dedicated inventory app	60+ products, multiple sellers or channels	Half a day	$20-100+

Most solo makers and small teams land in the middle column. It gives you AI-level analysis without paying for software built for warehouses and multi-location retailers.

Common Mistakes When Using AI to Calculate Inventory

Feeding it too little data. One show's worth of sales isn't a pattern, it's a data point. Give the AI at least three to four events before trusting its recommendations.

Ignoring outliers. A rained-out fair or a show with unusually low attendance will skew your averages. Tell the AI to exclude or flag these when you upload your data.

Not updating after every event. The value of this system compounds. Each new show makes the next prediction sharper. Skipping updates means you're back to guessing.

Trusting the number blindly. AI is working from your past data, not your gut instinct about a new venue or a trending product. Treat its output as a strong starting point, then adjust based on what you know that the spreadsheet doesn't.

Overcomplicating the sheet. You don't need 20 columns. Product, show, brought, sold, price, and cost cover 90 percent of what you need to make good decisions.

Comparing shows that aren't actually similar. A three-day outdoor festival with 10,000 attendees and a two-hour indoor pop-up with 200 attendees will never produce comparable numbers. When you prompt your AI assistant, tell it which past shows are genuinely similar in size and format to the one you're prepping for, and ask it to weight those more heavily than the outliers.

Most of these mistakes come down to one thing: treating the AI's output as a finished answer instead of a first draft. The tool is fast and consistent, but it only knows what you tell it. Pair its speed with your own knowledge of the craft fair circuit, and the two together beat either one working alone.

Building a Simple Restock Checklist for Every Show

Once your system is running, the actual routine before each fair takes ten minutes:

craft-fair-prep/
├── sales-history.csv
├── next-show-notes.txt
└── packing-list-final.csv

1. Update sales-history.csv with results from your last show.
2. Paste it into your AI assistant with your standard prompt.
3. Save the output as packing-list-final.csv.
4. Cross-check against what you physically have ready to pack.
5. Adjust for anything the data can't see, like a new product launch or a special order.

That's the entire workflow. No software subscription, no complicated dashboard, just a spreadsheet, a free AI tool, and five repeatable steps.

The bigger shift here isn't really about spreadsheets or prompts. It's about treating your inventory as something you measure instead of something you feel. Start small. Track your next two shows properly, run the numbers through an AI assistant, and see how close the recommendation lands to what you actually needed. Most sellers find the gap between guessing and calculating is bigger than they expected, in dollars saved and in trunk space freed up.

Q&A

1. Do I need a paid AI tool to calculate craft fair inventory?

No. The free versions of ChatGPT or Claude handle this task well. You only need a paid plan if you're uploading very large files or running dozens of queries a day, which is rare for a solo maker.

2. How many past shows do I need before the AI's recommendations are reliable?

Aim for at least three to four shows of similar size and season. Fewer than that, and the AI is working with too little pattern to trust fully.

3. Can AI help me decide what new products to bring, even without sales history?

Yes, but with less precision. Ask it to base the estimate on your closest comparable product's early sell-through rate, then treat the number as a rough starting point rather than a firm target.

4. What if my sales happen through both a POS system and cash at the table?

Combine both into one CSV before uploading. As long as every sale lands in the same "Sold" column per product, the AI can still calculate accurate totals.

5. Is a spreadsheet plus AI prompts better than buying inventory software?

For most craft fair sellers, yes. Dedicated inventory apps make more sense once you're managing 60 or more SKUs or selling across multiple channels at once. Below that, a spreadsheet and a few reusable prompts do the job for free.

My SaaS

Acluebox

Build modular and reusable system prompts with my SaaS,

Acluebox

. Also, free prompt template generators there.

References

• 10 Ways Small Businesses Can Use AI To Grow
• Etsy pops 16% on ChatGPT checkout news