Can I import kitted products in bulk?



  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 upload the kitted SKU and the kitting columns on your CSV. 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

    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

  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

A further 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: 18/11/2016 Neto Version: 6.4