Skip to main content
Warehouse data file specification

How to format the warehouse data file for the Advanced CSV connector

S
Written by Sara Jaffer
Updated over 2 weeks ago

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.

You can import warehouse data to create and update the warehouses used by the Advanced CSV connector.

At least one warehouse must be created, though multiple warehouses are supported. After creating additional warehouses, you can use a variant warehouse file to associate variants to specific warehouses. A variant warehouse file is also used to store and update variants’ stock levels against the different warehouses. Learn more about variant warehouse files here.

Note: The warehouse file must be included in the initial sync, as other entities rely on its data.

Warehouse data columns

The 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

WAREHOUSE_ID

VARCHAR(256)

Unique ID

(only unique to the connector)

DISPLAY_NAME

VARCHAR(256)

Warehouse name

UPDATED_AT

TIMESTAMP_NTZ

Row last updated timestamp

REMOVED

BOOLEAN

Soft remove the warehouse by setting to “true”

CURRENCY

CHAR(3)

3-letter ISO code.

If not included, the connector will use the connector currency.

BILLING_ADDRESS

VARCHAR(256)

Warehouse billing address

SHIPPING_ADDRESS

VARCHAR(256)

Warehouse shipping address

Outside of the file, the following warehouse settings can be configured directly in Inventory Planner:

  • Enable/disable warehouse

  • Ignore stockouts

  • Enable low stock alerts

  • Enable vendor low stock alerts

  • Maximum stock in units

  • Default warehouse priority

  • Allow production of assemblies

Did this answer your question?