If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Can I add the manufacturers name to product name?

Can I add the manufacturers name to product name?

Started by icecold on 23 May 2012, 9:41 PM · Views: 1,135

Results 1 to 5 of 5
23 May 2012, 9:41 PM
#1
icecold avatar

icecold

Zen Follower

Join Date:
Jul 2008
Posts:
360
Plugin Contributions:
0

Can I add the manufacturers name to product name?

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.

24 May 2012, 10:52 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I add the manufacturers name to product name?

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 ... :cool:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

3 Jun 2012, 4:59 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Can I add the manufacturers name to product name?

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

3 Jun 2012, 5:18 PM
#5
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Can I add the manufacturers name to product name?

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

20 years a Zencart User