Retailer Data Overview

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

Image Library – About Iceland

 

About this data source

SKUtrak collects data from Iceland through file-based email reports sent to SKUtrak. Currently, this data is updated on a weekly basis.

 

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: Iceland

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

 

1

Estate Level

Availability

 

1

Estate Level

Sales Value

 

1

Estate Level

Sales Volume

 

1

Estate Level

Average Price

 

1

Estate Level

Average Stores Ranged

 

1

Estate Level

Rate of Sale Volume

 

1

Estate Level

Rate of Sale Value

 

1

Estate Level

Lost Sales Value

 

1

Estate Level

Lost Sales Volume

 

1

Estate Level

Lost Sales % (Value)

 

1

Estate Level

Lost Sales % (Volume)

 

1

Depot Level

Depot Inbound  %

 

1

Depot Level

Supplier Ordered

 

1

Depot Level

Supplier Matched

 

1

Depot Level

Supplier Credited

 

1

Depot Level

Depot Matched/Satisfied

 

1

Depot Level

Depot Stock

 

1

 

Iceland data glossary:

Metric

Definition

Origin

Sales Value

Electronic Point of Sales (EPOS) value recorded

Retailer

Sales Volume

Electronic Point of Sales units

Retailer

Rate of Sale Volume (RoS)

As above in units

SKUtrak

Rate of Sale Value (RoS)

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

SKUtrak

Average Selling Price

Sales Value ÷ by Sales Volume

SKUtrak

Availability %

In store availability as defined by Iceland

Retailer

Lost Sales Value

Assumed number of stores unavailable (based on Stores Ranged & Availability %) x  average rate of sale on the day for stores assumed available

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 Stock

Stock cases on hand in depot

Retailer

Store Stock

Stock cases on hand in stores

Retailer

Average Stores Ranged

Total number of stores a product is ranged in

Retailer

 

FAQs

Q:  How does SKUtrak collect data from Iceland, and how often is it updated?

The sign-up process for Iceland involves setting up a forwarding email address. Once this is set up, the data is sent directly from the provided email address, which is auto-forwarded to SKUtrak. From there, SKUtrak processes the data for tracking and analysis.

 

Q:  What are the current limitations in data visibility? 

This data set is limited to the historical and current data provided, which may not include deeper or more extensive historical records provided to SKUtrak by suppliers.