> For the complete documentation index, see [llms.txt](https://support.ordereazi.com/central/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://support.ordereazi.com/central/order-management/products/product-management/import-products.md).

# Import Products

Typing in a whole catalogue, or updating hundreds of prices one product at a time, takes days. Import Products in OrderEazi adds and updates products from an Excel spreadsheet in one go. Products already in OrderEazi are matched by their product code and updated, and new codes are added.

### Before you start

You'll need the **Create Products** permission, in the **Products** permission group. Every supplier named in the file must already exist in [Suppliers](/central/order-management/suppliers.md). Brands and categories that don't exist yet are created for you.

### How to import products

> **Warning:** Updating a product replaces its details with what's in the file, including empty cells. An empty **IsActive** turns the product off, and an empty **Brand** removes its brand. Export your products first and edit that file, so nothing is cleared by mistake.

1. In the main menu, go to **Products** > **Product Management**.
2. Select **Import Products**.
3. Select **Download Template**.
4. Fill in one row for each product. See [Filling in the Import Product Template](/central/order-management/products/product-management/import-products/filling-in-the-import-product-template.md).
5. Save the file as Excel (.xlsx or .xls).
6. Drop the file onto the import page, or select it to upload.

You see "Import was successful." and go back to the product list.

**Example:** Your supplier sends a new price list. You export your products, change the **DefaultCost** and **DefaultSelling** for 300 products, and import the file. The 300 products are updated, and any new codes in the file are added as new products.

### How rows are matched

* **The product code decides:** A row whose **ProductCode** matches an existing product, ignoring capitals, updates it. Any other row adds a new product.
* **Duplicate rows are merged:** Rows with the same product code are combined into one product.
* **One error stops the import:** If any row has an error, nothing is saved.

### When the import fails

You see "Something went wrong, please review the errors below." and a **Product Import Errors** table, with each row number and what's wrong with it. Fix the rows and upload the file again.

* **"The uploaded file has been altered and the headings do not match criteria":** The column headings have been changed. Download the template again and copy your data into it.
* **"The Supplier Name of this cell ... does not exist.":** Create the supplier first, or check the spelling matches.

### Related pages

* [Filling in the Import Product Template](/central/order-management/products/product-management/import-products/filling-in-the-import-product-template.md): what to put in each column
* [Product Management](/central/order-management/products/product-management.md): export your products before you import