Hi,
We have the same delivery information in each products description. The delivery times have recently changed so we need to change it a little.
Rather than editing each product one by one is there an SQL query that could be used to bulk edit the whole lot at once?
i.e change 'Next Working Day' to '3-5 Working Days'
Any help on this would be greatly appreciated as it could us save loads of time!
Thanks
Never worked with sql queries before but after a bit of googling i worked it out to be
UPDATE `oc_product_description`
SET `description` = REPLACE(`description`,'Next Working Day','2-5 Working Days')
Solved
UPDATE `oc_product_description`
SET `description` = REPLACE(`description`,'Next Working Day','2-5 Working Days')
Solved

Who is online
Users browsing this forum: No registered users and 17 guests