# Bulk export & import variant options

Do you have a lot of valuable color samples and you need to convert them into color swatches or image swatches? The bulk export/import variant option will help you do that faster. 😇

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

You need to sync data before performing the export/import variant process.

In **dashboard** admin GLO Color Swatch -> click **update data**<br>

<figure><img src="/files/Q5a8xQcX5w8fxJBhzIki" alt=""><figcaption><p>Update data</p></figcaption></figure>

***

## Guide step to step

### <mark style="color:blue;">1. Config option variant</mark>

* Go to **Dashboad** admin GLOBO Color Swatch
* Find variant type color / image custom&#x20;

<figure><img src="/files/vlwrkoAR3y8evSvBCatF" alt=""><figcaption><p>Config button</p></figcaption></figure>

* Click **config** button

### <mark style="color:blue;">2. Export csv</mark>

* &#x20;In page option config, Click export CSV list data value of option

<figure><img src="/files/wwwCDuqzrPcKEjstC6lq" alt=""><figcaption><p>Export CSV<br></p></figcaption></figure>

### <mark style="color:blue;">3.</mark> <mark style="color:blue;"></mark><mark style="color:blue;">**Use excel / text editor to open file csv export**</mark> &#x20;

* Use Excel or Text editor to open file csv export. We suggest use **Excel** to Change data
* Data export example in excel tool

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

**Explanation column:**

* <mark style="color:orange;">Value</mark>: name of value option variant,
* <mark style="color:orange;">Select type:</mark> import data type
* <mark style="color:orange;">Custom:</mark> new value data (color, link image)

> <mark style="color:red;">You can change only column "Select type" and "Custom"</mark>

### <mark style="color:blue;">4. Change data</mark> <mark style="color:blue;"></mark><mark style="color:blue;">**file**</mark>

* <mark style="color:red;">**Do not edit column "Value"**</mark>
* For the value you want to leave blank, use **"one color"** for **"select type"** column and use text "**transparent"** for **"Custom"** column

{% hint style="info" %}
Column "Select type", use only one of the types:\
\&#xNAN;**"One color"**\
\&#xNAN;**"Two color"** \
**"Upload file"**\
**"Image url"**
{% endhint %}

* If you use **"One color"** in "**Select type**", you must enter the color code in the custom column. \
  We accept **hex codes**, because hex codes of colors have the most accuracy.

<mark style="color:purple;">E.g: for one color</mark><br>

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

* If you use **"Two color"** in "**Select type**", you must enter the color code in the custom column and **next to the column custom you need to add the 2nd color code.**

<mark style="color:purple;">E.g: for two color</mark><br>

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

* If you use **"Upload file" or "Image url"** in "**Select type**", you must enter the url link image.<br>

<mark style="color:purple;">E.g: for upload image</mark>

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

<mark style="color:purple;">E.g: for image url</mark><br>

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

### <mark style="color:blue;">5. Save data and import data</mark>

* Go back to admin GLOBO Color Swatch -> Option Config page
* Click **Import** button

<figure><img src="/files/zNDJ1tzeTJmXy4bOgDah" alt="" width="563"><figcaption><p>Import button</p></figcaption></figure>

* The modal import will open, you can **drag** the changed csv file or click the **add file** button

<figure><img src="/files/rjnj9hOHljedyfwxjxu3" alt=""><figcaption><p>Modal import</p></figcaption></figure>

* Click to **overwrite** all items if you need to replace the old value

* **Click import** and wait app read file import

* When import done, you can see all data import in column **preview** <br>

  <figure><img src="/files/jV16tMYhFZQx4IPLGtTh" alt=""><figcaption><p>Preview data import</p></figcaption></figure>

* You can check it again and click **save button**

<figure><img src="/files/Deux2Yxtz4hxwfwSOSDN" alt=""><figcaption><p>Save data</p></figcaption></figure>

{% hint style="info" %}
**💡 Tips:** If you have a lot of raw values, you can edit them all at once, then import each page, this trick will be very fast.
{% endhint %}

{% hint style="info" %} <mark style="color:orange;">This function supports update data entry for existing options, is not the function of adding new variants.</mark>
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.globo.io/product-variants-swatch/bulk-export-and-import-variant-options.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.