If you are automating a Product feed, please consider that we are able to retrieve a feed via HTTP(S), SFTP, or FTP. If you choose to use method, please ensure you whitelist our office and server locations, a Technical Services representative can provide this information on request.
Supported Columns
The below tables give the XML field names which should be used in your XML feed and their mapping to the columns in the publisher download and CSV upload.
All product data feeds may use these fields. *signifies a required field
+-----------------------+-----------------------+
| xmlFieldName |CSV Documentation Name |
+-----------------------+-----------------------+
| pid* | product_id |
| category | merchant_category |
| price* | price |
| brand | brand_name |
| upc | upc |
| ean | ean |
| mpn | mpn |
| isbn | isbn |
| modelno | model_number |
| name* | product_name |
| desc* | description |
| spec | specifications |
| promotext | promotional_text |
| lang | language |
| purl* | deep_link |
| thumburl | merchant_thumb |
| imgurl* | image_url |
| deltime | delivery_time |
| validfrom | valid_from |
| validto | valid_to |
| currency | currency |
| delcost | delivery_cost |
| weboffer | web_offer |
| preorder | pre_order |
| instock | in_stock |
| stockquant | stock_quantity |
| forsale | is_for_sale |
| warranty | warranty |
| condition | condition |
| ptype | product_type |
| parentpid | parent_product_id |
| cg | commission_group |
| lastupdated | last_updated |
| dimensions | dimensions |
| colour | colour |
| keywords | keywords |
| custom1 | custom1 |
| custom2 | custom2 |
| custom3 | custom3 |
| custom4 | custom4 |
| custom5 | custom5 |
| saving | saving |
| delivery_restrictions | delivery_restrictions |
| reviews | reviews |
| average_rating | average_rating |
| rating | rating |
| alternate_image | alternate_image |
| large_image | large_image |
| basket_link | basket_link |
+-----------------------+-----------------------+
fashion:
Specific columns for the 'Fashion' vertical.
+--------------+--------------------+
| xmlFieldName |CSV Name |
+--------------+--------------------+
| suitable_for | suitable_for |
| size | size |
| material | material |
| pattern | pattern |
| swatch | swatch |
+--------------+--------------------+
tickets:
Specific columns for the 'Tickets' vertical.
+----------------+--------------------+
| xmlFieldName | CSV Name |
+----------------+--------------------+
| primary_artist | primary_artist |
| second_artist | second_artist |
| event_date | event_date |
| event_name | event_name |
| venue_name | venue_name |
| venue_address | venue_address |
| available_from | available_from |
| genre | genre |
| min_price | min_price |
| max_price | max_price |
| longitude | longitude |
| latitude | latitude |
+----------------+--------------------+
travel:
Specific columns for the 'Travel' vertical.
+---------------------+---------------------+
| xmlFieldName | CSV Name |
+---------------------+---------------------+
| location | location |
| check_in_date | check_in_date |
| check_in_time | check_in_time |
| check_out_date | check_out_date |
| duration | duration |
| guests_per_room | guests_per_room |
| hotel_name | hotel_name |
| hotel_address | hotel_address |
| hotel_stars | hotel_stars |
| hotel_features | hotel_features |
| child_policy | child_policy |
| room_type | room_type |
| room_description | room_description |
| availability | availability |
| board_basis | board_basis |
| longitude | longitude |
| latitude | latitude |
| departure_code | departure_code |
| arrival_code | arrival_code |
| departure_date | departure_date |
| return_date | return_date |
| inbound_duration | inbound_duration |
| starting_from_price | starting_from_price |
| check_out_time | check_out_time |
| ticket_type | ticket_type |
| cancellation_policy | cancellation_policy |
| room_amenities | room_amenities |
+---------------------+---------------------+
groupbuy:
Specific columns for the 'Group Buying' vertical.
+-----------------+--------------------+
| xmlFieldName | CSV Name |
+-----------------+--------------------+
| event_city | event_city |
| event_address | event_address |
| number_sessions | number_sessions |
| terms | terms |
| number_sold | number_sold |
| min_required | min_required |
| supplier | supplier |
| group_latitude | group_latitude |
| group_longitude | group_longitude |
| deal_start | deal_start |
| deal_end | deal_end |
+-----------------+--------------------+
telco:
Specific columns for the 'Telco' vertical.
+------------------+--------------------+
| xmlFieldName | CSV Name |
+------------------+--------------------+
| contract_type | contract_type |
| term | term |
| initial_cost | initial_cost |
| month_cost | month_cost |
| gift | gift |
| inc_minutes | inc_minutes |
| inc_data | inc_data |
| connectivity | connectivity |
| inc_texts | inc_texts |
| tariff | tariff |
| storage_size | storage_size |
| special_offer | special_offer |
| network | network |
| operating_system | operating_system |
+------------------+--------------------+XML product data feed
We recommend providing the product data for single offers as a CSV file, as experience has shown this to be less error-prone. For automatic import of the article list via xml file, we recommend using the Awin XML labels (see previous section).
XML Scheme:
<products><product>…</product></products>Our XML format is also described in the Awin Product Data Feed DTD 1.4.
Note:
For Google Shopping feed XML files in the Google Shopping feed format (using Google labels instead of Awin XML feed labels), a feed import script adjustment is required. Alternatively, use the Awin feed API (based on the Google Shopping feed format).
Example:
<products>
<product>
<pid>Z187552zGDNst2b</pid>
<name>example single offer abc123</name>
<purl>https://shop-advertiserdomain.com/product/37f2c197a930?utm_source=awin&utm_medium=affiliate&utm_campaign=product-data-feed&utm_content=product-ads&utm_term=!!!productid!!!</purl>
<price>99.00</price>
<delcost>9.00</delcost>
<currency>EUR</currency>
<brand>examplebrandname</brand>
<category>examplecategoryname</category>
<colour>beige</colour>
<condition>new or refurbished</condition>
<deltime>7-12 days</deltime>
<desc>this product offer is the best, because...</desc>
<lang>EN</lang>
<basket_link>https://shop-advertiserdomain.com/product/37f2c197a930?add-to-cart=1&utm_source=awin&utm_medium=affiliate&utm_campaign=product-data-feed&utm_content=product-ads&utm_term=!!!productid!!!</basket_link>
<instock>1</instock>
<weboffer>1</weboffer>
<forsale>1</forsale>
<imgurl>https://images.cdn....com/...v0-middle.jpg</imgurl>
<thumburl>https://images.cdn....com/...v0-very-small-preview.jpg</thumburl>
<large_image>https://images.cdn....com/...v0-large.jpg</large_image>
<alternate_image>
https://images.cdn....com/...v1.jpg</alternate_image>
<modelno>ABC-387V3a</modelno>
</product>
<products>