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 ...

    • 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 ...

    • Does Elliott Encrypt Credit Card Number in the Database?

      Q - Recently, we were asked if we are PCI (Payment Card Industry) compliant. One of the subjects that came up is whether or not Elliott stores credit card numbers in its database with encryption. Can you tell me if credit card numbers stored in ...

    • Credit Card Transaction Time Out

      Q - When I process a credit card transaction in Elliott, I receive a message window with the title "Finished Transaction Status" and the detail message like followings: E:System.Net.WebException: The underlying connection was closed: A connection ...

    • 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? ...