This section will cover regular product imports and matrix product imports:
Starting a new product import
Product types
Upload file and import options
Import preview
Test import
Product import process explained
Matching existing products by one data field
Matching existing products by multiple data fields
Price lists and matrix dimensions
Uploading product groups
Available mapping fields
Regular products
Matrix products
Be sure to use our product import template. The maximum file size supported is 8MB. Files can be uploaded as .CSV, .XLS and .XLSX files.
Note: There is no required column order. You may delete unused columns in the xls-template.
Start a product import
In the back office, open the Inventory module and select Import products (beta).
Product types
Regular products:
Each product must be on a separate line.
Matrix products:
Each matrix variation must be on a separate line. Each variation line must contain a code or name of the matrix product.
If the variation code column is mapped, variation codes must be on every line and codes must be unique.
If you’re importing price lists or matrix products, these must be manually inputted in Erply beforehand.
Upload file and import options
Select the import file from your computer by clicking Choose file.
Warehouse
This section allows you to choose a warehouse to upload products to. This is used for stock replenishment and inventory registrations.
Matching existing products
The import checks whether the product already exists in Erply. If it does, then it will be updated. Existing products will be searched by Code, UPC/EAN code or Name. Please read the more detailed description below.
Add and update existing
By default new products will be added and existing ones will be updated. If you select “
Only add new
New products will be added and existing products will be skipped.
Only update existing
New products will be skipped and existing products will be updated.
Ignore archived
Archived products will be not matched with products in the import file.
Update archived where possible
Archived products will be updated if matching products are found in the import file.
Click Preview to continue.
Import preview
Here you can review the same import options and map you data fields.
File:
You can see the first (title) line of the import file. If a title is not fully displayed, move the mouse over it and the full title will be displayed.
Beneath each title is a drop-box for column mappings. Available Erply fields are logically grouped and most important fields are highlighted.
Review automatically mapped fields and manually map any other fields you wish to import.
Matrix dimensions are always required to be mapped manually.
Colored texts in the beginning of the rows indicate which rows will be added and which will updated or skipped.
Test your import
If columns are mapped correctly, click Test the import by importing 10 rows.
You’ll see import results for the first 10 rows. This allows you to confirm that your import columns were properly mapped and that the information is being imported as expected.
Click “See in Erply” to open an imported product.
If the first 10 rows were imported as expected and no duplicates were created, click Start import.
Product import process explained
Imports in Erply run server-side, which means you may close the import window after starting an import.
Progress of the running import will be displayed again if you reopen the import window.
If some rows in the import file were invalid, there will be a notice after import stating that “Import finished, but not all rows were successfully imported.”
Matching existing products by one data field
If you only select one field to match products by, Erply will look up exact matches.
Be aware that spaces at the beginning or end of the field make a difference. Letter case (capital or lowercase letters) does not make a difference.
For example:
Code “4332 ” is not equal to “4332” because of the spaces at the end of the first code.
Code “A332” is equal to “a332”.
If there are more than two matching products in Erply, the import tool will pick a random one.
Matching existing products by multiple data fields
If you choose multiple fields to match by, then the import tool will try to find the best match. The logic used by Erply is as follows:
A product in Erply with exactly the same field values is matched first (See Example 1, below).
If some “match by” fields are not set for the row, then the empty values are ignored. The product in Erply will be matched only by non-empty fields (Example 2).
If there is no product which matches all fields, the import will try to match based on as many fields as possible until it finds a match or there is no product in Erply that has any common matching fields (Example 3).
If there are more than two matching products in Erply, the import tool will pick a random one (Example 4).
For example:
Match by: Code, UPC/EAN
Product 1 in Erply: Code: “shirt-red”, UPC/EAN: “10001”
Product 2 in Erply: Code: “shirt-red”, UPC/EAN: “10002”
Example 1: Following row will match Product 2:
Code: “shirt-red”, UPC/EAN: “10002”
Example 2: Following row will match Product 1:
Code: “”, UPC/EAN: “10001”
Example 3: Following row will match Product 1 and overwrite the Code with new value:
Code: “shirt-green”, UPC/EAN: “10001”
Example 4: Following row will match random product:
Code: “shirt-red”, UPC/EAN: “”
Price Lists and Matrix Dimensions
To import price list prices or matrix products, it is required to manually input Price lists and Matrix Dimensions to Erply.
Price lists
Price lists Open the Retail chain module and navigate to Price lists.
Create price lists to which you will import prices. Later you can map these price lists to certain columns in the import file.
Matrix items
Open the PIM module and select Matrix dimensions.
Make sure that required matrix dimension names (like Color, Size etc.) have been added.
For more information, check out our matrix items guide.
To import matrix products, click Import matrix products in the top-right corner of the Import options box.
Matrix products cannot be imported with a regular products import and vice versa.
Uploading product groups
The product import tool can be used to edit product groups in bulk, but you must have your product groups properly set up before this can be done.
Using an example, say you want to upload a product under the product tree Audio → Amplifiers → Sonos.
When filling out your product import sheet, any products that you want to upload under this product tree should have Sonos as their product group.
Important: Avoid duplicate product group names
Available mapping fields
Available mappings for regular import:
Code
Code
UPC/EAN
Code 3
Manufacturer code
Name and description
Name ENG
Description
Long description
Origin and grouping
Product group
Product category
Priority group
Supplier
Country of origin
Manufacturer
Brand
Pricing, taxing and cost
Import allows you to use prices with comma separator (100,10) and with point separator (100.10) or without any separator (100).
Net sales price
Sales price with tax
Product cost
Tax %
Tax free (yes/no)
Price lists
You can use maximum 50 price lists for one import.
Price (price list A)
Price (pricelist B)
Measures and weight
Weight
Packed weight (gross weight)
Length
Height
Width
Volume
Stock keeping and delivery
Non-stock product (yes/no)
Unit
Amounts in packages (separate with spaces)
Usual delivery time
Reorder point
Restock level
Inventory Registration
Inventory Registration Quantity
Inventory Registration Price
Status
Product is active (yes/no)
Status (active/archived/no longer ordered/not for sale)
Show in webshop (yes/no)
Other
Attribute
Available mappings for matrix import
m – will be imported to matrix products
v – will be imported to variations
m&v – for matrix products and also for variations (if similar column for variation is not specified)
Variation Dimensions
v – Color
v – Size
Matrix Code
m – Code
m – UPC/EAN
m – Code 3
m – Manufacturer code
Matrix name and description
m – Name ENG
m&v – Description
m&v – Long description
Matrix & Variation measures and weight
m&v – Weight
m&v – Packed weight (gross weight)
m&v – Length
m&v – Height
m&v – Width
m&v – Volume
Matrix & Variation status
m&v – Product is active (yes/no)
m&v – Status (active/archived/no longer ordered/not for sale)
m&v – Show in webshop (yes/no)
Matrix & Variation taxing
m&v – Tax %
m&v – Tax free (yes/no)
Matrix & Variation stock keeping and delivery
m&v – Non-stock product (yes/no)
m&v – Unit
m&v – Amounts in packages (separate with spaces)
m&v – Usual delivery time
Matrix & Variation origin and grouping
m&v – Product group
m&v – Product category
m&v – Priority group
m&v – Supplier
m&v – Country of origin
m&v – Manufacturer
m&v – Brand
Variation code
v – Code
v – UPC/EAN
v – Code 3
v – Manufacturer code
Variation name and description
v – Name ENG
v – Description
v – Long description
Variation pricing and cost
v – Net sales price
v – Sales price with tax
v – Product cost
Variation Price Lists
v – Price (price list A)
v – Price (pricelist B)
Variation measures and weight
v – Weight
v – Packed weight (gross weight)
v – Length
v – Height
v – Width
v – Volume
Variation stock keeping and delivery
v – Non-stock product (yes/no)
v – Amounts in packages (separate with spaces)
v – Usual delivery time
v – Reorder point
v – Restock level
Variation Inventory Registration
v – Inventory Registration Quantity
v – Inventory Registration Price
Variation status
v – Product is active (yes/no)
v – Status (active/archived/no longer ordered/not for sale)
v – Show in webshop (yes/no)