If you need to edit product options via CSV, you need to do so by using the appropriate CSV template.
Go to [Product list] and click [Download as CSV files] to download the template for [Reset options and inventory]. Edit the products and upload the modified file.
File should be saved in .xlsx or .xls format.
When the number of options change, the value entered in the [Options] will be applied to all multi-language stores.
In this case, the existing variant code and the available stock quantity will be reset.
e.g. If the existing options are "Color{Black|White}//Size{S|M}//Pattern{Sun|Star}”, changing the number of options and writing “Color{Black|WHT}//Size{Free|M}//Pattern{Sun|Star}//Material{Glass|Plastic}” will override the existing items and create new options including “Black/Free/Sun/Glass”.
When you upload a CSV file with the same number of options, the options will be saved in the order entered, and the variant code and the available stock quantity will be maintained.
e.g. If the existing options are "Color{Black|White}//Size{S|M}//Pattern{Sun|Star}”, maintaining the number of options and writing “Color{Black|WHT}//Size{Free|M}//Pattern{Sun|Star}” will change the variant from “White/S/Sun” to “WHT/Free/Sun”.
For products with inventory tracking enabled, editing options via CSV is not recommended.
You need to edit other option details such as display status and sale status in [Edit product] page.
Note that for custom selection and independent variant selection types of options, option details cannot be edited via CSV. Option details for the above types can only be edited on [Edit product] page.
When uploading a CSV file, leave the first row empty and start entering values from the second row.
[Product code] is a required field. Make sure to enter a value for the required fields before uploading the file.
You can only edit up to 500 options based on the product code.
Entering a space in a field that should be left blank may lead to an error.
If [Enable auto-translation for option values] is set as [Yes] in [My Store>Store setup>General settings], option values you add will be automatically translated into your multi-language store's language.
(1) Column A: Product code
Enter the code of the product you wish to edit.
This column should not be left empty.
(2) Column B: Product name
Changes made to the additional fields will not be reflected.
If you want to change product names via CSV, you need to import a CSV file that contains new product names in [Add products] tab.
(3) Column C: Options
Type in Y to enable option or N to disable the option feature.
If this column is left empty, N will be entered by default.
You only need to enter data in column D through I when Y is entered for column C. If N is entered for column C, you do not need to enter data in column D through I.
(4) Column D: Variant configuration method
This column should be entered only when Y is typed in for column C (Options).
You can only edit products with variant selection type set as T.
Type in E for custom selection, or for independent variant selection.
(5) Column E: Option display
This column should be entered only when T (Combination-type) is entered for column E (Variant configuration method).
C: Option combination type, S: Individual option type
(6) Column F: Option input format
Refer below for entering options and option values.
Option name A{Option value a|Option value b|Option value c}//Option name B{Option value d|Option value e|Option value f}
e.g.) Color{Red|Blue}/Size{S|M}//Heel{3cm|5cm}
In the example below, color, size and heel height are options, and red and blue are option values.
If you change the option values without change the number of options, the changes you make to the option values in the CSV file will be reflected once you import the data.
Note that changing the number of options will reset the available stock level and variant codes.
(7) Column G: Option display format
For products with multiple options, type in multiple letters separated by commas.
Drop-down list: S
Preview: P
B: Text swatch
R: Radio button
For options with option style set as P (Preview), either color chip or swatch is required.
If no data has been entered or if items of data entered is less than the actual number of options, options will appear in a drop-down list (S).
(8) Column H: Swatch
Data for this column can be entered only when Y is entered for column G (Option style).
You have to type in the same name of the file image added to /web/product/option_button/.
Multiple options with display format set as [Preview] can be separated by double slashes ((//). Option values should be entered inside curly brackets ({}) and separated by bars (|).
The data you entered will be applied in the order of the options with display format set as [Preview].
When an entry is missing, the image in the missing entry will be deleted.
e.g.) {img1.gif|img2.gif}
(9) Column I: Color
Multiple options can be separated by double slashes (//), and option values should be entered as hex color codes inside curly brackets ({}) and separated by bars (|).
문의
e.g.) {#ff0000|#0033cc}//{}//{}
(10) Column J: Custom text field
Type in T to enable the file attachment option, or F to disable the file attachment option.
If this column is left empty, F will be entered by default.
You only need to enter data in column I through K when T is entered for column J.
(11) Column K: Custom text field name
Separate multiple custom text field names with bars (|).
Each entry cannot exceed 250 bytes.
e.g.) Name|Gift
(12) Column L: Custom text field (Required/Optional)
Type in T for required, or F for optional, and separate the letters (T or F) with bars (|) depending on the number you entered for column K (Custom text field).
e.g. T|F
(13) Column M: Character limit
Separate the numbers for character limit with bars (|) depending on the number you entered for column K (Custom text field).
Notes
Data in the CSV file should be entered from column A to column M. Note that the file may not be uploaded properly if you edit the column headers or enter data in columns other than the first 14 columns.
You need to enter the product codes of the products you wish to edit options or inventory information for.
When the number of options change, the variant codes and the available stock quantities will be reset. (For multi-language store users, the newly entered information will be applied to all the stores.)
When the CSV file has the same number of options, the options will be saved in the order entered, and the variant code and the available stock quantity will be maintained.
