Sign in

Any way to bulk change the links in all existing posts by adding affiliate ID?

Forum › General Inquiry

  • This topic has 4 replies, 3 voices, and was last updated 1 year, 8 months ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • March 12, 2022 at 7:54 am #7050
    Avatar photoleo

    Hi,

    Is there any way to bulk change the links in all existing posts by adding my Amazon Associates ID or other affiliate ID so to make them referral links and thus we can monetize our website?

    Of course we can do this one by one manually, but it will be very tedious and even crazy if we need to change hundreds posts. So hoping to have a better way to do so.

    Thanks!

    Leo

    March 12, 2022 at 1:01 pm #7052
    Avatar photoprivii

    One thing that comes to mind is opening the db.sqlite in the input folder of your site using something like DB Browser for SQLite and running a SQL query to replace the links.

    March 12, 2022 at 1:51 pm #7053
    Avatar photogpsblues

    Hi,

    SQLiteStudio or similar and run SQL Queries.

    March 12, 2022 at 1:53 pm #7054
    Avatar photoleo

    Yes I tried and it worked! Thank you privii!

    March 12, 2022 at 1:55 pm #7055
    Avatar photoleo

    privii and gpsblues, great thanks to both of you 😀

  • Author
    Posts
Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.