Free download · For Ascend POS shops

The 5 numbers your POS already knows.

Five saved queries for Ascend’s built-in SQL window. Paste, run, read. Each one answers a question most shop owners have never seen an actual number for — in about two minutes, without touching your data.

Read-only SELECT statements. Written against the real Ascend schema, tested in a real shop.

Five questions. Five queries. One decision each.

These aren’t dashboards. They’re the five numbers a good rep would pull before walking into your shop — the ones that tell you where the money is sitting and who stopped coming in.

Dormant customers

Who bought in the last four years, hasn’t in twelve months, and can still be reached.

Service-to-retail crossover

Of your work-order customers, what percent ever buy at the counter.

Dead stock by category

Units that haven’t moved in a year, and the cash sitting in them.

The first-tune-up list

Bikes sold 10–15 months ago that never came back for service. A call list.

Category velocity

Last 90 days vs the same 90 days a year ago, by category.

The read-me

How to run them, what the numbers mean, and the one thing to do with each.

Sample — query #3, one line, paste and run

SELECT TOP 20 cat.Topic AS Category, COUNT(*) AS Skus, SUM(p.Quantity) AS Units, CAST(SUM(p.Quantity * p.AvgCost) AS decimal(12,0)) AS CashAtCost FROM Products p JOIN Categories cat ON cat.ID = p.TopicID WHERE p.Quantity > 0 AND p.Hide = 0 AND p.DateQtyChng < DATEADD(month,-12,GETDATE()) GROUP BY cat.Topic ORDER BY CashAtCost DESC

That one has started more honest conversations with a rep than any report Ascend prints.

Your POS has been keeping score for a decade. Nobody reads it.

I’ve spent ten years walking into independent bike shops as a territory manager. The owners who are winning aren’t the ones with the best software. They’re the ones who know three or four numbers cold and act on them every week.

Ascend’s SQL window is the fastest way to get those numbers, and almost nobody uses it. These five are the ones I’d pull first. Run them once. Then pick one thing to do.

And if you’d rather a team watched these every night and handed you a short list every Monday — that’s what Summit and the crew do.

Get the free query pack

Five queries, instantly. Then decide for yourself whether the playbook — or the team — is worth your time.