Forums / Setting Up Categories, Products, Attributes / what database table are attributes assigned to products in zen cart

what database table are attributes assigned to products in zen cart

Locked

Views: 2,690

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
20 Mar 2009, 9:25 PM
#1
george_susini avatar

george_susini

New Zenner

Join Date:
Mar 2009
Location:
Raleigh, NC
Posts:
31
Plugin Contributions:
0

what database table are attributes assigned to products in zen cart

I am running Zen Cart 1.3.8a. I am trying to sort out a customers product attributes and clean up duplicates that they created, they have many attributes – Over a 100
I have tracked the attribute tables , but I cant seem to find what table they are assigned to the products in. Can anyone help with this ? Thanks !

George Susini Raleigh Tech Consulting - Raleigh, NC

21 Mar 2009, 2:47 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: what database table are attributes assigned to products in zen cart

All of these tables are used to build and maintain the Attributes of the products ...

Holds the Option Name types:
products_options_types

Build the Option Name and Option Values components:
products_options
products_options_values
products_options_values_to_products_options

Build the Attributes themselves:
products_attributes
products_attributes_download

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!

21 Mar 2009, 6:16 PM
#3
george_susini avatar

george_susini

New Zenner

Join Date:
Mar 2009
Location:
Raleigh, NC
Posts:
31
Plugin Contributions:
0

Re: what database table are attributes assigned to products in zen cart

Ajeh,
Thanks for the response that is a big help,
I see where products_options_id in product_options is products_options_values in product_options_values then in products_options_values_to_products_options it is stored as product_options _values_id

Do you know where the attributes are stored or associated to the product ?

George Susini Raleigh Tech Consulting - Raleigh, NC

22 Mar 2009, 3:19 AM
#4
ajeh avatar

ajeh

Oba-san

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

Re: what database table are attributes assigned to products in zen cart

The last two tables that I listed ...

That is where they are built ...

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!

27 Mar 2009, 11:37 AM
#5
george_susini avatar

george_susini

New Zenner

Join Date:
Mar 2009
Location:
Raleigh, NC
Posts:
31
Plugin Contributions:
0

Re: what database table are attributes assigned to products in zen cart

Ajeh,
Thanks for the response that is a big help:clap:

George Susini Raleigh Tech Consulting - Raleigh, NC