Exporting product options

Return to Introduction  Previous page  Next page

To export product options into a CSV file, follow the instructions below (Figure 13):

<br>
Figure 13: Exporting product options


Figure 13: Exporting product options

1.In the Administrator Zone, choose 'Export catalog' section in the 'Catalog' menu.
2.Select the 'Export product options' tab.
3.In the 'Column order' form specify the order in which data fields should appear in the resulting CSV file. The following field types are available:
'sku' for product SKU number;
'name' for product name;
'optclass' for option class name;
'opttext' for option selection text;
'options' for the list of available options;
'opttype' for option selector type;
'cols' for the width of a text area if the 'Text Area' or 'Text' type of selector is used;
'rows' for amount of rows in a text area if the 'Text Area' type of selector is used;
'orderby' for 'Pos.' value;
'categories' for the list of categories (used with global product option classes).
Note: All remaining fields must be set to 'NULL'.
4.Select the field delimiter conforming to the CSV file format you are using.
5.Click on the 'Export' button to export wholesale pricing data into a CSV file.

The default name of the exported file is 'product_options.csv'. If a file with this name already exists, the newly generated file will be named 'product_options-N.csv', where 'N' is the first integer number to form a file name which is not in use.

In the resulting CSV file, global product option class definitions are listed first, followed by product-specific option class definitions.