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

[Zean]

"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.

[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?

[Zean]

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?

[twitchtoo]

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.

[Zean]

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".

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. 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!