Regular Products
Product Details
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Product ID | ID value is expected to be a valid whole number | 1 | Product 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 type | Value 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. |
| Product code | Cell can be any alphanumeric value | abc123 | Product 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/EAN | Cell can be any alphanumeric value | abc123 | The 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 3 | Cell can be any alphanumeric value | abc123 | Product 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 code | Cell can be any alphanumeric value | abc123 | Field 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 5 | Cell can be any alphanumeric value | abc123 | Product 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 6 | Cell can be any alphanumeric value | abc123 | Product 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 7 | Cell can be any alphanumeric value | abc123 | Product 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 8 | Cell can be any alphanumeric value | abc123 | Product 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 | Cell can be any text value | Manufacturer | Manufacturer name. |
| Non-stock product | Value can be any of the following: 1, 0, true, false, yes, no | true | This is used to show whether a product has stock or not. |
| Product usual delivery time | Cell can be any text value | 5 days | Usual delivery time. This is useful for quotes. |
| Product deposit fee code | Cell can be any text value | CodeAbc | Used 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 amount | Cell can be any numeric value | 20 | Amount of deposit fee products attached to main product. |
| Product cashier must enter price in POS | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you want your cashier to set a price on. |
| Product is regular gift card | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for regular gift cards. |
| Product is serial numbered gift card | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for serial numbered gift cards. |
| Product promotion discounts do not apply | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give discounts on. |
| Product does not grant customer reward points | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give reward points for. |
| Non-refundable product | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to be refundable. |
| Product age restriction | Any interger value - 0 means the product is not age restricted | 18 | Use for products that have an age restriction, e.g. alcohol or nicotine. |
| Product has serial numbers | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that must have serial numbers. |
| Product is sold in packages | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that are sold in packages at the POS. |
| Product name (Language) | Cell can be any alphanumeric value | Product #1 | Product name. |
| Product description (Language) | Cell can be any alphanumeric value | Product #1 description | Product description. |
| Product long description (Language) | Cell can be any alphanumeric value | Product #1 long description | Product 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Additional Group ID's | Comma 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,27 | Use for products you want to add into multiple product groups. |
| Additional Group Names | Comma 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,GroupC | Use for products you want to add into multiple product groups. |
Product Links
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Cross-sell for product code | Code or codes (comma separated) of the products the link would be added to | CODEABC1 or CODEABC1,CODEABC2 | Used to attach related products to the main product. POS and e-commerce function. |
| Substitute for product code | Code or codes (comma separated) of the products the link would be added to | CODEABC1 or CODEABC1,CODEABC2 | Used to attach substitute products to the main product. POS function. |
Product Recipes
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Bundle product code | Cell 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. |
| Bundle product amount | Cell can be any numeric value Amount of this product in the bundle | 10 | Use to show how much of this product is in the bundle. |
| Assembly product code | Cell 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. |
| Assembly product amount | Cell can be any numeric value Amount of this product in the assembly | 10 | Use to show how much of this product is in the assembly. |
Product Status
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Product is active | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show if the product is active. |
| Product status | Value can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVED | ACTIVE | Use to show the status of the product. |
| Product show in webshop | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show whether the product is visibly in the webshop. |
Product Origin and Grouping
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Product country of origin code | Country code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the) | US | Use to show the country of origin of the product. |
| Product brand | Cell can be any text value | Brand #1 | Use to show the brand of the product. |
| Product family | Cell can be any text value | Family #1 | Use to show the family of the product. |
| Product supplier name | Cell 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. |
| 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. |
| 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. |
| 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. |
| 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 | Estonia | Use to show the country of origin of the product. |
Product Pricing
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Product net sales price | 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) | 10.5 | Price 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 tax | Cell can be any numeric value | 12.5 | Price with tax. Requires product tax % to be mapped. Will automatically calculate and overwrite net sales price if it is also mapped. |
| Product cost | Cell can be any numeric value | 5.5 | Use 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 locations | Value can be any of the following: 1, 0, true, false, yes, no | true | Use 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.25 | Price 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 value | 20.25 | Price 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Product weight | Cell can be any numeric value | 20 | Use to set product weight, without packaging. |
| Product gross weight | Cell can be any numeric value | 20 | Use to set product weight, including packaging. |
| Product length | Cell can be any numeric value | 20 | Use to set product length. |
| Product height | Cell can be any numeric value | 20 | Use to set product height. |
| Product width | Cell can be any numeric value | 20 | Use to set product width. |
| Product volume | Cell can be any numeric value | 20 | Use to set product volume, meaning how much of the unit is in the product. |
| Product unit | Cell can be any text value | Centimeters | Use 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Product reorder point | Cell can be any numeric value | 20 | Used to set a reorder point for a product. |
| Product restock level | Cell can be any numeric value | 20 | Used to set a restock level for a product. |
| Product inventory registration quantity | Cell can be any positive or negative numeric value. 0 is invalid | 20 | Used to import product amounts to the inventory registration act. |
| Product inventory registration price | Cell can be any numeric value | 20.20 | Used to import a product's Inventory registration price to the inventory registration act. |
| Product reorder in multiples of | Cell can be any numeric value | 20 | Used to set the minimum amount to this product that can be ordered. |
| Product location in warehouse | Cell can be any text value | Aisle F | Write 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 text | Cell can be any text value | North-side shelf, row 3 | Write 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Int Attribute | Cell 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. |
| Double Attribute | Cell 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. |
| Text Attribute | Cell 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. |
Extra Fields
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Extra field 1 code | String value. Code value. If the value does not exist then it is created. | ExtraA | Add the value of Extra field 1. |
| Extra field 2 code | String value. Code value. If the value does not exist then it is created. | ExtraB | Add the value of Extra field 2. |
| Extra field 3 code | String value. Code value. If the value does not exist then it is created. | ExtraC | Add the value of Extra field 3. |
| Extra field 4 code | String value. Code value. If the value does not exist then it is created. | ExtraD | Add the value of Extra field 4. |
Product Packages
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Box amount | Cell 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. | 5 | Used to add / update Box amount. |
| Box UPC | Cell 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. | CodeA | Used to add / update Box UPC on product. |
| Box net weight | Cell can be any numeric value | 20 | Used to add / update Box net weight. |
| Box gross weight | Cell can be any numeric value | 20 | Used to add / update Box gross weight. |
| Box length | Cell can be any numeric value | 20 | Used to add / update Box length. |
| Box width | Cell can be any numeric value | 20 | Used to add / update Box width. |
| Box height | Cell can be any numeric value | 20 | Used to add / update Box height. |
| Crate amount | Cell 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. | 5 | Used to add / update Crate amount. |
| Crate UPC | Cell 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. | CodeA | Used to add / update Crate UPC on product. |
| Crate net weight | Cell can be any numeric value | 20 | Used to add / update Crate net weight. |
| Crate gross weight | Cell can be any numeric value | 20 | Used to add / update Crate gross weight. |
| Crate length | Cell can be any numeric value | 20 | Used to add / update Crate length. |
| Crate width | Cell can be any numeric value | 20 | Used to add / update Crate width. |
| Crate height | Cell can be any numeric value | 20 | Used to add / update Crate height. |
| Pallet amount | Cell 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. | 5 | Used to add / update Pallet UPC on product. |
| Pallet UPC | Cell 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. | CodeA | Used to add / update Pallet UPC on product. |
| Pallet net weight | Cell can be any numeric value | 20 | Used to add / update Pallet net weight. |
| Pallet gross weight | Cell can be any numeric value | 20 | Used to add / update Pallet gross weight. |
| Pallet length | Cell can be any numeric value | 20 | Used to add / update Pallet length. |
| Pallet width | Cell can be any numeric value | 20 | Used to add / update Pallet width. |
| Pallet height | Cell can be any numeric value | 20 | Used 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Matrix ID | ID value is expected to be a valid whole number | 1 | Product 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 code | Cell can be any alphanumeric value | abc123 | Product 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/EAN | Cell can be any alphanumeric value | abc123 | The 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 3 | Cell can be any alphanumeric value | abc123 | Product 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 code | Cell can be any alphanumeric value | abc123 | Field 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 5 | Cell can be any alphanumeric value | abc123 | Product 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 6 | Cell can be any alphanumeric value | abc123 | Product 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 7 | Cell can be any alphanumeric value | abc123 | Product 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 8 | Cell can be any alphanumeric value | abc123 | Product 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 price | 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) | 10.5 | Price 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 tax | Cell can be any numeric value | 12.5 | Price with tax. Requires product tax % to be mapped. Will automatically calculate and overwrite net sales price if it is also mapped. |
| Matrix cost | Cell can be any numeric value | 5.5 | Use 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 value | Product #1 | Product name. |
| Matrix description (Language) | Cell can be any alphanumeric value | Product #1 description | Product description. |
| Matrix long description (Language) | Cell can be any alphanumeric value | Product #1 long description | Product 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Int Attribute | Cell 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. |
| Double Attribute | Cell 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. |
| Text Attribute | Cell 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. |
Matrix Extra Fields
Used only for the parent product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Extra field 1 code | String value. Code value. If the value does not exist then it is created. | ExtraA | Add the value of Extra field 1. |
| Extra field 2 code | String value. Code value. If the value does not exist then it is created. | ExtraB | Add the value of Extra field 2. |
| Extra field 3 code | String value. Code value. If the value does not exist then it is created. | ExtraC | Add the value of Extra field 3. |
| Extra field 4 code | String value. Code value. If the value does not exist then it is created. | ExtraD | Add the value of Extra field 4. |
Matrix & Variation Product
The Matrix & Variation fields set the value for both the main product and all of it's variations.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Matrix & Variation weight | Cell can be any numeric value | 20 | Use to set product weight, without packaging. |
| Matrix & Variation gross weight | Cell can be any numeric value | 20 | Use to set product weight, including packaging. |
| Matrix & Variation length | Cell can be any numeric value | 20 | Use to set product length. |
| Matrix & Variation height | Cell can be any numeric value | 20 | Use to set product height. |
| Matrix & Variation width | Cell can be any numeric value | 20 | Use to set product width. |
| Matrix & Variation volume | Cell can be any numeric value | 20 | Use to set product volume, meaning how much of the unit is in the product. |
| Matrix & Variation is active | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show if the product is active. |
| Matrix & Variation status | Value can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVED | ACTIVE | Use to show the status of the product. |
| Matrix & Variation show in webshop | Value can be any of the following: 1, 0, true, false, yes, no | true | Use 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 locations | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show whether the product is tax-free everywhere. |
| Matrix & Variation non-stock | Value can be any of the following: 1, 0, true, false, yes, no | true | This is used to show whether a product has stock or not. |
| Matrix & Variation deposit fee amount | Cell can be any numeric value | 20 | Amount of deposit fee products attached to main product. |
| Matrix & Variation usual delivery time | Cell can be any text value | 5 days | Usual delivery time. This is useful for quotes. |
| Matrix & Variation brand | Cell can be any text value | Brand #1 | Use to show the brand of the product. |
| Matrix & Variation family | Cell can be any text value | Family #1 | Use to show the family of the product. |
| Matrix & Variation country of origin code | Country code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the) | US | Use to show the country of origin of the product. |
| Matrix & Variation supplier name | Cell 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. |
| Matrix & Variation unit | Cell can be any text value | Centimeters | Use to set the unit the product is counted in. |
| Matrix & Variation manufacturer | Cell can be any text value | Manufacturer | Manufacturer name. |
| Matrix & Variation deposit fee (code) | Cell can be any text value | CodeAbc | Used 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 POS | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you want your cashier to set a price on. |
| Matrix & Variation location in warehouse | Cell can be any text value | Aisle F | Write down where this product goes in a specific warehouse. |
| Matrix & Variation location in warehouse text | Cell can be any text value | North-side shelf, row 3 | Write down the description of where the product is. |
| Matrix & Variation promotion discounts do not apply | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give discounts on. |
| Matrix & Variation does not grant customer reward points | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give reward points for. |
| Matrix & Variation non-refundable | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to be refundable. |
| Matrix & Variation Age restriction | Any interger value - 0 means the product is not age restricted | 18 | Use for products that have an age restriction, e.g. alcohol or nicotine. |
| Matrix & Variation has serial numbers | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that must have serial numbers. |
| Matrix & Variation is sold in packages | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that are sold in packages at the POS. |
| Matrix & Variation description (English) | Cell can be any alphanumeric value | Product #1 description | Product description. |
| Matrix & Variation long description (English) | Cell can be any alphanumeric value | Product #1 long description | Product 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 | red | Use 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 Color | Not 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. |
| 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. |
| 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. |
| 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 | Estonia | Use 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 Value | Value | E.g. | Use |
|---|---|---|---|
| Matrix & Variation Additional Group ID's | Comma 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,27 | Use for products you want to add into multiple product groups. |
| Matrix & Variation Additional Group Names | Comma 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,GroupC | Use for products you want to add into multiple product groups. |
Variation Product
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Variation ID | ID value is expected to be a valid whole number | 1 | Product 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 code | Cell can be any alphanumeric value | abc123 | Product 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/EAN | Cell can be any alphanumeric value | abc123 | The 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 3 | Cell can be any alphanumeric value | abc123 | Product 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 code | Cell can be any alphanumeric value | abc123 | Field 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 5 | Cell can be any alphanumeric value | abc123 | Product 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 6 | Cell can be any alphanumeric value | abc123 | Product 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 7 | Cell can be any alphanumeric value | abc123 | Product 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 8 | Cell can be any alphanumeric value | abc123 | Product 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 price | 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) | 10.5 | Price 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 tax | Cell can be any numeric value | 12.5 | Price with tax. Requires product tax % to be mapped. Will automatically calculate and overwrite net sales price if it is also mapped. |
| Variation cost | Cell can be any numeric value | 5.5 | Use 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 weight | Cell can be any numeric value | 20 | Use to set product weight, without packaging. |
| Variation gross weight | Cell can be any numeric value | 20 | Use to set product weight, including packaging. |
| Variation length | Cell can be any numeric value | 20 | Use to set product length. |
| Variation height | Cell can be any numeric value | 20 | Use to set product height. |
| Variation width | Cell can be any numeric value | 20 | Use to set product width. |
| Variation volume | Cell can be any numeric value | 20 | Use to set product volume, meaning how much of the unit is in the product. |
| Variation non-stock | Value can be any of the following: 1, 0, true, false, yes, no | true | This is used to show whether a product has stock or not. |
| Variation deposit fee amount | Cell can be any text value | CodeAbc | Used 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 time | Cell can be any text value | 5 days | Usual delivery time. This is useful for quotes. |
| Variation is active | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show if the product is active. |
| Variation status | Value can be any of the following: ACTIVE, NO_LONGER_ACTIVE, NOT_FOR_SALE, ARCHIVED | ACTIVE | Use to show the status of the product. |
| Variation show in webshop | Value can be any of the following: 1, 0, true, false, yes, no | true | Use to show whether the product is visibly in the webshop. |
| Variation reorder point | Cell can be any numeric value | 20 | Used to set a reorder point for a product. |
| Variation restock level | Cell can be any numeric value | 20 | Used to set a reorder point for a product. |
| Variation inventory registration quantity | Cell can be any positive or negative numeric value. 0 is invalid | 20 | Used to set a reorder point for a product. |
| Variation inventory registration price | Cell can be any numeric value | 20.20 | Used to set a reorder point for a product. |
| Variation brand | Cell can be any text value | Brand #1 | Use to show the brand of the product. |
| Variation family | Cell can be any text value | Family #1 | Use to show the family of the product. |
| Variation country of origin code | Country code following ISO 3166 international standard. Alpha-2 code as EE-Estonia or US-United States of America (the) | US | Use to show the country of origin of the product. |
| Variation supplier name | Cell 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. |
| Variation unit | Cell can be any text value | Centimeters | Use to set the unit the product is counted in. |
| Variation manufacturer name | Cell can be any text value | Manufacturer | Manufacturer name. |
| Variation deposit fee code | Cell can be any text value | CodeAbc | Used 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 POS | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you want your cashier to set a price on. |
| Variation is regular gift card | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for regular gift cards. |
| Variation is serial numbered gift card | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for serial numbered gift cards. |
| Variation location in warehouse | Cell can be any text value | Aisle F | Write down where this product goes in a specific warehouse. |
| Variation location in warehouse text | Cell can be any text value | North-side shelf, row 3 | Write down the description of where the product is. |
| Variation promotion discounts do not apply | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give discounts on. |
| Variation does not grant customer reward points | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to give reward points for. |
| Variation non-refundable | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products you do not want to be refundable. |
| Variation age restriction | Any interger value - 0 means the product is not age restricted | 18 | Use for products that have an age restriction, e.g. alcohol or nicotine. |
| Variation has serial numbers | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that must have serial numbers. |
| Variation is sold in packages | Value can be any of the following: 1, 0, true, false, yes, no | true | Use for products that are sold in packages at the POS. |
| Variation name (English) | Cell can be any alphanumeric value | Product #1 | Product name. |
| Variation description (English) | Cell can be any alphanumeric value | Product #1 description | Product description. |
| Variation long description (English) | Cell can be any alphanumeric value | Product #1 long description | Product 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.25 | Price 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 value | 20.25 | Price 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. |
| 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. |
| 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. |
| 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 | Estonia | Use to show the country of origin of the product. |
Variation Links
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Cross-sell for product code | Code or codes (comma separated) of the products the link would be added to | CODEABC1 or CODEABC1,CODEABC2 | Used to attach related products to the main product. POS and e-commerce function. |
| Substitute for product code | Code or codes (comma separated) of the products the link would be added to | CODEABC1 or CODEABC1,CODEABC2 | Used to attach substitute products to the main product. POS function. |
Variation Recipes
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Bundle product code | Cell 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. |
| Bundle product amount | Cell can be any numeric value Amount of this product in the bundle | 10 | Use to show how much of this product is in the bundle. |
| Assembly product code | Cell 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. |
| Assembly product amount | Cell can be any numeric value Amount of this product in the assembly | 10 | Use to show how much of this product is in the assembly. |
Variation Attributes
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Variation Int Attribute | Cell 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. |
| Variation Double Attribute | Cell 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. |
| Variation Text Attribute | Cell 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. |
Variation Extra Fields
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Variation extra field 1 code | String value. Code value. If the value does not exist then it is created. | ExtraA | Add the value of Extra field 1. |
| Variation extra field 2 code | String value. Code value. If the value does not exist then it is created. | ExtraB | Add the value of Extra field 2. |
| Variation extra field 3 code | String value. Code value. If the value does not exist then it is created. | ExtraC | Add the value of Extra field 3. |
| Variation extra field 4 code | String value. Code value. If the value does not exist then it is created. | ExtraD | Add the value of Extra field 4. |
Variation Packages
Used only for the variation product.
| Mapping Value | Value | E.g. | Use |
|---|---|---|---|
| Box amount | Cell 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. | 5 | Used to add / update Box amount. |
| Box UPC | Cell 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. | CodeA | Used to add / update Box UPC on product. |
| Box net weight | Cell can be any numeric value | 20 | Used to add / update Box net weight. |
| Box gross weight | Cell can be any numeric value | 20 | Used to add / update Box gross weight. |
| Box length | Cell can be any numeric value | 20 | Used to add / update Box length. |
| Box width | Cell can be any numeric value | 20 | Used to add / update Box width. |
| Box height | Cell can be any numeric value | 20 | Used to add / update Box height. |
| Crate amount | Cell 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. | 5 | Used to add / update Crate amount. |
| Crate UPC | Cell 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. | CodeA | Used to add / update Crate UPC on product. |
| Crate net weight | Cell can be any numeric value | 20 | Used to add / update Crate net weight. |
| Crate gross weight | Cell can be any numeric value | 20 | Used to add / update Crate gross weight. |
| Crate length | Cell can be any numeric value | 20 | Used to add / update Crate length. |
| Crate width | Cell can be any numeric value | 20 | Used to add / update Crate width. |
| Crate height | Cell can be any numeric value | 20 | Used to add / update Crate height. |
| Pallet amount | Cell 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. | 5 | Used to add / update Pallet UPC on product. |
| Pallet UPC | Cell 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. | CodeA | Used to add / update Pallet UPC on product. |
| Pallet net weight | Cell can be any numeric value | 20 | Used to add / update Pallet net weight. |
| Pallet gross weight | Cell can be any numeric value | 20 | Used to add / update Pallet gross weight. |
| Pallet length | Cell can be any numeric value | 20 | Used to add / update Pallet length. |
| Pallet width | Cell can be any numeric value | 20 | Used to add / update Pallet width. |
| Pallet height | Cell can be any numeric value | 20 | Used 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.