If you use Clean URLs for SEO, which I suspect most of you are, here's some handy SQL patches (tested), for those with a medium-large size product catalog.
If you've already optimised your product SEO titles and meta descriptions, this isn't for you.
If you want to just test on an individual product, for the last line above use...
If you want to just test on an individual product, for the last line above use...
Yikes, it's included product description HTML tags in the SEO meta descriptions...
Don't panic, you can strip HTML / Carriage Returns / Line Feeds with this patch... (assuming you have clean product description HTML)
Code:
# Remove HTML / Carriage Returns / Line Feeds and left trim
UPDATE xcart_products set meta_description=replace(meta_description, '<p>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</p>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<div>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</div>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<b>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</b>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<i>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</i>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<em>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</em>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<u>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</u>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<ul>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</ul>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<ol>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</ol>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<li>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</li>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<span>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</span>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<hr>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<hr />', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<br>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<br />', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h1>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h1>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h2>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h2>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h3>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h3>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h4>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h4>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h5>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h5>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, '<h6>', '');
UPDATE xcart_products set meta_description=replace(meta_description, '</h6>', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, ' ', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, ' ', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, ' ', ' ');
UPDATE xcart_products set meta_description=replace(meta_description, CHAR(9), '');
UPDATE xcart_products set meta_description=replace(meta_description, CHAR(10), '');
UPDATE xcart_products set meta_description=replace(meta_description, CHAR(13), '');
UPDATE xcart_products SET meta_description = LTRIM(meta_description);
If you've made any mistakes and want to start over...
or...
or...