We are having trouble with some simple addition of database cells not equaling zero. Does ECT do something funky with its maths? Or is it the XML line here that is causing the issue?

echo " <OrderTotal>" . ($rs['ordTotal']+$rs['ordStateTax']+$rs['ordCountryTax']+$rs['ordHSTTax']+$rs['ordShipping']-$rs['ordDiscount']) . "</OrderTotal>";
Where:
ordTotal = 38.28
orderStateTax = 0.00
ordCountryTax = 0.00
ordHSTTax = 0.00
ordShipping = 52.74
ordDiscount = 91.02

These should all add up to zero, but OrderTotal for some reason is 1.4210854715202E-14. This causes trouble when importing to Shipstation. It has been happening since the beginning so not something new.
Any idea where to look for the error?

Thanks.

Do your products have options, and if so, do the options impact the pricing?
I recall my Shipstation (I am on .asp) not handling order totals correctly, but it seems like it was related to product options.
I ended up edited the scripts and striped that stuff out.
I don't need ship station keeping track of every penny we take in.

Thanks for the reply Dave!

This order has no options. And for ShipStation those only factor into the unit prices, not the totals. So I don't think that holds the answer.

I would just create a .php test page and with an sql statement to see what's returned.
Obviously the store is working arithmetic correctly.
I was recently working with some of this (this tip I posted) https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=111261 and the cart handles this type of thing in a very straightforward way, so I would point the "finger" at the shipstation script first.

quote:

---

create a .php test page and with an sql statement to see what's returned.

---

You're already past what I know how to do!

I would also think ECT works in a straightforward manner, but the ShipStation XML file is really just that one line to calculate the OrderTotal:
$rs['ordTotal']+$rs['ordStateTax']+$rs['ordCountryTax']+$rs['ordHSTTax']+$rs['ordShipping']-$rs['ordDiscount']
I don't see how that could be a problem.

One thing that has me thinking it's ECT is that often, in Order Admin when I add a discount to a customer's order equal to the order amount, instead of making the total = $0.00, it makes the total $-0.00. So to me it looks like ECT is rounding things. You think no? Can the php test page you suggested tell us for certain?

Hi

I'm not an expert on this but it may be how PHP in general handles rounding rather than the arithmetic from ECT. Maybe someone with greater knowledge of the workings of PHP could confirm that for me.

Andy

Please feel free to review / rate our software