DUAL Pricing v2

[ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;]

when doing your sql patch
Change:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;

to:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price;

Cheers

Quote:

---

Originally Posted by Ragareb

[ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;]

when doing your sql patch
Change:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price_w;

to:
ALTER TABLE products_discount_quantity ADD discount_price_w VARCHAR( 150 ) DEFAULT '0' AFTER discount_price;

Cheers

---

thanks a lot , i just found it out.

Any one know how to fix that subtotal is 0 when applied wholesale price.?

I have a client who has started doing some holiday markdowns using Sale Make, This appears to by pass the dual pricing setting and so she has all kinds of explaining to do to her wholesale customers. I saw some discussion about updating tis module to take the sale pricing into account, was anything ever advanced.

failing that has any on developed a separate strategy for sale pricing for wholesale customers

Quote:

---

Originally Posted by brandon

I have an issue with dual pricing and 1.3.9h

This suggests that the dual pricing version of admin/attributes_controller.php is involved in the problem.

---

I have merged the security token changes (diff the file version 1.3.9g to 1.3.9h to see) and it seems to work now.

looks like dual_pricing__wholesale_pricing_1-7a, file includes/classes/shopping_cart.php is missing the 1.3.9h changes (diff shows about 8 small changes relating to cart management).

I can certainly merge the changes but i am in no position to run the regression testing that I am sure a conscientious maintainer would have. But at least I will know if i have a suspected fix.

Hey drgr33n,

First thank you very much for you work on the Dual Pricing module. I look forward to getting it working properly on our cart.

I am getting a bit of a strange behavior and hoping you may be able to shed some light on it for me.

We are using v1.3.9d

I have a product with retail price of $69 and wholesale of $49 and one Attribute which is for -$12 (minus 12). Haven't figured out where you are entering comma separated for Attributes - if you could help on this it would be great too.

However, in the backend when previewing the product before saving it displays as $69, $49, and $57 (which appears to be correct as the $57 is retail with attribute)

On the site when I log in as a Wholesale I see Retail with attribute as $81 and Wholesale with attribute as $37. When I add the item to my cart I get the original retail price showing in the cart whether I check the attribute or not: $69.

If you can shed any light on this behavior it would be great.

Thanks,
Pat

I have installed the mod with no problems BUT I am not seeing the radio button for customers to request wholesale on the register page...I also am not being notified so I have no idea who I am suppose to upgrade to wholesale and who I'm not unless I manually go through each new customer's profile any suggestions on where I might have gone wrong?

For everyone that is having problems with this mod and the sql problem here is the correct code without the zen_ prefix and also the code WITH the zen prefix. Use the code WITHOUT the prefix if you are running this through the Tools>>Install SQL patches in the admin of your website:

WITHOUT THE ZEN PREFIX:

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;


WITH ZEN PREFIX:

ALTER TABLE `zen_customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `zen_products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `zen_products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `zen_products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `zen_customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;

I also had problem running this with 1.3.9h because of changes in the INCLUDES>>CLASSES>>shopping_cart.php file that happened in 1.3.9h. It was causing a time out error when you logged in and tried to checkout, from either a wholesale or retail account.

The only glitch I have not been able to solve is that for Wholesale customers the TOTAL price in the CART shows up at $0.00 BUT it shows up correctly in checkout and through the rest of the process. If anyone knows the fix for this feel free to add...but this is the best I could do and still have the cart and this mod work. ****BE SURE TO BACK UP THE FILE BEFORE UPLOADING THIS FILE... JUST IN CASE*** this new file is only for VERSION 1.3.9h if you are using a prior version the file included in the mod download should work!