Skip to main content

Product

Introduction​

In order to be able to create many products 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.

warning

Partial import are not fully supported. This will be fix but in the meantime for update be sure to have an excel with all the data of your products. Field that we know can be erased with a partial update:

  • manufacturer
  • Commercial Informations

Process​

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

Products will be search in a sheet named Products. Headers are formatted and should be in one of those:

headervalue formatmandatory
IDText url compatibleAlways
ReferenceTextOn creation
Product TypeText, should be one of the known product type. Refer to the utility sheetOn creation
BrandText, should be one of the known brand. Refer to the utility sheetOn creation
ManufacturerTextNo
Parent Product IDTextNo
Start DateDate, MM/DD/YYYYNo
End DateDate, MM/DD/YYYYNo
Search ScoreNumber >= 0No
Name (en-GB)Text, the locale between parenthesis precise the locale in which the column will fill the valueNo
Commercial Description (en-GB)Text, the locale between parenthesis precise the locale in which the column will fill the valueNo
Short Description (en-GB)Text, the locale between parenthesis precise the locale in which the column will fill the valueNo
Website URL (en-GB)Text, the locale between parenthesis precise the locale in which the column will fill the valueNo
PriceNumberNo
Price CurrencyText, should be one of the known currencies. Refer to the utility sheetNo
Price TypeText, can be one of the known price type. Refer to the utility sheetNo
Price Start DateDate, MM/DD/YYYYNo
Price End DateDate, MM/DD/YYYYNo
Price Additional InformationsText of a json. fields can be found here: setup pricingNo
Pricing MethodText, can be one of the known pricing Method. Refer to the utility sheetNo
Pack AmountNumberNo
PercentageNumberNo
Direction ParameterText, should be width or height or depthNo
Direction ParametersText, should be one of the known Direction Parameters. Refer to the utility sheetNo
Rounding MethodText, should be one of the known Rounding Method. Refer to the utility sheetNo
Not Priced On Front EdgeBooleanNo
Model 3DText url. Should be a valid url.No
Model 2DText url. Should be a valid url.No
ThumbnailText url. Should be a valid url.No
MediaText url. Should be a valid url. Can be several urls, they should be separated with a spaceNo
Style TagsText, should be one or more of the known Style Tags. Refer to the utility sheet. If more that one, they should be separated with ;No
Room TagsText, should be one or more of the known Room Tags. Refer to the utility sheet. If more that one, they should be separated with ;No
Color TagText, should be one of the known Color Tag. Refer to the utility sheetNo
Material TagsText, should be one or more of the known Material Tags. Refer to the utility sheet. If more that one, they should be separated with ;No
Free TagsText, should be one or more of the known Free Tags. Refer to the utility sheet. If more that one, they should be separated with ;No
Target PositionText, should be one of the known Target Position. Refer to the utility sheetNo
Opening ShapeText, should be one of the known Opening Shape. Refer to the utility sheetNo
Default AltitudeNumber > 0No
Manip ModeText, should be one of the known Opening Shape. Refer to the utility sheetNo
UngroupableBooleanNo
Allow CollisionBooleanNo
ModularBooleanNo
ReplaceableBooleanNo
CodeTextNo
Code ManufacturerTextNo
Configurator IdText, should be one of the known Configurator Id. Refer to the utility sheetNo
Configuration DataTextNo
ForceBooleanNo

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.