Order & Payment Status

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Can anyone please help with the following:
I need to trigger a custom process when an order is placed eg. monitor the order & payment status
I could not find the status code table but I managed to get these codes from the orders table..
=================================
Order Status Codes
Pending = 2
Processed = 3
Shipped = 4
Cancelled = 5
Return = 6
Partially Shipped = 7
Shipping = 8
Partially Returned = 9
=============================
Payment Status
Pending = 0
Authorized = 1
Paid = 2
Refunded = 6
Voided = 8
============================
There seem to be some missing, can someone point me to the table that has the codes or fill in the ones that are missing.
Is there a published ER Diagram/Data Dictionary for the database explaining the structures?

Thanks in advance

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
terencef Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-May-2008 Status: Offline Points: 0	Post Options Post Reply Quote terencef Report Post Thanks(0) Quote Reply Topic: Order & Payment Status Posted: 02-January-2009 at 4:15pm
	Can anyone please help with the following: I need to trigger a custom process when an order is placed eg. monitor the order & payment status I could not find the status code table but I managed to get these codes from the orders table.. ================================= Order Status Codes Pending = 2 Processed = 3 Shipped = 4 Cancelled = 5 Return = 6 Partially Shipped = 7 Shipping = 8 Partially Returned = 9 ============================= Payment Status Pending = 0 Authorized = 1 Paid = 2 Refunded = 6 Voided = 8 ============================ There seem to be some missing, can someone point me to the table that has the codes or fill in the ones that are missing. Is there a published ER Diagram/Data Dictionary for the database explaining the structures? Thanks in advance

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 02-January-2009 at 4:27pm
	http://wiki.earlyimpact.com/developers/orderstatus