Rejected Orders

swood

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.

Tribulant

Thank you for your post.

The 'wp_wpcoorders' database table is correct, it contains all the orders.

There are 2 columns/fields in the table you can work with:

* 'completed' (Y | N) which tells whether the order has been completed by the customer.

* 'paid' (Y | N) which tells whether the order has been fully paid or not.

Please let me know if this helps.

swood

Thank you but I don't see a 'paid' column in the table.  Here is what I see in the wp_wpcoorders table:

id
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

I must be missing something???

cacheatnight

Swood, is this a plug in that you'd be interested in sharing?

swood

I wouldn't mind but it's pretty specific to the app that I'm interfacing with.  I don't know that it would be of much use to anyone else.

swood

Is the 'paid' field that Tribulant mentioned in his response a standard field in the wp_wpcoorders table?  Could I be working with a 'broken' version of the shopping cart software?  Is there any hope for a lonely subcontractor that is trying desperately to read from the shopping cart database and interpret the information that is stored there?  Sorry if I sound snarky but it is kind of frustrating to try to get information about a product that has virtually no documentation.

phil

Thanks for your reply.

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

bizert

I'm trying to do the same thing as Swood... Anyway to get in contact with Swood about what he setup to pull order info? Does this comment send an alert to him via email?

phil

Hi bizert,

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