DUAL Pricing v2

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?

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

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.

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.php?main_page=product_info&cPath=111_70&products_id=201

Then login with...
[email protected]
test123

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

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;

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

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

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!

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

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

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.

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

Sorry to bump this up, but does the new version work? I ran the SQL instructions, and uploaded the files, and nothing changed. I can't input wholesale pricing, and I can't edit customers to add them to have the wholesale group pricing.

ANyone got any ideas?

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

I just tested GV 1.3.3 and it has the exact same problem.

Scenario:
A product is $100 and quantity discount for 4+ is $80 for normal customers.
Wholesale Group A is charged $50 for same product. If the wholesale Group A customer purchases less than 4 he is charged $50 but if he purchases 4 or more he is charged $80.

The big problem is the wholesale customer must order 6 or more which is easy to implement but only worthwhile if I can get either Dual Pricing or GP to work correctly for a wholesale customer.

Mediaslave:

Sorry to bump this up, but does the new version work? I ran the SQL instructions, and uploaded the files, and nothing changed. I can't input wholesale pricing, and I can't edit customers to add them to have the wholesale group pricing.

ANyone got any ideas?

You must have done something wrong with the install as I have done it a few times in the past week and each install including the
recent V1.7c works. (besides the quantity discounts problem)

Scenario:
A product is $100 and quantity discount for 4+ is $80 for normal customers.
Wholesale Group A is charged $50 for same product. If the wholesale Group A customer purchases less than 4 he is charged $50 but if he purchases 4 or more he is charged $80.
I have to try that out to see what happens. My first thought is that buying that way would conflict with both these modules as these are setting flat prices for a given group of purchasers.

Obviously you can do a workaround (which I actually do but for a different reason) by creating a "special" which is a pre-pack at a reduced price. You then cross-sell it so even if the person bypasses the product listing they still see it cross-sold on the product page before ordering.

I use it as an upsell technique since I know most buyers buy say "3" and so I run a special at "5" units to get the upsell. It works really well in my case anyway.

Hi All,
First, I have zen-cart-v1.3.8a and it has been working pretty much great, other than a few security issues, which I have finally gotten resolved. Then I went and downloaded dual pricing and I have slammed up against an admin roadblock that has given me a major pia.:frusty: My site is showing up fine, I can't login to admin. I did the copy and paste into the sql patch and poof, admin was gone. :oops: I've looked everywhere and can't find the answer. I would be happy if it gave me a real error message, what it says is:

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I've been through the config files and I'm at a lose, they all look right. Somebody please give me an answer that will make it all good again. I was actually thinking about upgrading to the latest version and thought I would wait until after Christmas, now I'm wondering if I shouldn't ought to go ahead and do it.

Thanks in advance,

Katydid
groovingrannylive.com

Hi All,
First, I have zen-cart-v1.3.8a and it has been working pretty much great, other than a few security issues, which I have finally gotten resolved. Then I went and downloaded dual pricing and I have slammed up against an admin roadblock that has given me a major pia. My site is showing up fine, I can't login to admin. I did the copy and paste into the sql patch and poof, admin was gone. I've looked everywhere and can't find the answer. I would be happy if it gave me a real error message, what it says is:

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I've been through the config files and I'm at a lose, they all look right. Somebody please give me an answer that will make it all good again. I was actually thinking about upgrading to the latest version and thought I would wait until after Christmas, now I'm wondering if I shouldn't ought to go ahead and do it.

Thanks in advance,

Katydid
groovingrannylive.com

try this again on the first page instead of the last.:D

This has been mentioned a couple of times.

I have the latest versions of stock_by_attributes and dual_pricing installed on zencart 1.3.9h.

When logged in as a wholesale user and adding a product with attributes to the shopping cart, the retail price is listed.

I gather this is a problem with shopping_cart.php, but I can't find anything.

Has anyone figured out a solution to this?

Hi anyone has a solution to the shopping cart not displaying the correct pricing if the User is a WS?

Discount Value - This value is used in Shopping Cart instead of TEXT_PRODUCTS_DISCOUNT_PRICE_W.

Thanks a million.

this mod isn't working properly in 139h. it can't see the wholesale customer variable turned on. i'm desperately working on a solution, i have the value working in the admin just not in the cart... yet.