Product Parameters

Introduction

In order to be able to create many products parameters 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 parameters will be search in a sheet named Parameters.

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

  header	value format	mandatory
  Product ID	Text url compatible	Always
  Parameter ID	Text	Always
  Type	Text, should be one of the known parameter type. Refer to the utility sheet	On creation
  Editable	Text, should be one of the known Editable values. Refer to the utility sheet	No
  Parameter Translation Key	Text	No
  Default	Text	No
  Values	Text	No
  Value Translation Key	Text	No
  Magnitude	Text, should be one of the known Magnitude values. Refer to the utility sheet	No
  Allow any value	Boolean	No
  Tags	Text	No
  Freetags	Text	No

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.