Affiliates using our raw datafeed file solution should take note that we now support a feature called alternative datafeed download types. Specifically, it is now possible to append a parameter to your datafeed download URL and trigger the retrieval of an entirely different set of information from what you normally download. There are two alternative types available at present: pricing and variants.
By appending “&type=pricing” to your datafeed download URL, you will receive all available pricing history (price changes) for the products normally listed in your datafeed. For instance, a datafeed configured for Eddie Bauer might have a normal download URL such as:
http://datafeed.avantlink.com/download_feed.php?id=72037&auth=abc344652b48ww7cc9a30e0f5de089999
(note this URL is just for demonstration and does not resolve to an actual datafeed download)
Using a modified URL of:
http://datafeed.avantlink.com/download_feed.php?id=72037&auth=abc344652b48ww7cc9a30e0f5de089999&type=pricing
might yield data such as:
"Product SKU","Date","Retail Price","Sale Price"
"17064","2011-08-31 05:04:14","6.50","6.50"
"17326","2011-08-31 05:04:14","44.50","44.50"
"17326","2011-10-04 04:00:18","59.95","59.95"
"17327","2011-08-31 05:04:14","44.50","44.50"
If instead you append “&type=variants” to your datafeed download URL, then you will retrieve all product variations, e.g. size, color, etc. using the “Variants XML” field (if it is populated – not all merchants supply this information) for the products listed in your datafeed. Affiliates who have looked at or worked with the “Variants XML” field previously may find this option simpler to use since the data has been “expanded” from a single XML snippet to a fully-parsed data set. As an example, using the same Eddie Bauer datafeed download link mentioned above, but modifying it for variants information:
http://datafeed.avantlink.com/download_feed.php?id=72037&auth=abc344652b48ww7cc9a30e0f5de089999&type=variants
results in data such as the following:
"Product SKU","sku","upc","vendor_sku","size","color","style","retail_price","sale_price"
"17064","752680","","17064","ONESZE","Nautical Blue","","6.50","6.50"
"17064","767559","","17064","ONESZE","Medium Heather Gray","","6.50","6.50"
"17326","105678","","17326","L","Black","","59.95","59.95"
"17326","105680","","17326","M","Black","","59.95","59.95"
"17326","105682","","17326","S","Black","","59.95","59.95"
In both cases the alternative download will contain a “Product SKU” field which you can use to match up to the “SKU” field of records in your normal datafeed download. Additionally, the file format (CSV, tab-delimited text, or XML) and compression options (gzip, zip, or no compression) for alternative downloads will be as specified in your datafeed configuration.
Keep in mind you don’t need to change anything with regard to your datafeed subscriptions – you need only append this new “type” parameter to the datafeed download URL if you want to utilize one of these alternative datafeed downloads.
-David Clark
AvantLink.com
Recent Comments