Retailer Data Overview

💡Use this handy guide to understand more about SKUtrak’s Sainsbury’s connector.

Apollo's bid for Sainsbury's may be speculation, but UK grocers remain  attractive investments | Comment & Opinion | The Grocer

 

About this data source

Sainsbury's has replaced their Horizon reporting system with the Circana SupplyHub application. Discover more here.

 

Status page 

Please use this link to access our status page on all retailer data feeds and please ensure to subscribe to our email updates.

 

Historical data overview: Sainsbury’s

 

Measure

Days

Weeks

       

Estate Level

Store Stock

28

4

Estate Level

Availability

28

4

Estate Level

Sales Value

28

4

Estate Level

Sales Volume

28

4

Estate Level

Average Price

28

4

Estate Level

Average Stores Ranged

28

4

Estate Level

Rate of Sale Units

28

4

Estate Level

Rate of Sale Value

28

4

Estate Level

Lost Sales Value

28

4

Estate Level

Lost Sales Volume

28

4

Estate Level

Lost Sales % (Value)

28 

4

Estate Level

Lost Sales % (Volume)

28 

4

Depot Level

Supplier Service Level

1

 

Depot Level

Supplier Ordered

1

 

Depot Level

Supplier Matched

1

 

Depot Level

Supplier Credited

1

 

Depot Level

Depot Service Level

28

4

Depot Level

Depot Matched/Satisfied

28

4

Depot Level

Depot Credited

28

4

Depot Level

Depot Stock

28

4

 

 

Sainsbury’s data glossary:

Metric

Definition

Origin

Sales Value

Electronic Point of Sales (EPOS) value recorded

Retailer

Sales Volume

As above in units

Retailer

Rate of Sale Value (RoS)

EPOS daily sales value recorded for each store ÷ by either stores ranged or stores stocked

SKUtrak

Rate of Sale Volume (RoS)

As above in units

SKUtrak

Average Selling Price

Sales Value ÷ by Sales Volume

SKUtrak

Waste Value

Bin Waste at retail price

Retailer

Waste Volume

As above in units

Retailer

Waste Value %

Wastage Value as a % of Total Sales Value

Retailer

Waste Volume %

As above in units

Retailer

Availability %

The % of stores ranged where stock > 0

Retailer

Lost Sales Value

  • IF no stock showing in-store and no sales recorded on the day
    = Lost sales calculated by taking the average rate of sale on the day for stores with stock
  • IF no stock showing in-store but some sales recorded on the day
    = Lost sales calculated by subtracting the amount sold from the average rate of sale for stores with stock

Retailer

Lost Sales Volume

As above, in units

Retailer

Lost Sales Value %

Lost Sales Value, as a % of Total Sales Value

SKUtrak

Lost Sales Volume %

As above in units

SKUtrak

Supplier Ordered

Number of cases ordered into depot

Retailer

Supplier Matched

Number of cases delivered into depot

Retailer

Supplier Credited

Number of cases not fulfilled

Retailer

Supplier Service Level %

% of cases ordered which were fulfilled

SKUtrak

Depot Ordered

Stock units ordered from depot into store on the original order date

Retailer

Depot Matched

Stock units delivered from depot into store

Retailer

Depot Credited

Stock units not fulfilled from depot into store

Retailer

Depot Stock

Stock units in depot

Retailer

Store Stock

Stock units in store

Retailer

Average Stores Ranged

Total number of stores a product is ranged in

Retailer

 

 

 

FAQs

Q:  Do you collect store level data from ‘Big Button’?

Currently, we do not collect this due to accessibility issues and limitations to collect this data. 

 

Q. Why can I no longer see Sainsbury’s data within my SKUtrak account?

Following Sainsbury’s migration from the former Horizon system to the new Circana SupplyHub feed and as notified on July 30th, we have worked with Circana to reach an agreeable (three-way) Third Party Agreement ("TPA") to cover Atheon, Circana and Sainsbury's and define how SKUtrak will receive, process, analyse and supply SupplyHub data to you.

This means that this data will only be available to users from 21st December 2024 who have completed and agreed access to this service following Sainsbury’s transition from the Horizon reporting system to the Circana SupplyHub application. 

Our paying customers are eligible for a party data sharing agreement which allows the Circana data to be used to power your SKUtrak service. Unfortunately this means our historical ‘free’ Sainsbury’s service is no longer available.

Full details on the transition can be found here.

If you wish to discuss access to this service, please contact the Customer Success team at customersuccess@atheon.co.uk.

To discover how to upgrade your account to access this service, please contact our team here.