Rank: Member
Joined: 2/17/2005(UTC)
Posts: 14
|
Our orders keep magically changing prices every time they are accessed.
We had a customer place an order for 10 units of a product. At 10 units, the price is $3.50 each. At the time the customer placed the order, the shopping cart somehow calculated the subtotal at $36.00 instead of $35.00. There was a $6.20 shipping on the item, resulting in a grand total of $42.20 for the order. This is what I see on the copy of the order receipt sent to me. The customer submitted payment of $42.20 for the order.
I pulled up the order today to print a packing slip and the price of the items has now magically changed to $3.40 each with BVC5 now saying that 10 * 3.40 = $35.00 and stating that the customer has now overpaid by $1.00. I generated the shipping tag, input the tracking number, and shipped the order. BVC5 now says that the unit price has magically changed to $3.30 per unit and that 10 * 3.30 = $34.00 and that the customer has now overpaid by $2.00.
First of all, it is not calculating a correct subtotal, which is shear idiocy. Secondly, why is it changing the pricing on our items every time that we access an order. This is EXTREMELY disturbing. What in the heck is going on?
|
|
|
|
|
|
Rank: Member
Joined: 2/17/2005(UTC)
Posts: 14
|
One further. When I then edit the order to manually force this thing back to the price that it is supposed to have, i.e. the price of the product when the order was placed instead of this magically decreasing price, it is now showing the product price to be $3.20 with a subtotal of $33.00. This is idiotic.
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
What version do you have? There was a bug prior to 3.1 that had this effect you describe with volume discounts. |
|
|
|
|
|
|
Rank: Member
Joined: 2/17/2005(UTC)
Posts: 14
|
We just applied 3.1, which fixed the subtotal problem. The magically changing prices are still there.
The problem is entirely on the admin side. The code calculates the volume discount based on a differential. In our case, the regular price is $3.60 and the 10 qty price is $3.50. That gives the engine a 10 cent discount applied to the item. I understand why it is using this differential method due to the fact that you can have product modifiers that change the price based on the option selected, but you still want to allow volume discounts to be applied.
However, on the admin side, the code over there is still using this same differential calculation which is absolutely invalid. Once an order is placed, the price is fixed, unless we MANUALLY adjust the price. What is happening is that every time we view an order, edit an order, ship an order, print an invoice, in other words every single time the order is accessed from the admin side, the code is recalculating the volume pricing differential, subtracting that amount off, recalculating the prices and storing it back in the database. If you access an order enough times, the engine will eventually decrement the price so much that it would be telling us that we need to pay our customers for purchasing our products.
The work around that we currently have is to open every single order that comes through and manually edit the prices to what they are supposed to be. This appears to force the code to quit subtracting a price differential from orders. That work around is rather idiotic.
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Your issue was fixed in 3.1, at least as far as the testing I've seen. I had your issue prior to 3.1. Eventually the products were free as it removed the volume discount each time you viewed an order. Once you manually edit, it won't change again with the pre-3.1 version. |
|
|
|
|
|
|
Rank: Member
Joined: 2/17/2005(UTC)
Posts: 14
|
We're on 3.1 and while the subtotal and grand total problems are fixed. The volume discount issue still exists for us.
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
volume discount was fixed for us in 3.1 -- are you looking perhaps at a Pre-3.1 order that still perhaps shows the old values? what happens if you add new items to a cart after installing 3.1? |
|
|
|
|
|
|
Rank: Member
Joined: 2/17/2005(UTC)
Posts: 14
|
Already tested that with a brand new order after installing 3.1. The subtotal and grand total calculate correctly. But, the item price is still decrementing every time the order is accessed.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.