Retail pricing

Retail pricing: shelf, flyer and store chain

In retail the price is public. It is on the shelf tag, in the weekly flyer and on the e-commerce screen, and the customer compares yours with the corner store's item by item — not by the category's average margin.

This page covers what changes when pricing is for a store — supermarket, pharmacy, building materials, pet shop: each item's role in the assortment, the turnover curve, the flyer that has to close before it goes out and the distance between the margin the category promises and the one the register delivers.

How the shelf price is formed

Six inputs retail needs at hand before deciding an item's price — and which a spreadsheet per section tends to treat as if they were one.

Invoice cost, with the vendor allowance inside
What the receipt charged: product, freight, ICMS-ST paid on purchase, bonus goods and allowance negotiated with the manufacturer. It is the cost that changes with every load received, and the one the printed price tag does not follow.
The item's role in the assortment
Destination items, traffic items and long-tail items do not accept the same markup. The first defines the price perception of the whole store, the second fills the basket and the third pays for the aggressiveness of the other two.
ABC curve and turnover speed
The item that sells every day accepts a cent of difference; the one that turns once a month accepts margin. Pricing the section with a single percentage treats both as if they sold at the same pace.
Each store's competitor basket
The neighborhood store and the avenue store compete with different rivals. A single chain-wide price leaves margin on the table where there is no fight and loses sales where there is — and both losses happen on the same day.
Item tax, not section tax
NCM, regime and tax substitution change from one item to the next on the same shelf. An average rate per section is wrong on almost every line of it, and always in the same direction.
The margin that closes on the category
The calculation that matters closes on the category, not on the isolated product: the flyer can take an item close to cost as long as the surrounding basket sustains the result. This has to be calculated beforehand, not worked out afterwards.

The calculation for a shelf item, between two receipts

A grocery item bought for R$ 10.00 and sold for R$ 15.90. The calculation is any store's; what it shows is what happens when the price tag stays put and the invoice does not.

The calculation for a shelf item, between two receipts
Invoice costR$ 10.00
Freight allocated to the loadThe same freight weighs more on the slow-turning item.R$ 0.40
ICMS-ST paid on entryAlready paid on purchase: it is cost, not credit.R$ 1.80
Real acquisition costR$ 12.20
Shelf priceR$ 15.90
Card fee (3.5%)R$ 0.56
Item margin19.8% of the sale.R$ 3.14

The next load came in R$ 0.60 more expensive and the price tag stayed at R$ 15.90: the margin fell to R$ 2.54, or 16.0% — 3.8 points nobody sees in the store, because the price tag stays printed and legible. In a category with four thousand items receiving a load every week, this is the difference the month-end close finds too late.

What blocks margin in retail

Five store situations that appear before any discussion of pricing strategy, in the order in which they cost money.

  1. The price tag left behind

    The cost went up on yesterday's receipt and the shelf has the price from three weeks ago. Every day in that gap sells at the old margin, and nobody notices because the price tag stays printed, legible and wrong.

  2. The flyer closed in a rush

    The flyer goes out with the price the competitor advertised, and the replacement cost has already changed since the last purchase. The promotional week's result only shows up at the close — when the promotion is over and the stock is gone with it.

  3. The destination item protected by hand

    Rice, milk, diapers and soda form the price perception of the whole store. Anyone protecting those items by hand protects the ones they remembered — and the reputation for being expensive forms precisely on the ones left off the list.

  4. The same price in unequal stores

    The same price list across the chain ignores that the audience, the competitor and the freight cost change from address to address. The strongest store sells cheap without needing to, and the most contested one sells high without being able to.

  5. The approved price that does not reach the register

    A price decided in the back office and typed into the POS later is a price that diverges from the tag. The difference shows up in front of the customer, at the register, and the store settles by giving the lower of the two — every day, item by item.

Who already sells with the price set before the tag

BW Racer designs and sells ergonomic furniture: product lines with uneven turnover and premium materials, in a catalog where each line needs its own margin rule. It is not a supermarket, and the problem is the same — an assortment that does not accept a single markup.

The REVEMA team's support was exceptional throughout the whole implementation. The platform is intuitive and the results exceeded our expectations. We strongly recommend it.
Renata Ramalho — Consultant, BW Racer

Read the BW Racer case study

The numbers Revema measures in each operation are in results, and the companies that have already left the spreadsheet are in clients.

Where RevPrice fits

RevPrice in a store operation

RevPrice reads from the ERP the cost of each receipt with freight, ICMS-ST and vendor allowance, applies the margin rule the chain defined for that category and returns the suggested price item by item — with the margin calculated before the price tag is printed.

The rule follows the shape of the operation: markup by category, a floor for destination items, price by store and a simulation of the entire flyer before it goes to the printer. Whatever breaks the floor is blocked, with the reason on screen and the name of who can release it.

Frequently asked questions about retail pricing

The questions that come up before the first conversation, with answers written for this kind of operation.

How do you price a destination item without dragging down the category margin?

By separating the item's floor from the category markup. The destination item gets a floor of its own — the lowest price the chain accepts to charge on it — and the category rule recalculates the other items in the basket so that the result still closes with that floor. It is the calculation retail does in its head when putting together the flyer; the software does it for the whole assortment, not just the items someone remembered.

Can prices differ by store within the same chain?

Yes, and it is the usual case in chains with more than one audience profile. The price comes from a rule per category and receives an adjustment by store, by region or by competitor cluster. What does not change is governance: who can change that store's price, down to what floor and with what record.

Does the approved price reach the price tag and the POS on its own?

It does, through the ERP. The approved price goes back to the system the chain already uses to publish prices to the POS and print tags, so that the back office, the register and the shelf read the same price list. Where there are electronic shelf labels, the path is the same: the price comes from the ERP, not from a parallel spreadsheet.

How does the flyer enter the calculation before it is published?

As a scenario. The flyer is built with the proposed items and prices, and the calculation shows each item's margin and the result of the whole basket at current replacement cost. The flyer only goes to the printer after this calculation closes — the opposite of what happens when the promotional margin is worked out the following month.

How many items can a chain reprice at once?

The entire catalog, because the effort is in the rule and not in the item. A new supplier price list changes the cost of hundreds of items at the same time; the rule recalculates all of them and highlights only those that need human decision — the ones that break the floor, the ones that go above the competitor's price and the ones that change psychological range.

Further reading

The blog covers the same subjects with store examples: how to calculate a category's markup, what margin loses to discount and how to read the right cost of a receipt.

Pricing in the other segments

Price is formed differently in each operation. These are the two others Revema serves, each with its own problem and vocabulary.

Want to see this calculation running on your assortment?

Book a conversation with people who price store catalogs every day.