In addition to the required data, Crisp supports several optional fields of data, such as quantity delivered and order status. By providing this optional data, Crisp can improve the fidelity of your forecast.
If this optional data is available to you, label the relevant data with the column headers and format your data to match the specifications outlined below.
|
Column name |
Description |
Example |
|---|---|---|
|
delivered_quantity |
The quantity of product actually delivered. Including this allows us to consider when unfulfilled orders spill over into a later period. |
|
|
product_gtin |
The GTIN / UPC code of the product. Including this allows us link your data to your partners' data more easily. |
|
|
requested_delivery_date |
The date that the requested quantity ideally was to be delivered. Crisp will prefer this date over order date when considering true demand. |
|
|
unit_net_weight |
The net weight of the product (not including packaging), ideally in kilograms. Including this this allows us to roll up sales and forecasts for multiple products. |
|
|
order_status |
The status of the order. Including this allows us to update and cancel existing orders. |
|
|
unit_of_measure |
The unit of measure of the product |
|
|
product_group_name |
This is the name of the group that your product may belong to. For example, if the product is Honeycrisp Apple, the product group name may be Apple. |
|
|
product_group_id |
Identifier of a product group |
|
|
product_group_name_2 |
This is the name of another group, or a sub-category, that your product may belong to. For example, if the product is Honeycrisp Apple, the product group name may be Apple, and Product Group Name 2 may be Fruit. |
|
|
product_group_id_2 |
Identifier of another product group, related to Product Group Name 2 |
|
|
product_group_name_3 |
This is the name of another group, or a sub-category, that your product may belong to. For example, if the product is Honeycrisp Apple, the product group name may be Apple, and Product Group Name 2 may be Fruit, and Product Group Name 3 may be Fresh. |
|
|
product_group_id_3 |
Identifier of another product group, related to Product Group Name 3 |
|
|
per_item_price |
Optional per-item price of the product |
|
Comments
0 comments
Please sign in to leave a comment.