Retailer Data Overview

💡Use this handy guide to understand more about SKUtrak’s Co-op connector.

Co-op soft drinks range reset puts squeeze on sugar | News | The Grocer

About this data source

SKUtrak collects data directly from Co-op's Business Intelligence Database as part of our agreement. This data is updated daily in the morning.

The data includes trading data for The Co-op Group stores and depots only and does not include any societies.

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: Co-op

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	738	105
Estate Level	Availability	738	105
Estate Level	Sales Value	738	105
Estate Level	Sales Volume	738	105
Estate Level	Average Price	738	105
Estate Level	Average Stores Ranged	738	105
Estate Level	Rate of Sale Volume	738	105
Estate Level	Rate of Sale Value	738	105
Estate Level	Lost Sales Value	738	105
Estate Level	Lost Sales Volume	738	105
Estate Level	Lost Sales % (Value)	738	105
Estate Level	Lost Sales % (Volume)	738	105
Depot Level	Depot Inbound %	738	105
Depot Level	Supplier Ordered	738	105
Depot Level	Supplier Matched	738	105
Depot Level	Supplier Credited	738	105
Depot Level	Store Inbound %	738	105
Depot Level	Depot Ordered	738	105
Depot Level	Depot Matched/Satisfied	738	105
Depot Level	Depot Credited	738	105
Depot Level	Depot Stock	738	105
Store Level	Sales Value	738	105
Store Level	Sales Volume	738	105
Store Level	Rate of Sale Value (Stores stocked)	738	105
Store Level	Rate of Sale Volume (Stores Stocked)	738	105
Store Level	Store Stock	738	105
Store Level	Waste Value	738	105
Store Level	Waste Volume	738	105
Store Level	Waste Value (Markdown)	738	105
Store Level	Waste Value (Bin Waste)	738	105
Store Level	Waste Volume (Markdown)	738	105
Store Level	Waste Volume (Bin Waste)	738	105
Store Level	Wastage % (Value)	738	105
Store Level	Wastage % (Volume)	738	105

Co-op 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	SKUtrak
Rate of Sale Volume (RoS)	EPOS daily sales value recorded for each store ÷ by either stores ranged (estate only) or stores stocked (estate & store)	SKUtrak
Average Selling Price	Sales Value ÷ by Sales Volume	SKUtrak
Waste Value (Markdown)	Total value of markdown reductions	Retailer
Waste Value (Bin Waste)	Total value of bin waste at retail price	Retailer
Waste Volume (Markdown)	Total volume of markdown reductions	Retailer
Waste Volume (Bin Waste)	Total volume of bin waste at retail price	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, based on daily gap scan reports	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 cases in depot	Retailer
Store Stock	Stock units in store	Retailer
Stock Cover	Number of days that current stock quantity in depot & store would last, based on the current sales forecast	Retailer
Average Stores Ranged	Total number of stores a product is ranged in	Retailer
Stores Selling	Total number of stores which sold a product on a given day	SKUtrak

FAQs

Q: How are societies represented in Co-op data?

We do not currently get sales data from the societies, but we are able to see the group sales.