[ic] Different total in backend then total in receipt and cc charge

Ron Phipps interchange-users@interchange.redhat.com
Thu Apr 4 00:11:01 2002


> From: Ron Phipps [mailto:rphipps@reliant-solutions.com]
> 
> We are working on bringing a new site live this week.  About an hour
> before we were set to launch we noticed that a test order had been
placed
> that had a problem.  The weird thing about this test order was that in
the
> backend and order history the order total was stored without the
Shipping
> included.  Here are the relevant columns from that order:
> 
> code		subtotal	shipping	salestax
total_cost
> TEST0073	2.16		10.52		1.01		3.17
> 
> As you can see the total_cost = subtotal + salestax instead of
total_cost
> = subtotal + salestax + shipping.  Where things get ever weirder is
that
> the total_cost used in the Shop Owner Receipt and the value that was
sent
> to Verisign has the correct value of 13.69.
> 
> I'm having a hard time understanding how the value was correct for the
> verisign charge (which happens before the order is placed in the
database)
> and order receipt, but was incorrect for the logging to the database.
> 
> I have only seen this problem happen in 1 our of 77 test orders and
have
> been unable to reproduce the steps to make this happen.  If someone
has
> seen this problem or if someone more familiar with the core can
elaborate
> on how this could possibly happen I'd be interested in hearing what
you
> have to say.
> 
> Thanks for your help,
> -Ron

Oops, I sent before sending all the relevant information.  Here is our
testing environment:

Redhat 7.2
Interchange 4.8.3
Perl 5.6.1
All Perl modules installed
Using UPS WWW Lookup
Catalog is custom built
Low Traffic (for development only)
Verisign

We have not experienced any environment issues with this installation.
Error logs are clear of any errors when the order was placed and the
tracking.asc shows the correct total_cost.

-Ron