One of the basic data tables, Persoo needs to know to be able to provide product related features, are products. Regular product imports provide Persoo system with data like product names, prices, image links etc. These data are used by recommendation algorithms, decisions, for user segmentation and also in the Offers to display recommended products on the web site.
Generally, you can import any data table you need – products, categories, brands, articles, stores, pages,…
Here we look at the concept, which is the same for all data tables. But always, you can imagine data table items as products. See
- Getting Started: Importing Products … most basic setup
- User Guide: Imports … full explanation how to preprocess, process, run, test imports
Source file url
Provide URL with imput data … typically URL of your Google/Facebook/Heureka product feed. See examples of product feeds.
More over you can use Google Spreadsheet tables, which can be downloaded in CSV format. See how to use Google Spread Sheet as data import source.
Supported file formats are XML, CSV, JSON in encoding UTF-8.
For some formats, you must specify also item entity name, i.e. <item> for XML or delimeter for CSV.
Data table language
Each data table may contain text data. To provide a fulltext search engine, which can also use language tools, you need to specify the language of the table.
- Standartized product fields for tables products, categories, queries … where some fields ahs special meaning and functionality (but not all of them are required).
- Custom fields related to your product features or your internal tags (to be used in filters or internal to influence recommendation algorithms,…
All tables requires ID. Also there are standardized fields to be able to provide nice “titles”, links, images in targeting and in catalogue in Persoo administration.
- id (with the exception of table products, where we have itemID and itemGroupID instead)
From all fields cotained in the source, select those, you need to import and use. For each such a field, you must specify its data type, i.e. number, string, … See field data types.
Other import related notes
Passing on multiple values of the same field.
In the JSON format, pass an array of items (e.g. colors: [‘white’,’red’]). In an XML format, pass the same field multiple times. For example <colors><color>white</color><color>red</color></colors>.
In CSV import, use comma, and then process it into an array in Import processing.
Pay attention to the specifications of the feed fields, as any deviation will complicate the setup.
Make sure, that the values are identical to the values given by the site’s data layer, so they can be easily paired in our system.
We recommend consulting feed’s fields also with your personalization consultant and marketing representative, as these data directly impact what scenarios can be implemented.