Supermarket Software

A supermarket earns a small amount on a great many items, many times a day. The margin is not in the price. It is in what does not get wasted.

A supermarket is several stores under one roof: a produce department, a meat and fish counter, a bakery, a dairy and chilled section, a dry grocery floor, household goods, sometimes more. Each has its own suppliers, its own stock rhythm, its own shrink and its own margin, and the store's result is the sum of them. With Pentoggle, a supermarket operator can describe how their departments actually run and generate the starting application around it.

This page is for the multi-lane, department-based supermarket, whether a single large store or part of a chain, where buying is structured or central and the day is shaped by deliveries, fresh handling and customer flow by hour. The independent or neighbourhood store, where the owner buys, knows the regulars and may run credit, is Grocery Store Software. The small-format, long-hours store is Convenience Store Software.

Most supermarkets already run an accounting system such as QuickBooks, Tally or Xero, a multi-lane POS with scales, and often a supplier ordering portal or two. Those stay where they are. What is often still managed outside them is the department as a business: what each earned after waste and markdown, what each is short of this morning, and whether the promotion running in aisle four is being funded by the supplier as agreed.

Key takeaways

  • A supermarket's margin is thin and its volume is high, which makes small losses across many items the shape of the risk. Shrink, waste and markdowns decide the result more than any pricing decision.
  • Departments are the unit of management. Store-level totals hide that produce is losing what dry grocery earns, and the two need different action.
  • Fresh and weighed goods are a different kind of stock: sold by weight, dated, wasted daily, and often the reason customers choose the store.
  • Supplier funding is part of the margin. Promotional support, listing allowances and rebates are earned by running the promotion as agreed and claimed afterwards, and they are only received if they are tracked.
  • A useful number is department margin after waste and markdown, read alongside out-of-stocks at the shelf by department.

How a supermarket makes money

A supermarket earns a small margin on each item and depends on volume, basket size and frequency to turn that into a result. Customers come often, buy many things, and choose the store for a few reasons that are not price: the quality of the fresh departments, the range, the convenience, the experience at the checkout.

That structure has consequences. Because margin per item is small, the store cannot afford to lose much of it. A markdown, a waste bin, a short delivery paid in full, a promotion that ran a week too long: each is a small number that, multiplied across thousands of items and hundreds of transactions an hour, is the difference between a good week and a poor one.

Revenue also arrives in two forms. The obvious one is the till. The less visible one is supplier funding: promotional support for running an offer, contributions for shelf position or a new listing, volume rebates on the quarter, and in some arrangements price protection when a cost changes. In many supermarkets this second stream is material, and it is earned by doing specific things and proven by keeping specific records. A supermarket that runs a promotion and does not claim the funding has given the discount and received nothing for it.

The basket is the other lever. Average items per basket and average basket value are numbers a supermarket can move through range, layout, promotions and the fresh departments, and they compound across the volume in a way that a price change on one item does not.

The cost rhythm that runs against it

The supermarket's costs run on a faster clock than its revenue.

Deliveries arrive daily, several times a day for fresh categories, and each has to be counted, put away and rotated before the next. Fresh goods lose value every day they sit; some lose all of it. Labour is the largest controllable cost and it has to be placed hour by hour against a customer flow that peaks sharply and predictably. Waste is a daily event, recorded or not. Shrink accumulates continuously and is only measured when something is counted.

Set against a margin earned in small amounts, this rhythm means the store's result is decided by discipline in routines that happen every day: receiving against the order, rotating fresh stock so the earliest date sells first, marking down before the date rather than at it, recording waste when it goes in the bin, staffing the checkouts for the hour the queue forms, and counting the categories that leak.

The records of those routines are where the store's real margin lives, and they are the records most often kept on a clipboard.

Where the record usually breaks

A supermarket is a large, well-equipped operation and its systems usually cover the sale. The breaks are between the systems and at the department level.

When the department is not a business

