How to update Affiliate Link using SQL query

  • Ankurpreet
    Ankurpreet
    Newbie 44 points
    September 6, 2015 at 4:54 pm

    Hi All

    I was not working on my website for over a year due to some issues. Now when i am back, i noticed that lot of urls have become irrelevant and i want to update them. e.g I wish to update ‘Affiliate Link’ of all deals of Amazon store to something in one go from cpanel of my Hostgator account. Can anyone help me with the SQL query since i am not able to understand the table structure.

    Regards
    Ankur

  • Hemanta Chakladar
    Hemanta Chakladar
    Super Guru 1,710 points
    September 6, 2015 at 7:44 pm

    you can easily do this by any csv import using the coupon ID

  • Ankurpreet
    Ankurpreet
    Newbie 44 points
    September 14, 2015 at 4:03 pm

    Hemanta, can you please guide me finding the right tool. I am having a hard time. I tried few but they added new posts instead of updating existing ones.

  • Ankurpreet
    Ankurpreet
    Newbie 44 points
    September 14, 2015 at 6:19 pm

    I tried going to CouponPress > Tools and exported all my posts. I dont see any ‘ID’ field in the extracted data. So just to test, i deleted all records except one, modified its ‘LINK’ and uploaded again. It added a new post. I want it to update my existing post.

    The only think i want to update is that for a particular store (with 100s of posts), i want to update its LINK to one common url in one go.

Viewing 4 posts - 1 through 4 (of 4 total)

New Business Themes for WordPress 2020

Start your new website today!

View Business Themes