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 variant data to create and update variants in Inventory Planner.

Variants are matched on their Variant ID, which is assigned when creating the variant using the Advanced CSV connector. If you’re creating a variant using the file that already exists in Inventory Planner, you can combine them with your auto combine settings. Learn more about auto combining here.

Inventory levels for variants are loaded into Inventory Planner using a variant warehouse file. Learn more about variant warehouse files here.

Variant-specific information for variants (such as units of measurement, minimum order quantities and cost prices) are loaded using a variant vendor file. Learn more about variant vendor files here.

If you have bundle or assembly variants, you will need to configure their components using a variant component file. Learn more about variant component files here.

Variant data columns

The variant 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	Default value	Comments
VARIANT_ID	✓	VARCHAR(256)		Unique ID (must be unique across all variants)
SKU	✓	VARCHAR(256)
TITLE	✓	VARCHAR(256)
BARCODE	✓	VARCHAR(256)
PRODUCT_ID	✓	VARCHAR(256)
PRICE	✓	FLOAT
CREATED_AT	✓	TIMESTAMP_NTZ
UPDATED_AT	✓	TIMESTAMP_NTZ		Row last updated timestamp
REMOVED	✓	BOOLEAN		Soft remove the variant by setting to “true”
TYPE			“simple”	Choose one of “simple”, “bundle”, or “assembly”
IMAGE				Image URL
HANDLE				Google Analytics URL string match. Required to use Inventory Planner’s Google Analytics 4 connector.
INVENTORY_MANAGEMENT		BOOLEAN	true	“Tracked” in Inventory Planner filters. Whether or not the variant is stock tracked. If set to “false”, the variant’s inventory is not managed so its inventory and replenishment values are always 0.
PUBLISHED		BOOLEAN	true	“Visible” in Inventory Planner filters. Set to “true” if the variant is published and visible to customers on your storefront.
PUBLISHED_AT		TIMESTAMP_NTZ
PRODUCT_TITLE		VARCHAR(256)	same as TITLE
BRAND		VARCHAR(256)	“unknown”
CATEGORY		VARCHAR(256)	“unknown”
TAGS		VARCHAR(256)	Empty list	Enter as a comma separated list
OPTIONS		VARCHAR(256)	Empty list	Enter in the format {“option1”: “optionvalue1”; “option2”: “optionvalue2”}
COLLECTION		VARCHAR(256)	“unknown”
REGULAR_PRICE		FLOAT	Same as PRICE
CBM		FLOAT
NET_WEIGHT		FLOAT

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

Gross weight
Set replenishable/non-replenishable
Forecast settings

To learn more about configuring variants in Inventory Planner, click here.

Variant custom fields

Inventory Planner’s support team can enable custom fields for your variants, which you can then load data into using the Advanced CSV connector.

If you have a custom field you would like to map to, contact Support with:

The column name you want to use
The column type