Note: The feature is available with Online Store and Advanced Store plans.

There are several ways to import product options into your store. You can accomplish it using CSV file of the preferred format:

Each of these methods has its own features, but they all have one thing in common: they allow to add or update options only for the products that are already created in your catalog. To import products in bulk (just without options), follow these steps.

X-Cart

LiteCommerce

Bulk Product Editor

Paid

No

No

Yes

Supported option types

Dropdowns, text fields

Dropdowns, radio buttons, text fields, text areas

Dropdowns, radio buttons, sizes, checkboxes, text fields, text areas, date picker, file upload

X-Cart import format

You can import product options in the form of dropdowns or text fields through CSV files in X-Cart format. It only takes two steps:

  1. Create a CSV file with the list of product options that should be imported.

  2. Import this file using X-Cart format to your store manager.

1. Create a CSV file in X-Cart format

The easiest way to create a CSV file in X-Cart format is to use this template and fill it out with your data on your product options. You can also create such a file from scratch – according to the template – in any text editor or a spreadsheet (e.g., Google Sheets, MS Excel or a similar program) and then save it as CSV.

In general, X-Cart files can contain different data blocks, but for importing product options, only the [PRODUCT_OPTIONS] block is used. Each column of this block corresponds to a specific “part” of the product option.

You can see details in the table below (along with recommendations on how to fill out the columns).

Column name

Description

Type

Optional

Limits

!PRODUCTCODE

Product SKU

string

required

!PRODUCT

Product name

string

optional

!CLASS

Option class name, e.g., "Color", "Size”, etc.

string

required

!TYPE

Option type: "Text type" or "Drop-down type"

string

optional

"Text type" if empty.
"Drop-down type" if the value is equal to "Y".

!OPTION

Option name, e.g., "Small", "Medium" and "Large" for the "Size" option type

string

optional

!PRICE_MODIFIER

Price modifier value

floating point

optional

Can't be empty if used. Put "0", if the option doesn't affect the price.

!MODIFIER_TYPE

Price modified type

string

optional

If the value equals "%", the modifier type is "Percent" (%); it’s "Absolute" ($) if any other value.

Any floating point value in your file has to be formatted according to your store settings. You can look them up in your store manager's Settings → General → Regional Settings.

Example sheet 1. If you want to add "Size" and "Color" options for your product (in the form of drop-down lists) and also want to set price modifiers for sizes, your spreadsheet should look like this (before you save it as CSV file for a further import into Ecwid store):

Importing_product_options__6_.png

When this file is imported, products with the designated SKU (here – “Tshirt001”) will have new options ("Size" and "Color"). Price for items with “Medium” size will be equal to the initial product price + 1 (in the currency of your store). The price for items with “Large” size will be equal to the initial product price + 2 (in the currency of your store).

If you want to make prices for your options smaller – not bigger – than the initial price, just use negative values in the !PRICE_MODIFIER column. This is valid both for “numeric” values and for percentages.

Example sheet 2. If you want to add "Size" options for your product (in the form of a drop-down list) with the price modifier based on percent, your spreadsheet should look like this:

Importing_product_options__1_.png

When this file is imported, products with the designated SKU (here – “straw002”) will have a new option "Size" and a 50% increase in price for the "Small" size. Remember to put "0" in the !PRICE_MODIFIER column, if the option doesn't affect the price.

Example sheet 3. If you want to add a "Gift message" field (in the form of a text field) for your products and want to use import to add this option for many products at the same time, your spreadsheet should look like this:

Importing_product_options__5_.png

When this file is imported, all products with SKUs from “CAR001” to “CAR007” will have a new "Gift message" text field.

Example sheet 4. If you want to import options for several above-mentioned products at once, you can just list them all in the same file, one under another:

Importing_product_options__4_.png

2. Importing CSV file in X-Cart format

Once your spreadsheet is ready, save it as a CSV file to import it into your store:

1. From your store manager, go to Catalog → Products → Import Products.


2. Open the XCart tab:

3. Upload your CSV file.

4. Choose the delimiter (tab, semicolon or comma). The type of delimiter should be the same as in your CSV file. You can check it this way 💡

5. Select the character encoding used in your file. You can check it this way 💡

6. Press Import to upload your file

After the import is complete, the options of your products will be updated automatically.

LiteCommerce import format

With the LiteCommerce format, you can import product options in the form of drop-down lists, radio buttons, text fields, and text areas.

Unlike X-Cart format, using LiteCommerce format you cannot set or edit price modifiers.

1. Create a CSV file in LiteCommerce format

CSV files in LiteCommerce format have a very simple structure. You can easily create such a file from scratch in any text editor or in a spreadsheet.

Each line in the file represents a record about a certain option of a product with a certain SKU. These records consist of record fields separated by a designated delimiter: you can choose a semicolon, a comma or a tab delimiter for your file.

Let's say you want to import a Cotton Dress product that has SKU 00001 and the color options Red, Blue and Black.

This is how you can add such product options in TextEdit editor to import them in LiteCommerce format as radio-button choices:

