The Advanced CSV connector is in Early Access. If you're interested, you can click here to apply to our Early Adopter Program.
Note: The Advanced CSV connector is only available to Premium subscribers. Contact Inventory Planner Support to learn more about upgrading to Premium.
The data in the variant warehouse file tells Inventory Planner how variants appear in the relevant warehouses. Variants can be in multiple warehouses.
Inventory levels for variants are displayed for each individual warehouse. The inventory level included in the file should be the available stock (total stock minus stock already allocated to orders).
Note: The warehouse and variant files must be supplied to the Advanced CSV connector before or at the same time as the variant warehouse file.
Variant warehouse data columns
The variant warehouse file supports the following columns. If a required column is missing, or an unsupported column is present in the file, the file will not be processed.
Column name | Required | Column type | Comments |
VARIANT_ID | ✓ | VARCHAR(256) |
|
WAREHOUSE_ID | ✓ | VARCHAR(256) |
|
IN_STOCK | ✓ | FLOAT | Current inventory level. Should be the variant’s available inventory (total stock minus stock already allocated to orders). |
REMOVED | ✓ | BOOLEAN | Soft remove the association by setting to “true”. The variant will no longer appear in the warehouse and its stock in that warehouse will no longer be visible. |
UPDATED_AT | ✓ | TIMESTAMP_NTZ | Row last updated timestamp |
GROSS_WEIGHT |
| FLOAT |
|
MIN_STOCK |
| FLOAT |
|
MAX_STOCK |
| FLOAT |
|
MAX_ORDER |
| FLOAT |
|
TRANSFER_UOM |
| FLOAT |
|
Outside of the file, the following variant warehouse settings can be configured directly in Inventory Planner:
Lead time
Days of stock
Custom alert
Enable alert
Notify in advance
Assembly time
Assembly cycle