Importing Variants


There are two steps to importing variants:

  1. Defining Variant Groups - Variant Groups need to be defined, before the variants can be imported. If you already have variant groups defined, you can skip this step.
  2. Import the Product Variants with a .csv File

Start by selecting the tools icon in the lower left side of the admin console.


Once you are in the Product Variant Import page, select Product Variant Import in the tools menu.

Navigate to Tools > Data Import > 


Prepare your data and upload

To add or update multiple items, prepare your data in .CSV file format using Excel or a similar application.

On this screen you will see a link: click to download the Sample File (used as a reference for uploading). Click the link to download a CSV file that you can use to import your product data. Some columns require special formatting (see the second link) so it may not be possible to map all fields without modification.


Once the data is prepared, upload and select your .CSV file using the file browser, then select the appropriate options and click Next
Importing your .csv file

Importing your .csv file

Once your file is ready you can drag and drop it onto the screen or select the “Insert From” button. This will set your file for upload.

Hit Next to continue.



Step 2 Map your data columns allows you to map the columns from your CSV file to Spark Pay online stores .  If you used our template, you can skip this step because all of the data is properly categorized.


If you have your own format, you can Start A New Data Map



If you wish, you can save the current mapping scheme for future use at the top of the page. Next time you come to import the same file, you will not have to re-map the data again.

Next press Validate to run a test, or Import to finish the process.



 Background Jobs will now appear showing the progress of the upload.


Congratulations! You have just imported product variants into your catalog. Use similar methods with the Import Wizard for handling customer and order lists, tracking information, and inventory data.

Have more questions? Submit a request