Dataset

dominicks-scanner

Open Data Contract Standard v3.1.0

scanner groceries-and-food

Fundamentals

Basic information about the data contract

Name: Dominicks Finer Foods scanner dataset
Version: 1.0
Status: Draft
Target documentation level: 2
Tenant: Chicago Booth School of Business
Purpose: A dataset made up of 9 years of transaction (scanner) data for 26 different categories in 100 stores sold by Dominick's finer foods (a now defunct retailer in Chicago in the 90s).
Usage: Open dataset on seasonal products shared by Chicago Booth School Kilts Center for Marketing

Link to dataset:

Dataset site (see "Category Specific Files" section): https://www.chicagobooth.edu/research/kilts/research-data/dominicks

Dataset paper: Mehrhoff (2018) Promoting the use of a publically available scanner data set in price index research and for capacity building

Data Manual: Dominick's Data Manual
How to cite: APA style:
Kilts Center for Marketing (2013), Dominick's Data Manual, Chicago

Chicago style
TBC

Bibtex citation
Click here for raw form

Entity Relationship Diagram

Visual representation of data model relationships

                    erDiagram
	"**movement**" {
	store⌘ integer
	upc⌘ number
	week⌘ integer
	move integer
	qty integer
	price number
	sales number
	profit number
	sale number
	ok integer
}
	"**upc**" {
	upc number
	com_code integer
	nitem integer
	descrip string
	size string
	case integer
}
	"**stores**" {
	store integer
	city string
	price_tier integer
	zone integer
	zip_code integer
	address string
}
	"**weeks**" {
	week_num integer
	start object
	end object
	special_events string
}

"**stores**" ||--o{ "**movement**" : store
"**upc**" ||--o{ "**movement**" : upc
"**weeks**" ||--o{ "**movement**" : week_num

Schema

The data schema and structure

movement None The movement (or turnover) data. Schema identical but this is provided separately for each of the 26 categories.
Property	Business Name	Type	Required	Description
store	Outlet id	integer	No	Store number (references store data on https://github.com/eurostat/dff/blob/master/CSV/stores.csv)\| Example: 76
upc	Product ID	number	No	Universal Product Code for sold product
week	Sales week	integer	No	Week number representing the sales (references weeks data on https://github.com/eurostat/dff/blob/master/CSV/weeks.csv)
move	Quantity sold	integer	No	Number of units sold
qty	Quantity sold	integer	No	Quantity of products sold
price	Product price	number	No	Price a product (i.e. the UPC) was sold for
sales	Product sales	number	No	Derived variable for sales per UPC (SALES = PRICE x MOVE / QTY)
profit	Product profit	number	No	Profit per UPC (PROFIT = SALES - COST)
sale	Product sale	number	No	Sale value per UPC (SALE = PRICE x MOVE)
ok	Valid record flag	integer	No	Flag indicating if the record is valid (1) or not (0)

upc None List of unique products (tracked by UPC) sold by category
Property	Business Name	Type	Required	Description
upc	Product ID	number	No	Universal Product Code for sold product
com_code	Commodity code	integer	No	Commodity code (Dominick's version of categories). Lower granularity that each category file, hence one file may have more than one COM_CODE
nitem	Item code	integer	No	Item code (attempt at tracking products across multiple UPCs)
descrip	Product description	string	No	Description of the product (i.e. the UPC)
size	Product size	string	No	Size of the product
case	Case number	integer	No	Case number (i.e. the number of products in a case)

stores None Retailer outlets
Property	Business Name	Type	Required	Description
store	Outlet id	integer	No	Store id (references store data on https://github.com/eurostat/dff/blob/master/CSV/stores.csv)
city	Store city	string	No	City where the store is located
price_tier	Price tier	integer	No	Price tier of the store
zone	Store zone	integer	No	Zone of the store
zip_code	Store zip code	integer	No	Zip code of the store
address	-	string	No	Address of the store

weeks None Week definition file
Property	Business Name	Type	Required	Description
week_num	Sales week	integer	No	Week number representing the sales (references weeks data on https://github.com/eurostat/dff/blob/master/CSV/weeks.csv)
start	-	object	No	Pricing week started on date, MM/DD/YY format
end	-	object	No	Pricing week ended on date, MM/DD/YY format
special_events	Special events	string	No	Special events that occurred during the pricing week

Created at 24 Feb 2026 05:02:50 UTC with Data Contract CLI v0.11.5