How to import products using a CSV file?
With Nembol, you can list your products on multiple channels simultaneously. To do it, you need to import your listings in Nembol before publishing them on multichannel. You can decide to run a direct import or use a CSV file filled with all your product data.
CSV files can be downloaded from Quickbooks or any other e-commerce tool, accounting system, or ERP that allows CSV product export, or can be manually created.
In this guide, you’re going to learn how to use a CSV to import your products in Nembol: from its creation to the import.
CSV files can be downloaded or manually created:
If you download it from Quickbooks or any other e-commerce tool, accounting system, or ERP, you need to copy and paste the data inside the Nembol CSV templates, without changing the column titles/value.
If you need to manually create it, download the CSV template and fill the column with all the info using google sheets.
Please note: we highly recommend using Google Sheet to edit your CSV, since Excel might not accept commas as a separator.
How to use Nembol CSV template?
Once you have downloaded the CSV template, all you need to do is fill each column as follows:
Fill the ID column with a custom code of letters and numbers. If you need to list products with variants, remember to use the parent product ID also on each child product.
Fill the title column by typing the title only at the line of the parent product. Remember to leave the title line black for each child’s product.
Fill the description column by adding your product description. As for the title, only the parent product line should be filled with the description.
Fill the option_1_name column with the attribute of the variations (e.g: size, color, etc.). Only the parent line should be filled with this info.
Fill the option_1_value with the values of each attribute (e.g option_1_name = color; option_1_Value = black).
Fill the SKUcolumn with a unique code. Parent and child products must have different SKUs.
Fill the GTIN and ASIN column if your products are associated with a barcode. Please note: on Amazon barcodes are mandatory. You must provide them to list your products.
Fill the image_link column with the link to your product’s primary photo. To retrieve the link of an image, you should host them on cloud storage like dropbox.
Fill the additional_image_link column with all the links of the product secondary images. To add multiple images, remember to separate each photo using the comma “,” as a separator.
Fill the brand column with the brand of your products.
Fill the tag field with all your product tags, separating them with commas.
Fill the category column with the product category.
How to upload your CSV on Nembol?
Once you have finished editing your CSV, you can now import it to Nembol. To do it :
Go to the Product Tab and click the button “Import CSV”.
Click on “Choose file” in Nembol, select your file on your PC, and click “Start import”.
Nembol will start the import and add your products to your Nembol account. Once done, refresh the Products Tab in Nembol.