I was not working on my website for over a year due to some issues. Now when i am back, i noticed that lot of urls have become irrelevant and i want to update them. e.g I wish to update ‘Affiliate Link’ of all deals of Amazon store to something in one go from cpanel of my Hostgator account. Can anyone help me with the SQL query since i am not able to understand the table structure.
you can easily do this by any csv import using the coupon ID
Hemanta, can you please guide me finding the right tool. I am having a hard time. I tried few but they added new posts instead of updating existing ones.
I tried going to CouponPress > Tools and exported all my posts. I dont see any ‘ID’ field in the extracted data. So just to test, i deleted all records except one, modified its ‘LINK’ and uploaded again. It added a new post. I want it to update my existing post.
The only think i want to update is that for a particular store (with 100s of posts), i want to update its LINK to one common url in one go.
Start your new website today!