Product Mapping

Introduction

In order to be able to create many products mapping with the minimum amount of time, we have include an excel import feature that will allow you to prepare you product to create or to update in an excel.

Process

In order to be imported, the excel should follow some rules:

• Products mapping will be search in a sheet named Mappings.

• Headers are formatted and should be in one of those:

  header	value format	mandatory
  Product ID	Text url compatible	Always
  Mapping Index	Number	No
  Result	Text	No
  Priority	Number	No
  Parameter	Text	No
  Comparative	Text	No
  Value	Text	No
  Logical Operator	Text	No
  Parenthesis	Text	No

For this import, the columns Parameter, Comparative, Value can be repeated separated by a Logical Operator column and surrounded by Parenthesis column. It should allow you to construct complex mapping condition.

Example of a complexe mapping:

Excel:

Product:

written condition: width = 400 AND box IN Chair-HR_bryoCont20241007_085834AM,OLD_PUBLICATION_MATERIAL_Carpet_bryoCont20241007_091013AM AND ( width = 400 OR depth = 370 )

The template is available to be downloaded when clicking to the DOWNLOAD IMPORT TEMPLATE and then check the product:

Then click on DOWNLOAD

Once you have filled your excel with the data you want to import, you can now drop it into the drag and drop location ( you can also click and search your file through the explorer)

A preview of what will be imported is shown :

In this table, you are able to have a last look at your data before uploading them for real. A validation is done in order to minimize the possible webservice error after launching the import. If an issue is found on a line, an error icon appears at the beginning of the line. More information is shown when hovering the error icon.

in this example, we can see that the first id does not follow an url valid pattern. The error icon is therefore present, and the user is warn of what error is present.

If a line is on error, you will not be able to click on launch import.

When launching the import, a success icon appears on the lines that are really imported. Also, if an issue happened when calling the webservice, the error icon will appear. Hovering it will show you the webservice error. If an error icon appears after launching the import, it means that the line was not imported.