Locations dataset

Locations dataset for the Markdown & Promotions module, defining the stores or locations where products are sold and stocked.

The Locations dataset defines the stores or locations where products are sold, stocked, and priced. It provides the geographic and currency context used across the Markdown & Promotions module.

This dataset acts as a reference dataset and is joined to other datasets, such as Sales, Stock, and Product pricing daily, using the location_id.

Purpose

The Markdown & Promotions module uses the Locations dataset to:

• Define where products are sold and stocked
• Enable analysis across stores, regions, and channels
• Provide the currency context for value-based metrics

Required fields

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
location_id	Unique identifier for the store or location.	string	Primary key
country	Country in which the location operates.	string	Non-null
created_at	Timestamp when the record was created.	timestamp	Nullable
updated_at	Timestamp when the record was last updated.	timestamp	Nullable
name	Name of the location.	string	Nullable
region	Region used to segment locations for analysis.	string	Nullable
currency	Currency used at the location.	string	Nullable

Usage notes

• Every location referenced in other datasets must exist in the Locations dataset.
• The location_id must be consistent across all datasets.

Why this dataset matters

Location context lets the solution analyse markdown and promotion performance by store, region, or channel, and normalise values across currencies.