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 Jun 10 '15 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 Jun 10 '15 at 10:10

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

| improve this answer | |
  • so what files needs to be changed ? – Webjuice Jun 10 '15 at 14:24
  • can somebody help me more ? – Webjuice Jun 12 '15 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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