Home » Inventory » New products import

New products import

Open “INVENTORY > Import products (beta)”. If you can’t find a link to the new products import module in Inventory menu, please contact support@erply.com and ask to plug it in.

To import matrix products, click “import matrix products” in the top-right corner of the Import options box. Matrix products can’t be imported with regular products import and vice versa.

 

 

1. Import file

Supported file formats are CSV, XLS and XLSX.

It is recommended to use the example XLS-file provided in the import page (click “download example product template”).

Most of the columns will be mapped to Erply product fields automatically with this template. Otherwise only some of the columns will be mapped automatically.

Maximum file size is 8MB.

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 variation code column is mapped, variation codes must be on every line and codes must be unique.

There is no required column order.
You may delete unused columns in the xls-template.

 

2. Manual preparations in Erply

To import price list prices or matrix products, it is required to manually input Pricelists and Matrix Dimensions to Erply.

 

3. Upload file and set Import Options

File
Select the import file from your computer by clicking “Browse”.

Warehouse
The selected warehouse will be used for stock replenishment and inventory registrations.

Matching existing products
The import checks if 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 more detailed description below.

Add or update
By default new products will be added and existing will be updated.
If you select “Only add new”, then new products will be added and existing products will be skipped.
If you select “Only update existing”, then new products will be skipped and existing products will be updated.

Archived products
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.

 

 

4. Import preview

Here you can review the same import options as described above.

On the row “File:” you can see the first (title) line of the import file.
If a title is not fully displayed move 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 map manually all the other fields you wish to import.
Matrix dimensions are always required to map manually.

Coloured texts in the beginning of the rows are indicating, which rows will be added and which will updated or skipped.

If columns are mapped correctly click “Test the import by importing 10 rows”.

 

5. Import test

You’ll see import results for first 10 rows.

Click “See in ERPLY” to open an imported product.

If first 10 rows were imported as expected and no duplicates were created, click “Start import”.

 

6. The import process

Import is running server-side and you may close the import window after clicking “Start 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, system will display after import, that “Import finished, but not all rows were successfully imported”.

 


Matching existing products

Single match by field
If you select only one field as the field to match by, then exact match is looked up. Be aware that spaces at the beginning of at the end of the field make a difference. Letter case (capital or small letters) does not make a difference.

  • code “4332 ” is not equal to “4332”, because of the spaces at the end of first code
  • code “A332” is equal to “a332”
  • if there is more than two matching products in ERPLY, then the import tool will pick a random one.

Multiple match by fields
If you choose multiple fields to match by, then the import tool will try to find a best match. The logic is as follows:

  • Product in ERPLY with exactly the same field values is matched first (Example 1).
  • 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 match by all fields, then the import will try to match based on some of the fields until it finds a match or there is no product in ERPLY that has any common matching fields (Example 3).
  • If there is more than two matching products in ERPLY, then the import tool will pick a random one (Example 4).

Examples
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: “”


Pricelists and Matrix Dimensions

To import price list prices or matrix products, it is required to manually input Pricelists and Matrix Dimensions to Erply.

Pricelists
Open “INVENTORY > Price Lists” and create price lists to which you will import prices. Later you can map these price lists to certain columns in the import file.

Matrix dimensions
Open “INVENTORY > Matrix Dimensions” and make sure that required matrix dimension names (like Color, Size etc.) have been added. Then you can map dimenssions to columns in the import file.

 


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 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)

Pricelists
You can use maximum 50 pricelists for one import.
– Price (pricelist 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
– Beverage container’s
– 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 – Beverage container’s
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 Pricelists
v – Price (pricelist 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 – Beverage container’s
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)