Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do I Decide What to Order for Christmas When I Have to Buy Months Ahead and Cannot See What Sold Last Year?
Problems We Solve

How Do I Decide What to Order for Christmas When I Have to Buy Months Ahead and Cannot See What Sold Last Year?

Independent gift shops order Christmas stock months early from memory. We build a buying sheet from last year's till sales, sell-through and leftovers.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Christmas stock is often ordered at summer trade shows, months before the season, from memory of what sold last year. The till holds the answer but not in a form you can use at the show. We build a buying sheet from your own till history that shows, for each supplier and line, what you bought, what sold, when it sold out and what was left in January.

A trade show in the summer, a notebook and a guess

It is a hot day at a trade show, and you are standing at a supplier's stand looking at their Christmas range. Last year you had their ceramic decorations. Did they sell out? You think the robins went early and the snowmen were still on the shelf in the January sale. How many did you order? Somewhere around a box of each, maybe two.

You place an order based on that, and on how the new range feels. Multiply that by dozens of suppliers across a couple of shows, and the shop's whole Christmas is bought on memory.

The information exists, just not where you need it

Your till records every sale. The problem is that it reports by day and by product, not in the way you think when buying: by supplier, by range and by how quickly things sold before Christmas.

  • Seasonal lines change names and codes each year.
  • Sell-out dates are not recorded, only sales.
  • Leftovers sold off in January look like sales in the reports.
  • What you ordered lives in supplier invoices, not the till.
  • At the show, you have a phone and no time to run reports.

The cost of buying on memory

Buying too much leaves stock that is sold off cheaply in January or packed away for next year, tying up cash through the quiet months. Buying too little of the lines that flew leaves empty shelves in the first weeks of December, which is when a gift shop makes much of its year.

Both happen at once in most shops, which is why the January sale rail and the 'sorry, sold out' conversation often feature the same supplier.

How we build a buying sheet from your own sales

  1. We pull your till sales history for the last one or two Christmas seasons, and match seasonal lines to their supplier and range, even where codes changed.
  2. Supplier invoices or your purchase records are matched in, so each line shows what you bought as well as what you sold.
  3. For each line we show when it sold out, if it did, and how much was left at your chosen cut-off date, split between full price sales and markdown.
  4. Lines are grouped by supplier, so at a trade show you can open that supplier's page and see last year at a glance.
  5. You can add notes, such as 'robins went in early December, double next year', and they stay with the supplier for next time.
  6. As you place orders at shows, you record them on the same sheet, so you can see your total Christmas buy building up against last year.
LineBoughtSold before ChristmasSold outLeft at cut-off
Ceramic robinsOrdered quantityAllEarly DecemberNone
Ceramic snowmenOrdered quantityMostNoA few, sold in January
Advent calendarsOrdered quantityMostMid DecemberA handful

The sheet shows what happened, and the buying decisions stay yours. New ranges, trends and your own eye for what will sell are not things a report replaces.

Buying season with the sheet

At the show, you open the supplier's page on your phone and see last year's lines, quantities and outcomes. You order more of what sold out early and less of what ended up on the sale rail. Your running total tells you whether you are spending more or less than last year, before the season starts, not after.

In January, the sheet updates with how this Christmas went, ready for next year.

Does this sound like your Christmas buying?

  • You order Christmas stock at trade shows from memory.
  • You are not sure which lines sold out and when.
  • The same suppliers fill both your sold out list and your sale rail.
  • You only know your total Christmas spend when the invoices arrive.
  • Till reports do not match the way you think about buying.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this need several years of data?

One season is useful, two is better. If your till history is short or patchy, we show what there is and say where it is thin.

Which tills can you read sales from?

Most modern tills let you export sales or read them through an API. We check yours before starting.

Can it work for other seasons, like Mother's Day?

Yes. Any season with a clear date range can have its own buying sheet.

What do you need from us?

Access to your till data, your supplier invoices or purchase records, and your notes on which lines were seasonal.

Keep reading

More on Problems We Solve

Start here

Tell us how the shop runs behind the counter

Describe your till, your website, the spreadsheets and notebooks that fill the gaps, and the job that takes up your evenings. We will tell you honestly what is worth building for a shop your size, and if your till or an existing app already does it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →