Back to Website
Show / Hide Table of Contents

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

Importing SKU

  • Last updated on December 29, 2023
  • •
  • 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.

To export a CSV file, click Export.

Filling a workbook

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

A CSV file that contains an index, a product variant, SKUs, and the available column.

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.

Deleted cells.

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.

To import a filled workbook, click Import.

Was this page helpful?
Thanks for your feedback!
Back to top Copyright © 2001–2024 Aurigma, Inc. All rights reserved.
Loading...
    Thank for your vote
    Your opinion is important to us. To provide details, send feedback.
    Send feedback