Import/Export Option Sets

The Import/Export features allow quick customization across multiple stores

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.

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

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

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

How to import Option Set

Navigate to the Avis Option page then click on Import

Click on Add File

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

After importing, please navigate to all the Option set having add charge option and click on Save to re-activate the add charge option.

Contents of the CSV files

FieldTypeDescription

no.

Number

  • The order number of the exported option sets, each CSV row starting with a different number will be a different option set.

  • To add multiple options to one option set, the customer needs to add multiple rows with the same order number.

  • Rows without an order number will not be imported into the customer's store.

option_set_name

Text

Option set name, used to differentiate option sets

option_id

Text

  • option_id is unique for each option template. Each CSV row starting with a different ID represent a different option

  • To add multiple option values to one option, the customer needs to add multiple rows with the same option_id.

  • Rows without an option_id will not be added to the option.

label_product

Text

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.

label_cart

Text

  • 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.

  • This value needs to be unique for each and every one of your options.

  • 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

option_type

Text

Option types represent type of the option value and it can not be left blank. Here is the list of option_types default values:

  • text: Single line text

  • textarea: Multi-line text

  • number: Number

  • date: Datetime

  • email: Email

  • phone: Phone

  • color: Color picker

  • file: File Upload

  • switch: Switch

  • hidden_field: Hidden field

  • swatch_single_color: Color swatch (single selection)

  • swatch_single_image: Image swatch (single selection)

  • radio: Radio buttons

  • select: Drop-down Menu

  • swatch_select_color: Color Drop-down Menu

  • swatch_select_image: Image Drop-down Menu

  • swatch_multi_color: Color swatch (multiple selections)

  • swatch_multi_image: Image swatch (multiple seletccions)

  • checkbox: Checkboxes

  • paragraph: Paragaraph

  • heading: Heading

  • divider: Divider

  • modal: Pop-up

  • size_chart: Size chart

required

Text

Require field to be picked before adding to cart. This field contains 2 default values:

  • TRUE: enable required

  • FALSE: disable required

hidden_label

Text

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:

  • TRUE: hide label_product

  • FALSE: show label_product

status

Text

Check if the option set is activated or not. This contains 2 default values:

  • TRUE: active option set

  • FALSE: deactive(draft) option set

isHide

Text

Check if the option is hidden or not inside the option set. This contains 2 default values:

  • TRUE: hide option

  • FALSE: show option

switch_label

Text

  • The label besides the switch or so called the content of the switch

  • This text will be visible in product page, featured product, quick view and collection page

  • Represent as the value of switch besides the label in the cart, checkout and order detail pages.

default_status

Text

Show as the switch is selected or not selected automatically. This contains 2 default values:

  • TRUE: default selected

  • FALSE: default unselected

default_value

Text

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.

place_holder

Text

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.

min

Number

Minimum value của option Number

max

Number

Maximum value của option Number

help_text

Text

A text line used to guide buyer

allow_hover_img

Text

Show the bigger images when the customer hover on a swatch variant. This contains 2 default values:

  • TRUE: enable hover image

  • FALSE: disable hover image

value_id

Text

  • ID of an option value

  • Each id respresents a different option and there will be no duplication id inside 1 option

value

Text

The values/variants that has been set on an option

price

Number

Price of an option value/variant

value_type

Text

Show type of the option and check if the product is changed to charge types or not. This contains 3 default values:

  • adjustprice: no charge for option value

  • chargeorbundle: option value includes add charge

  • useexistingvariant: option value includes bundle

styles_heading

Text

Text size of the Heading option. This contains 6 values:

  • h1: Heading 1

  • h2: Heading 2

  • h3: Heading 3

  • h4: Heading 4

  • h5: Heading 5

  • h6: Heading 6

heading_color

Text

Option type Heading color value, showing in HEX code. For example: #ffffff

border_styles

Text

Border style of Divider option type. This contains 4 values:

  • solid: Solid

  • double: Double

  • dashed: Dashed

  • dotted: Dotted

divider_color

Text

Option type Divider color value, showing in HEX code. For example: #ffffff

title_on_product

Text

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

title_modal

Text

Title of Pop-up option type, showing on the top of the box when you click on the Pop-up title.

size_modal

Number

Pop-up size. There are 3 common values:

  • 380: Small

  • 620: Medium

  • 980: Large

chart_title

Text

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

chart_header

Text

Title of Size Chart option type, showing on the top of the box when you click on the Size Chart title.

conditional_logic

json

Condition for an option to show/hide using json format, working range is restricted to 1 option set only. 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"}]}

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 can be used to render the form

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

Last updated