The feeds that we have covered so far have been Google Merchant Centre, and related feeds that are very closely modelled on this format (e.g. Facebook/ Instagram ads, Pinterest), this feed format is more bespoke in terms of header names and some elements but still there is lots of overlap.

If you cloning an already built Google Merchant Centre feed, or starting from scratch ..please note, Affiliate Window require .csv format, with the following characters as accepted delimiters, comma, semi-colon or pipe. Ensure that you edit the new feeds settings in line with these requirements.

Column Header Labels & Descriptions

image_url

Link to main image (e.g. https://cdn.example.com/abc/123_main.png)

mandatory

deep_link

Link to product results page (e.g. https://www.example.com/prod/widget/red)

mandatory

product_id

Unique reference for the product (e.g. 123ABC)

mandatory

product_name

Merchants product name (e.g. Baltimore Jeans)

mandatory

price

Sale price (e.g. 159.99)

mandatory

rrp_price

Recommended Retail Price (e.g. 250.00)

recommended

alternate_image

Link to a second product image (e.g. https://cdn.example.com/abc/123_2.png)

optional

alternate_image_two

Link to a third product image (e.g. https://cdn.example.com/abc/123_3.png)

optional

alternate_image_three

Link to a third product image (e.g. https://cdn.example.com/abc/123_4.png)

optional

alternate_image_four

Link to a third product image (e.g. https://cdn.example.com/abc/123_5.png)

optional

average_rating

Average review star rating score (e.g. 4.5)

optional

basket_link

Link url to a pre-filled customer basket (e.g. https://www.example.com/cart?prod=123abc)

optional

brand_name

Name of the brand name (e.g. Levis)

recommended

colour

Colour of the product (e.g. Ochre)

recommended

condition

Condition of the product (e.g. New)

recommended

currency

ISO 4217 code (e.g. GBP)

recommended

custom1 (+ custom2-9)

Additional fields used as needed (e.g. Bestseller)

recommended

delivery_cost

Shipping cost for the product (e.g. 3.49)

recommended

delivery_time

Estimated delivery time and unit, usually defined in days. (e.g. 3-5 working days)

recommended

delivery_weight

Weight of the product for delivery purposes, with unit (e.g. 4kg)

recommended

description

Product description long text provided by the merchant, no html

recommended

dimensions

Dimensions, usually supplied as length x width x height (e.g. 140 x 70 x 50 cm)

optional

product_GTIN (also can use ean)

Product barcode (Global Trade Item Number, European Article Number), values are not validated by AWIN (e.g. 5019998887771)

recommended

in_stock

Preferred method is to use value of 1 for in stock and 0 for out of stock (e.g. 1)

recommended

language

Language of the product data as ISO 639-1 code (e.g. en_GB)

recommended

merchant_category

The merchants main category definition (e.g. Fitness Equipment)

recommended

merchant_category_path

The merchants product hierachy path (e.g. Fitness Equipment > Free Weights > Dumbell Sets)

optional

google_taxonomy

Google merchant centre category definition (e.g. Apparel & Accessories > Clothing Accessories > Sunglasses)

optional

model_number

Manufacturer model number (e.g. SHDTV-199)

recommended

mpn

Manufacturer Part Number (e.g. FILT-099-088)

recommended

stock_quantity

Product stock available to buy (e.g. 258)

recommended

Help Documentation from Affiliate Window

For a longer more in-depth read on data specifications required – here are links to the help guides provided by Affiliate Window themselves

Product Feed Guide for Advertisers

Building an AWIN product feed

Feed Column Descriptions (pdf document)