Advanced Ads Groups & Rotations IDs

  • Resolved Antonio Calvosa

    (@fuzzfaced)


    2 months ago

    Hi,

    I recently migrated my website to a new hosting and domain, moving from
    http[:]//fuzzfacedbeta.altervista.org to http[:]//fuzzfaced.it.
    The site is currently under redesign and development.

    After the migration, I noticed that all Advanced Ads Groups & Rotations IDs have changed. For example, a group I previously used (named “Header Desktop: Below the Header”) had ID 145, and now the same group has ID 404.

    Because of this, all ads stopped displaying on the site. To fix the issue, I would need to manually update the group IDs on every page, which is not practical due to the number of pages involved.

    My question is:
    Is there a way in WordPress or Advanced Ads to remap, update, or redirect Groups & Rotations IDs globally after a domain/hosting migration?
    Alternatively, is there a recommended approach to restore ads without manually editing each page?

    Any advice or similar experiences would be greatly appreciated.
    Thanks in advance!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support ahmeddr

    (@ahmeddr)

    2 months ago

    Hi @fuzzfaced ,

    Thanks for reaching out!

    I am sorry to hear about this issue you are facing!

    Unfortunately, I can’t think about a way to automatically change and remap the post Ids (the ads) directly in the database.

    The most practical solution is to first map each old ID to its new corresponding ID in document for example, and then perform a bulk replacement across the database.

    This can be done safely using a plugin like Better Search Replace, replacing occurrences of the old group IDs with the new ones (for example, replacing the shortcode of the ad with id=”145″ with the shortcode of the ad with id=”404″). This is what i would recommend.

    Alternatively, if you’re comfortable working directly in the database, you can run a targeted SQL search-and-replace query to update all affected entries in bulk. The same logic as i just explained, just using SQL instead of the Better search replace plugin.

    Please ensure to make a backup before performing the replacement.

    Have a great day!

    Best regards,

    Thread Starter Antonio Calvosa

    (@fuzzfaced)

    2 months ago

    Thank for your quick reply,

    All the best!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.