Importing_product_options__11_.png

And this is how these product options will look in Google Sheets:

Importing_product_options__9_.png

To avoid problems during import, do not add any names/headers for your columns.

Each record field corresponds to a specific “part” of your product option:

  • 00001 is the product SKU.

  • Cotton Dress is the product name.

  • Color is the name of the option class. You can put any text here, e.g. “Size”, “Print”, “Gift message”, etc.

  • Red|Blue|Black are the option names. You can list any number of option names here and just separate them by “|”.

  • Radio Button is the option type (also called “input type”).

Note: Product SKU is a mandatory parameter. You can leave the product name field empty if you want to.

LiteCommerce format supports four option types:

  1. Radio Button allows displaying your options in the form of radio buttons.

  2. SelectBox allows displaying your options in the form of a drop-down list.

  3. Text allows adding options in the form of a text field. If you use this option type, leave the option names field empty.

  4. Textarea allows adding options in the form of a text area. Unlike text fields, text areas may contain multiple lines. If you use this option type, leave the option names field empty.

In order to import several product options using one CSV file simply add a new line for each option.

Learn more: LiteCommerce: Import/Export Procedures and CSV File Format 💡

Example 1. If you want to add the "Size" option (in the form of radio buttons) and the "Color" option (in the form of a drop-down list) for your product, the text of your CSV file should look like this in your text editor:

00011;Cotton Dress;Size;S|M|L;Radio Button
00011;Cotton Dress;Color;Red|Blue|Black|Yellow;SelectBox

When this file is imported, products with the designated SKU will have new options: "Size" and "Color". “Size” will have S, M and L option names in the form of radio buttons. “Color” will have Red, Blue, Black and Yellow option names in the form of a drop-down list.

Example 2. If you want to add a "Gift message" field (in the form of a text field) for your products and want to use import to add this option for many products at the same time, then the text of your CSV file should look like this if you edit it in a plain text editor:

00001;Porcelain dog figurine;Gift message;;Text
00002;Porcelain cat figurine;Gift message;;Text
00003;Porcelain bird figurine;Gift message;;Text
00004;Porcelain fox figurine;Gift message;;Text
00005;Porcelain mouse figurine;Gift message;;Text

When this file is imported, all products with SKUs from “00001” to “00005” will have a new "Gift message" text field.

Example 3. If you want to add a "Gift message" field (in the form of a text field) for one of your products and also want to add a "Poem" field (in the form of a text area) for it, the text of your CSV file should look like this in your text editor:

00001;Porcelain dog figurine;Gift message;;Text
00001;Porcelain dog figurine;Poem;;Textarea

When this file is imported, products with the designated SKU will have a new "Gift message" text field and a new “Poem” text area:

Example 4. If you want to import options for several above-mentioned products at once, you can just list them all in the same text file, one under another:

00011;Cotton Dress;Size;S|M|L;Radio Button
00011;Cotton Dress;Color;Red|Blue|Black|Yellow;SelectBox
00001;Porcelain dog figurine;Gift message;;Text
00001;Porcelain dog figurine;Poem;;Textarea

This is how your CSV file would look in Google Sheets (before you save it as CSV to further import into your store):

Importing_product_options__10_.png

Once the CSV file is imported, all the products with the SKUs from the first column will be updated. All the examples feature a semicolon delimiter, but you can use a comma or a tab instead of it.

2. Importing CSV files in LiteCommerce format

Once your CSV file is compiled, all you have to do is import it into your store.

1. From your store manager, go to Catalog → Products → Import Products.


2. Open the LiteCommerce tab, and then open the 2 step: Product Options tab.

3. Make sure to uncheck all the “Skip column” boxes (there are 4 of them).

4. Arrange the columns (drag and drop them) in the exact order they are in your CSV file. Feel free to uncheck the columns that are not used in your file.

5. Choose the delimiter (tab, semicolon or comma). The type of delimiter should be the same as in your CSV file. You can check it this way 💡

5. Select the character encoding used in your file. You can check it this way 💡

6. Upload your CSV file and press Import.

After the import is complete, the options of your products will be updated automatically.

Bulk Product Editor app

The Bulk Product Editor app can be very useful when you need to edit multiple products at once. You can also use it to create or update options for products that are already in your catalog. Bulk Product Editor supports all types of options! 🚀

You can also set or edit price modifiers, remove options and option values or even change or translate their names. You can either apply all the changes manually or import options and option values (in the app they are called “choices”) through CSV files.

Install the app

To install the Bulk Product Editor app:

1. In your store manager, go to Apps → App Market.

2. Find the Bulk Product Editor app.

3. Click Add payment method and buy under the app name and pricing.

Once the payment is complete, the app will be available in the Catalog section of your store manager. If you're struggling to install the app, contact us and we'll give you a hand!

Add or update product options manually

Bulk Product Editor allows you to choose products and set options for them in bulk. It means that all the chosen products will get the exact same options after the changes are applied.

To set product options manually:

