First, thanks for an awesome plugin.
We used it on our site willysmoke.com and have over 50 shortcodes in play.
We want to update the affiliate tag on these sites. So it is very time consuming to go through each code and update. So I was hoping we can update all the links in bulk from the back end.
I read through forum posts and learnt that the data is available in wp_options table with option name ‘shortcoder_data’.
I attempted to update the data there. The moment I touch anything there, the entire data in the shortcoder app is wiped out.
I rand a query like below and tested that the change in the value is exactly as intended. But the outcome on wordpress is not. Can you please help?
Query:
UPDATE wp_options
SET option_value
=REPLACE(option_value
,’amzn.to/2uuptqy’,’www.amazon.com/Victorinox-Fibrox-Chefs-Knife-8-Inch/dp/B008M5U1C2?&tag=willysmoke-20′)
WHERE option_name
=’shortcoder_data’