...
| Info |
|---|
As mentioned on the Prepare 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 yourselvesyourself with the excentos Workbench. If you have more complex feeds (e.g. web services or XML feed), please return to the Prepare the Product Data section or contact excentos support if you have any questions regarding your data - we'll help you getting cover any data feed requirements covered. |
Table of Contents:
| Table of Contents | ||
|---|---|---|
|
...
If you want to connect your product data directly yourselves to the Workbench, the product data CSV file needs to fulfill the following requirements (as mentioned above, please contact excentos for more complex feeds formats such as XML or JSON):
| Type / Field | Specification | ||
|---|---|---|---|
| File type | CSV file (preferred encoded as is UTF-8) | ||
| Field separator | Needs to be one of the following: ',' (comma), ';' (semi-colon), ':' (colon), '|' (pipe), tab or whitespace character. | ||
| Text separatordelimiter | Text cells have 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 that is used within the text separatorscells. Normally this is a '\' (backslash), to escape a single double quote, another single double quote can also be used. | ||
| Decimal separator | Has to be Default is a '.' (dot), e.g. '799.99'. All For comma separated decimals (e.g. '799,99') cannot be converted into numbers at the momentyou need to set the number format in the Workbench. | ||
| 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. with a comma; such as "black,blue"). Otherwise these two values will be interpreted as one value and cannot be split by using the "Multi valueValue" switch button in the data attribute table (see Upload your Product Data File, Multi Values).
| ||
| Units | Such as kilogram, currencies etc. should be in a separate field if the data field should is required to be interpreted as a number. (we've marked this as suggestion only because the unit is only required if it shall be displayed in the Product Guide. The unit is not technically required, except if prices are displayed in the result list because we then need to know the currency) |
| Info | ||
|---|---|---|
| ||
The field separator and text separatordelimiter 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). |
...
| Attribute Name | Required | Recommended | Remarks | Visible in Recommendation | ||
|---|---|---|---|---|---|---|
| id | X | - | Unique ID provided by the feedfor a single product
| - | ||
| 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 | | ||
| currency unit | (X) | Not strictly necessary, but cleaner. The currency can be directly included in the price attribute, too. | ||||
| status / available / online etc | (X) | If you can not restrict your product feed to products actually available, please provide a suitable filter attribute to excentos | ||||
| category | (X) | Having a category indicator for the product is often helpful. Please try to include the tree of parent categories (in a separate attribute if possible) | ||||
| Push factors / merchandising information | (X) | If you have information available that helps excentos to optimize the product listing for your business (such as margin, stock levels), include them. |
...