If this is your first visit, check our documentation. To post, register or login.
Forums / Discounts/Coupons, Gift Certificates, Newsletters, Ads / Crazy cart totals using simple group discount

Crazy cart totals using simple group discount

Locked

Started by dwdesigns on 8 Sep 2006, 1:56 AM · Views: 5,474

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
8 Sep 2006, 1:56 AM
#1
dwdesigns avatar

dwdesigns

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

Crazy cart totals using simple group discount

Dear zenners,
I've set up a live site and normal orders go through fine, but those customers who I've assigned to a group discount are getting invalid order totals -- numbers that are close to the mark, but not close enough even with rounding. A sample total is below with the customer in the 25% discount category:

1 x Test Item 0% $1.00 $1.00 $1.00 $1.00
Sub-Total: $1.00
Ground Shipping (DHL): $6.99
Group Discount: -$0.36
GA Tax 6%: $0.32
Total: $7.94

I cannot reproduce the total using any traditional math. I've added 1.00 to 6.99 and taken 6% tax on that, which gets me .48 -- without taxing the shipping, I get tax as: .06, or taking the product price, discount, etc. I still can't reproduce those numbers. I'm not a math wizard, not even close, and my client is crying foul. I've set up a test account in my store with a 25% discount -- can someone place a test order please and look at the cart upon completion to see if you can tell what is happening? The url is https://www.qcelabs.com/zencart/

username: tester2
password: tester2

Pick any product and use the check option for checkout. Thanks a ton. The 1 item above is temporarily inactive, so choose a real one. We're still testing, so a sample order is fine. OR, if you can tell from the above what is going on, please let me know, again -- normal orders for people not in discount groups are calculating fine. THANKS!

8 Sep 2006, 5:12 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Crazy cart totals using simple group discount

I'm not understanding the repeated prices here:> DWDesigns:

1 x Test Item 0% $1.00 $1.00 $1.00 $1.00or is that just a product name?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Sep 2006, 5:33 AM
#3
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Crazy cart totals using simple group discount

What are all your sort-orders in Admin->Modules->Order Totals ?

What are all your settings for the ot_group_discount module?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Sep 2006, 10:21 PM
#4
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,759
Plugin Contributions:
56

Re: Crazy cart totals using simple group discount

Userid should be an email address ([email protected]). Pls post a valid email & password and I'll give it a try.

What version of ZenCart are you running? Pls. also post your order totals settings, as Dr. Byte suggested.

Scott

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

11 Sep 2006, 2:23 AM
#5
dwdesigns avatar

dwdesigns

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

Re: Crazy cart totals using simple group discount

My sort totals are:

Modules Sort Order Action
COD Fee ot_cod_fee
Discount Coupon ot_coupon 280
Group Discount ot_group_pricing 290
Gift Certificates ot_gv 840
Low Order Fee ot_loworderfee 400
Shipping ot_shipping 200
Sub-Total ot_subtotal 100
Tax ot_tax 300 Info
Total ot_total 999

11 Sep 2006, 2:25 AM
#6
dwdesigns avatar

dwdesigns

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

Re: Crazy cart totals using simple group discount

Also, the version info is:

Zen Cart 1.3.0.1
Database Patch Level: 1.3.0.1
v1.3.0.1 [2006-06-07 13:22:25] (Fresh Installation)

The group discount information is:

Group Discount

This module is installed
true

Sort Order
290

Include Shipping
false

Include Tax
true

Re-calculate Tax
Standard

Tax Class
--none--

Thanks so much for looking into this!

11 Sep 2006, 2:33 AM
#7
dwdesigns avatar

dwdesigns

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

Re: Crazy cart totals using simple group discount

I've set up another test account for you to have access:

User: [email protected]
Pass: tester

I don't know why the product price of $1.00 is repeated 4 times in that report --perhaps that's a clue to this problem. Thanks again.

11 Sep 2006, 2:36 AM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Crazy cart totals using simple group discount

NOTE: It is strongly recommended that you upgrade to v1.3.5 ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

11 Sep 2006, 2:51 AM
#9
dwdesigns avatar

dwdesigns

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

Re: Crazy cart totals using simple group discount

We're working off a modified template right now and I don't want to mess anything up with an upgrade. Besides, the upgrade process looks overwhelming. Certainly this problem can't be attributed to having a version that's only a few months old?

11 Sep 2006, 3:14 AM
#10
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Crazy cart totals using simple group discount

At a glance ... changes were made in v1.3.0.2 and v1.3.5 that effect the order totals ...

These changes may be part of the problem you are having ... I have not had time to break them down ...

I'd make a test directory and test database and copy your site to the test directory and upgrade the test database and switch to classic template and just see if the errors are fixed ...

NOTE: be sure when you copy your site to your test directory, as in /new_shop and load your database into a test database that you edit the two configure.php files to reflect the path changes and database changes ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!