Tuesday 16 November 2010 3:30:02 am
Apologies if this has been addressed, but I could not find any mention which did surprise me as this is a potential fundamental flaw in the shop module. If you apply a discount of for example 30% to products in the webshop, the calculation produces numbers of many decimal points. These are rounded for the display in the shopping basket. However, the stored number that is used to produce the total is not rounded. Therefore, as the number of products in the basket increase, the totals do not equal a sum of the listed products. In large shopping baskets this can add up to a difference of 10s or cents, which becomes unacceptable. Because of rounding, the totals are less than the sum of the line items so customers are not being overcharged, the problem for me is that the order is generated by the shop module, but invoices are generated by my ERP system which does get the pricing correct, so customers think they are being overcharged from their order. does anyone have any ideas how to fix this, as getting the totals correct should be quite a fundemental element of a shopping cart. Update. Even if you do not apply discount, the rounding error effects the excluding VAT total and the amount of VAT. If you are preparing your VAT tax returns from the webshop calculations, they will be wrong. You will be paying to much VAT so the tax man will be happy.
www.peakm3.com
|