skip to Main Content

To set up Product Import, go to Data Hub – Imports – Product. See

for more details. Here we explain the format of product export file.

Important note: if you changed the product import and some Scenarios, that would require the new/updated product data, make sure to publish the product import first and run it. Otherwise you might publish Scenario changes that will not have available new/updated product data.

File formats

Supported file formats are XML, CSV, JSON in encoding UTF-8.

Product fields

There are

  • Supported product fields are related to 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, like to sell products with higher margins more often). Examples of custom fields:
    • fields you need to display product card / what you need to pass to product HTML template
      • stickers like New, Action, Sale, Free Shipping,…
      • availability date like “Delivery by 24.12.”.
    • fields used in filtering, where value should be final value displayed to visitor
      • material: “stone”/”plastic”/”glass”,
      • collection: “MyArt”,…
      • season: “summer”, “winter”,…
      • … look at your custom filters you display in category list
    • fields used in recommendation algorithms and for decision making
      • to distinguish products with higher margins,…
      • compatibility restrictions … which memory cards are available with the device,…
      • manually selected product list for each product (manual alternatives/cross-sell to override automaticly selected alternative/cross-sell products)

How to prepare product import file

Typically, there are two ways how people implement product import file.

  • use product feed you already have, duplicate it and add extra fields you need to use in Persoo, i.e. start with Google Merchant Product feed, Heureka feed,… and in Persoo Administration select format with mapping from one format to persoo format. After sucessfully importing such data, start adding extra fields.
  • create your own product export from the scratch. Then refer to persoo product fields.

Examples of product feeds in various formats (with 1 product).

Recommendation: export all product fields you have in your product database. It’s easier to export all columns you have in your product DB at once, than to ask your developer to add fields one by one and wait for it.

You can even use your orignal field/column names. Persoo has rich options, how to rename, modify product fields,…(javascript preprocessing function). So you cannot make mistake if you export all raw product data with original field names.

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.

Important notes

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.

Back To Top
×Close search
Search