---
title: "Importing SKU | Customer's Canvas Hub"
canonical: "https://customerscanvas.com/docs/hub/admin-guide/pim/import-sku/"
---

# Importing SKU

> 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 [Product Variants](https://customerscanvas.com/docs/hub/admin-guide/pim/variants.md) 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.](./images/import-sku-available-export-button.png)

## 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.](./images/import-sku-available-workbook.png)

| Column | 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.](./images/import-sku-available-deleted-cells.png)

:::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.](./images/import-sku-available-result.png)