Knowledgebase: Tips and Tricks
Release 8 Update 9 Variant Import module
Posted by Wayne Smith, Last modified by Wayne Smith on 16 October 2014 03:41 PM

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.



Attachments 
 
 createattribute.csv (0.58 KB)
 createoption.csv (0.61 KB)
 createproduct.csv (0.58 KB)
 createproductkit.csv (0.71 KB)
 createvariant.csv (0.71 KB)
(7 vote(s))
This article was helpful
This article was not helpful
Help Desk Software by Kayako support.miva.com/supportsuite/index.php?