This form may look big, but it is actually very simple, if you divide it into sections

  1. Information section - Here it shows the information that you chose on the previous screen
  2. Tell which Excel column corresponds to your local product attribute.
    Field label is the heading name from Excel file
    Field value is the dropdown of all possible product attributes
    The more columns you have, the bigger the form.
    Unmapped columns will be ignored
  3. Action section - for example if you wish to preview first lines



If you are inserting new products, then at minimum you need to map:

  • Product SKU
  • Product Name
  • Product price
  • Product description (if marked as required)
  • Product short description (if marked as required)


If you are updating products, then at minimum you need to map:

  • All identification attributes that you chose. For example if you chose to match products by SKU and EAN/UPC code, then you need to map both SKU column and EAN/UPC column.
  • At least one attribute that you are going to update. For the moment being you cannot change EAN/UPC, ID, SKU attributes.


When all ok, proceed by pressing the button "Preview first lines"

If you encountered any errors you will be redirected back here with detailed error messages.