Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / "Qty Discounts Off Price" on Product page only displays one row of discounts

"Qty Discounts Off Price" on Product page only displays one row of discounts

Started by zean on 21 Feb 2016, 3:20 AM · Views: 4,837

Results 1 to 5 of 5
21 Feb 2016, 3:20 AM
#1
zean avatar

zean

Zen Follower

Join Date:
May 2009
Posts:
200
Plugin Contributions:
0

"Qty Discounts Off Price" on Product page only displays one row of discounts

"Qty Discounts Off Price" on Product page only displays one row of discounts. And says, "Discounts may vary based on options above."
I want the "Qty Discounts Off Price" to show all rows.

I have products with several attributes. Only one of the attributes have "Apply Discounts Used by Product Special/Sale" set to "yes".
The name of this attribute is "Size." There are 20 sizes.
Having used the Products Price Manager, the correct discount prices are properly used for calculations in the shopping cart.

However, on the Product page, the "Qty Discounts Off Price" only displays one of the sizes for the customer to see.
I want the "Qty Discounts Off Price" to show the discounts for all 20 of the sizes.

Limitations: Because I frequently update attribute prices via MySQL code executed in phpMyAdmin, I can not use the attribute_qty_prices Field in the products_attribute Table which is accessed by "Admin > Catalog > Attribute Controller > Attributes Qty Price Discount", as that field is a complex and uniquely formatted text string and would therefore involve complex MySQL coding. I mention this because the "Option Quantity Discounts" display shown via the link "Quantity Discounts Available" might otherwise be involved in a solution, because when invoked, it would show all rows when that field is used.

ZenCart v1.5.4
Thank you for your kindness.

22 Feb 2016, 3:36 AM
#2
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: "Qty Discounts Off Price" on Product page only displays one row of discounts

You're template hiding the rest of it or it's not loading?

Template is easy to see in browser - inspect code view.

Not loading - you're bypassing the attributes controller in admin... using direct SQL statements... perhaps you DO need to add all of the necessary data in each of the fields it's looking for to... correct the missing data problem.

Any reason you don't just code the SQL functions into the admin alongside the original attributes controls?

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

22 Feb 2016, 5:57 AM
#3
zean avatar

zean

Zen Follower

Join Date:
May 2009
Posts:
200
Plugin Contributions:
0

Re: "Qty Discounts Off Price" on Product page only displays one row of discounts

twitchtoo:

You're template hiding the rest of it or it's not loading?

Template is easy to see in browser - inspect code view.

Not loading - you're bypassing the attributes controller in admin... using direct SQL statements... perhaps you DO need to add all of the necessary data in each of the fields it's looking for to... correct the missing data problem.

Any reason you don't just code the SQL functions into the admin alongside the original attributes controls?

Hi and thanks for your thoughts.
No, there is no issue with the template and no issue with the data.
"Qty Discounts Off Price" on Product page only displays one row of discounts is a NORMAL "Feature" of Zencart but is not ideal behavior.
Just to confirm, I observed this behavior even with the standard default installation of the demo data store in Zencart version 1.5.4.

Any other thoughts?

23 Feb 2016, 1:18 AM
#4
twitchtoo avatar

twitchtoo

Totally Zenned

Join Date:
Apr 2007
Location:
Ontario, Canada
Posts:
1,733
Plugin Contributions:
14

Re: "Qty Discounts Off Price" on Product page only displays one row of discounts

Okay you want to display the chart for everything, not just one thing.

It will need to be coded to get the data and display it dynamically.

Twitch.
https://www.twitchtoo.com Do you work for free? Please donate.
June 7.2026 - NOW AVAILABLE - Twitch Base8 - Obsidian

23 Feb 2016, 5:52 AM
#5
zean avatar

zean

Zen Follower

Join Date:
May 2009
Posts:
200
Plugin Contributions:
0

Re: "Qty Discounts Off Price" on Product page only displays one row of discounts

twitchtoo:

Okay you want to display the chart for everything, not just one thing.

No, not "everything." Just 1 attribute. As mentioned in post #1, Only one of the attributes have "Apply Discounts Used by Product Special/Sale" set to "yes".

twitchtoo:

It will need to be coded to get the data and display it dynamically.

Yeah, it will need to be coded since computers still need to be told what to do. :smartalec: ZenCart is already "dynamically" displaying the first row. It is a common need for store owners. Most people would want to show the discount for all sizes, not just the cheapest size.
Perhaps someone who has already done this with ZenCart could make a suggestion.

Thanks again!