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

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

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

    • How to Reverse Credit Card Sales

      Q - What is the process to reverse out a credit card sale that hasn't been picked, invoiced, etc.? A - The following outlines the procedure depending on whether you had to delete the original order or keep the original order: If you deleted the ...

    • What Is the Credit Card Authorization Member Field for?

      Release Date: 07/21/20 Version: 7.5 & above Q - We don't know what this field means or if we should do something with it when running credit cards. In the screenshot below, that name in the Member field does not match the name of the credit card ...