Product options require a specific format for import with the Total Import PRO, but once you have this set up you have great flexibility and control over the product options you wish to create in OpenCart. Below is a description and examples of importing different product options. For a sample CSV file, please see http://feeds.hostjars.com/complete_1.csv
Multiple Product Options
Each product option you wish to import must have its own field in your CSV file, or its own tag in your XML file. If you wish to import Size and Color, you will have a column for each.
Multiple Product Option Values
If you wish to import multiple product option values per product, these must be separated by a | (pipe):
For example, if you are importing Size options, and the first product in your CSV file has two sizes, small and large, the value in that product’s row’s size column would contain:
If you wish to import a quantity, additional price, additional weight or sort order for a certain product option value, you can do this by creating a : (colon) separated list for each option value:
For example, if you are importing Size options, and your values are as follows:
Sizes: Small and Large
Small Quantity: 3
Large Quantity: 5
Small Additional Price: $2.50
Large Additional Price: $3.75
Small Additional Weight: 0
Large Additional Weight: 40
Small Sort Order: 1
Large Sort Order: 3
Small Required: yes
Large Required: yes
Then, the Size column in your CSV file (or the Size tag in your XML file) would contain the following:
If you wish to import only sort order, you must still specify everything to the left. This applies also to additional weight, price and quantity – you must always specify everything to the left, even if you just use arbitrary values (such as 0 for additional price and weight, and 1000 for quantity). The required field is optional. The default is "Yes" or "1" for required if not specified. If you wish to set the Required to No, set this parameter to "0".
For example, if you only wanted to import additional price, the Size column in your CSV file (or the Size tag in your XML file) would contain the following:
Option Values in Different Columns or Tags
Sometimes the option values will be present in different columns of your spread sheet. You might have:
Note: option_name would be the actual name of your option e.g: Size
In these cases, you can use the Step 3 operation 'Append Field to Field' separated by ':' in order to create the required format. This operation can be used many times in sequence, to add each required field to a : list.
Then, you can map your newly appended field as your option.