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 are shared across warehouses—if a variant is added for a connection, it appears in all warehouses—but if a variant isn't stocked in a particular warehouse, you don't need to add any inventory data.
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.
Tip: If you would like to hide variants from warehouses where they're not stocked, contact Inventory Planner support and ask them to disable the "Show all variants from corresponding connection regardless if there is a stock in warehouse" admin-only setting. Learn more about admin-only settings here.
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).
This value can be negative. If supplied as negative from the source system, it will not be rejected as an error. |
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 |
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