industry-department-solutions

latest

false

Supply Chain & Retail Solutions API guide

Last updated Apr 16, 2026

Markdown and Promotions Data Model

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`	`parent_product_category_id` → `product_category`
`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`
`stock`	`location_id`, `product_id`, `stock_date_at`	`location_id` → `location`, `product_id` → `product`
`tax`	`location_id`, `product_id`	`location_id` → `location`, `product_id` → `product`

On this page

Tables Summary

Was this page helpful?

PREVIOUSMarkdown & Promotions

NEXTLocation