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

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

    • What Happens if Credit Card PreAuth Is Not Followed by Completion?

      Q - I previously "Pre-authorized" a credit card in Elliott. When I shipped the order, I used the "Sales" transaction instead of "Complete." That seems to work fine. So my question is what happens if I don't use the "Complete" transaction after the ...

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