is there some SQL query to import Product Title - Category into Meta Title?

So example: I have Products and these products have parts. I want to import product titles - part titles - categories into Meta Title.

So if i have: product 1 - electric showers Part 1 - product 1 - electric showers

Is there some SQL query to make this?

  • please give an good examle
    – Amit Bera
    Commented Jun 10, 2015 at 10:06
  • so here is a product which has parts theshowerdoctors.ie/mira-sport-7-5-and-8-5-kw-j84.html , i want to add to all parts into meta titles this. MIRA SPORT 7.5 AND 8.5 KW (J84) - MULTI CLAMP BRACKET SPARE - Electric Showers . So first means its product Mira sport 7.5 and 8.5 KW the second is part - MULTI CLAMP BRACKET SPARE and third is category which is Electric Showers
    – Webjuice
    Commented Jun 10, 2015 at 10:10

1 Answer 1


try to do it the "magento-way"

you can obtain products in php with

$product = Mage::getModel('catalog/product')->getCollection();

then iterate through the collection and do smth. like

  • so what files needs to be changed ?
    – Webjuice
    Commented Jun 10, 2015 at 14:24
  • can somebody help me more ?
    – Webjuice
    Commented Jun 12, 2015 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.