Convert CSV Data Feeds To Wordpress Posts
Posted on October 29th, 2008 in Wordpress | 56 Comments »
Convert your Affiliate product data feeds into wordpress posts, creating perfect posts with Titles, Descriptions, Affiliate Links, Images and Prices. The tool will work with any, yes i said ANY! Affiliate data feeds, but for peace of mind I’ve used it with Commission Junction, Affiliate Future & Affiliate Window.
Installation
1. Unzip the downloaded file upcsv.zip
2. Upload the complete folder /upcsv/ to the following location http://www.yourblog.com/wp-admin/
3. Navigate to http://www.yourblog.com/wp-admin/upcsv/upload.php
4. Done!
Formatting
Every .csv file must contain a Title, Description, Image, Link and Price, formatted as shown below. I’ve used Neo Office to edit the data feed titles, “Title” obviously being the wordpress post title and so on.
Leave the price without the pound sign this is added in by the tool.
Edit the following code in upload.php to change the affiliate link button,
<a href=\”$row[link]\”><img src=\”http://www.matboo.co.uk/buynow.gif\” alt=\”Buy now\” /></a>”;
Download Below
CSV To Wordpress Post (4.01 KB)
Errors
You may come across some errors about file memory size these are usualy solved by removing excess fields from your csv file to decrease the upload size, e.g some affiliate data feeds come with other columns which arent needed like data, time - just delete these.
Your host might not support the file upload size of your data feed, to solve this you could ask for an increase or for example if your uploading 1,000 products cut 500 then repaste into another file and upload, usually this isnt a problem.
Example Post
Here is an example of a product from the data feed converted into a wordpress post.
You are free to edit the code and make modifications but you are not allowed to sell the tool and you must credit us with a link if you are going to release updated versions on your own site
Requirements
PHP 4.*
Wordpress