How Per-Product Reports Can Change Your Business Decisions

Your Bestseller Might Not Be What You Think

Ask any cafe owner what their top-selling product is. Most will answer confidently — "Iced Coffee Latte, obviously." And they might be right. But "might" is the dangerous word here.

From our conversations with F&B business owners, we've consistently found a gap between what they believe sells best and what actually sells best. Iced Coffee Latte gets ordered a lot, sure. But when you look at the actual data, it turns out Matcha Latte has a higher margin and sells consistently every day — not just on weekends.

This isn't about gut feeling being wrong. Gut feeling is shaped by what's most "noticeable" — the product customers mention most, the one that runs out, the one people complain about when it's unavailable. But gut feeling can't capture the nuances that only data reveals.

Why We Built Per-Product Reports

When CrescendPOS first got reporting features, we started basic: total sales per day, per week, per month. Big numbers that give a general picture. Useful? Yes. Enough? No.

What we heard repeatedly from users: "I know total sales went up, but I don't know which products are driving the increase." Or conversely: "Sales are down, but I don't know which products to cut."

Per-product reports answer those questions. Not just "what's today's total" but "which products sold how many units, at what times, and what percentage of total revenue do they represent."

That sounds technical, but the implications are deeply practical. With per-product data, you can make decisions that were previously just guesses.

Finding Products That Aren't Actually Profitable

This is one of the most powerful insights from per-product reports: some products that look like bestsellers aren't actually profitable when you run the numbers.

An example we've heard often: Special Fried Rice sells at Rp 35,000 with COGS around Rp 22,000 — that's a margin of just Rp 13,000. Meanwhile, French Fries sell at Rp 25,000 with COGS of Rp 8,000 — margin of Rp 17,000. The cheaper product is actually more profitable per serving.

Without per-product reports, you never know this. You keep pushing Special Fried Rice because it's the "bestseller," while every portion sold generates a lower margin than French Fries.

We're not saying you should remove low-margin items from the menu — sometimes they exist for strategic reasons (traffic drivers, customer expectations). But you need to know which ones are low-margin so you can make conscious decisions, not blind ones.

Time Patterns: When Products Sell Matters Just as Much

Per-product data isn't just about "how many" but also "when." And time patterns often reveal unexpected insights.

For example:

• Hot coffee dominates mornings (7-9 AM), iced coffee takes over in the afternoon. This might seem obvious, but the data helps you optimize prep — no need to prepare ice in bulk first thing in the morning.
• Heavy meals spike at lunch (11:30 AM - 1:00 PM) but drop to nearly zero outside that window. If you're prepping meal ingredients all day, you're wasting supplies.
• Desserts and snacks have a more even distribution. People buy brownies at 10 AM and at 4 PM. These are products you can count on to fill the gaps between rush hours.

With this data, you can start optimizing not just your menu but your operations — prep schedules, stocking, even staff scheduling.

Menu Engineering: Data-Driven Without Losing Intuition

There's a well-known concept in the F&B industry called "menu engineering" — categorizing products by popularity and profitability. Products that are popular and profitable (stars), popular but low-margin (workhorses), unpopular but high-margin (puzzles), and neither popular nor profitable (dogs).

Per-product reports in CrescendPOS don't automatically categorize your products this way — we deliberately chose not to replace business owner judgment with an algorithm. But the data we provide enables you to do this analysis yourself:

• Stars: Keep them, ensure they're always available, consider a small price increase if the market can absorb it.
• Workhorses: Find ways to reduce COGS (switch suppliers, adjust portions) or gradually increase the price.
• Puzzles: Promote more aggressively — these are profitable products that aren't well-known yet. Consider placing them more prominently on the menu.
• Dogs: Evaluate whether they still belong on the menu. Sometimes the answer is yes (complementary items), sometimes no.

We believe data is an input to decisions, not the decision itself. Business owners know context that data can't capture — like the regular who always orders a specific product, or the signature item that defines the brand.

Actionable Reports, Not Just Informative Ones

One of our design principles for reporting: every report should be actionable. There's no point showing data that just makes the user say "oh, interesting" but leaves them with no idea what to do next.

That's why per-product reports in CrescendPOS are designed with specific business questions in mind:

• "Which products should I promote?" — look at high-margin, low-volume products.
• "Which products can I remove without major impact?" — look at low-volume AND low-margin products.
• "When should I prep more?" — look at hourly sales patterns per product.
• "Did last week's price change affect volume?" — compare volumes before and after the price change.

Each of these questions can be answered from the data in the report, without needing to export to a spreadsheet and build pivot tables manually.

What We Deliberately Didn't Build

When designing per-product reports, we faced the temptation to add sophisticated analytics: sales forecasting, automatic price recommendations, AI-powered product scoring. All ideas that sound impressive.

We didn't build any of that. Not because we couldn't, but because we didn't want to create an illusion of precision that doesn't actually exist. Forecasting requires long historical data and complex external factors. Price recommendations without context can be dangerous. And automatic product scoring can make business owners over-rely on numbers without thinking.

What we built instead: clean, organized, easy-to-read data. The decisions stay with you — we just give you the information you need to make better ones.

From Gut Feeling to Informed Intuition

We're not anti-gut-feeling. The intuition of a business owner with years of industry experience is valuable and can't be replaced by data. What we want to change isn't the intuition — it's the foundation beneath it.

A gut feeling backed by data operates on a different level than pure gut feeling. You can still say "I think we should keep this product" — but now you also know its exact revenue contribution, its margin, and its peak sales times. That's not replacing intuition — it's enriching it.

And that's what we're trying to achieve with per-product reports in CrescendPOS.