Wholesale Pricing Problems when Quantity Dscounts Set

ZC 2.1+
PHP 8.1
MySQL 10.5.28-MariaDB
Cloned Bootstrap
POSM
DBIO
EO
OPC
Sitemap
All are the latest.

Trying to set up wholesale pricing and quantity discounts but running in to confiicts where some instructions say to leave the price blank in the attributes controller, set the Wholesale Price to (in this case, 50%) and set the attributes quantity price (in this case, 5:9.95,6:8.45,12:7.95).

The product is set to 50% for wholesale. Setting the two places up as shown in the images results in the display on the product page, "Your Price: $0.00" versus the $4.98 is should be.

When 6 items are placed in the cart, it properly shows $8.45 as the unit price. When 7 items are placed in the cart, it shows a unit price of $7.95 which should be for 12 or more.

dbltoe:

ZC 2.1+
PHP 8.1
MySQL 10.5.28-MariaDB
Cloned Bootstrap
POSM
DBIO
EO
OPC
Sitemap
All are the latest.

Trying to set up wholesale pricing and quantity discounts but running in to confiicts where some instructions say to leave the price blank in the attributes controller, set the Wholesale Price to (in this case, 50%) and set the attributes quantity price (in this case, 5:9.95,6:8.45,12:7.95).

The product is set to 50% for wholesale. Setting the two places up as shown in the images results in the display on the product page, "Your Price: $0.00" versus the $4.98 is should be.

When 6 items are placed in the cart, it properly shows $8.45 as the unit price. When 7 items are placed in the cart, it shows a unit price of $7.95 which should be for 12 or more.

When a product is priced by attributes with no base price such as that it doesn't have a price until an attribute is selected.

That , of course is understood. What's going on here is twofold.

First, there appears to be no way to combine wholesale pricing and quantity discounts in a priced-by-attributes product and have it show the Your Price Is... without doubling the item price or adding the wholesale and discount price together. It appears that the wholesale has no where to go since quantity discounts wants the price for the option to be blank but wholesale needs it to display the Your Price Is...

Second, with the quantity discount settings of 5:9.95,6:8.45,12:7.95, adding a quantity fo 7 to the cart should show a price of $8.45 versus $7.95, correct?

Unfortunately, without a wholesale account, you cannot see the result but I can get you close. The links below are only different in that the first has no price set for the Suncatcher or Night Light. They both have QD set and wholesale set to 50%.

Clicking the Quantity Discounts Available link on both items shows the popup with no mention of a quantity of 12.

https://enightlights.com/index.php?main_page=product_info&cPath=40_44&products_id=78 No price for the Suncatcher attribute

Note that no price is shown but when one Suncatcher is added to the cart with no Suction Cup, the price is shown as $9.95. When 7 are added to the cart, it shows $7.95 versus the $8.45 it should be.

When logged in as a wholesale customer, the product shows Your Price: $0.00. Clicking on Type > First Choose ... > Suncatcher, you see $9.95. It should show the wholesale price of $4.98.

https://enightlights.com/index.php?main_page=product_info&cPath=40_44&products_id=146 Suncatcher attribute price set to $9.95

Note that the page shows Starting at:$9.95 but, when you click on the dropdown for Type (First Choose ...), the Suncatcher shows as $19.90 which is double the single price. When you add 7 Suncatchers without cups to the cart, The item Price shows 17.90 which is exactly double $8.45 which should be the price based on the QD settings of 5:9.95,6:8.45,12:7.95.

When logged in as a wholesale customer, the product displays Your Price: $4.98 and clicking on the Type > First Choose ... > Suncatcher, you see the price of $14.93 which is the sum of the base price and the wholesale price.

Again, it looks like a really good catch 22.

Wholesale will not work on a priced-by-attributes product without a Price entry >0 and a Wholesale Price entry.

QD will not work without the Price set to 0.0000 and a proper setting in Attributes Qty Price Discount:

Combine the two and all h e double-hockysticks breaks loose.

I can PM a wholesale login if needed.

And furthermore, both prooducts (set as noted above) bvring up the up the following two log files:

https://enightlights.com/index.php?main_page=product_info&cPath=40_44&products_id=78

