💡Use this handy guide to understand more about SKUtrak’s Tesco connector.
About this data source
SKUtrak collects data from the Tesco Partner Toolkit in several ways. Once a week, we receive the range performance file, which indicates which products are available in how many stores. On a daily basis, we pull sales and stock data separately at both the estate level and store level. The estate-level data provides additional metrics, such as customer service levels.
Additionally, we receive inbound service level information daily, which includes depot data. The range performance data is updated weekly. SKUtrak also collects data through late polling, which accounts for retroactive data changes. This approach helps us identify core changes and ensures the accuracy and reliability of the data we provide.
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: Tesco
Use this matrix to see an overview of historical data available when SKUtrak is first connected, determined by the number of days or weeks of data available per measure.
|
Measure |
Days |
Weeks |
|
|
Estate Level |
Store Stock |
41 |
104 |
|
Estate Level |
Availability |
28 |
4 |
|
Estate Level |
Sales Value |
41 |
104 |
|
Estate Level |
Sales Volume |
41 |
104 |
|
Estate Level |
Average Price |
41 |
104 |
|
Estate Level |
Average Stores Ranged |
28 |
4 |
|
Estate Level |
Rate of Sale Units |
41 |
104 |
|
Estate Level |
Rate of Sale Value |
41 |
104 |
|
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 |
100 |
104 |
|
Depot Level |
Supplier Ordered |
100 |
104 |
|
Depot Level |
Supplier Matched |
100 |
104 |
|
Depot Level |
Supplier Credited |
100 |
104 |
|
Depot Level |
Depot Service Level |
100 |
104 |
|
Depot Level |
Depot Ordered |
100 |
104 |
|
Depot Level |
Depot Matched/Satisfied |
100 |
104 |
|
Depot Level |
Depot Credited |
100 |
104 |
|
Depot Level |
Depot Stock |
28 |
4 |
|
Store Level |
Sales Value |
56 |
8 |
|
Store Level |
Sales Volume |
56 |
8 |
|
Store Level |
Rate of Sale Value (Stores Stocked) |
56 |
8 |
|
Store Level |
Rate of Sale Volume (Stores Stocked) |
56 |
8 |
|
Store Level |
Store Stock |
56 |
8 |
|
Store Level |
Waste Value |
56 |
8 |
|
Store Level |
Waste Volume |
56 |
8 |
|
Store Level |
Wastage % (Value) |
56 |
8 |
|
Store Level |
Wastage % (Volume) |
56 |
8 |
Retailer specific definitions
|
Metric |
Definition |
Origin |
|
Sales Value |
Electronic Point of Sales (EPOS) value recorded |
Retailer |
|
Sales Volume |
Electronic Point of Sales units |
Retailer |
|
Rate of Sale Value (RoS) |
EPOS daily sales value recorded for each store ÷ by either stores ranged (estate only) or stores stocked (estate & store) |
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 Value % |
Wastage Value as a % of Total Sales Value |
Retailer |
|
Availability % |
Tesco CSL % |
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 |
SKUtrak |
|
Lost Sales Volume* |
As above, in units |
SKUtrak |
|
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 |
|
Depot Inbound % |
% 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 |
|
Store Inbound % |
% of stock ordered which was fulfilled from depot into store |
SKUtrak |
|
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: How are online sales broken out for Tesco?
There are limitations in the data available to fully break out online sales. However, we do report customer fulfilment centres (CFCs) alongside their respective stores within the store-level data, providing an indicator of online sales performance.
Retailer specific definitions
|
Metric |
Definition |
Origin |
|
Sales Value |
Electronic Point of Sales (EPOS) value recorded |
Retailer |
|
Sales Volume |
Electronic Point of Sales units |
Retailer |
|
Rate of Sale Value (RoS) |
EPOS daily sales value recorded for each store ÷ by either stores ranged (estate only) or stores stocked (estate & store) |
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 Value % |
Wastage Value as a % of Total Sales Value |
Retailer |
|
Availability % |
Tesco CSL % |
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 |
SKUtrak |
|
Lost Sales Volume |
As above, in units |
SKUtrak |
|
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 |
|
Depot Inbound % |
% 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 |
|
Store Inbound % |
% of stock ordered which was fulfilled from depot into store |
SKUtrak |
|
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: How are online sales broken out for Tesco?
There are limitations in the data available to fully break out online sales. However, we do report customer fulfilment centres (CFCs) alongside their respective stores within the store-level data, providing an indicator of online sales performance.