Order Status Codes
When an order is saved
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 also considers an order "incomplete" anytime a customer can't complete an order due to a failed payment.
The Payment Status can be found in the pcOrd_PaymentStatus column of the orders table
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 also considers an order "incomplete" anytime a customer can't complete an order due to a failed payment.
ProductCart order status codes
ProductCart payment status codes
The Payment Status can be found in the pcOrd_PaymentStatus column of the orders table