industry-department-solutions
latest
false
Supply Chain & Retail Solutions API guide
- Overview
- API Resources
Markdown and Promotions Data Model
Entity Relationship Diagram (ERD) for the B2C pricing (markdown and promotions) data model, showing relationships between products, locations, and pricing entities.
This data model supports the Merchandising solution. For a full overview of the solution, see About the Merchandising Solution.
Tables Summary
| Object | Primary Key | Foreign Keys |
|---|---|---|
location | location_id | - |
product_category | product_category_id | - |
product | product_id | lowest_product_category_id → product_category |
product_extra | product_extra_attribute, product_extra_value, product_id | product_id → product |
product_pricing_daily | location_id, pricing_at, product_id | location_id → location, product_id → product |
purchase_order | order_number, product_id | product_id → product, location_id → location |
sale | location_id, product_id, sold_at | location_id → location, product_id → product |
sale_extra | product_id, location_id, product_variant, sold_at | product_id → product, location_id → location |
stock | location_id, product_id, stock_date_at | location_id → location, product_id → product |
stock_extra | product_id, location_id, product_variant, stock_date_at | product_id → product, location_id → location |
tax | product_id, location_id, created_at | location_id → location, product_id → product |
currency_conversion | from_currency, to_currency, created_at | - |