How to Find Orders That Have Been Pre-Authorized for Credit Card Charge

How to Find Orders That Have Been Pre-Authorized for Credit Card Charge

Release Date: 8/7/2018

Q - I am in the process of implementing Elliott online credit card charge processing with pre-authorization through the COP Order Payment window. I need to develop a separate process to identify orders that have been pre-authorized for credit card charges.  Could you suggest what would be the quick and easy way to identify a pre-authorized order?

A -For the order that has been preauthorized, you should be able to see the order_comment1 with text like:

                PreA *3546   $194.19 TX#179235969

See sample screen below:



So you could use the following SQL statement to find the pre-authorized orders:

    select order_no, order_comment1 from cpordhdr where order_comment1 like 'PreA%';



EMK


    • Related Articles

    • Does Elliott Support Credit Card Pre-Authorization Transactions?

      Release Date: 07/17/2020 Version: 8.0 & Up Q - We are doing more and more credit card charges lately, which is also increasing the amount of adjustments that need to be made to order totals. Do you have a way to "pre-charge" a card for a number of ...

    • How to Charge a Credit Card If Pre-Authorized for the Wrong Customer

      Q - We tried to complete a credit card charge with a pre-authorization for the wrong customer. Since we don't keep the credit card number when we do the pre-authorization, how do we go about completing the credit card charge for the correct customer? ...

    • Credit Card Processing Frequently Asked Questions

      Q - If a customer wants to give us new CC information for their next order or a new Expiration date and Sec # for a CC that has been used recently, is there a way to enter that information at that time if we do not have an order to process? A - You ...

    • Elliott Credit Card Processing Summary

      Release Date: 6/10/2024 Version: 8.5 & Up Summary Elliott Credit Card Processing is a real time solution that works with payment gateways that support all levels of processing (Levels 1, 2, and 3 depending on the payment gateway.) Currently, there ...

    • Feature - Online Credit Card Interface Level 3 Support

      Release Date: 4/21/23 Revised Date: 12/20/23 Version: 8.5 and Above Introduction Elliott currently supports credit card level 2 transactions. This means, in addition of passing the credit card number, expiration number info when charge a credit card, ...