Data Tables
Inventory Table
Data Tables
Inventory Table
This table should include current inventory for all products in your store. You may optionally include last 30 days of historical inventory levels which we can use to improve our pricing models and forecasts.
Time Period: Current
Why do we need this? We use this information to account for inventory levels when setting prices. We can use historical inventory levels to improve our future forecasts.
Schema
Unique Constraint:
sku_primary, store_id, timestamp.| Name | Required? | Type | Field Description | Example |
|---|---|---|---|---|
| unique_id | optional | string | If no ID is provided, it will be auto-populated. | |
| sku_primary | required | string | This must match the SKU used in the Product Table. | "sku_178" |
| store_id | optional | string | Fill in if stockouts happen at a location level. Should match store_id in the Product Table, if both are being filled in. If left empty, we will assume inventory is available across all locations. | "loc_3" |
| inventory_level | required | int | Amount of inventory on hand at the time of the specified timestamp | 10 |
| timestamp | required | datetime | Specifies the timestamp when the inventory level was measured. | 2023-01-01 8:00:00 |