Return Authorisation Item Analytics in Retailer

Return Authorisation Item Analytics: Know What's Still Selling

Send back the right stock, keep the stock that sells. Available in Retailer 2611.4 or later, Item Analytics shows you, on every line of a Returns Authorisations request, whether a title is still selling, how long your stock will last, and how much of the delivery has sold. You decide what goes back with the facts in front of you, instead of finding out when you pull it off the shelf. The figures come from your store's sales history and deliveries.

New to Returns Authorisations? Start with Using the Returns Authorisations Console.

Before you start

  • Returns Authorisations activated. If it isn't, the screen opens with an upgrade message. Contact support to activate it.
  • The appropriate password (if one is set for Returns Authorisation).
  • Stock received through Arrivals. Sell-through is measured against supplier invoices received in Arrivals. Titles never received that way won't have a sell-through figure.

In a multistore setup, all figures are for the store you're currently logged in to.

What each line shows

The figures sit under the Sales performance heading on the right of the request:

  • Selling? – the verdict badge: Selling, Slowing or Dormant. This answers “is this still selling?”
  • Last Sold – when it last sold, and how many days ago.
  • 3 / 12 mth – units sold in the last 3 and 12 months.
  • Cover (mths) – how many months your current stock will last at the past year's rate of sale. This is the main figure to decide on.
  • Sell Thru % – how much of the delivery has sold.
  • Sold Since Arr. – units sold since the delivery arrived.
  • Last Recd – when you last received it.

How the verdict badge is decided

VerdictMonths of coverWhat it suggests
● Selling3.0 or lessStock is moving – usually keep it.
● SlowingMore than 3.0, up to 12.0Still selling, but you hold more than a quarter's worth. Worth a look.
● DormantMore than 12.0, or no sales in 12 monthsA strong return candidate.

The badge, the shading on Cover and the Sell Thru bar all use the same colours, so they always agree.


Build a request and read the figures

You build a request exactly as before – the figures are added for you to the right of each line.

1. Start a new request

  • Go to Stock Maintenance › Stock Returns › Returns Authorisations. Enter the password if asked.
  • Click + New request.
  • Choose the Supplier.
  • Choose a Range type: Arrival date (the default – enter from and to dates), Invoice number, Recall (book recall suppliers) or Manual (add titles one by one).
  • Optionally enter a Submission due date.

2. List the stock

Click List stock -> and enter your initials if asked. For large ranges (over 200 lines) a progress window shows while the figures are worked out.

3. Read the figures

The request opens with your strongest return candidates at the top – Dormant titles first, then highest months of cover. Start reading from the top.

For each line, check the Selling? badge first, then Cover (mths) and Sell Thru %.

IdeaTip: hover over a Cover (mths) figure to see how it was worked out – for example, “3 on hand ÷ 0.33 sold a month = 9.0 months”.

4. Decide and save

  • To keep a title, untick its Incl. box.
  • To send back only some, change Qty to Return.
  • Click Save.

Each time you reopen the request, the figures refresh with that day's sales and stock. Retailer also keeps a copy of the figures from when each line was first saved, so you have a record of what each decision was based on.

Handy grid options

  • Filter by verdict – click the filter icon on the Selling? heading, for example to see only Dormant titles.
  • Sort – click any column heading. Your choice is remembered.
  • Show or hide columns – right-click a column heading. Days Since and 12 Mth are hidden by default.
  • Find – type part of a title or barcode to jump to it.
  • Print pick list – choose departments, print order, and whether to leave out items with nothing on hand. This never changes the request itself.

A quick example

Sample Card GameSample Board Game
On hand35
Sold in last 12 months44
Cover (mths)3 ÷ (4 ÷ 12) = 9.05 ÷ (4 ÷ 12) = 15.0
VerdictSlowingDormant
Sell Thru %2 of 2 sold = 100%1 of 2 sold = 50%

The card game sold its whole delivery but has slowed down – worth a look. The board game has 15 months of stock and only half its delivery sold – the stronger return candidate.


Frequently Asked Questions

A title hasn't sold for months but shows Selling. Why?
The verdict measures how long your stock will last, not how recently it sold. If you hold just 1 copy and sold 4 in the year, that's only 3 months of cover. Check Last Sold alongside the badge.

Lines with nothing on hand show Selling and 0.0 cover
There's no stock left to return, so Qty to Return is set to 0.

Sell Thru % is over 100%
The line is measured against its oldest delivery in the range, but every sale since is counted – including stock from later deliveries.

Sell Thru % is negative
More units were refunded or credited than sold since the oldest delivery arrived.

Sell Thru % shows -
The line has no delivery arrival to measure against – usually because it was added with Add item without picking an arrival.

12 Mth doesn't match Sold Since Arr.
They're worked out from different sales records, so small differences are normal.

The figures changed when I reopened a request
They refresh every time you open it. The figures from when each line was first saved are kept on record.

Does Item Analytics return anything automatically?
No. Nothing is excluded until you untick Incl. or change Qty to Return.