Can I add the manufacturers name to product name?

[icecold]

I was wondering how can I modify the products name, so it adds the manufacturer's and looks like this >>> Canon PowerShot G12 Compact Camera

which file needs to be modified? and I am talking about the product field so it can be exported to Google Merchant Center.

[Ajeh]

First, backup your database ...

If you want the Manufacturer Name added in front of the Product Name ... you can use:

UPDATE products p, products_description pd, manufacturers m
 SET pd.products_name =  concat( m.manufacturers_name, ' ', pd.products_name) 
 where p.products_id = pd.products_id and p.manufacturers_id = m.manufacturers_id

Note: compliments of the amazing DrByte with just a tad of help from da elf ...

[icecold]

great! I knew there should be a concatenate SQL command to do that! Thanks!!!

[Ajeh]

You are most welcome ... just be sure to backup your database first, in case you really goober it up ...

[schoolboy]

This may be a futile exercise... The MANUFACTURER'S name ADDED to the product name will NOT satisfy Google Merchant conditions.