- Home
- >
- Sell More Without Selling Harder
Order Smarter for the Holidays
Order Smarter for the Holidays: How Florists Can Use AI to Forecast What They Need
Every florist knows the feeling. It's post-holiday and you're either staring at three empty buckets and a list of orders you turned away, or at forty bunches of roses that didn't move. Holiday ordering is the biggest bet most shops make all year, and too often it's made from memory.The fix is a forecast built from your own sales, and you don't have to do the math by hand anymore. Free AI tools like ChatGPT, Claude, Google Gemini and Microsoft Copilot can turn last year's sales into a stem-by-stem forecast in minutes, for Christmas, Valentine's Day, Mother's Day and beyond. Your job is to give the AI the right information and make sure the answer makes sense. This guide shows you what to gather, what the AI needs to know, and what prompts to use.
Step 1: Gather Last Year's Numbers
Start with what actually sold, not what you remember selling. From your POS or order book, pull these for the same holiday last year:
• Total orders, broken out by day (the week before, the day before, the holiday itself and the day after)
• Orders by product type: dozen roses, half dozen, mixed arrangements, wrapped bunches, add-ons
• Your top 10 recipes and the stems in each
• Orders you turned away or sold out of, and when it happened
• Product you threw away afterwardThose last two lines matter most.
Sellouts tell you where you ordered too little. Waste tells you where you ordered too much.Your recipes matter too. Flowers are ordered by the stem and the bunch, but you sell arrangements. Your recipes are what let the AI translate one into the other.
Tip: If your POS can export a report as an Excel or CSV file, most AI tools can read it directly. Before you upload, delete customer names, addresses, phone numbers and payment details. The AI only needs products, quantities and dates.
Step 2: Know what's different this year
Last year is the starting point, not the answer. AI doesn't know your town, your customers or your plans, so these are the details only you can add. They're what make the forecast yours.
• The calendar. Valentine's Day 2027 falls on a Sunday, and it's also Super Bowl Sunday. After a Saturday holiday in 2026, expect orders to shift toward Friday and Saturday, with fewer office deliveries and more customers celebrating early. Sunday deliveries may be limited and customers may plan to celebrate late, so expect day-after orders on Monday, February 15, which is also Presidents’ Day. Christmas 2026 falls on a Friday, so plan for heavy Tuesday through Thursday deliveries.
• Growth or change. New corporate accounts, a new website, a busier wedding calendar, or a lost account.
• Price. If holiday pricing rises, your customers may shift from a dozen roses to a mixed design. Adjust the mix, not just the total.
• A buffer for breakage. Add roughly 5% for stems lost to bent necks, damaged heads or processing.
• Greens at Christmas. Forecast fresh evergreens separately from flowers. They hold longer, so the buffer can be smaller.
• What to prebook and what to leave open. Prebooking locks in product and pricing weeks ahead, so many shops prebook about 70% of their forecast on core items and buy trend colors and add ons closer to the date.
Step 3: Ask AI to build your forecast
Open the AI tool of your choice, attach your sales file, and paste in the prompt below. Fill in everything in brackets with your own details. The more specific you are, the better the forecast.
Copy and paste this prompt
I own a retail flower shop located in [city, state] and I'm planning my flower and supply order for [holiday, such as Valentine's Day or Mother's Day]. I've attached my sales from the same holiday last year. Please build a forecast for this year.Here's what you need to know:
My top recipes and the stems in each: [for example, Dozen red roses: 12 red roses, 5 stems salal, 3 stems eucalyptus]
Expected growth or change this year: [for example, up about 5%, plus a new corporate account]Calendar notes: [for example, Valentine's Day 2027 is on a Sunday and is also Super Bowl Sunday]
Items I sold out of last year: [list]
Items I threw away afterward: [list]
Stems per bunch from my wholesaler: [for example, roses 25, spray roses 10, carnations 25]Please:
1. Convert last year's orders into total stems for each flower and green.
2. Adjust for growth and add a 5% breakage buffer.
3. Round up to full bunches.
4. Split each item into about 70% to prebook and 30% to buy closer to the holiday.
5. List the vases, foam, tape, wire, wrap, ribbon, cards, flower food and delivery boxes I'll need, with quantities, based on the same order counts.
6. Tell me which days will likely be busiest, including the day after the holiday, based on the calendar.
Show the results in a table and show your math so I can check it.
Step 4: Have AI check the math
AI is fast, but it can make mistakes, especially with long lists of numbers. The good news is you can ask it to check its own work. Paste this prompt into the same conversation:
Copy and paste this prompt
Before I place this order, please double check your forecast.
1. For each flower and green, walk through the math step by step: last year's orders, the stems in each recipe, total stems, the growth adjustment, the 5% breakage buffer, the bunch count rounded up, and the 70/30 prebook split.
2. Use a calculator or spreadsheet to recalculate every number instead of estimating.
3. Confirm that you used my recipes and my stems per bunch exactly as I gave them.
4. Tell me about any number you changed, any assumption you made, and any information you were missing.5. Give me a corrected table if anything changed.
Finally, do a gut check. Does the forecast match the kind of year you're expecting? AI handles the math, but you know your shop better than any tool does..
Save your process for next time
Once your forecast works, you don't have to start over for the next holiday. Most AI tools can save instructions you use again and again, through features like projects, memory or custom assistants (for example, ChatGPT Projects, Claude Projects or Gemini Gems). Set it up once, and next time the AI runs the forecast and the math check together.
Please save this as my holiday forecasting process so I can reuse it for every holiday. Each time I upload a sales file and name the holiday, do the following without me explaining it again:
1. Before you start, ask me what's different this year: the calendar, expected growth, price changes, recipe changes, and what I sold out of or threw away.
2. Build the forecast using my recipes and stems per bunch, a 5% breakage buffer, full bunches, and a 70/30 prebook split.
3. List the supplies I'll need and the busiest days.
4. Check the math step by step with a calculator before showing me the final table.
Next holiday, just upload your sales file and type: "Run my holiday forecast for Mother's Day." Keep a copy of your prompts in a document too and update your recipes whenever they change.