# Import/Export Option Sets

Leveraging the Import/Export feature streamlines the process of setting up new stores, saving valuable time. This functionality is particularly beneficial for merchants who operate in multiple countries or those managing diverse product lines across various stores.

⚠️ **Note:** Import and export files are limited to **5MB**. If you need to process larger files, feel free to contact our support team for assistance.

### Import/Export supported format

Our Import/Export feature uses CSV to synchronize data. CSV stands for comma-separated values, a file format (.csv) for spreadsheets. You can use CSV files to import and export products, customers, inventory, orders (export only), and discounts (export only).

Here is our **sample folder** with different files format that cover all the option types available in the app

{% file src="<https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2FUIurAikbORIMeceb5qGP%2FAvis-sample-options.csv?alt=media&token=9401440f-ffef-42b0-8788-c787ceff8647>" %}

### How to export Option Set

First, navigating to the Avis Option page

You can select the option set that you want to export by ticking on the box besides option. Then click Export

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2FleqfryC9mrPCQDFgW4cg%2Fimage_2024-07-08_141358216.png?alt=media&#x26;token=96a61c43-3026-4982-b03c-13f10aa4f486" alt=""><figcaption></figcaption></figure>

Select Export Range, you can choose to export All option sets on current page or whole store, or only selected one.

Click on Export button again to download a CSV file automatically. You can use this file to import or use as template to fill in the options in bulk

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2F2LN8oJQZMeTYAg8tqbAt%2Fimage_2024-07-08_141753029.png?alt=media&#x26;token=5fd0ca6e-2826-4089-b94c-309927f514db" alt=""><figcaption></figcaption></figure>

### How to import Option Set

Navigate to the Avis Option page then click on Import

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2F71aoWpNDEs7LiZQ5lKWB%2Fimage_2024-07-08_141858171.png?alt=media&#x26;token=25cd5e9e-3581-4b38-bc00-1cb9065cb5c2" alt=""><figcaption></figcaption></figure>

Click on Add File

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2Fe0cYgFzNBAuPGl8SQhl4%2Fimage_2024-07-08_142252503.png?alt=media&#x26;token=8e57a2fb-3c00-4ed8-8c6a-aba181216c5c" alt=""><figcaption></figcaption></figure>

Choose the file that were exported or any supported file in the CSV format, then click on Open file

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2FjtxOpClPEY0EarYstDtT%2Fimage_2024-07-08_143347717.png?alt=media&#x26;token=0c59d371-dbdd-4ec2-9ba0-9d3e811d26f5" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2Fy0aFWKLfLfZ5MlsFPCBm%2Fimage_2024-07-08_143753235.png?alt=media&#x26;token=a3b85c80-9ce9-4c59-9cb0-a99348526831" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3264408981-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F3ClFZbSMFYUfUOKXAOru%2Fuploads%2F2iw5EJ2HvXLM1CdFrk4z%2Fimage_2024-07-08_143723630.png?alt=media&#x26;token=ce3e030f-b493-493f-8fbc-cc695eed2fb5" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
After importing, please navigate to all the Option set having add charge option and click on **Save** to re-activate the add charge option.
{% endhint %}

### Contents of the CSV files

