Zen Cart Logo
Forums / General Questions / add manufacturer to all items

add manufacturer to all items

Views: 517

Results 1 to 3 of 3
21 Jul 2011, 9:15 PM
#1
sham avatar

sham

Zen Follower

Join Date:
Feb 2010
Posts:
159
Plugin Contributions:
0

add manufacturer to all items

Most of my products are from 1 manufacturer. Manufacturer info. was not entered originally. Is there a way to add a manufacturer to all items? or do I have to do it one by one?
Thanks

22 Jul 2011, 2:16 AM
#2
gaurav10feb avatar

gaurav10feb

Zen Follower

Join Date:
Jan 2010
Location:
Australia
Posts:
243
Plugin Contributions:
1

Re: add manufacturer to all items

the easiest way i can think of is

  1. create manufacturer in catalog>>manufacturers
  2. login to you sql and see in manufactuers table to find the manufactuers_id for that particular manufactuers
  3. run query UPDATE products SET manufactuers_id = 'ID'
    ** replace red texted ID to the id you found on step 2.
26 Jul 2011, 8:11 PM
#3
sham avatar

sham

Zen Follower

Join Date:
Feb 2010
Posts:
159
Plugin Contributions:
0

Re: add manufacturer to all items

Thanks for the help worked great. After fixing manufactuers_id as shown below.

gaurav10feb:

the easiest way i can think of is

  1. create manufacturer in catalog>>manufacturers
  2. login to you sql and see in manufacturers table to find the manufacturers_id for that particular manufacturers
  3. run query UPDATE products SET manufacturers_id = 'ID'
    ** replace red texted ID to the id you found on step 2.

Thanks again