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.
Variants may be sourced from multiple vendors, each with their own specific references and variant attributes such as cost prices, minimum order quantities and units of measurement.
Variant vendor files are used to associate vendors to variants. Even if you only purchase a variant from a single vendor, you must use the file to link them together and configure the vendor-specific attributes.
Note: The vendor and variant files must be supplied to the Advanced CSV connector before or at the same time as the variant vendor file.
Variant vendor data columns
The variant vendor 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) |
|
VENDOR_ID | ✓ | VARCHAR(256) |
|
REMOVED | ✓ | BOOLEAN | Soft remove the association by setting to “true”. The variant and vendor will no longer be linked. |
UPDATED_AT | ✓ | TIMESTAMP_NTZ | Row last updated timestamp |
COST_PRICE |
| FLOAT |
|
LANDING_COST_PRICE |
| FLOAT |
|
VENDOR_REFERENCE |
| VARCHAR(256) |
|
VENDOR_NAME |
| VARCHAR(256) | Vendor product name |
MOQ |
| FLOAT |
|
UOM |
| FLOAT |
|
Outside of the file, you can edit tier prices directly within Inventory Planner.