As mentioned on the Prepare your the Product Data page, this part of the documentation describes the requirementsthat your product data feed needs to fulfill in order to build Product Guides entirely yourselves with the excentos Workbench. Please return to the Prepare your the Product Data section if you have more complex feeds (e.g. web services or XML feed) or contact excentos support if you have any questions regarding your data.
...
| Type / Field | Specification | ||
|---|---|---|---|
| File type | CSV file (preferred encoded as UTF-8) | ||
| Field separator | Needs to be one of the following: ',' (comma), ';' (semi-colon), ':' (colon), '|' (pipe), tab or whitespace character. | ||
| Text separator | Coherent text has to be surrounded by " " (double quote) or ' ' (single quote). One of them at the beginning of a cell; one at the end of a cell. This is especially important if the text contains a specified field separator. | ||
| Escape character | The escape character is used within the text separators. Normally this is a '\' (backslash), to escape a single double quote another single double quote can also be used. | ||
| Decimal separator | Has to be a '.' (dot), e.g. '799.99'. All comma separated decimals (e.g. '799,99') cannot be converted into numbers at the moment. | ||
| Multiple values separator | If some attributes contain cells with more than one value in a cell (e.g. the attribute color with the values black and blue) these values need to be separated by a separator (e.g. a comma; result: "black,blue"). Otherwise these two values are always interpreted as one value and cannot be split by using the "Multi value" switch button in the data attribute table (see Upload your Product Data File, Multi Values).
| ||
| Units | Such as kilogram, currencies etc. need to be in a separate field if the data field should be interpreted as a number. |
...
| Info | ||
|---|---|---|
| ||
The field and text separator as well as the file type encoding and the escape character can be set during the uploading process of your product data file (local upload). |
| Anchor | ||||
|---|---|---|---|---|
|
...
| Note | ||
|---|---|---|
| ||
Despite that fixed naming convention it is fortunately possible to map the underlying attribute names to your product attribute naming schema (see Attribute Mapping). |
| Info | ||
|---|---|---|
| ||
|
The required and recommended data attributes and the name conventions for the data fields are:
| Attribute Name | Required | Recommended | Remarks | Visible in Recommendation | ||
|---|---|---|---|---|---|---|
| id | X | - | Unique ID provided by the feed
| - | ||
| name | (X) | X | Name of the product
|  | ||
| image | (X) | X | Product image URL, e.g. a URL to the product image on your website
| | ||
| price | - | X | Product price (dot-separated decimal number) | | ||
| manufacturer | - | X | Manufacturer or brand name | | ||
| detailUrl | - | X | URL to the product details page | | ||
| purchaseUrl | - | (X) | URL to shopping basket. We recommend to include it since the product recommendation can then directly perform a "add to basket" action without the user needing to visit the product details page first. However, this depends on the desired customer journey throughout your shop / website.
| | ||
| variantId | - | - | Master variant ID of a product. Useful if your product assortment contains e.g. color or size variants. excentos can collect them make sure only the master product is displayed in the product result list. | - | ||
| description | - | X | Product description text | |
| Info | ||
|---|---|---|
| ||
That means that the name 'price' and 'Price' will be recognized as two different attributes (with small and capital 'p'). Please make sure that all attributes are written correctly to match the required/recommended attributes above. Otherwise make sure that your own attribute names are mapped correctly. Else the corresponding information cannot be displayed or executed properly. |
...
For more information on possible data attributes and which data might help to even improve the Product Guide, please also check https://www.excentos.com/en/documentation/data-feed-requirements.
Read about the Template Data File and Example Data File to get started building your own Data File
...