Versions Compared

Old Version 5

changes.mady.by.user Sören Zach

Saved on

compared with

New Version 6

changes.mady.by.user Julius Höfler

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

As mentioned on the Prepare your 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 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.


Table of Contents:

Table of Contents
maxLevel2

...

Type / FieldSpecification
File typeCSV file (preferred encoded as UTF-8)
Field separatorNeeds to be one of the following: ',' (comma), ';' (semi-colon), ':' (colon), '|' (pipe), tab or white space whitespace character.
Text separatorCoherent 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 operatorseparator.
Escape characterThe 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 separatorHas 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

',' (comma);

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).

Info

You can change the global Multiple values separator anytime as well as the local separator (for each attribute separately) in the Product Data view.


Unitssuch Such as kilogram, currencies etc. need to be in a separate field if the data field should be interpreted as a number.


Info
titleHint

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
RequiredFileds
RequiredFileds
Required Fields and Their Names

...

  • The "Required" attributes in the table below are the minimal set of data that every Product Guide needs to work properly.
  • The "Recommended" attributesare technically optional, but we recommend you using them in order to display certain information like the product name or price in the product recommendation card.


Note
titleAttribute Mapping

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
titleHint

(lightbulb) If you build up your product data from scratch, the easiest way to fulfill the data requirements is to start with the Template Data File.


The required and recommended data fieldsattributes and the name conventions for the data fields are:

Attribute Name
in Product Data
RequiredRecommendedRemarksVisible in Recommendation
id

X

-

Unique ID provided by the feed

Info

If your feed does not contain that kind of information, an internal generic id is created to distinguish all products. This internal id is not visible in the data or the Workbench at all.



name

(X)

-

Product name

(warning) Note: The

Name of the product

Info

The name is not technically required, but makes it a lot easier for you and the end-users to identify products in the result list.


(tick)
image

(X)

-

Product image URL,

i

e.

e

g. a URL

on each

to the product

's (warning) Note: The

image

on your website

Info

The

image is not technically required, but makes it a lot easier for you and the end-users to identify products in the result list.


(tick)
price

 -

XProduct price (dot-separated decimal number)(tick)
manufacturer

 -

XManufacturer or brand name(tick)
detailUrl

 -

XURL to the product details page(tick)
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.

(warning) Note:
Note

This feature has to be supported by your website and furthermore implemented for your individual requirements.


(tick)
variantId

 -

-Master variant ID of a product. Useful if your product assortment contains e.g. color or size variants
and
. excentos can
then filter down the result list to
collect them make sure only the master product is displayed in the product result list.-
description-XProduct description text(tick)


(info) Note: All attribute names are case sensitive. 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 below are written correctly. Otherwise the corresponding information cannot be displayed or executed.

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

...