> For the complete documentation index, see [llms.txt](https://docs.globo.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.globo.io/product-variant-swatch/bulk-export-and-import-variant-options.md).

# Bulk export & import variant options

The **Export and Import** feature allows you to manage multiple variant options at once using a CSV file.

This is especially useful when:

* Updating a large number of color swatches or image swatches.
* Migrating settings between stores.
* Making bulk changes more quickly than editing options one by one.

## <mark style="color:red;">Prerequisites \*</mark>

You need to sync data before performing the export/import process.<br>

<figure><img src="/files/7dFllXs7bQATzuBaKCAw" alt=""><figcaption></figcaption></figure>

***

### How to Export

1. Open the **GLO Color Swatch** app.
2. Go to the **Options** page.
3. Choose the product option you want to export > Click **Set Swatches** button.
4. Click the **Export** butto&#x6E;**.**

<figure><img src="/files/YmoYSpOfUtr9u50JK4jY" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/bcZXvcYrWenMJlXlcx84" alt=""><figcaption></figcaption></figure>

The exported file contains your current variant option configurations and can be edited in spreadsheet software such as Excel or Google Sheets.

<figure><img src="/files/YR8UQJjAT5wxbhlQlPL7" alt="" width="375"><figcaption><p>Data in excel tool</p></figcaption></figure>

### CSV Column Explanation

**Value**\
The name of the variant option value, such as **Red**, **Blue**, or **Large**.

**Select Type**\
Determines the type of data being imported for the variant option.

**Custom**\
The custom value associated with the selected type, such as:

* A color code (e.g., `#FF0000`)
* An image URL
* Other custom swatch data depending on the selected type

**Important**

* Do **not** edit the **Value** column. This column must match your Shopify variant option values exactly.
* If you want to leave a value blank, set:
  * **Select Type** = `One color`
  * **Custom** = `transparent`

{% hint style="info" %}
The **Select Type** column supports the following values only:\
\&#xNAN;**"One color"**\
\&#xNAN;**"Two color"** \
**"Upload file"**\
**"Image url"**
{% endhint %}

#### <mark style="color:$primary;">One Color</mark>

Use this option to display a single color swatch.

* Set **Select Type** to `One color`.
* Enter a color code in the **Custom** column.

We recommend using **HEX color codes** for the most accurate color representation.

**Example**

| Value | Select Type | Custom  |
| ----- | ----------- | ------- |
| Black | One color   | #000000 |

<br>

<figure><img src="/files/8ArHn0tPlWPrIRrbMikD" alt="" width="563"><figcaption><p>One color</p></figcaption></figure>

#### <mark style="color:$primary;">Two Colors</mark>

Use this option to display a swatch with two colors.

* Set **Select Type** to `Two color`.
* Enter the first color code in the **Custom** column.
* Enter the second color code in the next color column.

**Example**

| Value       | Select Type | Color 1 | Color 2 |
| ----------- | ----------- | ------- | ------- |
| Black/White | Two color   | #000000 | #FFFFFF |

<figure><img src="/files/ecIIGp4v6cwq6MSe5pVQ" alt="" width="563"><figcaption><p>Type two color</p></figcaption></figure>

#### Upload File

Use this option when the swatch image has already been uploaded to Shopify.

* Set **Select Type** to `Upload file`.
* Enter the image URL in the **Custom** column.

**Example**

<figure><img src="/files/u4iSwkjfgESCQ3stcMmN" alt=""><figcaption><p>Type upload image</p></figcaption></figure>

<figure><img src="/files/kpaB8Y2JOcK7AslOwDeh" alt=""><figcaption><p>Type image url</p></figcaption></figure>

### <mark style="color:blue;">How to Import</mark>

* Go back to the **GLO Color Swatch** app
* Open the **Options** page.
* Choose the product option you want to export > Click the **Set Swatches** button.
* Click **Import**.
* Upload your CSV file.
* Tick on the **Override all items** box if you need to replace the old value
* Click **Import** to apply the changes.
* Click to **overwrite** all items if you need to replace the old value
* Click **Save** to finish.<br>

  <figure><img src="/files/TPWIT8CIN4zD7qKPl34C" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
**Note:** The import feature only updates existing variant values. It does not create new variants or add new option values to your products.
{% endhint %}

***

**💬 Need help?**

Email us at **📧 <contact@globo.io>** - we’re happy to assist!