Search

[FinnishGifts]

I tried Get Batches for the first time and got an error msg:
Error - Unable to interpret credit card expiration '152593' in batch 1495, sale/credit 2.

The data in batch 1495 (with no confidential data displayed):
Sales Order  Invoice #  Card  Expiry  Approval  Amount
6981  3792887287  41*3797  11/2006  412043  $157.50
6982  3797678844  47*6420  7/2008  094918  $54.00
6983  3798055737  54*7706  5/2007  152593  $312.08
6984  3798774883  37*1001  7/2007  111503  $152.00
6985  3803648644  54*0315  2/2008  083814  $146.00
6986  3803444427  41*9374  4/2009  002493  $131.00
6987  3809787503  51*9160  9/2007  243363  $207.00
6988  3811644050  55*5342  1/2009  075381  $228.00
6989  3812193101  54*0791  10/2007  003498  $118.75
6990  3814181484  43*0578  11/2006  051538  $197.00
6991  3814977146  43*2733  3/2009  024823  $43.00
man-FS16302  3109  43*1929  09/2009  195279  $56.00
Total  12 for 1802.33

Credits Order  Invoice #  Card  Expiry  Approval  Amount
6798  3107  43*1559  6/2009    $39.25
Total  1 for 39.25

How to do I resolve this?

Ben Horn

[David Johns]

Ben,

Sorry for the late reply - I've been on the road today.  I took the list you gave below and reformatted it a bit to look like I would expect the batches text file from Yahoo to look (still preserving confidential data):

Batches through FinnishGifts Merchant Account 1111111111

Code Select Expand


000002 at Aug 13 18:55:12
  Sales                        Invoice    Card                 Expiry     Approval   Amount
    finnishgifts-6981          3792887287  4100000000003797     11/2006    412043    $157.50
    finnishgifts-6982          3797678844  4700000000006420     7/2008     094918     $54.00
    finnishgifts-6983          3798055737  5400000000007706     5/2007     152593    $312.08
    finnishgifts-6984          3798774883  3700000000001001     7/2007     111503    $152.00
    finnishgifts-6985          3803648644  5400000000000315     2/2008     083814    $146.00
    finnishgifts-6986          3803444427  4100000000009374     4/2009     002493    $131.00
    finnishgifts-6987          3809787503  5100000000009160     9/2007     243363    $207.00
    finnishgifts-6988          3811644050  5500000000005342     1/2009     075381    $228.00
    finnishgifts-6989          3812193101  5400000000000791     10/2007    003498    $118.75
    finnishgifts-6990          3814181484  4300000000000578     11/2006    051538    $197.00
    finnishgifts-6991          3814977146  4300000000002733     3/2009     024823     $43.00
    finnishgifts-man-FS16302   3109        4300000000001929     09/2009    195279     $56.00
    Total                                                                          $1802.33

  Credits                      Invoice    Card                 Expiry     Approval   Amount
    finnishgifts-6798          3107       4300000000001559     6/2009                $39.25
Total  1 for 39.25


When I imported it in this format it worked.  Here is what you probably need to do:

1. Go to your desktop and click on "My Computer" to bring up windows explorer.
2. In the "Address" box type "%temp%\SuperManager".  This should take you automatically to your windows temp folder SuperManager directory.
3. Open the file "batches.txt" in notepad.
4. Search for the batch you had problems with, "01495".
5. Look at the third entry in the list and see if it appears as it is above.  Do you see something that looks a bit different?  The most likely culprit is in spacing (or lack thereof).  Yahoo sometimes does not put a space between the order number and the invoice number.  When this happens The SuperManager does not know where the space is supposed to fall.
6. If this is the reason and add the space to the entry where it belongs (or at least where it looks like it might belong since there is no for sure way to know).
7. In The SuperManager go to "File" | "Import" | "Yahoo!" | "Batches File" and choose the file you have just fixed.

I beleive it will import for you then.  My experience has been that these type of errors are not very common.  You may run into similar problems with other entries that you will have to fix in a similar manner if they appear.  After they are imported you will be able to import future batches as long as they don't have the same problem.

Please let me know how it works out.

Thanks,
David

[Ben Horn]

David-

That worked. The Yahoo file had the text "number not available" where the cc number belonged.

Ben

[David Johns]

Ben,

Glad that worked for you.  Keep us posted of any other questions or difficulties.

Thanks,
David