|
Home > Archive > Commerce Server Solution Sites > December 2004 > Shipping Cost value missing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Shipping Cost value missing
|
|
| Alex V. 2004-12-02, 7:50 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
| |
| Nihit Kaul [MSFT] 2004-12-07, 5:49 pm |
| Hi,
I would recommended running a SQL profiler trace to figure out when this
order is saved and possibly updated etc.
Thanks,
Nihit Kaul[MSFT]
Commerce Server
http://blogs.msdn.com/nihitk
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
--------------------
From: "Alex V." <alexvaccaro@hotmail.com>
Newsgroups: microsoft.public.commerceserver.general,
microsoft.public.commerceserver.solutionsites
Subject: Shipping Cost value missing
Date: 2 Dec 2004 04:47:37 -0800
Organization: http://groups.google.com
Lines: 26
Message-ID: <1101991657.317043.139080@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 62.231.158.140
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1101991661 2495 127.0.0.1 (2 Dec 2004 12:47:41
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 2 Dec 2004 12:47:41 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=62.231.158.140;
posting- account=ivj8cQwAAADQII7SS7uPgmh_2X2XuooO
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwi
x.com!newsfeed.cwix.com!prodigy.com!news.glorb.com!postnews.google.com!f14g2
000cwb.googlegroups.com!not-for-mail
Xref: cpmsftngxa10.phx.gbl
microsoft.public.commerceserver.solutionsites:6001
microsoft.public.commerceserver.general:15176
X-Tomcat-NG: microsoft.public.commerceserver.solutionsites
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
| |
| Alex V. 2004-12-08, 7:47 am |
| I've found the bug. The page was not loading correctly because of
other changes in the code behind.
|
|
|
|
|