What will be the sql statement for generating meta text for my product pages?

What will be the sql statement for generating meta text for my product pages?

Avatar image
Apr 29, 2013
Naveen Kumar wrote
I would like to add below info dynamically to all my product page meta-titles.

(Color) (Product Name), Buy Online (Product Name), Shop Discounted (Product Name), Buy (Category) (Product Name)

Please help!
Reply
3 Answers
Avatar image
Apr 29, 2013
Ira Kobylianska agent wrote
Thank you for your reply.

You can update your meta-titles using MultiEditior or during import. You need to use CONCAT command to merge values.
Please check the following articles for details how to create correct expression that allows to update meta-titles as you need:
http://www.mag-manager.com/useful-articles/tipstricks/how-to-input-missing-data-and-modify-existing-on-the-fly-by-means-of-expressions-in-the-process-of-magento-import

You can also find example of correct expression at Multi Editor - see attached

If you want us to create specific expression or SQL statement for you, please contact us via e-mail and we will provide you with estimated time and cost.

Waiting to hear from you
Avatar image
May 01, 2013
Naveen Kumar wrote
Great! it worked like a charm. thanks a lot.
Just to add, I did not get this particular help/hint in my version of Store Manager. Is there a way i can update my current version to the latest version.

Are there any pre-requisites for that?

Thanks in advance.
Naveen
Avatar image
May 01, 2013
Ira Kobylianska agent wrote