Product Feed with multiple Categories that must be set (logical AND)

  • 12 August 2022
  • 2 replies

Badge +3

We would like to create a product feed / data feed, with products that have to include multiple categories. We can already create a feed, where one of the categories must be set (logical OR) through `Limit to specific categories`.


As an example, we would like to create a feed with all consoles, games and accessories in our `Nintendo Wii`, `Nintendo Gamecube` and `Gameboy` and Category. As of now we have to set:

  • Nintendo Wii - Games
  • Nintendo Wii - Consoles
  • Nintendo Wii - Accessories
  • Nintendo Gamecube - Games
  • Nintendo Gamecube - Consoles
  • Nintendo Gamecube - Accessories
  • Gameboy - Games
  • Gameboy - Consoles
  • Gameboy - Accessories

If we could `AND` categories like in Flows, this would shorten the list dramatically:

  • Categories
    • Games
    • Consoles
    • Accessories
  • AND
    • Nintendo Wii
    • Nintendo Gamecube 
    • Gameboy

We are planning to use 30-50 Categories in combination with 5  or more general Categories, so at the moment we would have to set 150-250 entries.


Best answer by alex.hong 12 August 2022, 22:28

View original

2 replies

Userlevel 7
Badge +58

Hi @Aram Becker,

Some info regarding catalog and product feeds. Klaviyo can sync custom catalog feeds that meet the following requirements:

  • The catalog is a public, hosted feed of all the items in your catalog

    • If you do not have your own feed hosting location, you can use a service such as Google Merchant feeds

  • The feed is in JSON or XML (example product feed files are attached to this message).

  • The data in the feed is only one node deep, not nested JSON or XML (unless it is hosted on Google Merchant Feeds).

  • The size of any one feed file should not exceed 100 MB; for optimal performance, we recommend each feed file not exceed 50 MB. If your file exceeds this amount, please split the feed into multiple files. All files used as sources will feed into the same catalog in Klaviyo.

  • Required fields must not be left blank. For unavailable numeric fields, pass a zero (0), and for unavailable text fields, pass something indicating this such as “n/a” or “unavailable”.

  • If your feed is hosted with a caching layer, disable caching for the location where the feed is hosted or refresh this cache when the feed is updated. Otherwise, Klaviyo will only pull updated data for the feed items after the cache is refreshed.

Here is our documentation to set this up. The process of setting up a custom product feed within Klaviyo, end-to-end, typically takes less than 30 minutes. 

As you read the attached documentation, please take note of the following:

  • The first step is to sync your custom catalog to Klaviyo; you will be asked to specify a URL to fetch products from. This custom catalog feed URL must be either an XML or JSON feed, and we only accept data 1 node deep (unless the feed is hosted by Google Merchant Feeds).

  • There are certain required fields for each catalog item, as well as some optional but recommended fields, so you can maximize the use of your catalog in Klaviyo. If you are setting this Catalog up for Back in Stock purposes, then you will need to use the $inventory_quantity field as described on Page 6 of the attached guide.

  • The size of any one feed file cannot exceed 100 MB. If the feed does exceed this amount, please split the feed into multiple files. For optimal performance, we recommend that each feed file does not exceed 50 MB. All separate files used as sources will feed into the same Catalog in Klaviyo.

  • If your catalog will have more than 1 million items, please let us know beforehand so that we can take some additional steps on our end to optimize for ingesting the larger feed.

Once you have synced your Catalog, then you will need to reach out to the Support team so they can configure your product mapping to enable the Product Feed feature within Email Templates (for using Product Blocks). If you want this Product Feed feature enabled, please also provide them with the name of the API metric within your account that you would like to use for personalized recommendations (this must be a single-item metric passed into Klaviyo via API, such as ‘Viewed Product’ or  ‘Ordered Product’).




Badge +3

@alex.hong That makes sens, I guess for more complicated feeds we will have to set up a Web feed ourselves