I recently took over administration of a web site run on Zencart, which I am very familiar with.

The last genius who ran this site copy/pasted a section of text into every product description for about 1700 products, which included information that could change over time.

It has changed...

Now I need to replace a repeating block of text in 1700 product descriptions with the new block of text.

Please tell me I can do this somehow without manually editing every product. Maybe go into the database itself and do some sort of replace command in an editor?