Variant Import Use
The Variant Import is used to Add/Update Product Variants from a CSV/XLS file. It can also be used to add/update product attributes, options and product kits. The product kits and product variants are created in succession. For example, it could take 5 rows to create a single product variant, so the variant import will collect all the information needed until the row data has changed enough to denote that it is no longer creating that product variant. Once the data is collected then it will create the variant or product kit and move to the next set of data.
Header Row Column Description
Header column |
Description |
Validation |
MASTER_PRODUCT_CODE |
Denote's the main product |
CODE |
PART_PRODUCT_CODE |
Denote's the part product used for the variant |
CODE |
PRODUCT_KIT_CODE |
Denote's the product kit code |
CODE |
PRODUCT_SKU |
Main product or product kit SKU |
STRING |
PRODUCT_NAME |
Main product or product kit name |
STRING |
CATEGORY_CODES |
Category codes assigned to main product or product kit |
STRING |
CANONICAL_CATEGORY_CODE |
Canonical category code to main product or product kit |
STRING |
ALTERNATE_DISPLAY_PAGE |
Alternate display page for main product or product kit |
STRING |
PRICE |
Price of main product or product kit |
STRING |
COST |
Cost of main product or product kit |
STRING |
WEIGHT |
Weight of main product or product kit |
STRING |
DESCRIPTION |
Description of main product or product kit |
STRING |
TAXABLE |
Declares if main product or product kit is taxable |
BOOLEAN |
ACTIVE |
Declares if main product or product kit is active |
BOOLEAN |
THUMBNAIL_URL |
Thumbnail URL for main product or product kit |
STRING |
IMAGE_URL |
Image URL for main product or product kit |
STRING |
TRACK_PRODUCT_INVENTORY |
Declares if main product or product kit's inventory is trackable |
BOOLEAN |
ATTRIBUTE_CODE |
Attribute code assigned to the main product |
CODE |
ATTRIBUTE_TYPE |
Attribute type |
STRING |
ATTRIBUTE_PROMPT |
Attribute prompt |
STRING |
ATTRIBUTE_PRICE |
Attribute price |
CURRENCY |
ATTRIBUTE_COST |
Attribute cost |
CURRENCY |
ATTRIBUTE_WEIGHT |
Attribute weight |
FLOAT |
ATTRIBUTE_REQUIRED |
Declares if attribute is required |
BOOLEAN |
ATTRIBUTE_IMAGE |
Attribute image URL |
STRING |
OPTION_CODE |
Option code assigned to the main product |
CODE |
OPTION_PROMPT |
Option prompt |
STRING |
OPTION_PRICE |
Option price |
CURRENCY |
OPTION_COST |
Option cost |
CURRENCY |
OPTION_WEIGHT |
Option weight |
FLOAT |
OPTION_IMAGE |
Option image URL |
STRING |
VARIANT_PRICE |
Specific variant price |
CURRENCY |
VARIANT_COST |
Specific variant cost |
CURRENCY |
VARIANT_WEIGHT |
Specific variant weight |
FLOAT |
Examples
Create a Product
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
PRODUCT_SKU |
PRODUCT_NAME |
THUMBNAIL_URL |
|
IMAGE_URL |
|
PRICE |
|
COST |
|
DESCRIPTION |
|
WEIGHT |
|
TAXABLE |
|
ACTIVE |
|
TRACK_PRODUCT_INVENTORY |
|
CATEGORY_CODES |
|
CANONICAL_CATEGORY_CODE |
|
ALTERNATE_DISPLAY_PAGE |
Update a Product
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
PRODUCT_SKU |
|
PRODUCT_NAME |
|
THUMBNAIL_URL |
|
IMAGE_URL |
|
PRICE |
|
COST |
|
DESCRIPTION |
|
WEIGHT |
|
TAXABLE |
|
ACTIVE |
|
TRACK_PRODUCT_INVENTORY |
|
CATEGORY_CODES |
|
CANONICAL_CATEGORY_CODE |
|
ALTERNATE_DISPLAY_PAGE |
Create an Attribute
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
ATTRIBUTE_REQUIRED |
ATTRIBUTE_CODE |
ATTRIBUTE_IMAGE |
ATTRIBUTE_TYPE |
|
ATTRIBUTE_PROMPT |
|
ATTRIBUTE_PRICE |
|
ATTRIBUTE_COST |
|
ATTRIBUTE_WEIGHT |
|
Update an Attribute
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
ATTRIBUTE_REQUIRED |
ATTRIBUTE_CODE |
ATTRIBUTE_IMAGE |
|
ATTRIBUTE_TYPE |
|
ATTRIBUTE_PROMPT |
|
ATTRIBUTE_PRICE |
|
ATTRIBUTE_COST |
|
ATTRIBUTE_WEIGHT |
Create an Option
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
OPTION_IMAGE |
PART_PRODUCT_CODE |
|
ATTRIBUTE_CODE |
|
OPTION_CODE |
|
OPTION_PROMPT |
|
OPTION_COST |
|
OPTION_PRICE |
|
OPTION_WEIGHT |
|
Update an Option
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
OPTION_IMAGE |
PART_PRODUCT_CODE |
OPTION_PROMPT |
ATTRIBUTE_CODE |
OPTION_COST |
OPTION_CODE |
OPTION_PRICE |
|
OPTION_WEIGHT |
Create a Product Variant
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
PRODUCT_NAME |
PART_PRODUCT_CODE |
VARIANT_PRICE |
ATTRIBUTE_CODE |
VARIANT_COST |
OPTION_CODE |
VARIANT_WEIGHT |
Create a Product Kit
Required Columns |
Optional Columns |
MASTER_PRODUCT_CODE |
PRODUCT_NAME |
PRODUCT_KIT_CODE |
PRODUCT_SKU |
ATTRIBUTE_CODE |
THUMBNAIL_URL |
OPTION_CODE |
IMAGE_URL |
|
PRICE |
|
COST |
|
DESCRIPTION |
|
WEIGHT |
|
TAXABLE |
|
ACTIVE |
|
TRACK_PRODUCT_INVENTORY |
|
CATEGORY_CODES |
|
CANONICAL_CATEGORY_CODE |
|
ALTERNATE_DISPLAY_PAGE
|
Example files are attached.
|