Unique Rounding Problem

27 Feb 2011, 09:38

#1

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Unique Rounding Problem

In my product configuration, I have my price set to 32.95. However, when I go to checkout, quantities of 10 and under are priced correctly, but 11+ are not.

In my example, I'm using 11 items priced at 32.95/ea.
Step 1 of the checkout process is priced at 362.31 (32.937272/ea). But wait, it gets even worse. Once I get to step 3 of the checkout (after entering in credit card info), two different totals are presented!

I can't begin to tell you how unprofessional this is! :censored:

In the example, I'm using an address not taxable, so I know that's not the issue.
I'm using ZC 1.3.9h, current on everything. I have 14 mods installed, but none relating to pricing or products.

If anyone can help me figure this out and get rid of the rounding, I'd appreciate it!!!

27 Feb 2011, 14:24

#2

ajeh

Oba-san

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

Re: Unique Rounding Problem

Do you have Attributes on this product?

If you edit the Attributes do you have anything about price on them?

Is your Product marked as Priced by Attribute?

How do the prices look for quantity 10 and quantity 11 in the Shopping Cart?

What are your currency settings?

Is this in the default currency?

Is that currency marked as the value of: 1.0000

27 Feb 2011, 16:27

#3

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Ajeh,

Do you have Attributes on this product? I do have attributes.

If you edit the Attributes do you have anything about price on them? All of the attributes cost (0.00), they are more like options for me.

Is your Product marked as Priced by Attribute? It is set to NO right now; should it be YES??

I included images in my original post with both 10 and 11 quantities in the shopping cart. It won't let me upload them again.

Yes, this is in the default currency of USD, marked as 1.000000.

Thank you so much for your help! :yes:
Wendy

27 Feb 2011, 16:40

#4

ajeh

Oba-san

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

Re: Unique Rounding Problem

Attributes should be set as NOT Priced by Attributes ...

Priced by Attributes is used when you cannot determine a Product Price without the addition of the Attributes ...

Do you have an URL to your site that we could perhaps peek at and the products_id for this Product? :unsure:

27 Feb 2011, 17:07

#5

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Linda (Sorry, I didn't notice your real name last post!),
I am PMing you since the website is in a half-live state and you can't get to the shopping cart normally. :)

Wendy

27 Feb 2011, 17:17

#6

ajeh

Oba-san

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

Re: Unique Rounding Problem

How are you managing discounts on the quantity ordered?

27 Feb 2011, 18:01

#7

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Well aren't I just an idiot :lamo:

I added quantity discounts a few days ago, but it was so far down the priority line, I think anymore about it. Obviously.

Is there a way to delete the entire thread? I'm dying of embarrassment! :)

I am very sorry for wasting your time!!!

27 Feb 2011, 18:59

#8

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Although that still doesn't explain why the two subtotals different by a few cents in Step 3 of the checkout process (see image in first post)....Grrr...and here I thought it was taken care of.

27 Feb 2011, 19:26

#9

ajeh

Oba-san

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

Re: Unique Rounding Problem

I don't know how you are using the Discounts for the Products or how they are setup to see if there is an issue on the amount you are charging on the discount multiplied by the quantities ...

What version Zen Cart are you using?

If you switch to the Classic Template does that changing how the pricing works?

27 Feb 2011, 20:33

#10

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Linda,
I'm using Quantity Discounts under Product Price Manager to set up the pricing structure. I just took off all the discounts for the product and both totals are now correct. So it appears to have something to do with setting percentages in the price manager. Maybe if I tried using "Amount off" instead of "Percentage.... Let me try the different options in the discount box to see if I can't isolate the problem

I'm using 1.3.9h, admin says everything is current.

I am using the classic template.

27 Feb 2011, 20:43

#11

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Linda,
The problem is with the "Percentage off" option in the discount manager. Everything appears correctly and both subtotals are the same when I use "Amount off" (which works just fine for the time being, but it would have been extra nice to be able to use the percentage option).

28 Feb 2011, 00:38

#12

ajeh

Oba-san

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

Re: Unique Rounding Problem

What are the exact settings that you are using?

I cannot reproduce the problem ...

28 Feb 2011, 02:00

#13

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

Linda:
Product settings:
$32.95
NO: Free, Call for Price, Priced by Attributes
Qty Min:1
Qty Max:0
Qty Units:1
Mix: Yes
2 Attributes, both $0.00

Currencies Settings:
USD Default
Decimal Places: 2
Value: 1.00000

Product Price Manager Settings:
Discount Type: Percentage
From: Price
Qty: 11, Discount: 4
Qty: 21, Discount: 8
Qty: 31, Discount: 12

No Special Pricing or Sales enabled. Let me know if you need other settings.

28 Feb 2011, 05:41

#14

ajeh

Oba-san

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

Re: Unique Rounding Problem

I still cannot reproduce the error using the same settings ... :unsure:

28 Feb 2011, 17:06

#15

wendyandmilo

New Zenner

Join Date:: Jan 2010
Posts:: 34
Plugin Contributions:: 0

Re: Unique Rounding Problem

I can't think of what other settings would affect only the "Percentage" discount option.

But like I said, that option is the only one with a problem, and using "Amount off" is fine for me.

Absolutely bizarre.