The POS reports store sales. Waste is on a sheet in the back. Markdowns are on the shelf edge. Nobody produces produce's margin after waste for last week, so nobody knows that produce lost money on a strong sales week.

When fresh stock has no date in the system

The chiller is full. Which units are from Monday's delivery and which from Thursday's is written on the case, not held anywhere that could warn the department manager, and the markdown happens when someone notices.

When the promotion outlives its funding

The supplier funded a two-week offer. The shelf-edge price stayed for four. The store gave two weeks of discount at its own expense, and the claim for the first two was never raised because nobody recorded what was agreed.

When the shelf is empty and the back store is full

The item shows stock. The shelf is empty. The units are in the back, unreceived onto the floor, and the customer walks to a competitor while the store technically has what they wanted.

What supermarket software holds

Departments

Each department with its own items, suppliers, stock, waste, markdown and margin, rolling up to the store.

Fresh and weighed items

Items sold by weight with scale codes and unit-of-measure handling, dates captured at receipt, and FEFO rotation with markdown windows by category.

Replenishment by department

Reorder against sales velocity and delivery frequency per department, with supplier order days and cutoffs, feeding orders to each supplier's own method.

Receiving at the dock

Deliveries counted against orders on a phone, with short, damaged and short-dated stock recorded and passed to claims.

Promotions and supplier funding

Each offer with its dates, items, mechanics and the funding agreed, the label reprint list at start and end, and the claim raised when the offer closes.

Waste and markdown

Waste recorded by item and reason as it happens, markdowns recorded with the step and the result, both attributed to the department.

Shelf availability

Out-of-stocks at the shelf recorded by gap scan or by staff, distinguished from out-of-stocks in the store.

Manager's daily view

Sales, margin after waste and markdown, out-of-stocks, waste and labour hours against sales, by department, on a phone before the store opens.

Workflows this business depends on

Why supermarkets choose Pentoggle

Departments as businesses

Stock, waste, markdown and margin per department, rolled up to the store, so produce and dry grocery are managed as the different operations they are.

Fresh goods with dates and a window

FEFO rotation, markdown windows by category and waste recorded as it happens, so the value in short-dated stock is recovered rather than binned.

Supplier funding tracked and claimed

The agreement held with the promotion, the offer ended on its date, and the claim raised when it closes.

The shelf, not only the store

Out-of-stocks at the shelf distinguished from stock in the building, because the customer only sees the shelf.

Sits around your accounting, your POS and your supplier portals

QuickBooks, Tally, Xero and comparable systems continue handling the books. Your multi-lane POS and scales continue at the checkout. Supplier portals continue taking orders. Pentoggle runs the department layer between them.

A useful number for a supermarket

Department margin after waste and markdown, read alongside out-of-stocks at the shelf by department.

The first is what each department actually earned. Read after waste and markdown, because those are where a fresh department's margin goes, and read by department, because the store total blends departments that are in different situations.

The second is the sale the department did not make. A department with good margin and high shelf out-of-stocks is protecting margin by under-ranging or under-replenishing, and the customer is going elsewhere for those items and possibly for the basket.

Read both weekly by department, and read waste as a share of that department's sales beside them. A rising waste share in a fresh department with flat sales is a buying or rotation finding, and it shows here weeks before it shows in the accounts.

Ready to build supermarket software?

You know what the store sold last week.

You may not be able to say which department lost money after waste, which shelves were empty while the back store was full, or how much supplier funding you earned and did not claim.

Describe your departments, your suppliers and how the day runs to Pentoggle in plain English and generate a working first version in hours, then refine it around your process.

Related resources

Frequently asked questions

Software that runs a multi-lane, department-based store as the set of businesses it is: department stock, margin and shrink, fresh and weighed items with dates and rotation, replenishment against daily deliveries, promotions with supplier funding, waste and markdown recorded as they happen, and a daily view by department.

You write. We build.

Your idea, live on the web today. Start with a single sentence.

Start building