Hi,

After a little advice regarding a "global" search and replace approach - so imagaine a client is rebranding and changing thier name.

The original string appears in 000's of CMS and Commerce pages and is also published in Find and needs to be replaced.

Possible options:

1. Purely manual - hire some temps and just go through every page, block and product to find & replace!
2. Use the import/export functionality to export files, update using some text editor, then import. 
3. Write something using the Find API to locate pages, block and products then for every string/Xhtmlstring property replace any matching strings, saving and publishing via the API.
4. Write SQL directly against the CMS and Commerce database tables to find & replace.

Option 1 is a little blunt, would work!

Option 2 could be a little brittle - I'venot had much success with the CMS Import/Export - it errors a lot. The Commerce one appears to be OK. The client could also do this themselves.

Option 3 seems straight forward, although it would need custom code, testing, deploying, runnning etc and would come at a cost to the client.

Option 4 I'm not sure if this is supported? We'd need to know which tables to update (Commmerce is complicated) also how do we update Find with the updated values - we'd still need to republish everything wouldnt we?

Anyone any experience with this?

Any other options?

Cheers