AbleCommerce Shopping Cart Software

Is it possible to programmatically identify a specific order (based on OrderId) and change the status of the payment for that order - e.g. from "Authorisation failed" to "Authorised" (maybe using payment.PaymentStatus or PaymentStatusId)??

Check this thread
viewtopic.php?f=42&t=8681

Mazhar - that's very useful - thanks.

There is one issue - is there an ac_PaymentStatuses table in the DB? If not, where are the Payment Status flags stored?

The payment statues are defined in an enum. Its not something dynamic as is the case with order statuses.

Mazhar - you're a legend - thanks!

I am currently using an SQL backend on the site we are developing. We would like to know what tables contain the mappings for two fields from the table ac_Orders. The fields are PaymentStatusID and ShipmentStatusID. We have been unable to find the mapping tables for these ID fields, which I assume would be similar to how the field OrderStatusID is clearly mapped to the table ac_OrderStatuses. Any help you could provide would be greatly appreciated.

Those both contains the Enum values and doesn't come from tables. The case with order status is that you can create new statuses that's when they are implemented from table. Those order table fields represents the values of following Enums

CommerceBuilder.Payments.PaymentStatus and CommerceBuilder.Orders.OrderShipmentStatus

Thanks for the help Mazhar...

Where in the source code can this enum info be found?

These are in backend(CommerceBuilder) source code. You can view the definitions by using Object Browser window in Visual Studio or can download the API docs from here
ftp://ftp.ablecommerce.com/evals/Commer ... 7_Help.zip