This feature is available only upon request. To enable it in your account, contact our support team.

Importing SKU

• 1 minute to read

In this article, you will learn how to fill the SKU fields and select the Available checkbox for your product variants via a CSV file. This CSV file allows you to fill these values at the same time.

To read more about product variants, SKU, and the Available checkbox, see the Variants article.

Let's create a CSV file for your product.

Exporting a workbook

You can download a CSV file with filled columns to your PC. To do so, go to the Variants tab in your product and click Export. A CSV file will be downloaded.

Filling a workbook

In this CSV file, you can see the following columns. Let's consider their purpose.

Number	Name	Description	Type	Example
1.	#	Mandatory. A product variant index.	number	5
2.	Value	Mandatory. A product variant.	string	S/White
3.	SKU	Optional. An SKU value.	string	t-sh-1
4.	Available	Optional. This value defines availability of a product variant in a storefront. By default, False.	boolean	yes, no, true, false, 1, 0

Note

The # and Value cells and all the names of the columns must stay the same. Otherwise, Customer's Canvas doesn't recognize such a workbook correctly.

Deleting product variants

You may delete the random rows that you don't want to change.

For example, the following workbook will be imported successfully.

Note

A CSV file with empty rows won't be imported.

Importing a workbook

To import a CSV file, go to your product, select the Variants tab, and click Import. Select your CSV file and upload the file to your product.

This is how the result will look.