In the ProductCart database, an order's current status can be found in the orderStatus column of the orders table. The value is always an integer between 1 and 6. Below is a description of each of the values.
Note that orders are first saved to the database when a customer clicks on the “Continue” button on the order verification page (pc/orderVerify.asp), before getting to the payment details page. The page that saves data to the database is pc/SaveOrd.asp. At that point, no payment information has been collected from the customer, and the customer has not decided whether to finalize the order. Therefore, ProductCart considers the order “incomplete”.
ProductCart order status codes
ProductCart payment status codes
The Payment Status can be found in the pcOrd_PaymentStatus column of the orders table
|Cancelled by Google||5|