Download
We're evolving to serve you better! This current forum has transitioned to read-only mode. For new discussions, support, and engagement, we've moved to GitHub Discussions.

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

  • #7050
    Avatar photo[anonymous]

    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

    #7052
    Avatar photo[anonymous]

    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.

    #7053
    Avatar photo[anonymous]

    Hi,

    SQLiteStudio or similar and run SQL Queries.

    #7054
    Avatar photo[anonymous]

    Yes I tried and it worked! Thank you privii!

    #7055
    Avatar photo[anonymous]

    privii and gpsblues, great thanks to both of you 😀