> 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/filling-in-the-import-product-template.md).

# Filling in the Import Product Template

A product import is only as good as the spreadsheet behind it: a code in the wrong column or an empty cell can change hundreds of products at once. This page explains each column of the OrderEazi product import template, in the order they appear. Keep the headings exactly as they are.

### The required columns

These must be filled in on every row:

* **ProductType:** Product, Service, or Courier. See [Products](/central/order-management/products.md) for the difference.
* **ProductCode:** The product's SKU (the product code). It must be unique, and it's how the import matches existing products.
* **Description:** What appears on your quotes and invoices.
* **BaseCode:** The code that links sizes and colours of one product, such as GOLF for GOLF-BLK-M and GOLF-NAV-L. For a product with no sizes or colours, use the product code.

**DefaultSelling** and **DefaultCost** are also marked as required in the template. Enter the selling price and cost, excluding VAT.

### The other columns

| Column                 | What to enter                                                                                         |
| ---------------------- | ----------------------------------------------------------------------------------------------------- |
| IsActive               | true to let reps add the product to projects, false to keep it off for now. An empty cell means false |
| Brand                  | A brand from the Brands\_Lookup sheet, or a new one to create it. An empty cell removes the brand     |
| Category               | A category from the Category\_Lookup sheet, or a new one to create it                                 |
| Size                   | The size, if the product comes in sizes                                                               |
| Colour                 | The colour, if the product comes in colours                                                           |
| Length, Width, Height  | The packaged size of the product                                                                      |
| Weight                 | The packaged weight                                                                                   |
| WeightUnitOfMeasure    | The unit of the weight, from the WeightUOM\_Lookup sheet. Leave it empty if there's no weight         |
| RecommendedRetailPrice | The recommended retail price, excluding VAT                                                           |
| SupplierName           | The supplier's name, exactly as it is in OrderEazi. Leave it empty for products you make yourself     |
| PreferredSupplier      | true if this is the supplier you normally buy from                                                    |
| SupplierCode           | The supplier's own code for the product. Required when SupplierName is filled in                      |
| StockCheckCode         | The code your supplier uses for stock updates, if it's different from their product code              |
| Notes                  | Internal notes about the product                                                                      |

**Example:** A row with ProductType Product, ProductCode MUG-WHT, IsActive true, Description "White ceramic mug 330ml", BaseCode MUG-WHT, Brand Acme, DefaultCost 35, and DefaultSelling 65 adds an active mug priced at R65 excluding VAT.

### Things to check before you import

* **Empty cells change products:** When a row updates an existing product, empty cells overwrite what's there. Start from an export of your products so every cell is filled in.
* **Supplier names must match:** The import doesn't create suppliers. Add any new supplier in OrderEazi first.
* **The lookup sheets:** Copy brands, categories, and units from the lookup sheets at the bottom of the template, so they match exactly.

### Related pages

* [Import Products](/central/order-management/products/product-management/import-products.md): upload the finished file
* [Adding and editing a product](/central/order-management/products/product-management/adding-and-editing-a-product.md): what each field does on the product screen