Updated on March 17, 2026

Content

How to import products using a CSV file

You can use a CSV file containing your product data to import products into Nembol, as well as to later edit them.

CSV files can be downloaded from Quickbooks, other ecommerce tools, accounting systems, ERPs that allow CSV product export, or can be manually created.

If you download it from Quickbooks, other ecommerce tools, accounting systems, or yoru ERP:

Copy and paste the data inside Nembol CSV template, without changing the column titles of the template. Bear in mind: no changes in the column titles, and Title vs. title are different things in a CSV file: keep everything in lowercase, as it is in the template.

If you need to manually create it:

Download the CSV template by clicking the button below, then fill each column with your product data as needed using Google Sheets, of Microsoft Excel, Apple Numbers or your preferred spreadsheet package, the export it as CSV, using ; as a separator.

Download the free CSV template

How to edit existing products or create new ones with CSV

how to fill Nembol csv template

Once you have downloaded Nembol CSV template, all you need to do is to fill each column as follows:

  • id : (required field). Type a string of letters and numbers which will be the unique identifier of each of your products. You can make it up, as long as it is unique. If you need to list products with variants, remember to use the parent id also for each variation.
  • title : (required field). Type the title of your products. If your products have variations, type the title only at the line of the parent product. Remember to leave the title line blank for each child’s product.
  • price : (required field). Use the format 129.87 with . as a decimal separator, no currency, no thousand separator
  • quantity : (required field). Type integer only. No decimals. 
  • description : column by adding your product description. As for the title, only the parent product line should be filled with the description.
  • option_1_name : type the attribute of the variations (e.g: size, color, etc.) Only the parent line should be filled with this info.
  • option_1_value : insert the values of each attribute (e.g option_1_name = color; option_1_Value = black).
  • sku : insert the SKU code. SKU stands for “Stock Keeping Unit” and SKU codes must be mandatorily unique in many systems, therefore either use the SKU code you received from the manufacturer, or create a unique code per each SKU you sell. Parent and child products must have different SKU codes.
  • gtin and asin : insert them if your products are associated with a barcode. Please note: on Amazon barcodes are mandatory. You must provide them to list your products.
  • image_link : (required field). Paste the one link to your product’s primary photo. To retrieve the link of an image, you should host them on cloud storage like dropbox.
  • additional_image_link : paste here the links of the product secondary images. To add multiple images, separate each photo using the comma “,” as a separator.
  • brand : type the brand of your products.
  • tag field : add the tags you wish to associate with each product, separate them with commas.
  • category : use this column to type the product category. Whatever you write in this field will be used by most AI categorizer as keywords to set your products in a category or in another. You do not need to write an exact category, but the keywords that best will help a machine to categorize your item.

Read here how to add images to your CSV file ->

Please note: to import CSV file correctly, it is necessary to fill in five mandatory fields: id, title, description, quantity, price.

How to edit product data by SKU code (CSV Light Edit)

Nembol allows you to exactly and specifically update values of just the four “inventory” data of your products:

  • quantity
  • price
  • barcode
  • asin

These fields will be edited by the system matching them by sku-code, and SKUs not included will rest untouched by your edit. An important guarantee for many sys-admin of brands editing products daily or even multiple times a day.

To access this feature, you can use your own CSV or download our template. Any file will work with minimum two columns:

  • sku-code — which is the required column, the key for the system to recognize items to be edited.
  • At least one of quantity, price, barcode, asin. From just one to all four according to what you want to edit.

Step-by-step guide:

  1. Fill the “sku-code” column with the SKU code you want to update. Nembol will match products using the SKU code.
  2. Add the field you want to update (quantity, price, barcode, and / or ASIN) and type in the new values. Update only the columns you want to change, leave other fields blank. Blank fields will not overwrite existing information in Nembol.
  3. If your file by chance includes additional columns, you can delete them or leave them: Nembol will ignore them, no worries.

Note: This function cannot edit SKU codes nor delete products from Nembol. Use CSV full template for this. 

Please note:  CSV light edit is available starting from the Enterprise plan.

How to upload your CSV on Nembol

Once you have finished editing your CSV, you can now import it to Nembol.

Follow these steps:

  1. Go to the Products Tab.
  2. Click on the “Import” button.
  3. Select “Import CSV file“.
  4. Click on “Upload a CSV file” in Nembol, or drag and drop the file.
  5. Click on “Import CSV”.
  6. Nembol will start the import and add or edit your products to your Nembol account.