NewsMAN products feed

In order to create newsletters with ecommerce blocks (with products) or ecommerce automations (such as abandoned cart or product review flow), you need to generate a CSV feed that returns certain information of these products.

Feed requirements

The feed must be accessible online, feed url example: https://mywebsite.com/feed.csv. The product information in this feed should update in the shortest interval possible or should be retrieved in real time.

Feed header

"product id","product name","product url","image url","stock","price","sale price","brand","category","description"

Field	Compulsory	Description
product id	Yes	Product id
product name	Yes	Product name
product url	Yes	Full url of the product. For example: https://mywebsite.com/my-product
image url	Yes	Image src full form. For example: https://mywebsite.com/images/product-image.jpg.
stock	Yes	Quantity in stock of the product. If there is no quantity there can be used 1 or 0.
price	Yes	The regular price of the product, for example 49.99.
sale price	Yes	Sale price of the product with decimals. For example 45.99. If the product has no sale price, it will be used the regular price of the product.
brand	Yes	Product manufacturer.
category	Yes	Main category of the product.
description	Yes	Product description.

CSV feed example

"product id","product name","product url","image url","stock","price","sale price","brand","category","description"
"101","Red dress","https://mywebsite.com/dresses/red-dress","https://mywebsite.com/images/red-dress.jpg","3","655.00","455.00","Local brand","Dresses","Dresses","Red dress from Local brand"
"102","Slim fit jeans","https://mywebsite.com/jeans/slim-fit-jeans","https://mywebsite.com/images/slim-fit-jeans.jpg","18","355.00","355.00","Local brand","Jeans","Slim fit jeans from Local brand"
"103","Black jeans","https://mywebsite.com/jeans/black-jeans","https://mywebsite.com/images/black-jeans.jpg","12","385.00","300.00","Local brand","Jeans","Black jeans from Local brand"
"104","Blue jeans","https://mywebsite.com/jeans/blue-jeans","https://mywebsite.com/images/blue-jeans.jpg","15","385.00","300.00","Local brand","Jeans","Blue jeans from Local brand"
"105","Red tshirt","https://mywebsite.com/tshirts/red-tshirt","https://mywebsite.com/images/red-tshirt.jpg","14","155.00","155.00","Local brand","Tshirts","Red tshirt from Local brand"
"106","Green tshirt","https://mywebsite.com/tshirts/green-tshirt","https://mywebsite.com/images/green-tshirt.jpg","11","155.00","155.00","Local brand","Tshirts","Green tshirt from Local brand"
"107","Yellow tshirt","https://mywebsite.com/tshirts/yellow-tshirt","https://mywebsite.com/images/yellow-tshirt.jpg","17","155.00","155.00","Local brand","Tshirts","Yellow tshirt from Local brand"
"108","Black jacket","https://mywebsite.com/jackets/black-jacket","https://mywebsite.com/images/black-jacket.jpg","2","830.00","830.00","Local brand","Jackets","Black jacket from Local brand"
"109","Green jacket","https://mywebsite.com/jackets/green-jacket","https://mywebsite.com/images/green-jacket.jpg","4","830.00","830.00","Local brand","Jackets","Green jacket from Local brand"

Here you can download a file example.

Set feed in NewsMAN interface

After creating the feed, go to Settings -> Feeds in the NewsMAN admin interface, tap Add Feed, insert the feed URL, select NewsMAN CSV as Feed Type, then save. More details about adding the feed can be found here.