| Alex V. 2004-12-02, 7:51 am |
| Hi,
I have a MSIB21 based site with CS 2002.
I regurarly send order information data to a 3rd party organisation by
querying the CS db.
Recentt I've noticed that the values for SHIPPING_COST and DISCOUNT
columns of the ORDERGROUP table in the transactions db return NULL for
all new orders. Up until then the values returned where 2.99 for
shipping (as specified in the Shipping Methods module of the BizDesk)
and 0 for discount (no campaigns set).
No changes have been applied to Shipping Methods or Discount rules in
BizDesk, the only change that occurred recently was an update on the
CheckoutReceipt.aspx page to include some pixel tagging (no change to
the code behind).
To make things more puzzling the total order value does include the
shipping cost (saved_cy_total_total column) and when I view an order in
BizDesk the value for Shipping Cost is displayed correctly on the page!
Although I haven't changed the C# code behind in CheckoutReceipt page
can it be that referencing the currentOrder object (value=<%=
currentOrder.Total %> ) from the aspx file is causing this problem?
Thanks
Alex
|