Can I import kitted products in bulk?

This article has moved to a new home. View the updated version

Kits are bundles of products made up of one or more items. There are several terms specific to kits that you should familiarise yourself with in our guide to creating kits.

  1. From Neto dashboard, navigate to Setup & Tools > Import Data.

  2. Select Products as the type and click Perform complex import > Start Data Import Wizard.



  3. You will now need to enter the SKU, and the kitting columns into your CSV file. To give some context on how this should look, you can download our sample CSV to work from.

    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]

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

    Please Note: If the Quantity is entered as 0 the product will not be added to the kit, unless you specify it as an Editable Kit.

    This will create one component of the kitted SKU. To add a second component, just add a comma (,) at the end of the string and repeat like this:

    [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], …

    Example: abc_3=6:20:1:10:group1,abc_4=24:20:1:10:group1

    Please Note: If you wish to import editable kits you will need to add a column called Editable Kit and enter the value Yes or No for each kit.

  4. Once you’ve uploaded your file, continue to the next step. In field mapping, your kitted SKU and your kitted components will be mapped up with field names from the CSV file. It should look something like this.



  5. Continue through the next steps, selecting to update or add new products and continue to the final process to upload your CSV.

Further Examples

Another 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 by joining the fields together in the field mapping section like in the example screenshot.




  • Last Modified: 28/09/2017 Neto Version: 6.9