How do I bulk import item specifics?

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

Creating your Import File

Product specifics can be uploaded to Neto using the Import Wizard, or an import template. You can use our example specifics import template to help you get started.



Specifics are imported as a semicolon separated list format:

[Specific Type 1]:[Specific Value 1];[Specific Type 2]:[Specific Value 2];

If your specific has multiple values from the same time, they need to be pipe ‘|’ separated.

Example: one value for each specific:

Colour:Red;Size:Large

Example: adding multiple values to a specific:

Colour:Royal Blue|Black|White|Silver;Size:Small

Please Note: Save your file as a CSV (comma separated values), so that the import wizard is able to read it correctly.

Importing from a template file

  1. From the Neto Dashboard navigate to Setup & Tools > Import Data.



  2. Select Perform Complex Import and choose Start Data Import Wizard.



  3. Choose File and browse to where you saved your spreadsheet and Open. Continue To Next Step.



  4. You now need to match the fields in your file with Neto’s database. If you used the example template above your mapping should look like the below. Continue To Next Step.



  5. Set the How Do You Want To Update Your Database to Add New/Update Existing Products Only.

    You can also configure an advanced settings relating to replace your existing specifics on products (only products in the file will have their specifics overwritten). Set this as desired and Continue To Next Step.



  6. In the last step you can choose to save the configuration as a template, to be used in the future. Check the box and enter an Import Template Name if desired, and choose Process File Now.



  7. Neto will then start the import process, which takes around 10 minutes to complete. After which, your products will have their specifics loaded against them.



Export/Import Mapping

The Import Wizard is designed so that you can use almost any combination of fields to apply specifics to your products, as long as they are mapped correctly.

The below mapping will import specifics from a CSV file exported using Neto’s Simple Export method.



This mapping links multiple fields together by using the Join To function (highlighted red), and adds the field separators (; & :) by inserting Static Values (highlighted blue) between the data values.

By doing this you can combine multiple fields with the specific data into one field in Neto, so that the item specifics can be applied correctly.


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

     

    Related Articles & Videos