Imports: Variants

Imports: Variants

Imports: Variants

The Variants Import provides a convenient way for Fulfillers to upload and apply Variant information to Products within the Catalog. 

The required import format is CSV. 


What is the Variant Import used for?
The import is used by Fulfillers to create Variants or to edit existing ones. 

Create: Add new Variants to Products in bulk.

To create new Variants, the relevant Products should first be 'selected' or filtered in Product Manager prior to generating a Variant Export.

The generated CSV file serves as a template, allowing the Product data to be added in a format that is then suitable for use with the Variant Import to update the Products. 
It is recommended that Imports are tested on a sample range prior to rollout across a high volume of Products.

The CSV must be populated with data based on how the Products are currently configured, with relevant names as defined in the Catalog. This can be achieved in two ways:
  1. Utilise other Exports (eg Attributes and Excel) to download relevant data in bulk, this can be extracted and used to populate the Variant Import
  2. Review the configuration of each Product by clicking Edit in Product Manager 
For more information on using the Attribute Export click here

For more information on using the Excel Export click here

Failure to specify and match the relevant option names defined against the Products will result in the import failing.

For more information on using the Export / Import to create Variants click here

Note: When creating new Variants, the Variant ID field should be kept empty - the system will creates these automatically when new Variants are added.
 

Edit: Update existing Variants across a range of Products. Some typical use cases are;
  1. To review / replace the Stock Product IDs in bulk. 
  2. To review / edit Aspects and Aspect options set within Variants.
  3. To review / edit Attributes set within Variants. 
To edit Variants, the relevant Products should be 'selected' or filtered in Product Manager prior to generating a Variant Export.

The generated CSV file serves as a template, allowing the Product data to be edited in a format that is then suitable for use with the Variant Import to update the Products.
It is recommended that Imports are tested on a sample range prior to rollout across a high volume of Products.

For more information on using the Export / Import to edit Variants click here


CSV Import Format Requirements
If using OpenOffice or equivalent, save as .CSV and be sure to:
  1. Enable 'Edit the Filter Settings'
  2. Keep Current Format
  3. Change the character set to UNICODE (UTF-8)
  4. The saving delimeter needs to be ","
  5. Enable 'Quote all text cells'
The file can then be imported.


Further Reading


Still Need Help?
You can access our extensive knowledge base or raise a ticket with our technical support teams using the buttons below

View all help articles

Raise a support ticket

    • Related Articles

    • Exports: Variants

      Exports: Variants The Variants Export provides a convenient way for Fulfillers to extract Variant setup information in bulk.  The export produces a CSV document for any 'selected' or filtered Products in Product Manager; this allows you to target a ...

    • Imports: Simple Stock

      Imports: Simple Stock The Simple Stock Import provides a convenient way for Fufillers to create Stock products on bulk.  The required import format is csv. What is the Simple Stock Import used for? The import is used by Fulfillers to create Simple ...

    • Product Manager : Variants

      Variants This section of the platform is for configuring Variants and associating SKUs to your product options. What is a Variant? A Variant is an identifier for the variable product options on a Blank Product, for example; A T-Shirt available in 5 ...

    • Imports: Attributes

      Imports: Attributes The Attributes Import provides a convenient way for Fulfillers to import and create Attributes against Products in the Platform.  The required import format is CSV.  What is the Attribute Import used for? The import is used ...

    • Imports: Excel

      Imports: Excel The Excel Import provides a convenient way for Fufillers to upload Blank Product setup information to the Catalog.  The required import format is .xlsx   What is the Excel Import used for? The import is used by Fulfillers to create new ...