How to organize your Clover item catalogue for cleaner reports

You pull a sales-by-item report expecting answers and instead you get a mess: the same coffee shows up three times under three spellings, half your sales sit in a category called “Misc,” and a modifier you set up two years ago is now its own line item outpacing real products. The report isn’t wrong — it’s faithfully reporting a catalogue that was never cleaned up.

Item catalogue hygiene is the least glamorous retail task there is, and the one with the widest payoff. Every report you will ever run — weekly sales, slow movers, period comparisons, multi-store rollups — reads from this one list. Clean it once and every number downstream gets sharper. Here is how to do it without spending a weekend on it.

Why a messy catalogue quietly costs you

When the same product exists under several names, its sales get split across several lines. Individually, none of them looks important, so a real top-seller can hide in plain sight and never make your top 10. The reverse happens too: a junk entry or a stray modifier climbs the ranking and pulls your attention toward something that isn’t a product at all.

Categories make it worse or better depending on how you set them. If most of your sales fall into “Misc” or have no category at all, you lose the ability to ask the questions that actually drive buying: which department is growing, where margin is thin, what to reorder first. A clean catalogue is the difference between a report you read and a report you act on.

Warning signs your catalogue needs a cleanup

• The same item appears more than once with slightly different names, capitalization, or spacing.
• A large share of sales lands in “Misc,” “Other,” or no category at all.
• Modifiers (sizes, add-ons, extras) show up as separate top-selling “products.”
• Old or seasonal items you no longer sell still clutter the list and search.
• Two staff members ring up the same product differently because there are two buttons for it.

How to clean it up, step by step

You don’t need to redo everything at once. Work from the most-sold items down, because that’s where errors distort your reports the most. Pull a sales-by-item export, sort by quantity, and start at the top.

1. Merge duplicates: pick one official name per product and delete or rename the rest so all sales land on a single line.
2. Agree on a naming convention: decide how you write names (for example, “Brand — Product — Size”) and apply it consistently so search and reports stay predictable.
3. Give every item a real category that matches how you think about your store, not a catch-all “Misc.”
4. Turn options into modifiers, not separate items, so a large coffee still reports as coffee.
5. Archive what you no longer sell so it stops cluttering search and skewing comparisons.

Categories and modifiers, done right

Categories should map to decisions you actually make. If you buy and budget by department — drinks, snacks, tobacco, household — those are your categories. Keep the list short enough to scan and specific enough to be useful; ten clear categories beat forty overlapping ones. Every new item should get a category the moment it’s created, while it’s fresh, not “later.”

Modifiers are where most catalogues go sideways. A size, a flavor, or an add-on belongs to the product as a modifier, not as its own item. Done right, “large” adds to the coffee’s total instead of competing with it, and your sales-by-item report shows real products at the top instead of a confusing mix of products and options.

Common mistakes to avoid

The most common mistake is creating a brand-new button every time a product doesn’t scan or isn’t found, instead of fixing the original entry. Within a few months you have five versions of the same item and a report that no longer means anything. The second mistake is deleting items that already have sales history: deleting can erase the past, while archiving keeps the record and just hides the item from the active list. When in doubt, archive — don’t delete.

How CornerPilot helps

Once your Clover catalogue is reasonably clean, a connected dashboard makes the payoff obvious. CornerPilot reads your Clover sales on a scheduled sync and groups them by product and category, so duplicates and uncategorized items stand out instead of hiding in a long export. It won’t rename your items for you — that judgment stays with you — but it makes the messy spots visible, and it keeps your cleaned-up categories working across every report and, if you run more than one store, across locations. If you want to see what that looks like, take a look at the features, or connect your Clover data and start from your own numbers.

What to do this week

Don’t plan a full overhaul. Export your sales by item, sort by quantity, and clean just the top 20 products: merge their duplicates, give each a clear name and a real category, and turn stray options into modifiers. Those 20 items are where most of your money and most of your reporting errors live, so fixing them gives you the biggest improvement for the least effort.

A clean catalogue is quiet work that pays off every single time you open a report. Your register already captures every sale; tidy item list is what turns that raw record into numbers you can trust and decisions you can defend.