Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

<RESOLVED> How can I fix Multiple Spelling Errors At Once?  Mass Spelling Correction? 
 
ncotrona
Sr. Member
 
Total Posts:  161
Joined:  2009-05-15
 

I am looking to correct spelling errors in the data fields for my product pages. Some of the corrections are required in the short description, long description, title, meta description, etc....

In some instances, I may have approximately 1000 corrections to make of the same work for 1000 different products.  Does anyone have any suggestions in regards to how I can make a mass correction.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ncotrona
Sr. Member
 
Total Posts:  161
Joined:  2009-05-15
 

PhpMyAdmin SQL Search and Replace

Using SQL Query Search and Replace
1.  Login to phpMyAdmin and select your database
2.  Click the SQL tab
3.  Enter the following in the run SQL Query text box (replacing tablename, tablefield, findstring and replacestring with your actual information:
4.  Click go to process the changes and update your SQL database

That’s all there is to it. A quick and effective way to replace multiple text string SQL database content on the fly from phpMyAdmin.
Example

UPDATE tablename SET tablefield =
replace(tablefield,"findstring”,"replacestring");

Here is a WordPress SQL Query database example for reference:
UPDATE wp_posts SET post_content =
replace(post_content,"coolstuff.com”,"lancelhoff.com")

This example would replace any and all occurrences of coolstuff.com with lancelhoff.com in the post_content field under table wp_posts

SEE : http://www.lancelhoff.com/phpmyadmin-sql-search-and-replace/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top