Customizing ProductCart - Order & Payment Status

Print Page | Close Window

Order & Payment Status

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=2297
Printed Date: 22-July-2025 at 11:20am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Order & Payment Status

Posted By: terencef
Subject: Order & Payment Status
Date 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

Replies:

Posted By: Greg Dinger
Date Posted: 02-January-2009 at 4:27pm

http://wiki.earlyimpact.com/developers/orderstatus - http://wiki.earlyimpact.com/developers/orderstatus

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |