Data Mapping Fields in Product Importer

January 25, 2023


Regular Products

Product Details

Mapping ValueValueE.g.Use
Product IDID value is expected to be a valid whole number1Product ID is an internal ID given by Erply to the program. It's primary use is when working with API-s and it can be used to match existing products.
You cannot set a product ID yourself.
Product typeValue can be any of the following: PRODUCT, BUNDLE, ASSEMBLY
If the value is not one of the allowed ones then it is set to ‘PRODUCT’. Note that when any bundle or assembly fields are mapped then this value will be ignored.
PRODUCT

This is used to differentiate between the three given product types.
Read more about this HERE.

Product codeCell can be any alphanumeric valueabc123Product code is used to differentiate between products and match them to each other in the importer. This is the main code used for all products.
This has to be unique to the product.
Product UPC/EANCell can be any alphanumeric valueabc123The UPC/EAN is the code that goes on barcodes. It can be used to match existing products.
This has to be unique to the product.
Product code 3Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Product manufacturer codeCell can be any alphanumeric valueabc123Field can be used to add a code the manufacturer of the product uses to differentiate between products.
Product codes are used to differentiate between products and match them to each other in the importer. 
Product code 5Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Product code 6Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Product code 7Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Product code 8Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Product manufacturerCell can be any text valueManufacturerManufacturer name.
Non-stock productValue can be any of the following: 1, 0, true, false, yes, notrue

This is used to show whether a product has stock or not. 
Read more about this HERE.

Product usual delivery timeCell can be any text value5 daysUsual delivery time. This is useful for quotes.
Product deposit fee codeCell can be any text valueCodeAbcUsed to attach a deposit fee product to a regular product. The deposit fee product has to be configured earlier. 
This is used for tare and other similar items.
Product deposit fee amountCell can be any numeric value20Amount of deposit fee products attached to main product.
Product cashier must enter price in POSValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you want your cashier to set a price on.
Product is regular gift cardValue can be any of the following: 1, 0, true, false, yes, notrue

Use for regular gift cards.
Read more about this HERE.

Product is serial numbered gift cardValue can be any of the following: 1, 0, true, false, yes, notrue

Use for serial numbered gift cards.
Read more about this HERE.

Product promotion discounts do not applyValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give discounts on.
Product does not grant customer reward pointsValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give reward points for.
Non-refundable productValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to be refundable.
Product age restrictionAny interger value - 0 means the product is not age restricted18Use for products that have an age restriction, e.g. alcohol or nicotine.
Product has serial numbersValue can be any of the following: 1, 0, true, false, yes, notrue

Use for products that must have serial numbers.
Read more about this HERE

Product is sold in packagesValue can be any of the following: 1, 0, true, false, yes, notrueUse for products that are sold in packages at the POS.
Product name (Language)Cell can be any alphanumeric valueProduct #1Product name.
Product description (Language)Cell can be any alphanumeric valueProduct #1 descriptionProduct description.
Product long description (Language)Cell can be any alphanumeric valueProduct #1 long descriptionProduct long decription.
Product long description (HTML) (Language)Cell can be any alphanumeric value
Note: If this is mapped then the other long description field values will be ignored. 
<strong>Product description in html</strong>Product formatted long description.

Product Additional Groups

Mapping ValueValueE.g.Use
Additional Group ID'sComma separated string of existing product group ID's. This field updates the group connections - groups that have been added before and are not added here will be removed. 
Note: Should not be used together with the additional group names map.
10,25,27Use for products you want to add into multiple product groups. 
Additional Group NamesComma separated string of existing product group ID's. This field updates the group connections - groups that have been added before and are not added here will be removed. Groups that cannot be found with the name will also be newly created.
Note: Should not be used together with the additional group id's map.
GroupA,GroupB,GroupCUse for products you want to add into multiple product groups. 

Product Links

Mapping ValueValueE.g.Use
Cross-sell for product codeCode or codes (comma separated) of the products the link would be added toCODEABC1 or CODEABC1,CODEABC2

Used to attach related products to the main product.

POS and e-commerce function. 
In the POS, it will open a popup after the product is added to the cart, offering related products.
In e-commerce, it acts as a “Related Products” field.

Substitute for product codeCode or codes (comma separated) of the products the link would be added toCODEABC1 or CODEABC1,CODEABC2

Used to attach substitute products to the main product.

POS function.
If a product that is out of stock is added to the cart, the POS will open a popup offering substitute products.

Product Recipes

Mapping ValueValueE.g.Use
Bundle product codeCell can be any alphanumeric value
Code of the product that is the main bundle
ABC123

Use for if this product is part of a bundle. Attach this value to the column that has the code of the main bundle product.
Read more about this HERE.

Bundle product amountCell can be any numeric value
Amount of this product in the bundle
10Use to show how much of this product is in the bundle.
Assembly product codeCell can be any alphanumeric value
Code of the product that is the main assembly
ABC123

Use for if this product is part of an assembly. Attach this value to the column that has the code of the main assembly product.
Read more about this HERE.

Assembly product amountCell can be any numeric value
Amount of this product in the assembly
10Use to show how much of this product is in the assembly.

Product Status

Mapping ValueValueE.g.Use
Product is activeValue can be any of the following: 1, 0, true, false, yes, notrueUse to show if the product is active.
Product statusValue can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVEDACTIVEUse to show the status of the product.
Product show in webshopValue can be any of the following: 1, 0, true, false, yes, notrueUse to show whether the product is visibly in the webshop.

Product Origin and Grouping

Mapping ValueValueE.g.Use
Product country of origin codeCountry code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the)USUse to show the country of origin of the product.
Product brandCell can be any text valueBrand #1

Use to show the brand of the product.
Read more about this HERE.

Product familyCell can be any text valueFamily #1Use to show the family of the product.
Product supplier nameCell can be any text value
If there is more than one supplier that matches this name, a new one will be created
Supplier #1

Use to show the supplier of the product.
Read more about this HERE.

Product group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing groups - secondary language names will only be used when the group does not yet exist
Group #1

Use to show the group of the product.
Read more about this HERE.

Product category (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing categories - secondary language names will only be used when the category does not yet exist
Category #1

Use to show the category of the product.
Read more about this HERE.

Product priority group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing priority groups - secondary language names will only be used when the priority group does not yet exist
Priority #1

Use to show the priority group of the product.
Read more about this HERE.

Product country of origin name (Language)Cell can be any text value
Note: Value will be ignored when used together with product country of origin code field
EstoniaUse to show the country of origin of the product.

Product Pricing

Mapping ValueValueE.g.Use
Product net sales priceCell can be any numeric value
Note: When tax is not mapped, the account's first tax rate will be assigned (first one in the list of taxes)
10.5Price without tax. 
When mapped with product sales price with tax, the value in this field will be automatically calculated on import and any inputs here will be omitted
Product sales price with taxCell can be any numeric value12.5Price with tax. Requires product tax % to be mapped. 
Will automatically calculate and overwrite net sales price if it is also mapped.
Product costCell can be any numeric value5.5Use to note down the cost of the product.
Not used for inventory registrations in the import, for that use the Product inventory registration price mapping instead.
Product tax %Cell can be any numeric value 
Note: Can be written with or without the % character
20%Use to set the tax percentage of the product.
Product is tax free in all locationsValue can be any of the following: 1, 0, true, false, yes, notrueUse to show whether the product is tax-free everywhere.
Product price list price (Price list)Cell can be any numeric value
Note: When tax is not mapped, the account's first tax rate will be assigned (first one in the list of taxes)
20.25Price without tax. Cannot be used together with price list price with tax for the same price list.
Note: You can use up to 50 price lists in one import
Product price list price with tax (Price list)Cell can be any numeric value20.25Price with tax. Requires product tax % to be mapped. Cannot be used together with price list price for the same price list.
Note: You can use up to 50 price lists in one import

Product Measures

Mapping ValueValueE.g.Use
Product weightCell can be any numeric value20Use to set product weight, without packaging.
Product gross weightCell can be any numeric value20Use to set product weight, including packaging.
Product lengthCell can be any numeric value20Use to set product length.
Product heightCell can be any numeric value20Use to set product height.
Product widthCell can be any numeric value20Use to set product width.
Product volumeCell can be any numeric value20Use to set product volume, meaning how much of the unit is in the product.
Product unitCell can be any text valueCentimetersUse to set the unit the product is counted in.

Inventory

The importer uses the information mapped with these values to create an inventory registration.

Mapping ValueValueE.g.Use
Product reorder pointCell can be any numeric value20Used to set a reorder point for a product.
Product restock levelCell can be any numeric value20Used to set a restock level for a product.
Product inventory registration quantityCell can be any positive or negative numeric value. 0 is invalid20Used to import product amounts to the inventory registration act.
Product inventory registration priceCell can be any numeric value20.20Used to import a product's Inventory registration price to the inventory registration act.
Product reorder in multiples ofCell can be any numeric value20Used to set the minimum amount to this product that can be ordered.
Product location in warehouseCell can be any text valueAisle FWrite down where this product goes in a warehouse.
Note: Only one warehouse can be added here. If you require specific locations for more than one, look into WMS.
Product location in warehouse textCell can be any text valueNorth-side shelf, row 3Write down the description of where the product is.
Note: Only one warehouse can be added here. If you require specific locations for more than one, look into WMS.

Attributes

Mapping ValueValueE.g.Use
Int AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the full number value of the cell
25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Double AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the decimal value of the cell
25.25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Text AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the text value of the cell
MyValue

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Extra Fields

Mapping ValueValueE.g.Use
Extra field 1 codeString value. Code value.
If the value does not exist then it is created.
ExtraA

Add the value of Extra field 1.
Read more about this HERE.

Extra field 2 codeString value. Code value.
If the value does not exist then it is created.
ExtraB

Add the value of Extra field 2.
Read more about this HERE.

Extra field 3 codeString value. Code value.
If the value does not exist then it is created.
ExtraC

Add the value of Extra field 3.
Read more about this HERE.

Extra field 4 codeString value. Code value.
If the value does not exist then it is created.
ExtraD

Add the value of Extra field 4.
Read more about this HERE.

Product Packages

Mapping ValueValueE.g.Use
Box amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Box amount.
Box UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Box UPC on product.
Box net weightCell can be any numeric value20Used to add / update Box net weight.
Box gross weightCell can be any numeric value20Used to add / update Box gross weight.
Box lengthCell can be any numeric value20Used to add / update Box length.
Box widthCell can be any numeric value20Used to add / update Box width.
Box heightCell can be any numeric value20Used to add / update Box height.
Crate amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Crate amount.
Crate UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Crate UPC on product.
Crate net weightCell can be any numeric value20Used to add / update Crate net weight.
Crate gross weightCell can be any numeric value20Used to add / update Crate gross weight.
Crate lengthCell can be any numeric value20Used to add / update Crate length.
Crate widthCell can be any numeric value20Used to add / update Crate width.
Crate heightCell can be any numeric value20Used to add / update Crate height.
Pallet amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Pallet UPC on product.
Pallet UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Pallet UPC on product.
Pallet net weightCell can be any numeric value20Used to add / update Pallet net weight.
Pallet gross weightCell can be any numeric value20Used to add / update Pallet gross weight.
Pallet lengthCell can be any numeric value20Used to add / update Pallet length.
Pallet widthCell can be any numeric value20Used to add / update Pallet width.
Pallet heightCell can be any numeric value20Used to add / update Pallet height.

Matrix Products

Do note that in order to import matrix products correctly, your file has to have headers.

Matrix Product

Used only for the parent product.

Mapping ValueValueE.g.Use
Matrix IDID value is expected to be a valid whole number1Product ID is an internal ID given by Erply to the program. It's primary use is when working with API-s and it can be used to match existing products.
You cannot set a product ID yourself.
Matrix codeCell can be any alphanumeric valueabc123Product code is used to differentiate between products and match them to each other in the importer. This is the main code used for all products.
This has to be unique to the product.
Matrix UPC/EANCell can be any alphanumeric valueabc123The UPC/EAN is the code that goes on barcodes. It can be used to match existing products.
This has to be unique to the product.
Matrix code 3Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Matrix manufacturer codeCell can be any alphanumeric valueabc123Field can be used to add a code the manufacturer of the product uses to differentiate between products.
Product codes are used to differentiate between products and match them to each other in the importer. 
Matrix code 5Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Matrix code 6Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Matrix code 7Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Matrix code 8Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products.
Matrix net sales priceCell can be any numeric value
Note: When tax is not mapped, the account's first tax rate will be assigned (first one in the list of taxes)
10.5Price without tax. 
When mapped with product sales price with tax, the value in this field will be automatically calculated on import and any inputs here will be omitted
Matrix sales price with taxCell can be any numeric value12.5Price with tax. Requires product tax % to be mapped. 
Will automatically calculate and overwrite net sales price if it is also mapped.
Matrix costCell can be any numeric value5.5Use to note down the cost of the product.
Not used for inventory registrations in the import, for that use the Product inventory registration price mapping instead.
Matrix name (Language)Cell can be any alphanumeric valueProduct #1Product name.
Matrix description (Language)Cell can be any alphanumeric valueProduct #1 descriptionProduct description.
Matrix long description (Language)Cell can be any alphanumeric valueProduct #1 long descriptionProduct long decription.
Matrix long description (HTML) (Language)Cell can be any alphanumeric value
Note: If this is mapped then the other long description field values will be ignored. 
<strong>Product description in html</strong>Product formatted long description.

Matrix Attributes

Used only for the parent product.

Mapping ValueValueE.g.Use
Int AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the full number value of the cell
25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Double AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the decimal value of the cell
25.25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Text AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the text value of the cell
MyValue

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Matrix Extra Fields

Used only for the parent product.

Mapping ValueValueE.g.Use
Extra field 1 codeString value. Code value.
If the value does not exist then it is created.
ExtraA

Add the value of Extra field 1.
Read more about this HERE.

Extra field 2 codeString value. Code value.
If the value does not exist then it is created.
ExtraB

Add the value of Extra field 2.
Read more about this HERE.

Extra field 3 codeString value. Code value.
If the value does not exist then it is created.
ExtraC

Add the value of Extra field 3.
Read more about this HERE.

Extra field 4 codeString value. Code value.
If the value does not exist then it is created.
ExtraD

Add the value of Extra field 4.
Read more about this HERE.

Matrix & Variation Product

The Matrix & Variation fields set the value for both the main product and all of it's variations.

Mapping ValueValueE.g.Use
Matrix & Variation weightCell can be any numeric value20Use to set product weight, without packaging.
Matrix & Variation gross weightCell can be any numeric value20Use to set product weight, including packaging.
Matrix & Variation lengthCell can be any numeric value20Use to set product length.
Matrix & Variation heightCell can be any numeric value20Use to set product height.
Matrix & Variation widthCell can be any numeric value20Use to set product width.
Matrix & Variation volumeCell can be any numeric value20Use to set product volume, meaning how much of the unit is in the product.
Matrix & Variation is activeValue can be any of the following: 1, 0, true, false, yes, notrueUse to show if the product is active.
Matrix & Variation statusValue can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVEDACTIVEUse to show the status of the product.
Matrix & Variation show in webshopValue can be any of the following: 1, 0, true, false, yes, notrueUse to show whether the product is visibly in the webshop.
Matrix & Variation tax %Cell can be any numeric value 
Note: Can be written with or without the % character
20%Use to set the tax percentage of the product.
Matrix & Variation is tax free in all locationsValue can be any of the following: 1, 0, true, false, yes, notrueUse to show whether the product is tax-free everywhere.
Matrix & Variation non-stockValue can be any of the following: 1, 0, true, false, yes, notrue

This is used to show whether a product has stock or not. 
Read more about this HERE.

Matrix & Variation deposit fee amountCell can be any numeric value20Amount of deposit fee products attached to main product.
Matrix & Variation usual delivery timeCell can be any text value5 daysUsual delivery time. This is useful for quotes.
Matrix & Variation brandCell can be any text valueBrand #1

Use to show the brand of the product.
Read more about this HERE.

Matrix & Variation familyCell can be any text valueFamily #1Use to show the family of the product.
Matrix & Variation country of origin codeCountry code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the)USUse to show the country of origin of the product.
Matrix & Variation supplier nameCell can be any text value
If there is more than one supplier that matches this name, a new one will be created
Supplier #1

Use to show the supplier of the product.
Read more about this HERE.

Matrix & Variation unitCell can be any text valueCentimetersUse to set the unit the product is counted in.
Matrix & Variation manufacturerCell can be any text valueManufacturerManufacturer name.
Matrix & Variation deposit fee (code)Cell can be any text valueCodeAbcUsed to attach a deposit fee product to a regular product. The deposit fee product has to be configured earlier. 
This is used for tare and other similar items.
Matrix & Variation cashier must enter price in POSValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you want your cashier to set a price on.
Matrix & Variation location in warehouseCell can be any text valueAisle F

Write down where this product goes in a specific warehouse.
The importer uses the information mapped with these values to create an inventory registration.

Matrix & Variation location in warehouse textCell can be any text valueNorth-side shelf, row 3

Write down the description of where the product is.
The importer uses the information mapped with these values to create an inventory registration.

Matrix & Variation promotion discounts do not applyValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give discounts on.
Matrix & Variation does not grant customer reward pointsValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give reward points for.
Matrix & Variation non-refundableValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to be refundable.
Matrix & Variation Age restrictionAny interger value - 0 means the product is not age restricted18Use for products that have an age restriction, e.g. alcohol or nicotine.
Matrix & Variation has serial numbersValue can be any of the following: 1, 0, true, false, yes, notrue

Use for products that must have serial numbers.
Read more about this HERE

Matrix & Variation is sold in packagesValue can be any of the following: 1, 0, true, false, yes, notrueUse for products that are sold in packages at the POS.
Matrix & Variation description (English)Cell can be any alphanumeric valueProduct #1 descriptionProduct description.
Matrix & Variation long description (English)Cell can be any alphanumeric valueProduct #1 long descriptionProduct long decription.
Matrix & Variation long description (HTML) (English)Cell can be any alphanumeric value
Note: If this is mapped then the other long description field values will be ignored.
<strong>Product description in html</strong>Product formatted long description.
Dimension value code (Color)Cell can be any text value
Column name has to be the name of the dimension and can be any text value
redUse to match existing values. 
If an existing value is not found then it is created. 
Dimension value name (Color) (Language)Cell can be any text value
Column name has to be the name of the dimension and van be any text value
Note: Can only be used together with the dimension code mapping. 
Red ColorNot used to search for existing values. 
Can be used to update or set values name translations. 
Matrix & Variation group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing groups - secondary language names will only be used when the group does not yet exist
Group #1

Use to show the group of the product.
Read more about this HERE.

Matrix & Variation category (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing categories - secondary language names will only be used when the category does not yet exist
Category #1

Use to show the category of the product.
Read more about this HERE.

Matrix & Variation priority group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing priority groups - secondary language names will only be used when the priority group does not yet exist
Priority #1

Use to show the priority group of the product.
Read more about this HERE.

Matrix & Variation of origin country name (Language)Cell can be any text value
Note: Value will be ignored when used together with product country of origin code field
EstoniaUse to show the country of origin of the product.

Matrix & Variation Additional Groups

The Matrix & Variation fields set the value for both the main product and all of it's variations.

Mapping ValueValueE.g.Use
Matrix & Variation Additional Group ID'sComma separated string of existing product group ID's. This field updates the group connections - groups that have been added before and are not added here will be removed. 
Note: Should not be used together with the additional group names map.
10,25,27Use for products you want to add into multiple product groups. 
Matrix & Variation Additional Group NamesComma separated string of existing product group ID's. This field updates the group connections - groups that have been added before and are not added here will be removed. Groups that cannot be found with the name will also be newly created.
Note: Should not be used together with the additional group id's map.
GroupA,GroupB,GroupCUse for products you want to add into multiple product groups. 

Variation Product

Used only for the variation product.

Mapping ValueValueE.g.Use
Variation IDID value is expected to be a valid whole number1Product ID is an internal ID given by Erply to the program. It's primary use is when working with API-s and it can be used to match existing products.
You cannot set a product ID yourself.
Variation codeCell can be any alphanumeric valueabc123Product code is used to differentiate between products and match them to each other in the importer. This is the main code used for all products.
This has to be unique to the product.
Variation UPC/EANCell can be any alphanumeric valueabc123The UPC/EAN is the code that goes on barcodes. It can be used to match existing products.
This has to be unique to the product.
Variation code 3Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products
Variation manufacturer codeCell can be any alphanumeric valueabc123Field can be used to add a code the manufacturer of the product uses to differentiate between products.
Product codes are used to differentiate between products and match them to each other in the importer. 
Variation code 5Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products
Variation code 6Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products
Variation code 7Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products
Variation code 8Cell can be any alphanumeric valueabc123Product codes 3-8 are extra product code fields and can be used for whatever purpose required.
It can be used to match existing products
Variation net sales priceCell can be any numeric value
Note: When tax is not mapped, the account's first tax rate will be assigned (first one in the list of taxes)
10.5Price without tax. 
When mapped with product sales price with tax, the value in this field will be automatically calculated on import and any inputs here will be omitted
Variation sales price with taxCell can be any numeric value12.5Price with tax. Requires product tax % to be mapped. 
Will automatically calculate and overwrite net sales price if it is also mapped.
Variation costCell can be any numeric value5.5Use to note down the cost of the product.
Not used for inventory registrations in the import, for that use the Product inventory registration price mapping instead.
Variation weightCell can be any numeric value20Use to set product weight, without packaging.
Variation gross weightCell can be any numeric value20Use to set product weight, including packaging.
Variation lengthCell can be any numeric value20Use to set product length.
Variation heightCell can be any numeric value20Use to set product height.
Variation widthCell can be any numeric value20Use to set product width.
Variation volumeCell can be any numeric value20Use to set product volume, meaning how much of the unit is in the product.
Variation non-stockValue can be any of the following: 1, 0, true, false, yes, notrue

This is used to show whether a product has stock or not. 
Read more about this HERE.

Variation deposit fee amountCell can be any text valueCodeAbcUsed to attach a deposit fee product to a regular product. The deposit fee product has to be configured earlier. 
This is used for tare and other similar items.
Variation usual delivery timeCell can be any text value5 daysUsual delivery time. This is useful for quotes.
Variation is activeValue can be any of the following: 1, 0, true, false, yes, notrueUse to show if the product is active.
Variation statusValue can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVEDACTIVEUse to show the status of the product.
Variation show in webshopValue can be any of the following: 1, 0, true, false, yes, notrueUse to show whether the product is visibly in the webshop.
Variation reorder pointCell can be any numeric value20

Used to set a reorder point for a product.
The importer uses the information mapped with these values to create an inventory registration.

Variation restock levelCell can be any numeric value20

Used to set a reorder point for a product.
The importer uses the information mapped with these values to create an inventory registration.

Variation inventory registration quantityCell can be any positive or negative numeric value. 0 is invalid20

Used to set a reorder point for a product.
The importer uses the information mapped with these values to create an inventory registration.

Variation inventory registration priceCell can be any numeric value20.20

Used to set a reorder point for a product.
The importer uses the information mapped with these values to create an inventory registration.

Variation brandCell can be any text valueBrand #1

Use to show the brand of the product.
Read more about this HERE.

Variation familyCell can be any text valueFamily #1Use to show the family of the product.
Variation country of origin codeCountry code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the)USUse to show the country of origin of the product.
Variation supplier nameCell can be any text value
If there is more than one supplier that matches this name, a new one will be created
Supplier #1

Use to show the supplier of the product.
Read more about this HERE.

Variation unitCell can be any text valueCentimetersUse to set the unit the product is counted in.
Variation manufacturer nameCell can be any text valueManufacturerManufacturer name.
Variation deposit fee codeCell can be any text valueCodeAbcUsed to attach a deposit fee product to a regular product. The deposit fee product has to be configured earlier. 
This is used for tare and other similar items.
Variation cashier must enter price in POSValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you want your cashier to set a price on.
Variation is regular gift cardValue can be any of the following: 1, 0, true, false, yes, notrue

Use for regular gift cards.
Read more about this HERE.

Variation is serial numbered gift cardValue can be any of the following: 1, 0, true, false, yes, notrue

Use for serial numbered gift cards.
Read more about this HERE.

Variation location in warehouseCell can be any text valueAisle F

Write down where this product goes in a specific warehouse.
The importer uses the information mapped with these values to create an inventory registration.

Variation location in warehouse textCell can be any text valueNorth-side shelf, row 3

Write down the description of where the product is.
The importer uses the information mapped with these values to create an inventory registration.

Variation promotion discounts do not applyValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give discounts on.
Variation does not grant customer reward pointsValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to give reward points for.
Variation non-refundableValue can be any of the following: 1, 0, true, false, yes, notrueUse for products you do not want to be refundable.
Variation age restrictionAny interger value - 0 means the product is not age restricted18Use for products that have an age restriction, e.g. alcohol or nicotine.
Variation has serial numbersValue can be any of the following: 1, 0, true, false, yes, notrue

Use for products that must have serial numbers.
Read more about this HERE

Variation is sold in packagesValue can be any of the following: 1, 0, true, false, yes, notrueUse for products that are sold in packages at the POS.
Variation name (English)Cell can be any alphanumeric valueProduct #1Product name.
Variation description (English)Cell can be any alphanumeric valueProduct #1 descriptionProduct description.
Variation long description (English)Cell can be any alphanumeric valueProduct #1 long descriptionProduct long decription.
Variation long description (HTML) (English)Cell can be any alphanumeric value
Note: If this is mapped then the other long description field values will be ignored.
<strong>Product description in html</strong>Product formatted long description.
Variation price list price (Price list)Cell can be any numeric value
Note: When tax is not mapped, the account's first tax rate will be assigned (first one in the list of taxes)
20.25Price without tax. Cannot be used together with price list price with tax for the same price list.
Note: You can use up to 50 price lists in one import
Variation price list price with tax (Price list)Cell can be any numeric value20.25Price with tax. Requires product tax % to be mapped. Cannot be used together with price list price for the same price list.
Note: You can use up to 50 price lists in one import
Variation group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing groups - secondary language names will only be used when the group does not yet exist
Group #1

Use to show the group of the product.
Read more about this HERE.

Variation category (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing categories - secondary language names will only be used when the category does not yet exist
Category #1

Use to show the category of the product.
Read more about this HERE.

Variation priority group (Language)Cell can be any text value
Note: Only the default language name will be used to match with existing priority groups - secondary language names will only be used when the priority group does not yet exist
Priority #1

Use to show the priority group of the product.
Read more about this HERE.

Variation of origin country name (Language)Cell can be any text value
Note: Value will be ignored when used together with product country of origin code field
EstoniaUse to show the country of origin of the product.

Variation Links

Used only for the variation product.

Mapping ValueValueE.g.Use
Cross-sell for product codeCode or codes (comma separated) of the products the link would be added toCODEABC1 or CODEABC1,CODEABC2

Used to attach related products to the main product.

POS and e-commerce function. 
In the POS, it will open a popup after the product is added to the cart, offering related products.
In e-commerce, it acts as a “Related Products” field.

Substitute for product codeCode or codes (comma separated) of the products the link would be added toCODEABC1 or CODEABC1,CODEABC2

Used to attach substitute products to the main product.

POS function.
If a product that is out of stock is added to the cart, the POS will open a popup offering substitute products.

Variation Recipes

Used only for the variation product.

Mapping ValueValueE.g.Use
Bundle product codeCell can be any alphanumeric value
Code of the product that is the main bundle
ABC123

Use for if this product is part of a bundle. Attach this value to the column that has the code of the main bundle product.
Read more about this HERE.

Bundle product amountCell can be any numeric value
Amount of this product in the bundle
10Use to show how much of this product is in the bundle.
Assembly product codeCell can be any alphanumeric value
Code of the product that is the main assembly
ABC123

Use for if this product is part of an assembly. Attach this value to the column that has the code of the main assembly product.
Read more about this HERE.

Assembly product amountCell can be any numeric value
Amount of this product in the assembly
10Use to show how much of this product is in the assembly.

Variation Attributes

Used only for the variation product.

Mapping ValueValueE.g.Use
Variation Int AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the full number value of the cell
25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Variation Double AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the decimal value of the cell
25.25

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Variation Text AttributeCell can be any numeric value
Column name has to be the name of the attribute and value the text value of the cell
MyValue

Attribute name (column name) cannot contain whitespaces, special characters, and has a maximum length of 50.
Read more about this HERE.

Variation Extra Fields

Used only for the variation product.

Mapping ValueValueE.g.Use
Variation extra field 1 codeString value. Code value.
If the value does not exist then it is created.
ExtraA

Add the value of Extra field 1.
Read more about this HERE.

Variation extra field 2 codeString value. Code value.
If the value does not exist then it is created.
ExtraB

Add the value of Extra field 2.
Read more about this HERE.

Variation extra field 3 codeString value. Code value.
If the value does not exist then it is created.
ExtraC

Add the value of Extra field 3.
Read more about this HERE.

Variation extra field 4 codeString value. Code value.
If the value does not exist then it is created.
ExtraD

Add the value of Extra field 4.
Read more about this HERE.

Variation Packages

Used only for the variation product.

Mapping ValueValueE.g.Use
Box amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Box amount.
Box UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Box UPC on product.
Box net weightCell can be any numeric value20Used to add / update Box net weight.
Box gross weightCell can be any numeric value20Used to add / update Box gross weight.
Box lengthCell can be any numeric value20Used to add / update Box length.
Box widthCell can be any numeric value20Used to add / update Box width.
Box heightCell can be any numeric value20Used to add / update Box height.
Crate amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Crate amount.
Crate UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Crate UPC on product.
Crate net weightCell can be any numeric value20Used to add / update Crate net weight.
Crate gross weightCell can be any numeric value20Used to add / update Crate gross weight.
Crate lengthCell can be any numeric value20Used to add / update Crate length.
Crate widthCell can be any numeric value20Used to add / update Crate width.
Crate heightCell can be any numeric value20Used to add / update Crate height.
Pallet amountCell can be any numeric value
If a match is found, it will be updated (if UPC is not mapped then they are matched by category/amount), if not, a new row will be created. You can also import multiple rows of the same type, just make sure that any additional fields for the package are mapped after the amount column and before the next possible package amount column.
5Used to add / update Pallet UPC on product.
Pallet UPCCell can be any text value
If this is mapped, existing packages will be searched using UPC instead of amount. If there are multuple entries with the same UPC, only the first one will be updated.
CodeAUsed to add / update Pallet UPC on product.
Pallet net weightCell can be any numeric value20Used to add / update Pallet net weight.
Pallet gross weightCell can be any numeric value20Used to add / update Pallet gross weight.
Pallet lengthCell can be any numeric value20Used to add / update Pallet length.
Pallet widthCell can be any numeric value20Used to add / update Pallet width.
Pallet heightCell can be any numeric value20Used to add / update Pallet height.

Terms To Know

Alphanumeric - Often simply called 'text', this refers to data made up of letters (alphabet) and numbers (numeric). Usually symbols ($%^+@, etc.) and spaces are also allowed. These tell the computer that this is text data and not some special command.
Numeric - Numeric data simply means numbers.
Text - This refers to data made up of letters (alphabet) and numbers (numeric). Usually symbols ($%^+@, etc.) and spaces are also allowed. These tell the computer that this is text data and not some special command.