Product extra dataset

Product extra dataset for the Markdown & Promotions module, holding tenant-specific product attributes in key-value format.

The Product extra dataset holds tenant-specific product attributes in a key-value format, allowing additional descriptive data to be attached to products without changing the core Products dataset.

This dataset extends the Products dataset and is joined using the product_id.

Purpose

The Markdown & Promotions module uses the Product extra dataset to:

• Attach custom, tenant-specific attributes to products
• Support segmentation and analysis using attributes not in the core Products dataset

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
product_extra_attribute	Name of the custom product attribute.	string	Primary key
product_extra_value	Value of the custom product attribute.	string	Primary key
product_id	Unique identifier for the product SKU.	string	Primary key Foreign key to product
created_at	Timestamp when the record was created.	timestamp	Nullable
updated_at	Timestamp when the record was last updated.	timestamp	Nullable

Usage notes

• Each row represents a single attribute-value pair for a product.
• The product_id must reference an existing product in the Products dataset.

Why this dataset matters

Custom attributes let the solution incorporate business-specific product characteristics into markdown and promotion analysis.