ORDER STATUS

Sections:
Setup
Configuring Shipping
FulFillment

Order status is a webpage which the customer can view which displays the status of their orders. This page lists the last N orders with the shipping status. Each order can be clicked-on for a display of the full printable receipt for the order..

ORDER STATUS SETUP

Order status is setup by selecting which items are displayed in the status window.

SQL Select syntax used on the Order Status page. This SQL is used to select the columns for display on this page. The first column MUST ALWAYS be "orders.transactionid" (this is the column that is used in the order hyperlink).

The Order Status Page is controlled by:

• Application("urlfor_ORDERSTATUS") = "Store.OrderStatusV2.asp" - Set to Store.OrderStatusV2.asp for non-IFRAME V2 page
• Application("urlfor_ORDERSTATUS") = "Store.OrderStatus.asp" - Set to Store.OrderStatus.asp for IFRAME based page.

The SQL statement is setup with these variables:

• Application("OrderStatusSelect") - This contains the SQL Selection list.
• Application("OrderStatusSelectColLables") - This contains labesl for the selection list

The following DB tables are available for use in this SQL Statement:

• OrderLineItem
• Addresses
• customers
• Orders
• orderspostproc
• items

The order# column will not be displayed if Application("UseSeralizerInPlaceOfOrderNumber") = true. In addition, the serializer column must immediately follow the orders.transactionid in the select statement (see optional setting). If this is not true then the second column will not be displayed AND the serializer column will be displayed twice.

Examples of SQL:

• distinct top 30 orders.transactionid, date, Name
• distinct top 30 orders.transactionid, Serializer, date, ProcessStep

You use SQL select syntax which lists individual lineitems, but this can be confusing. It is better to have one entry per order displayed on this page. You should only include the shipping status column if orders are never split shipped.