Order Line Item Table
The order line item data may be provided as an independent dataset OR as a list of objects included in each order. In either case the line item objects must adhere to the schema defined below, with one exception: If you provide the order line items as an independent dataset you must include a unique identifier for each line item.
This table should include line item details for all historical orders for
products in your store. This table is connected to the orders table via
order_id.
Time Period: 12 months
Why do we need this? We use this information to train our pricing models including calculating the elasticities of your products and projecting future performance. We look at orders at a line item level as well as an order level to see relationships between items within a basket and at a customer-level
Schema
line_item_id.| Name | Required Field | Type | Field Description | Example |
|---|---|---|---|---|
| Identifiers | ||||
| line_item_id | optional | string | Must be unique. Required if this data is not provided as part of the order data. | "12345" |
| sku_primary | required | string | This must match the SKU used in the Product Table. | "sku_variant_12" |
| barcode | optional | string | Barcode value | "12345678905" |
| barcode_type | optional | string | Barcode type - e.g asin/ upc/ gtin | "gtin" |
| Price | ||||
| actual_price_paid | required | float | This is the price paid by the customer for one unit after all discounts have been applied | 13.79 |
| list_price | required | float | This is the price the product was listed at before discounts | 15 |
| item_discount | optional | float | The discount applied to the sku. This should not include order-level discounts already included in the Order table. | 1.21 |
| Costs | ||||
| cost | required | float | The unit cost to be used when calculating revenue and profit in the dashboard and when modeling. | 7.10 |
| custom_costs | optional | ZodJsonObject | {} | |
| Details | ||||
| order_id | required | string | This must match the ID in Order Table | 12 |
| quantity | required | int | 1 | |
| purchase_currency | required | string | e.g “USD” | "usd" |
| misc | optional | json | Any fields that we should know about, but aren’t in our schema? |