Best Amazon Affiliate ID Manager for WordPress? Fix hard coded IDs

Discussion in 'Amazon' started by MTUser2010, Apr 24, 2012.

0
  1. #1
    I've bought a few Amazon sites that have affilate IDs hard coded into images and webpages. Is there a good WP plugin to change them to your ID?

    I am aware of this free plugin, Amazon Link Localizer: http://wordpress.org/extend/plugins/amazon-affiliate-link-localizer/ But it makes money by putting the author's affiliate ID in when you don't have one for the country the click comes from. I'd rather pay to get something that changes them all to my ID.
     
    MTUser2010, Apr 24, 2012 IP
  2. onlinebu

    onlinebu Greenhorn

    Messages:
    27
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #2
    If it was me I would do it manually. I know it takes time, but then you are sure to get it right. If you download the data base you can use search and replace.
     
    onlinebu, Apr 24, 2012 IP
  3. blacknet

    blacknet Active Member

    Messages:
    709
    Likes Received:
    16
    Best Answers:
    2
    Trophy Points:
    70
    #3
    I can think of a good way to do it ....
     
    blacknet, Apr 25, 2012 IP
  4. freshdevelopment

    freshdevelopment Notable Member

    Messages:
    1,303
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    240
    #4
    You could easily construct an SQL statement to do it.. something like

    UPDATE wp_posts SET content = REPLACE(content, 'oldid-20', 'newid-20');

    You can run this on phpMyAdmin

    WARNING: this is off the top of my head, you need to make sure it is on the correct fields etc. Also make sure you backup before doing anything like this.
     
    freshdevelopment, Apr 28, 2012 IP