DUAL Pricing v2

[richphitzwell]

Also, Trying to hunt down the actual cause but I came across another user who has both H and using Dual Pricing, when adding an attribute to a product it fails to add and kicks us to the admin home screen.

Anybody know the cause of this or how to fix this?

Too simple but should be noted, the admin/attribute.php file in this mod was to blame. I cant recall any difference with dual price when it involved attributes, but simply reverting back to the original does the trick

[lewisje]

I have fixed an error that caused this problem for kcarl; I would post the update here while the mods check it but the ZIP was too big for the forum, even on the highest compression settings.

[adam2020]

I have a problem where the wholsale customer is charged the retail amount when quantity discounts are reached.

I'm testing with ZC V1.3.9h and Dual Pricing V1-7b

Example:
Product is Retail: $29.40, Wholesale: $23.00
Quantity discounts are 4 or more = $24.50

If wholesale customer orders 1 - 3 price is $23.00 each which is correct
If wholesale customer orders 4 or more price is $24.50 each which is inccorrect

Problem is Whoelsale customer will need to order 10 or more of each product which is possible to implement but only if I can overcome this problem.

To test please see this product with a wholesale price
http://shop.adventure11.com/index.ph...roducts_id=201

Then login with...
[email protected]
test123

I will be very thankful if anyone can help me with this problem.

[adam2020]

I fixed the problem after another look I found a field wasn't added to the products_discount_quantity table due to an error with the install sql. Once this was loaded I was able to change the quantity discounts to work :)

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`;

[adam2020]

I spoke too soon, I was able to edit the quantity discounts in admin so it display correctly on product info page but still show insorrect amount in shopping cart

[eadavis]

I spoke too soon, I was able to edit the quantity discounts in admin so it display correctly on product info page but still show insorrect amount in shopping cart

Running into this too. It looks as if the cart is calculating using the discount amount value under "Discount Value" and ignoring the value input under "TEXT_PRODUCTS_DISCOUNT_PRICE_W," even if the customer is designated as a Wholesaler. The discount values are displayed correctly on the product info page, though.

Any help with this would be greatly appreciated!

[adam2020]

I have posted a job on scriptlance.com so should have a solution soon.

[JimmyV]

Have you tried group pricing mod? I use that and it gives 5 levels of "retail/wholesale price and 5 levels of discount price which is huge for me as 2 is not nearly enough. Doing loads of volume with it with thousands of SKU's no problems ever.

Just a thought...

[adam2020]

Hi Jimmy

Thanks but as far as I know the price is the same using groups and the discount is provided at the end.

This project is a bit complicated as all customers need to see only one price (the price they will pay) plus a few other issues so I decided to go with Multisite and try and get Dual Pricing to work with it.

[JimmyV]

NOPE Gp 1.3.3 that David Simmons wrote retains the basic pricing level call that retail... plus adds 4 more levels which could be more than four but it's plenty for me. So I can list the same product using the same everything with 5 diffrent prices to 5 different customers and 5 different discounted prices or not discounted it all your choice.

I muddled with DP and it is about a 1 compared to GP being a 100. No offense to the creator it just has been surpassed IMO