Importing Variations

Please read first! For information on this function in Sellercloud’s original interface, download this file.

You can create new matrices in bulk using a file import, or add products to an existing matrix using the same file import.


Importing a new variation configuration

  1. Click Catalog > Tools > Import Product Info > Import Product Variations.
  2. Select a File Type from the top right corner. Sellercloud supports TAB Delimited, CSV, and Excel.
  3. Populate the columns.
    • In the ParentProductID column, enter the Variation Parent SKU. You must enter the parent SKU in every row that has a variation child of that parent. Important! The Variation Parent must exist in your Sellercloud catalog before importing.
    • In the ProductID column, enter the product ID of the variation product. If the Product ID matches an existing SKU in your catalog, that SKU will be configured as a variation child. If the SKU does not exist, the import will create it and configure it as a variation child.
    • In the remaining columns, enter the values of the dimensions associated with that variation. In the image below, there are two dimensions – Color and Size – and on the product rows are Red, Green, Small, and Large, respectively.
  4. Save the file and return to Sellercloud.
  5. Click to upload file > select file > Import.
If you have more dimensions for this variation, add more columns with that dimension name as the header. If dimensions or values entered do not exist in Sellercloud, they will be created with this file import.

Adding products to a variation

The easiest way to add products to an existing variation is to export the existing variation, and then import it with the updated products:

  1. Open Manage Catalog and search for the variation. You can do this by adding the custom filter Variations Variation Parent.
  2. Select the Variation Parent > Action Menu > Export Products (Catalog)…
  3. Click Variations from the dropdown > Export.

  4. Populate the columns as needed > return to Sellercloud.
  5. Access Catalog > Tools > Import Product Info > Import Product Variations.
  6. Click to upload file > Choose file > Import.


Was this article helpful?

Related Articles