Welcome to WebmasterWorld Guest from 54.80.102.170

Forum Moderators: eljefe3 & skibum

Message Too Old, No Replies

Commission Junction API Script

     
11:51 am on Jun 3, 2015 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 28, 2003
posts: 489
votes: 1


Is there a script out there that I can license that utilizes the Commission Junction API to automatically download products from the Advertisers I'm signed up with? I just want to load their products into my own database on my server.
3:29 pm on June 3, 2015 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5774
votes: 132


You can have the product feeds download to your server automatically. Login to CJ then:
Account -> Subscriptions -> Create Product Export

You can have the feeds e-mailed to you, get or push FTP files, or get via HTTP. Once you have the data files, load into your DB.

I have several subscriptions setup, depending on how often the feeds are updated (some I get once/week, others daily, others hourly). I wrote some custom scripts to auotomagically unzip the files, import the data into a staging DB, then merge into the Production DB using just the fields I need.
8:50 pm on July 4, 2015 (gmt 0)

Preferred Member

10+ Year Member

joined:Apr 28, 2003
posts: 489
votes: 1


Yeah I guess thats probably better than downloading products through the CJ API since the API seems to constantly change and my script has to be modified all the time accordingly.

It would be nice to have a more automated way of syncing down the latest product info from CJ but when you have to spend tons of time writing and modifying scripts it defeats the purpose.

Maybe I'll try a script that imports the file instead of using the API. Thanks!