[06-May-2025 15:47:24 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&products_filter=78&current_category_id=27, IP address: 123.234.134.255, Language id 1#0 /MY_ADMIN/attributes_controller.php(1111): zen_debug_error_handler()
#1 /MY_ADMIN/index.php(16): require('/home/enigjohn/...')
--> PHP Warning: Undefined array key "products_options_type" in /MY_ADMIN/attributes_controller.php on line 1111.


[06-May-2025 15:47:24 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&products_filter=78&current_category_id=27, IP address: 123.234.134.255, Language id 1
#0 /MY_ADMIN/attributes_controller.php(608): zen_debug_error_handler()
#1 /MY_ADMIN/attributes_controller.php(1111): translate_type_to_name()
#2 /MY_ADMIN/index.php(16): require('/home/enigjohn/...')
--> PHP Warning: Undefined array key "" in /MY_ADMIN/attributes_controller.php on line 608.
***********************************************************************************
[06-May-2025 15:47:27 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&action=update_attribute&attribute_id=6322&products_filter=78&current_category_id=27, IP address: 123.234.134.255, Language id 1
#0 /MY_ADMIN/attributes_controller.php(1111): zen_debug_error_handler()
#1 /MY_ADMIN/index.php(16): require('/home/enigjohn/...')
--> PHP Warning: Undefined array key "products_options_type" in /MY_ADMIN/attributes_controller.php on line 1111.


[06-May-2025 15:47:27 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&action=update_attribute&attribute_id=6322&products_filter=78&current_category_id=27, IP address: 123.234.134.255, Language id 1
#0 /MY_ADMIN/attributes_controller.php(608): zen_debug_error_handler()
#1 /MY_ADMIN/attributes_controller.php(1111): translate_type_to_name()
#2 /MY_ADMIN/index.php(16): require('/home/enigjohn/...')
--> PHP Warning: Undefined array key "" in /MY_ADMIN/attributes_controller.php on line 608.

https://enightlights.com/index.php?main_page=product_info&cPath=40_44&products_id=146

[06-May-2025 14:51:25 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&current_category_id=44&products_filter=146, IP address: 216.177.186.199, Language id 1#0 /MY_ADMIN/attributes_controller.php(1111): zen_debug_error_handler()
#1 /MY_ADMIN/index.php(16): require('/home/MY_USER/...')
--> PHP Warning: Undefined array key "products_options_type" in /MY_ADMIN/attributes_controller.php on line 1111.


[06-May-2025 14:51:25 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&current_category_id=44&products_filter=146, IP address: 216.177.186.199, Language id 1
#0 /MY_ADMIN/attributes_controller.php(608): zen_debug_error_handler()
#1 /MY_ADMIN/attributes_controller.php(1111): translate_type_to_name()
#2 /MY_ADMIN/index.php(16): require('/home/MY_USER/...')
--> PHP Warning: Undefined array key "" in /MY_ADMIN/attributes_controller.php on line 608.
***********************************************************************************
[06-May-2025 14:52:31 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&action=update_attribute&attribute_id=9742&products_filter=146&current_category_id=44, IP address: 216.177.186.199, Language id 1
#0 /MY_ADMIN/attributes_controller.php(1111): zen_debug_error_handler()
#1 /MY_ADMIN/index.php(16): require('/home/MY_USER/...')
--> PHP Warning: Undefined array key "products_options_type" in /MY_ADMIN/attributes_controller.php on line 1111.


[06-May-2025 14:52:31 UTC] Request URI: /MY_ADMIN/index.php?cmd=attributes_controller&action=update_attribute&attribute_id=9742&products_filter=146&current_category_id=44, IP address: 216.177.186.199, Language id 1
#0 /MY_ADMIN/attributes_controller.php(608): zen_debug_error_handler()
#1 /MY_ADMIN/attributes_controller.php(1111): translate_type_to_name()
#2 /MY_ADMIN/index.php(16): require('/home/MY_USER/...')
--> PHP Warning: Undefined array key "" in /MY_ADMIN/attributes_controller.php on line 608.

See follow-on discussion in the following bug-report thread:

https://www.zen-cart.com/showthread.php?230725-Wholesale-Priceing-and-Quantity-Discounts-Failling-for-Priced-by-Attributes-Products&p=1407453#post1407453