Rejected Orders
I created an inventory management application that accesses the shopping cart database to get order information. I haven't been able to find a schema for the database so I did some investigation and found that the wp_wpcoorders table contains the information that I'm interested in. BUT, I don't know how to distinguish an order that has successfully completed the payment process from an order that has been rejected by the credit card authorization process.
Thank you for your help.
Comments
user
user_id
completed
pmethod
shipmethod_id
cp_shipmethod
cu_shipmethod
shiptrack
buynow
gc_order_id
fname
lname
email
euvatnumber
ship_fname
ship_lname
ship_company
ship_phone
ship_fax
ship_address
ship_address2
ship_city
ship_state
ship_country
ship_zipcode
bill_fname
bill_lname
bill_company
bill_phone
bill_fax
bill_address
bill_address2
bill_city
bill_state
bill_country
bill_zipcode
shipping
shipmethod_name
discount
tax
tax_percentage
subtotal
total
created
modified
The order gets the status Paid = Yes when the 'paid' column has the value 'Y' on all the order items. The items are in the database table wp_wpcoitems and references the order by ID with the 'order_id' column.
I hope that helps? Please let us know, I look forward to your reply.
Best regards,
Phil
Thanks for your post.
Swood should be receiving an email notification about posts in this thread, yes. Unfortunately we don't have his email so as to put you in contact with him.
Best regards,
Phil