<table><thead><tr><th width="173">Field</th><th width="94">Type</th><th>Description</th></tr></thead><tbody><tr><td><mark style="color:red;"><strong>no.</strong></mark></td><td>Number</td><td><ul><li>The order number of the exported option sets, each CSV row starting with a different number will be a different option set.</li><li>To add multiple options to one option set, the customer needs to add multiple rows with the same order number.</li><li>Rows without an order number will not be imported into the customer's store.</li></ul></td></tr><tr><td>option_set_name</td><td>Text</td><td>Option set name, used to differentiate option sets</td></tr><tr><td><mark style="color:red;"><strong>option_id</strong></mark></td><td>Text</td><td><ul><li>option_id is unique for each option template. Each CSV row starting with a different ID represent a different option</li><li>To add multiple option values to one option, the customer needs to add multiple rows with the same option_id.</li><li>Rows without an option_id will not be added to the option.</li></ul></td></tr><tr><td>label_product</td><td>Text</td><td>The Label on Product is the title for your option. It is the text appearing above the option field on the storefront product page, featured product, quick view and edit option in cart.</td></tr><tr><td><mark style="color:red;"><strong>label_cart</strong></mark></td><td>Text</td><td><ul><li>The Label on Cart is the text appearing on the Cart summary screen, Checkout, and Order detail page, next to what customers have inputted or selected for the option. </li><li>This value needs to be unique for each and every one of your options.</li><li>The Label on Cart can not be left blank on option types: Single line text, Multi-line text, Number, Datetime, Email, Phone, Color picker, File Upload, Switch, Swatch, Radio buttons Drop-down Menu, Checkboxes</li></ul></td></tr><tr><td><mark style="color:red;"><strong>option_type</strong></mark></td><td>Text</td><td><p>Option types represent type of the option value and it can not be left blank. Here is the list of option_types default values: </p><ul><li>text: Single line text</li><li>textarea: Multi-line text</li><li>number: Number</li><li>date: Datetime</li><li>email: Email</li><li>phone: Phone</li><li>color: Color picker</li><li>file: File Upload</li><li>switch: Switch</li><li>hidden_field: Hidden field</li><li>swatch_single_color: Color swatch (single selection)</li><li>swatch_single_image: Image swatch (single selection)</li><li>radio: Radio buttons</li><li>select: Drop-down Menu</li><li>swatch_select_color: Color Drop-down Menu</li><li>swatch_select_image: Image Drop-down Menu</li><li>swatch_multi_color: Color swatch (multiple selections)</li><li>swatch_multi_image: Image swatch (multiple seletccions)</li><li>checkbox: Checkboxes</li><li>paragraph: Paragaraph</li><li>heading: Heading</li><li>divider: Divider</li><li>modal: Pop-up</li><li>size_chart: Size chart</li></ul><p></p></td></tr><tr><td>required</td><td>Text</td><td><p>Require field to be picked before adding to cart. This field contains 2 default values:</p><ul><li>TRUE: enable required</li><li> FALSE: disable required</li></ul></td></tr><tr><td>hidden_label</td><td>Text</td><td><p>This field allows hiding the label on product from the product page, featured product, quick view, and edit option in cart. It contains 2 default values:</p><ul><li>TRUE: hide label_product</li><li>FALSE: show label_product</li></ul></td></tr><tr><td>status</td><td>Text</td><td><p>Check if the option set is activated or not. This contains 2 default values:</p><ul><li>TRUE: active option set</li><li>FALSE: deactive(draft) option set</li></ul></td></tr><tr><td>isHide</td><td>Text</td><td><p>Check if the option is hidden or not inside the option set. This contains 2 default values:</p><ul><li>TRUE: hide option</li><li>FALSE: show option</li></ul></td></tr><tr><td>switch_label</td><td>Text</td><td><ul><li>The label besides the switch or so called the content of the switch</li><li>This text will be visible in product page, featured product, quick view and collection page</li><li>Represent as the value of switch besides the label in the cart, checkout and order detail pages. </li></ul></td></tr><tr><td>default_status</td><td>Text</td><td><p>Show as the switch is selected or not selected automatically. This contains 2 default values: </p><ul><li>TRUE: default selected</li><li>FALSE: default unselected</li></ul></td></tr><tr><td>default_value</td><td>Text</td><td>The default value of an option, this value will be added to the cart page automatically when the buyer clicks the Add to Cart button without changing the option or option value.</td></tr><tr><td>place_holder</td><td>Text</td><td>The preview value of the option and the value will be removed when the buyer fill in the value or add the option to cart.</td></tr><tr><td>min</td><td>Number</td><td>Minimum value của option Number</td></tr><tr><td>max</td><td>Number</td><td>Maximum value của option Number</td></tr><tr><td>help_text</td><td>Text</td><td>A text line used to guide buyer </td></tr><tr><td>allow_hover_img</td><td>Text</td><td><p>Show the bigger images when the customer hover on a swatch variant. This contains 2 default values:</p><ul><li>TRUE: enable hover image</li><li>FALSE: disable hover image</li></ul></td></tr><tr><td><mark style="color:red;"><strong>value_id</strong></mark></td><td>Text</td><td><ul><li>ID of an option value</li><li>Each id respresents a different option and there will be no duplication id inside 1 option</li></ul></td></tr><tr><td><mark style="color:red;"><strong>value</strong></mark></td><td>Text</td><td>The values/variants that has been set on an option</td></tr><tr><td>price</td><td>Number</td><td>Price of an option value/variant</td></tr><tr><td>value_type</td><td>Text</td><td><p>Show type of the option and check if the product is changed to charge types or not. This contains 3 default values:</p><ul><li>adjustprice: no charge for option value</li><li>chargeorbundle: option value includes add charge</li><li>useexistingvariant: option value includes bundle</li></ul></td></tr><tr><td>styles_heading</td><td>Text</td><td><p>Text size of the Heading option. This contains 6 values:</p><ul><li>h1: Heading 1</li><li>h2: Heading 2</li><li>h3: Heading 3</li><li>h4: Heading 4</li><li>h5: Heading 5</li><li>h6: Heading 6</li></ul></td></tr><tr><td>heading_color</td><td>Text</td><td>Option type Heading color value, showing in HEX code. For example: #ffffff</td></tr><tr><td>border_styles</td><td>Text</td><td><p>Border style of Divider option type. This contains 4 values:</p><ul><li>solid: Solid</li><li>double: Double</li><li>dashed: Dashed</li><li>dotted: Dotted</li></ul></td></tr><tr><td>divider_color</td><td>Text</td><td>Option type Divider color value, showing in HEX code. For example: #ffffff</td></tr><tr><td>title_on_product</td><td>Text</td><td>Label of Pop-up option type, representing the value that can be clicked on to show the pop-up. The value is visible in product page, featured product, collection page and quick view</td></tr><tr><td>title_modal</td><td>Text </td><td>Title of Pop-up option type, showing on the top of the box when you click on the Pop-up title. </td></tr><tr><td>size_modal</td><td>Number</td><td><p>Pop-up size. There are 3 common values:</p><ul><li>380: Small</li><li>620: Medium</li><li>980: Large</li></ul></td></tr><tr><td>chart_title</td><td>Text</td><td>Label of Size Chart option type, representing the value that can be clicked on to show the Size Chart. The value is visible in product page, featured product, collection page and quick view</td></tr><tr><td>chart_header</td><td>Text</td><td>Title of Size Chart option type, showing on the top of the box when you click on the Size Chart title. </td></tr><tr><td>conditional_logic</td><td>json</td><td>Condition for an option to show/hide using json format, working range is restricted to 1 option set only. <br>For example: {"type":"show","logic":"any","condition_items":[{"field":"avis_shopify_option","type":"contains","field_label":"avis_shopify_option","org_option_values_combobox":null,"filter_option_values_combobox":null,"value":"Blue"},{"field":"Single line text","type":"contains","field_label":"Single line text","field_option_key":"w2n2B5imofqxFB1cLHNq2vOm9hRUS2","org_option_values_combobox":null,"filter_option_values_combobox":null,"value":"avis"},{"field":"Switch","type":"contains","field_label":"Switch","field_option_key":"ovSe2xZoykKAbdsaNiQiKmrCrLDRde","org_option_values_combobox":null,"filter_option_values_combobox":null,"value":"Yes"},{"field":"Color swatch (single selection)","type":"contains","field_label":"Color swatch (single selection)","field_option_key":"gzUEp0Onfy4s_PzMgv9qH9zQCLEF6C","org_option_values_combobox":[{"value":"option_1","label":"option_1"}],"filter_option_values_combobox":[{"value":"option_1","label":"option_1"}],"value":"option_1"}]}</td></tr></tbody></table>

{% hint style="info" %}
Required fields are notes as BOLD parameters and those include: no.; option\_id; label\_cart; option\_type; value\_id; value\
\
value\_id and value columns will need to be rendered in nanoid form, 30 characters long\
This [**tool**](https://toolinone.com/nanoid-generator/) can be used to render the form
{% endhint %}

Woah lah, a list of option sets will soon appear on your Avis Option.\
If you have any difficulty while working on this feature, don’t hesitate to contact us promptly via Livechat or the email address <help@avisplus.io>