Forums / Setting Up Categories, Products, Attributes / How to do a "if product is priced by attributes" query?

How to do a "if product is priced by attributes" query?

Locked

Views: 1,353

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
20 Nov 2006, 3:09 PM
#1
stehodges avatar

stehodges

New Zenner

Join Date:
Jun 2005
Posts:
52
Plugin Contributions:
0

How to do a "if product is priced by attributes" query?

Some of the products in my shop are provided in smaller samples.
These are priced by attributes and i would like to make it clear on the product listing page which items are available in sample sizes.

I imagine there's a way of looking up which product ids are priced by attributes - can anyone help out?

If i could query whether a particular option value is being used even better!

20 Nov 2006, 3:18 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: How to do a "if product is priced by attributes" query?

In the products table the field products_priced_by_attribute is either 0 or 1 ... 1 being that the product is Priced by Attributes ...

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!

20 Nov 2006, 3:37 PM
#3
stehodges avatar

stehodges

New Zenner

Join Date:
Jun 2005
Posts:
52
Plugin Contributions:
0

Re: How to do a "if product is priced by attributes" query?

Ah, ok - so i could use that, is there a similar field to say which option value is being used - this way any other products i choose to price by attributes (but do not offer sample sizes) will not show up

20 Nov 2006, 4:58 PM
#4
stehodges avatar

stehodges

New Zenner

Join Date:
Jun 2005
Posts:
52
Plugin Contributions:
0

Re: How to do a "if product is priced by attributes" query?

Any pointers on the code?

20 Nov 2006, 5:15 PM
#5
stehodges avatar

stehodges

New Zenner

Join Date:
Jun 2005
Posts:
52
Plugin Contributions:
0

Re: How to do a "if product is priced by attributes" query?

added

p.products_priced_by_attribute

to queries in default_filter.php