How to use the Product Import Tool

How to use the Product Import Tool


This article will show you how to use the product import function inside of Zangerine. If you have questions preparing your file for import, please contact Zangerine Support for help.

  1. Click Settings.
  2. Click Imports.
  3. Select Products.

You will be redirected to the import tool. See image below:




  1. In the upper right of the import tool, Click the Download Template link.

An excel file will download with pre-populated headings. See image below:




Enter data into the fields for each product.

Any fields you do not fill will be left blank inside of Zangerine.

If you have questions about what is necessary, contact Zangerine Support.

  1. Save the file to your computer.
  2. Back in Zangerine, Click Browse.

Select the File you Saved.

  1. Note: On the Product import there is an option to Overwrite existing products IDs. Use this if you would like to replace the product IDs in Zangerine with those entered in the file you are uploading.
  2. Click Upload.
  3. An orange Result banner will show with a plus on the right, that you can click to expand. This will show you which imports were successful, and if there were any errors. See image below:
  4. If you see a red error message, check the text found after VALUES for those entries that have caused the error.
  5. If you try to import an existing item, there are two things that can happen:
  1. The Result section will show the following:


  1. Or, if you Clicked the Overwrite existing products ids checkbox, it will show:



Key to template:






    • Related Articles

    • Product Edit Fields Descriptions

      General: Product Name- Required acts as the product identifier. URL alias- for website, can change how the product’s listing shows on the URL. Product information- this is the product description. Short information- this acts as a brief description ...

    • Use Customer Credits

      This article will show you how to apply customer credit to a sales order. Click Sales. Click Orders. You will be redirected to the Sales Order List screen. Select an Order to add payment to. You will be redirected to the Sales Order screen. Under the ...

    • Cross Reference: Sales By Product Report

      This report will show you which orders were purchased using a cross reference that has been attached to a product listing. Potential uses for this report include: Tracking popularity of an item by name or branding. Total sales history for all ...

    • How to use Master and Child Products

      This article will show you how to use the Options tab within a product listing. This tab allows you to create variations of a product based upon option sets you create. The original listing becomes the Master product, and any variations are Child ...

    • Delete A Product

      Discontinued products, or accidental entries can add unnecessary clutter. Do the following to delete a product. Click Catalog. Click Products. Click the product you wish to delete. Click the arrow next to Save and Continue. Click Delete Product. ...