Commision Junction MySQL scrapers

Discussion in 'Commission Junction' started by brandondrury, May 6, 2007.

  1. #1
    Hello,

    I'm sick of the horrid script known as the CJ Datafeed.

    I'd greatly prefer to scrape X content out of CJ and put it into my own MySQL database.

    Does anyone have any recommendations?

    I've considered writing such a script, but I've never written a scraper before.

    Brandon
     
    brandondrury, May 6, 2007 IP
  2. jazz7620

    jazz7620 Banned

    Messages:
    357
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I wrote some php programs that I use to get the datafeed into my mysql database and then display them on pages.

    The CJ sends me datafeed everyweek and it is painful to re-run the same thing everyweek.

    I also do some customization (as the advertiser's categories sometimes are clobbered)..!! So I need to break them into cat -> subcat...!!

    You can checkout one of my sites (design is not good), where I parsed the datafeed from superjewelers.

    The site is http://jewelry.usadealsclub.com/ [Admin, I can remove the url from here, if it is considered spam]

    I would say, if u can find a cj scraper, please post here as we may all want that. I currently have a painful way of achieving the same thing to some extent.

    I am planning to sell (or license) the scripts at some later time..may be after June when it is more stable...!!
     
    jazz7620, May 6, 2007 IP
  3. Micromag

    Micromag Well-Known Member

    Messages:
    1,757
    Likes Received:
    67
    Best Answers:
    0
    Trophy Points:
    165
    #3
    Sorry going a bit off-topic here:

    jazz, your site has some flaw: I clicked BUY button for "14k White Gold 1/4ct Diamond Pave Set Ring" (just to see what happens), so I saw the coupon 10% off discount tip - but when I it went to superJeweler site, the cart was empty :confused:

    maybe you're loosing some sales there.

    I went back (to your site) and clicked buy again and now the cart was updated with 2 blank items (no description, $0.00 price) - looks like it is showing the cart before add the item and after all added a blank item.
     
    Micromag, May 6, 2007 IP
  4. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #4
    check mine laptop battery, I have srape... CJ Websevices too.

    to jazz7620, make hidden your buyUrl...avoid from from Googlebot, that your site is affilite site purpose.
     
    pogung177, May 6, 2007 IP
  5. jazz7620

    jazz7620 Banned

    Messages:
    357
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi Micromag, I think the product that you clicked might have expired / discontinued..I have not updated the database in a while...one drawback when using the datafeed (which comes every week)...!!

    Hi pogung177, Could you please explain? What do u mean be hiding the buyUrl? and how will it affect googlebot?
    Please share if you know the trick.
     
    jazz7620, May 6, 2007 IP
  6. Micromag

    Micromag Well-Known Member

    Messages:
    1,757
    Likes Received:
    67
    Best Answers:
    0
    Trophy Points:
    165
    #6
    Why?


    ........
     
    Micromag, May 6, 2007 IP
  7. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #7
    Micromag & jazz7620,
    By hidden your buyUrl, it will avoid your page to supplemetal result on google.
    I have CJ site have indexed over 60k pages on Google by hidden all CJ url with redirect. Make sure the redirect links set to "nofollow."
     
    pogung177, May 6, 2007 IP
  8. Micromag

    Micromag Well-Known Member

    Messages:
    1,757
    Likes Received:
    67
    Best Answers:
    0
    Trophy Points:
    165
    #8
    No, your page is added to supplemental result when:

    • You link to orphan pages (you link to pages that no one links) or your pages are orphan.
    • You have copied content from another page (duplicated content)
    • Have same title for all pages on your site or have meta tag problems

    There is no relation with supplemental result and using affiliate link on your site.
     
    Micromag, May 6, 2007 IP
  9. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #9
    pogung177, May 6, 2007 IP
  10. brandondrury

    brandondrury Peon

    Messages:
    375
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #10
    I read the blog. I don't see anything about using datafeed URLs. He was speaking of a site that had NOTHING but affiliate content.

    Of course, if a site has NOTHING but affiliate content, that is not going to be new or incredibly useful to users.

    I guess it doesn't hurt to be careful.

    Awesome. I may start developing something like this soon, but let me know when you get your script finished.

    Brandon
     
    brandondrury, May 7, 2007 IP
  11. Luke Jones

    Luke Jones Peon

    Messages:
    427
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Hello,
    Can your script scrape any CJ product/merchant?
     
    Luke Jones, Aug 18, 2007 IP
  12. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #12

    I'm not scape at all, just generate using CJ Webservices
     
    pogung177, Aug 18, 2007 IP
  13. Luke Jones

    Luke Jones Peon

    Messages:
    427
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Can it be used for any product/merchant?
    Is this more lucrative than ebay?
     
    Luke Jones, Aug 18, 2007 IP
  14. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #14
    in any merchants which provide product catalog...
     
    pogung177, Aug 18, 2007 IP
  15. Luke Jones

    Luke Jones Peon

    Messages:
    427
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #15
    So is it more lucrative than ebay?
     
    Luke Jones, Aug 18, 2007 IP
  16. albertalbs

    albertalbs Active Member

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    56
    #16
    I like this forum. Lot of reviews for affiliate marketing.
     
    albertalbs, Aug 18, 2007 IP
  17. pogung177

    pogung177 Well-Known Member

    Messages:
    415
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #17
    I dont think so, but you can access Ebay products via their API.
    I have ever try it, with rss format so you only need Ebay API account to access.
    A lot of sample script on Google
     
    pogung177, Aug 18, 2007 IP