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

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