To main website
  1. Help Center - Channable
  2. Imports
  3. FAQ

Articles in this section

See more

My import doesn’t have UPC / EAN / GTIN numbers, how can I add these?

Do you want to interactively learn about setting up your import in Channable? Learn how to create a Channacademy account in the Channable app through this Help Center article and start with the Basic Imports course.

Most marketplaces require that you provide the UPC, EAN or GTIN number of a product. They use this to match product information based on this barcode. It depends on the marketplace which type of barcodes you need; some local marketplaces only accept EAN, whereas the global marketplaces usually accept any of these codes. 

If these codes are not included in your import, you can add them manually. 

Step 1: Get UPC / EAN / GTIN numbers for your products

If you don’t have these barcodes yet, there are two ways to get them: 

  1. Ask your supplier, they should keep a list of barcodes for their products. 
  2. Buy barcodes for your products from GS1, which is the official global barcode provider. 

Step 2: Create a data feed

In this step you will create a data feed in a Google Spreadsheet. This feed contains all barcodes, which we will import into Channable.

  1. Create a new Google Spreadsheet
  2. Use the first row as a header. You can use for instance ‘ID’ for the first column, and ‘EAN’ for the second column.
    Import-EANs-Google-Sheets.png
  3. In the first column, provide all the ID’s of your products. 
  4. In the second column you put the matching UPC / EAN / GTIN for each product. 
  5. Use the steps in this article to import this sheet into Channable.  
Note: Instead of ID, you could also use another unique identifier for your products in the sheet, such as SKU or the product title. It is however very important that the identifier is unique, and already exists in Channable. Make sure it is exactly the same as what you have in Channable (it is case-sensitive). 

Step 3: Combine the data feed with your main import

  1. After you’ve provided the link to the Google Spreadsheet in Channable, you’re taken to the ‘Edit mapping’ screen. 
  2. At the bottom of the page you can specify which fields you want to combine. Here you select the field that is present in your main import, and in the Google Spreadsheet data feed. In this case, it is id.

    Channable_-_combine_on_id.png
  3. Click ‘Save & Import’. The Google Spreadsheet will now be imported, and the barcode information will be added to your items.