Can I import kitted products in bulk?



Go to:
Import/export> import wizard

The import wizard requires you to upload a .CSV,.XLS or an .XML file. (You can convert an Excel file into a .CSV file by using the "Save As File Type" feature in all versions of Excel. This article explains this and other ways to create .CSV files in detail.)
 

You can import kitted products in bulk using the import system using the following string:

[SKU]=[quantity]:[price_breakdown]:[min_qty]:[max_qty]:[assemble_group]


This matches up with the fields that you can enter when you create the products manually in the system.


Adding more components (products) to the kit

To add more components to the product you can use a comma to separate out the the products, like so:

[SKU_1]=[SKU_1_quantity]:[SKU_1_price_breakdown]:[SKU_1_min_qty]:[SKU_1_max_qty]:[SKU_1_assemble_group],[SKU_2]=[SKU_2_quantity]:[SKU_2_price_breakdown]:[SKU_2_min_qty]:[SKU_2_max_qty]:[SKU_2_assemble_group], ...

and you can keep adding more products in that format using a comma as separator.

If you had a kitted product with the SKU 'my_kit', you would list out all of the other product details as you would with a normal product import.
This includes details like the product name, price and description plus any other details you want on the product.

When you are importing the components you need to follow that format above. An example of importing two components 'abc_1' and 'abc_2' with default quantity of 1, price of $10, minimum quantity of 1, maximum quantity 10 in the group 'group1' would be as follows:

abc_1=1:10:1:10:group1,abc_2=1:10:1:10:group1


If you do not need as many details you could omit some of the values. So add the same components without a maximum quantity or group you could use this format:

abc_1=1:10:1::,abc_2=1:10:1::
 

If the CSV has columns for each field

If you have each of the required fields in separate fields in your spreadsheet, you can combine them together into a string using the "concat" feature in the field mapping section.

Concatenation example:


Uploading the file
 
Go to:
Import/export> import wizard
Select the import type (product)
Browse select the file you want to upload from your local computer
Map the columns in your file with the available fields in your database
Choose how you would like the uploaded file to update your database
Upload

Once you have completed these steps the file will be uploaded. You can check the progress of the upload by going to:
Import/export> view process log

Here you will find a log of all integration processes. A file is completely uploaded when the related process is showing "finished".



For more information on inventory import fields, types and restrictions, see the support article below. 
What product / inventory import fields are available?

  • Last Modified: 29/10/2015