Dynamic Datafeeds

We have two types of datafeeds available for our affiliates through Pepperjam.  The first type you can find in the Pepperjam system.  These are easy to use and can be easily formatted with the Pepperjam storebuilder.  Carsten Cumbrowski has put together an excellent guide for how to use these datafeeds at http://www.cumbrowski.com/CarstenC/affiliatemarketing_datafeeds_pepperjamnetwork.asp.

For those who want something a bit more advanced, our dynamic datafeeds might be a good option.  Our dynamic datafeeds make it easy for you to promote specific types of products from your website. Download some simple code, customize it for your site, and you’ll never have to worry about updating your datafeeds again.  Our dynamic datafeeds are only available for affiliates partnered through Pepperjam, so if you’d like to use them, you’ll need to sign up for our programs on that network.  Find out more at http://www.hayneedleaffiliates.com/pepperjam-overview/.

Directions

We have stored all of our datafeeds from 160+ stores in a MySQL table for your use. In order to connect to the MySQL database on our server and display products from our datafeeds, your website must be located on a server that is PHP, ASP, or CF enabled. For any page of your website that you want to place datafeed content on, you must paste the correct code into that page.
You will need to modify two lines of code initially.

1. Change the table variable from the default “pj_adirondackchairs” to whatever store you want to pull data from (see complete list below).
2. Change “AFFID” to your own unique affiliate id.

PHP Code:

<?php
$login = “hnaffili_hnaffil”;
$password = “feedme”;
$table = “pj_adirondackchairs“;
$aid = “AFFID“;
$database = “hnaffili_datafeeds”;
$connection = mysql_connect(“datafeed.hayneedleaffiliates.com”,”$login”,”$passwor d”)
or die (“Unable to connect.”);
mysql_select_db($database)
or die (“Unable to open database.”);
$sql = “SELECT * FROM $table order by category”;
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result))
{
extract($row);
echo “<table width=’100%’ border=’0′ cellspacing=’0′ cellpadding=’3′> \n”;
echo “<tr>\n”;
echo “<td valign=’top’>\n<a href=’$prefix$aid$link‘> <img src=’$image’ border=0> </a> \n <br> <b> Price: </b> $$price\n </td> \n”;
echo “<td valign=’top’>\n<a href=’$prefix$aid$link‘> \n<b> $product </b> </a> \n<br> $description\n <br> <b> Item: </b> <i> $sku </i> \n <b> Category: </b> <i> $category </i> <br> </td>\n”;
echo “</tr>\n”;
echo “</table>\n”;
echo “<hr size=’1′>\n”;
}
mysql_close($connection);
?>

1. It is recommended that you first run the provided script to get a sense of the categories those products are broken down into.
2. Decide how you want to categorize the products on your site, and then modify the SQL query to pull only the products you want for each page.
3. Feel free to modify the layout of the table to suit your design tastes – the example above is just for introductory purposes – you’ll want to tweak it and make it your own (you will probably want to remove the category field, for example).

The more familiar you are with HTML, SQL, and at least one of the above languages, the more you can do with the script. The tables in the below right column should prove very helpful as well. If you are having problems, please contact us.