Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Can I See Which Parts of My Shop Actually Make Money, Not Just Which Things Sell?
Problems We Solve

How Can I See Which Parts of My Shop Actually Make Money, Not Just Which Things Sell?

Independent shops see sales totals but not which ranges earn their shelf space. We build a margin view by category, supplier and shop area from your till.

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

Most till reports show what sold, not what each range earned once cost prices, discounts and markdowns are taken into account, and not how that compares with the space it takes up. We build a view from your till and supplier costs that shows margin by category, supplier and area of the shop, so decisions about what to grow and what to shrink rest on your own figures.

Cards sell all day, but do they pay the rent?

The card spinner is always busy. The till report says greetings cards are among your top categories by number of sales. The homeware table near the window sells less often but at higher prices. The children's books section takes up a whole wall. You have a feeling about which of these are really worth their space, but it is only a feeling.

When you try to work it out, you realise the till knows sale prices but many products have no cost price on them, discounts at the counter are recorded as a single line, and the January sale muddles everything.

Tills report takings, not margin

Tills are designed to take money and report sales. Margin needs cost prices, which live on supplier invoices, and many independent shops never entered them on the till, or entered them once and never updated them.

  • Cost prices are missing or out of date on many products.
  • Categories on the till were set up quickly and do not match how you think about the shop.
  • Counter discounts and staff discounts are not linked to products.
  • Markdowns in the sale reduce margin but are not visible by range.
  • Space in the shop is not measured anywhere.

What not knowing costs

Without margin by range, decisions about what to stock, where to put it and how much to buy are made on sales volume and instinct. A busy category with low margin can look like a winner while a quieter, more profitable one gets squeezed.

It also makes supplier conversations harder. You cannot easily say which suppliers' ranges earn their place, or show that a price rise has eaten into a line's margin.

How we build a margin view for your shop

  1. We read sales, discounts and refunds from your till for the period you choose.
  2. Cost prices are filled in from supplier invoices, matched to products, and kept up to date as new invoices arrive.
  3. Categories are regrouped into the way you think about the shop, such as cards, homeware, kitchen, children's and seasonal, without changing your till setup.
  4. Each product is linked to an area of the shop, such as window, front table, left wall, so you can see what each area earns.
  5. The view shows sales, margin after discounts and markdowns, and stock value for each category, supplier and area.
  6. You can compare periods, such as this autumn against last, or before and after a layout change.
ViewWhat it answers
By categoryWhich ranges earn the most after discounts
By supplierWhich suppliers' lines earn their place
By shop areaWhat each wall, table and window earns
By periodWhether a change in layout or buying worked

The figures are only as accurate as the cost prices behind them. Where a product has no cost we can find, it is shown as missing rather than guessed. How you use these figures in your accounts is for your accountant.

Running the shop with the margin view

You can see, for each part of the shop, what it sells, what it earns and how much stock is sitting there. Decisions about growing the homeware table or trimming a section are made with your own numbers in front of you. When a supplier raises prices, you can see the effect on that range's margin straight away.

Over time, the view shows whether the changes you make are working, which is the part most small shops never get to see.

It also helps with the conversations that are hard to have on instinct alone, such as telling a long-standing supplier that their range is losing its place, or deciding whether a new category deserves a trial table by the door.

Signs you need this view

  • Your till reports sales but not margin.
  • Many products have no cost price on the till.
  • You judge ranges by how busy they feel.
  • You are not sure which suppliers earn their shelf space.
  • You cannot tell whether a layout change made a difference.

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

Do I have to enter cost prices for everything?

No. We fill them in from supplier invoices where possible and show you what is still missing.

Will this change how my till is set up?

No. The regrouping happens in the view, not on the till.

How do you know which area of the shop a product is in?

You tell us once, by range or by product, and update it when you move things.

What drives the cost?

Which till you use, how many suppliers you have and how your invoices arrive.

Keep reading

More on Problems We Solve

Start here

Tell us what you wish your till could tell you

Describe your till, your website, how you price and promote stock and the question you can never quite answer about your shop. We will tell you what we would build, and if a report your till already has would answer it, we will show you where it is.

  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 →