Units per transaction by store: where the upside sits
The short answer
Every store's units per transaction (UPT) is total units sold divided by the number of transactions. Compare stores of similar size and traffic, then size the upside as the gap to the peer average multiplied by transactions and average unit price. Split single-item baskets by customer type to see where an extra item is realistic.
Units per transaction formula, four stores compared
Why it matters
An extra item per basket grows revenue without a single extra visitor. Small UPT gaps add up across thousands of transactions, so a store sitting half a unit below its peers can miss tens of thousands of dollars a quarter.
The question to ask
Copy this into Lexi as written.
How to work it out
1. Calculate UPT by store. Divide units sold by transactions for the quarter, excluding returns and staff purchases.
2. Compare like with like. Group stores by size, format and traffic, then calculate each group's average and each store's gap to it.
3. Look at single-item baskets. Split each store's one-item transactions by new and repeat customers and by category, to see where a second item fits naturally.
What the answer looks like
Illustrative output on sample data
Illustrative example: how Lexi answers this for a beauty retailer with four mall stores. It divides units by transactions for each store over one quarter.
- Store A: 2.5 units per transaction (UPT)
- Store B: 2.6
- Store C: 1.8, across 6,000 transactions
- Store D: 2.4
What the data shows
The group average is about 2.3. Store C trails, and 58% of its transactions are single-item baskets.
What it means
Most of those single-item baskets come from repeat customers restocking one product. They already trust the brand, which makes a pairing suggestion an easy step. Lifting Store C to the average adds about 3,000 units, around $66,000 a quarter at a $22 average unit price.
What to do
Test a sample or pairing prompt at Store C's counter for restock purchases.
Want me to show which products Store C's single-item customers buy?
Frequently asked questions
How do I increase units per transaction without discounting?
Start at the counter and the cart. Train store associates to suggest one item that fits the purchase, place natural pairings together and show complementary items at online checkout. Multi-buy offers lift units too, but they cut margin per unit, so test them against a simple prompt and compare margin dollars per transaction.
Does a higher UPT always mean better selling?
Not always. Multi-buy promotions and low-priced add-ons can raise UPT while revenue per transaction barely moves, or while margin per transaction falls. Read UPT next to average transaction value and margin per transaction. A store with lower UPT but higher-value items may be selling well.
Should returns come out of units per transaction?
Measure UPT on the original sale, then track returns separately. Netting returns out of the same week's units mixes two different behaviors and makes store comparisons noisy. If one store's high UPT comes with a high return rate, report both numbers together so the extra units are not counted as wins.