Product options require a specific format for import with Bulk Import, but once you have this set up you have great flexibility and control over the product options you wish to create in KartRocket. Below is a description and examples of importing different product options.
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:
small|large
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:
<option_name>::<additional_price>:<additional_weight>:<sort_order>
For example, if you are importing Size options, you have two sizes, small and large, and each has a quantity of 3, additional price of +2.50 and additional weight of +400, the Size column in your CSV file would look like (or the Size tag in your XML file would contain) the following, where the last digit on each option is the sort order:
small:3:2.50:400:1|large:3:2.50:400:3
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).
Sometimes the option values are all present in different columns of your spread sheet. You might have:
option_name,option_value,option_price
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.