Products dataset

Products dataset for the Inventory Management solution, containing product metadata used across inventory analysis and reporting as a reference dataset.

The Products dataset contains metadata for the products managed by the UiPath solution for inventory management. It defines the items that are planned and provides descriptive and categorical information used across inventory analysis and reporting.

This dataset acts as a reference dataset and is joined to other datasets, such as Customer orders, Stock, Pricing, and Order parameters, using the product_id.

Purpose

The solution uses the Products dataset to:

• Identify the products included in inventory planning
• Enable analysis at both individual product and aggregated levels
• Support reporting and categorization across product hierarchies
• Ensure consistent product identifiers across all datasets

During presales, this dataset is also used to validate product coverage and support category-level analysis.

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_id	Unique identifier for the product SKU. Must match across all related datasets.	string	Primary key Unique
product_name	Name of the product. Improves readability and reporting.	string	Nullable
product_description	Description of the product. Provides additional context.	string	Nullable
product_category	Category or type of the product. Enables aggregated analysis at a category level.	string	Nullable
source_id	Identifier for the supplier or internal distribution centre associated with the product.	string	Non-null
pack_size	Number of units contained in a single pack of the product.	integer	Non-null
minimum_order_quantity	Smallest quantity of the product that can be ordered at one time.	integer	Nullable
product_image_urls	URL(s) referencing images of the product.	string	Nullable

Usage notes

• Every product referenced in other datasets (for example, Customer orders, Stock, Pricing, Purchase orders, or Transfers) must exist in the Products dataset.
• The product_id must be consistent across all datasets.
• Product category information is optional but strongly recommended to support higher-level analysis and reporting.
• Units of measure associated with products must be consistent with related datasets (for example, Stock and Customer orders).
• If supplier relationships vary by location, this relationship should be reflected in the relevant datasets (for example, Order parameters), not encoded solely in the Products dataset.

Why this dataset matters

The Products dataset defines the scope of inventory planning. Without a consistent product reference dataset, the solution cannot reliably join demand, stock, pricing, and replenishment data or generate meaningful inventory insights.