Results 1 to 5 of 5
  1. #1
    PHP/mySQL-based affiliate data feed parsing script?
    I'm somewhat new to the Affiliate marketing game. I'm looking for a free script that will import a data feed from an affiliate program into a mySQL database and then using PHP parse the data into an online "store" which allows visitors to browse/search by category or brand. Any suggestions?

    I have an affiliate in mind that I'd like to try this with. They provide a feed as a CSV file and it consists of only about 14 fields (product category, item name description, image URL, buy link URL, etc.). The buy link includes the CJ domain in the URL so this would be through Commission Junction. I would like something flexible enough to be able to add additional vendors (other networks or custom) if I can.

    My PHP skills are somewhat weak which is why I'm looking for a prebuilt script. I'm okay at modifying existing code to get it to look the way I want, but I'm lost when starting from the ground up. Any thoughts?

  2. #2
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    I suggest trying OS commerce. It's not built for affiliate datafeeds, but I'm sure with some tweaking you can make it work. I've seen it done before. To me, that's the closest thing you'll find to what you're describing. People won't let that kind of system go for free or for even a modest amount if it works well.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  3. #3
    Lone Ranger muddyboots's Avatar
    Join Date
    March 11th, 2005
    Location
    Asheville, NC
    Posts
    219
    Lightbulb
    There are two different but related components to deal with. The establishment and update of the MySQL DB and the script to do the searches that become the browse/search capability.

    If you use something like PHP/MyAdmin (free) to maintain your MySQL database you can define a table that matches your datafeed and upload it directly. There's a limit of about 2MB for the file upload size but there are several work-arounds. One is to break the file into pieces. Another is to eliminate unnecessary data elements (columns) to reduce the size of the upload file. Perhaps the best is to write a PHP script (coming next) to read a txt file and write to the MySQL DB table.

    I suggest looking over a simple PHP/MySQL tutorial. There's a simple free one available at Free Webmaster Help that I used. It gives very useful examples.

    Once you try setting up the DB and do a simple search script/test things will probably begin to fall into place.

    Good luck.

  4. #4
    Newbie
    Join Date
    January 18th, 2005
    Location
    Chandigarh, India
    Posts
    20
    I think the better idea is to build the PHP interface around your mysql database.

  5. #5
    Newbie
    Join Date
    May 19th, 2005
    Posts
    15
    Quote Originally Posted by AlpineZone
    I'm somewhat new to the Affiliate marketing game. I'm looking for a free script that will import a data feed from an affiliate program into a mySQL database and then using PHP parse the data into an online "store" which allows visitors to browse/search by category or brand. Any suggestions?
    Not free but worth the time savings:
    http://www.phpmill.com/feedparser/

    It leaves the store making part up to you but it takes the hassle out of getting the data feed into the database.

  6. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Parsing XML using php simplexml_load_file()
    By Uncle Rico in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: November 24th, 2008, 07:28 AM
  2. data feeds and SID/Member ID/u1 tracking using php/mysql
    By scattdaddy21 in forum Programming / Datafeeds / Tools
    Replies: 0
    Last Post: July 22nd, 2004, 07:26 PM
  3. Need help with a PHP/MySql Jump Script
    By dak142 in forum Programming / Datafeeds / Tools
    Replies: 11
    Last Post: April 13th, 2004, 07:29 PM
  4. Best to use - Web Merge or another PHP/MySQL script
    By aprillougheed in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: February 13th, 2004, 06:43 PM
  5. convert data feed with php/mysql
    By cowox in forum Programming / Datafeeds / Tools
    Replies: 20
    Last Post: November 27th, 2002, 07:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •