Units per transaction (UPT)
Units per transaction (UPT) is total units sold in a period divided by the number of transactions (receipts): the average number of items a customer buys per trip.
Also calledUPT, items per transaction, IPT, units per basket
Formula
Total units sold ÷ Number of transactions (receipts)- Total units sold
- Net units sold after returns; for weighed products, the number of receipt lines.
- Number of transactions
- Sales receipts in the period, excluding voided and return receipts.
Calculator
Enter your own figures and the result updates instantly. The defaults are the figures from the worked example below.
Result2,4 units
Worked example
How to read it, and what good looks like
UPT is the only basket measure free of price effects. If average transaction value is rising under inflation while UPT falls, customers are buying fewer items and growth is coming from price. That is why UPT is tracked as the unit-based measure alongside LFL and average transaction value. The formula and the order of intervention are covered in detail in the basket size and store productivity guide; this page is for the quick calculation.
Differences between formats and categories are structural: a big weekly shop naturally carries many lines, while a receipt with a few items is normal in a neighbourhood branch people visit for bread and milk. Compare by category and store cluster rather than the chain average, against your own quarterly history. When UPT falls, the levers are cross-selling, complementary product placement, the till-point layout and bundle offers. A rise on its own is not margin: a "3 for 2" offer lifts units while cutting unit price and margin.
In Mindpera, Mind Ops calculates UPT from the receipt line, in the same data model as revenue, conversion and average transaction value; running the report twice for the same day returns the same number, and a store that drifts from its cluster band lands on its owner as a task.
Where it misleads
- If weighed products are summed in kilograms, 1.35 kg of tomatoes counts as 1.35 items; count a weighed product as one receipt line.
- Non-product lines such as carrier bags, service charges and gift wrapping inflate UPT; flag them in master data and leave them out.
- Whether a multipack (a six-pack of water) is one item or six is written into the selling-unit definition; changing it breaks the historical series.
- Returned units are deducted from net units, but the return receipt is not added to the transaction count; otherwise the basket shrinks artificially on high-return days.
Data you need
- Receipt line: product, selling unit, quantity, return flag
- Product master data: weighed product, multipack and non-product line flags
- Receipt header: void and return receipt flags
Mindpera products that calculate this KPI
Frequently asked questions
- How do you calculate units per transaction?
- Divide total units sold by the number of transactions (receipts) in the same period. A store that sold 30,000 items across 12,500 receipts has a UPT of 30,000 ÷ 12,500 = 2.4. Returned units are deducted, and voided and return receipts are not counted. Weighed products count as lines rather than kilograms, and bags and service lines are excluded.
- What is a good units per transaction figure?
- There is no single right value; format and category decide it. Many items per receipt is natural in a big weekly shop, while a few items per receipt is normal in a small branch visited for daily needs. The right comparison is within the same category and store cluster, against your own quarterly history. The trend says more than the level: rising ATV with falling UPT means growth is coming from price.
- How should UPT and average transaction value be read together?
- Average transaction value = UPT × average unit price. If both rise, customers are buying more and pricier items. If ATV rises while UPT falls, the increase comes from price and the basket may be shrinking in real terms. If UPT rises while ATV falls, discounted and bundle sales have gained weight, and margin needs checking separately.