Results 1 to 5 of 5
May 23rd, 2005, 10:35 AM #1PHP/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?
May 23rd, 2005, 10:46 AM #2
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.
- ScottHatred stirs up strife, But love covers all transgressions.
May 23rd, 2005, 12:51 PM #3
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.
June 9th, 2005, 02:08 AM #4
- Join Date
- January 18th, 2005
- Chandigarh, India
I think the better idea is to build the PHP interface around your mysql database.
June 17th, 2005, 07:02 PM #5
Originally Posted by AlpineZone
- Join Date
- May 19th, 2005
It leaves the store making part up to you but it takes the hassle out of getting the data feed into the database.
By Uncle Rico in forum Programming / Datafeeds / ToolsReplies: 2Last Post: November 24th, 2008, 07:28 AM
By scattdaddy21 in forum Programming / Datafeeds / ToolsReplies: 0Last Post: July 22nd, 2004, 07:26 PM
By dak142 in forum Programming / Datafeeds / ToolsReplies: 11Last Post: April 13th, 2004, 07:29 PM
By aprillougheed in forum Programming / Datafeeds / ToolsReplies: 1Last Post: February 13th, 2004, 06:43 PM
By cowox in forum Programming / Datafeeds / ToolsReplies: 20Last Post: November 27th, 2002, 07:41 PM