Tutorial: How to implement product feed (WIP)

Here, we will provide some general guidelines on product feeds and how it can be implemented as part of the data model in CDP

Pre-requisites

The client should provide a link to their product feed. It is usually a xml, html, or csv file with important information about their products. Here are the important fields that a product feed must have to fulfill a majority of our use cases.

Field	Description
Product ID	The ID of the product, also referred to the SKU sometimes. Ensure that the Product ID matches with the product IDs from other sources of data (Purchase, cart events from Meiro Events, transactions from their POS database etc)
Product Name	Name of the product
URL	The link to the product's page of the website
Image URL	A publicly accessable link to the image of the product. The link usually ends with .jpg .jpeg or .png The product image is often attached to emails or other activation mediums.

Here are some useful but not necessary fields in a product feed. They are useful for specific use cases.

Field	Description
Price	Price of the product Useful in cases where you want to notify customers of a price drop
In Stock	Flag that says if the product is in stock Useful in cases where you want to notify a customer that a product is back in stock

Where to store your product feed

Your product feed should live in the external_data schema of the CDP

How to parse your product feed

If your product feed is in csv, you can use Pandas package with our Python processor to format the product feed.

if your product feed is in xml/html, you can use BeautifulSoup package with our Python processor to parse and format the product feed. Here is an example script we have used to parse a product feed. Remember that the product feed source can vary from client to client and you will have to change the script accordingly to parse the feed.