1. In your store manager, go to CatalogBulk product editor.

2. Find and select products for which you want to add or update product options (you can either press the pictures of products or use filters to choose the products you need). The number of products you chose will appear on the Products selected for modification tab.

3. Press Proceed to change these products!

4. Find and press (+) next to Options and Choices to expand the menu.

Bulk_Product_Editor_app__1_.png

5. In the Options and Choices menu add, remove, rename or translate product options and choices for them (you can also set price modifiers in the Choices section). Just enter all the necessary data into the fields and press the + rule button to store it.

Bulk_Product_Editor_app__7_.png

Note: You can create as many “rules” as you need to describe all your options and choices. Each “rule” describes one option (in the Options section) or one option choice (in the Choices section).

6. After you are done setting up options and choices, press APPLY CHANGES NOW at the bottom of the page. The changes will be applied to all the products you chose.

You can always track if the changes were applied successfully in the Processing Status section (below the APPLY CHANGES NOW button).

Add or update product options with CSV files

Along with a completely manual setup of product options, in Bulk Product Editor you can upload CSV files with data on your options and choices.

Note: At the moment you cannot upload files for the Renaming and Translating sections. However, this can be achieved manually.

There are several reasons to use CSV files instead of manual setup:

  • You can generate similar (repetitive) options and choices using formulas in a spreadsheet (MS Excel or a similar program) and then just export them into a CSV file.

  • You can import options and choices in the exact same order as you listed them in your CSV file: when importing options and choices, the order is preserved.

  • You can save yourself a considerable amount of time if you need to create many options and choices.

In Bulk Product Editor, there are two separate CSV files: one for options and one for choices. To download templates of these files, simply press the Import from file button in the corresponding section (Options or Choices) and click the blue “download our model file” link:

Bulk_Product_Editor_app__4_.png

These model files give you an overview of inputs that you can use in your CSVs to describe options and choices. They completely “duplicate” the settings that you can enter in the Bulk Product Editor app manually.

This is what the Options model file looks like in Google Sheets:

Bulk_Product_Editor_app__5_.png

In this CSV file, columns describe your product option and the action that needs to be performed:

  • operation defines the type of action that you want to perform. You can add or remove options.

  • name stands for option class name. You can put any text here, e.g. “Size”, “Print”, “Gift message”, etc.

  • type defines option type (also called input type). You can choose from “drop-down-list”, “size”, “radio-buttons”, “checkboxes”, “text-field”, “text-area”, “date-picker” and “upload-files”. Make sure to write them exactly as they are written in the model file.

  • required defines whether this is a mandatory parameter or not. To make your parameter mandatory, put “true”, otherwise put “false” or leave the column empty.
    Note: This column is case-sensitive, so make sure that you do not use capital letters when you put “true”. If you write “TRUE” the column will be read as empty.

  • default-choice-index defines the choice that will be pre-selected by default. It is an optional column: if you leave it empty, by default, the first choice will be pre-selected. Note: The count starts with “0”, not with “1”, so to pre-select the third option in the choices list, you have to put “2”.

This is how the Choices model file looks like in Google Sheets:

Bulk_Product_Editor_app__6_.png

In this CSV file, columns describe choices (or “option names”) for your product options. Connect these choices to a specific “parent” option and specify the action that needs to be performed:

  • operation defines the type of action that you want to perform. You can add or remove choices.

  • parent-option binds a choice to a specific product option.

  • name stands for the name of your choice.

  • price-modifier-type (optional) defines the type of price modifier. It can be a percentage or a fixed “numeric” value.

  • price-modifier (optional) sets the size of your modifier.


Using CSV files for Options and Choices you can fully describe your product options and put them in the desired order.

Example 1. You want to add two options for your products: “Color” (in the form of a drop-down list) and “Size” (in the form of radio buttons). The first one is mandatory, the second one is not. You also want to pre-select the third choice for “Size”. In this case, the text of your CSV file should look like this if you edit it in a spreadsheet:

Bulk_Product_Editor_app__11_.png

Example 2. You want to add choices for your “Color” and “Size” options – 3 choices for each. You also want to set price modifiers: percentages for “Color” and fixed values for “Size”. In this case, the text of your CSV file should look like this if you edit it in a spreadsheet:

Bulk_Product_Editor_app__2_.png

Example 3. You want to remove the choice “Blue” from your “Color” option. In this case, the text of your CSV file should look like this if you edit it in a spreadsheet:

Bulk_Product_Editor_app__8_.png

When you are done editing your CSV files, just upload them into Bulk Product Editor:

1. Press the Import from file button in the Options and/or Choices section of the Options and Choices menu:

Bulk_Product_Editor_app__3_.png

2. Choose your file (it can be in CSV or in TXT format) and press Import to upload it:

Bulk_Product_Editor_app__9_.png

After that, you can either further edit options and/or choices for your products in the menu or press the APPLY CHANGES NOW button right away.

If you have any questions about adding or updating product options with Bulk Product Editor, please contact the developer of the app directly.

Did this answer your question?