Sign in

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

  • 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
  • #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

    #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.

    #7053
    Avatar photogpsblues

    Hi,

    SQLiteStudio or similar and run SQL Queries.

    #7054
    Avatar photoleo

    Yes I tried and it worked! Thank you privii!

    #7055
    Avatar photoleo

    privii and gpsblues, great thanks to both of you 😀

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