[ic] Totals not correct

DB interchange-users@icdevgroup.org
Sun Mar 23 10:34:01 2003


>> From: Matt Kerner
>> 
>> We're having two consistent problems with Interchange and the totals
> of
>> orders.
>> 
>> 1. The order total does not include shipping (it is calculated, but
> not
>> added to the subtotal).
>> 2. The order total includes shipping, but only the subtotal gets
> billed
>> at the credit gateway.
>> 
>> I've been unable to find anything in the logs that would tell me what
>> is causing this problem.  Does anybody have an idea?  This is very
>> frustrating because it seems to happen on orders with expensive
>> shipping.
>> 
>> Thanks,
>> Kerner
> 
> Kerner,
> 
> Are you using UPS or FedEx online lookup for the shipping?  If you are
> then the problem is with your server contacting UPS or FedEx.  What
> happens is the shipping is calculated every time a subtotal, shipping or
> total tag is in a page.  So the person sees the correct shipping (the
> server was contacted) then when the order is being stored in the
> database or displayed on the receipt or mailed report your server cannot
> reach UPS/FedEx so shipping is set to 0.  The only way I know of to get
> past this, short of making IC use a cache for the shipping value or
> force IC to try multiple times, is to use static tables which reside on
> your server.  We went to that method for one of our clients after UPS
> went down for an entire day.
> 
> Good luck,
> -Ron
> 

Internal lookups are more work but I prefer to not rely on remote 
servers for the operation of my business.

DB