Tracking seasonal best sellers to update a coffee shop menu

30/10/2026

Every coffee shop menu swells over time. A few blended drinks get added for summer, a new item appears because customers kept asking, something sells for a couple of weeks and then goes quiet but stays on the board anyway. Look back later and you have a thirty-item menu where the revenue really comes from seven or eight of them. The rest still take up space in the store room, still have to be remembered as recipes, and still leave new customers hesitating at the counter.

Don't look at total revenue, look at the product report

The product report in Ordersys lists every item sold within the date range you choose: cups, revenue, and share of the total. Pick one month, then pick the same month a year earlier, or compare this month against last — changing the date range on the filter gives you two tables to set side by side.

What matters is not which item is at the top. Anyone who works the counter already knows that. What matters is the bottom of the list and the items that moved sharply between the two periods.

Four-step diagram: reading the seasonal product report and then deciding to keep, drop or add an item
The step most often skipped is the last one: after changing the menu you have to measure again, otherwise next time you are guessing all over.

Sort items into four groups before deciding

Cups sold is only half the story. The other half is cost. If the shop has defined consumption per item, each drink has a cost derived from its ingredients; put that next to the selling price and you can see which items actually keep the shop running.

High margin per cupLow margin per cup
Sells a lotProtect it: keep ingredients stocked, make sure staff follow the recipe, give it a visible spot on the menuReview the recipe quantities and the price; it may also be the drink that brings people in, in which case a thin margin is acceptable
Sells littleWorth pushing: move it up the menu, have staff suggest it, pair it in a combo with a best sellerA candidate for removal, unless a fixed group of regulars orders it

An item in the bottom-right box that still needs three or four ingredients of its own is the most expensive item you have: it occupies fridge space, its ingredients spoil waiting, and it sells a handful of cups a month.

For seasons, compare with the same period, not the month before

Coffee shops have a clear rhythm. Blended drinks selling twice as much in May as in February is normal and does not mean the item is on the rise. To know whether an item is genuinely strong or weak, compare it with itself a year earlier, or compare its share of total revenue instead of the raw cup count.

  • Weeks of rain pull total revenue down and every item falls with it — that is weather, not a bad drink.
  • A new item always sells well for its first three weeks out of curiosity; wait until the second month before concluding anything.
  • Hot and iced versions need to be read separately; combined, every season looks "steady".

Dropping an item is more than deleting a line

Before removing one, check what ingredients go with it. A syrup used only in that single drink means dropping the item clears a shelf as well. But if the ingredient is shared with three other drinks, removing it saves nothing beyond a tidier menu.

In the software, instead of deleting outright, you switch the item off on the sales screen. The historical sales data stays for next year's comparison, and when the season comes round you turn it back on in a moment — no re-entering the recipe, the quantities or the price.

Decide how you will measure a new item before you launch it

Adding an item to the menu is the easy part. What gets forgotten is deciding in advance what counts as success. For example: after four weeks it reaches at least 3% of total cups sold, and its margin per cup is no lower than the group average. With a threshold set in advance, you open the report on the date and decide — instead of "let's give it another month" stretching out across a year.

A new item should have its consumption defined from day one as well. Without it you sell a whole season before discovering how much ingredient it eats, and by then the price board is already printed.

The product report, recipe consumption and drink options are part of Ordersys coffee shop management software, free to try for 7 days. Read more: how to work out the cost of a cup of coffee or milk tea and ingredient loss in a coffee shop: how to measure it and where it goes.

Software that fits this article Fast checkout for cafés and bubble tea shops at rush hour

Checkout in a few taps, print cup labels with toppings, send drinks to the bar screen and issue e-invoices from the POS.

Other news

Sales software for household businesses that fits the new rules
21/11/2026

Sales software for household businesses that fits the new rules

From 2026 household businesses no longer pay presumptive tax and declare based on actual revenue; stores with revenue of 1 billion VND/year or more selling directly to consumers must use e-invoices generated from cash registers. This guide summarises the regulatory milestones that affect retail stores and what sales software must do: record every order, issue e-invoices, report by period, keep purchase records and track debts.

Scan a QR code to order at the table: guests order for themselves, the restaurant needs fewer staff
21/11/2026

Scan a QR code to order at the table: guests order for themselves, the restaurant needs fewer staff

When guests scan a QR code to order at the table, handing out menus, taking orders, running tickets to the kitchen and answering "where is our food?" move to the guest. This guide separates what guests do themselves, what staff still have to do, how to rearrange shifts by table zone, and where things slip when the restaurant runs with fewer people.

Ordering software for wedding banquet restaurants: serving many tables at once without the bill going wrong
21/11/2026

Ordering software for wedding banquet restaurants: serving many tables at once without the bill going wrong

A thirty-table wedding banquet usually goes wrong on the extras: drinks added mid-party, tables set up at the last minute, dishes sent to the kitchen twice, deposits remembered by word of mouth. This guide puts the whole banquet into one order from a multi-table booking or by merging tables, takes extra orders by phone, sends only new items to the kitchen, and settles with the host using a provisional bill, surcharges and automatic deposit deduction.

Complete coffee shop management software: how ordering, checkout, inventory and reports connect
21/11/2026

Complete coffee shop management software: how ordering, checkout, inventory and reports connect

Complete coffee shop management software is not a long feature list but ordering, checkout, inventory and reports working together: ring up one cup and the money goes into the right shift, ingredients are deducted by recipe and the end-of-day report updates itself. The article follows one cup through four stages, shows four common break points and the order to switch things on.

Billiards management software for a small new club: what to set up before opening day
21/11/2026

Billiards management software for a small new club: what to set up before opening day

For a new billiards club with five to ten tables, where the owner works the counter and starts the clocks, the software needs to do a few things right: set up tables, hourly rates, the menu and QR codes before opening; let players order drinks themselves and have table lights follow playing time; use camera highlights to get the club known; and after the first month read reports by table, debts and shift close.

Retail order management software: counter sales and online orders in one place
20/11/2026

Retail order management software: counter sales and online orders in one place

Counter orders, phone and Zalo orders, and orders from the store's web shop all go into one order book in Ordersys. Each online order moves through five clear statuses, delivery requires the address, delivery time and delivery person, customers track their own order, and there is no adding up two places at the end of the day.

Spa and hair removal appointment software with no double bookings
20/11/2026

Spa and hair removal appointment software with no double bookings

Hair removal sessions are short, tightly packed and crowded into one machine room, so they clash easily. Each Ordersys appointment records the time, duration, room/bed and therapist; on save the software checks for room clashes, therapist clashes and therapists busy in the spa, adds bed turnover time, and shows exactly which booking is holding the slot.

QR table ordering software for restaurants and eateries
20/11/2026

QR table ordering software for restaurants and eateries

One round of QR ordering in Ordersys goes through five steps: the guest scans the code on the table, picks dishes with options and notes, sends the order (with or without a confirmation step), the kitchen and bar receive it, and the guest reopens the page to check the order and order more. Plus a list of what to set up before putting codes on tables.

Ordersys or KiotViet? A Straight Comparison to Choose Right
20/11/2026

Ordersys or KiotViet? A Straight Comparison to Choose Right

An honest Ordersys vs KiotViet comparison by real needs: retail, services, billiards, QR ordering, automatic payment — choose right, not the wrong fit.

090 750 1000 Zalo Chat Zalo Facebook