Editing Payment System (section)

= Payment-related emails = 
== "No Payment Received for JohnCompanies account - Action Required - WARNING - SHUTDOWN IMMINENT" ==

<pre>(NOTE: this is the 4th notice we have sent in 6 weeks - please respond immediately)


Re:

Hello,

Our records indicate that your billing is not current for your JohnCompanies account -
you may have recently changed billing information or perhaps initiated new service or
altered existing service.

This is not a problem - we simply need you to immediately visit your Account Manager via
this link:

https://secure.johncompanies.com/am/billing.html?cid=col02020

which contains your current and/or past-due charges in detail. Please do contact
payments@johncompanies.com if you have any questions at all.

Thank you so much for your continued business - we appreciate it greatly,

JohnCompanies Hosting
</pre>

We send out automatic notices to customers who were paying via credit card (have a negative ledger balance) and are marked in the database as in arrears. The send schedule is (subject addendum):
week 1<br>
week 3 ("SECOND NOTICE")<br>
week 5 ("THIRD NOTICE - PLEASE RESPOND")<br>
week 6 ("WARNING - SHUTDOWN IMMINENT")<br>
and weekly thereafter

'''Action to take:''' Once we see the WARNING - SHUTDOWN IMMINENT notice, we take action to put their server on shutdown in mgmt. We set a cancel date for 10 days in advance and set a note like: "20121024 - no pmt, setup shutdown"

== "batch gather report - 5 ($-1720)" ==
<pre>
accounts with balances: 50
items added to pfp batch queue: 5 ($-1720)
accounts with alternate (non-ccard) pmt source: 41 ($-16920.06)
</pre>

Shows you how many accounts have balances (50) how many items were added to the batch and their cumulative value (5, $1720) and the number of accounts and the amount due for customers with no valid payment source (41, $16920.06)

'''Action to take:''' Watch that the [[#.22batch_process_report_-_4_.28.241596.29.22|batch process report - 4 ($1596)]] email roughly matches what was gathered today. Delete email.

== "batch process report - 4 ($1596)" ==
<pre>
items processed: 9
items billed successfully: 4 ($1596)
items failed to bill: 5 ($629)
</pre>

Shows you how many items were in the queue. How many were billed successfully and the total amount (4, $1596), and the items that failed and their value (5, $629)

'''Action to take:'''Make sure ''something'' was processed today- maybe a payflow error? Delete email.

== "failed pfp_batch item for col01788" ==
<pre>
RESPMSG:Declined: 15005-This transaction cannot be
processed.;X-VPS-REQUEST-ID:1349989805Scol01788;CVV2MATCH:X;AVSADDR:N;PROCCVV2:I;PROCAVS:
N;HOSTCODE:15005;PNREF:EQFP7B38D1B3;RESULT:12;AVSZIP:N;IAVS:N;
</pre>

Indicates we have tried to bill this card 5 times and it has failed each time, and now the customer has been placed in arrears (will get automatic email reminders with payment link) and their charge has been removed form the payflow batch queue [[https://secure.johncompanies.com/mgmt/pfp_batch.html https://secure.johncompanies.com/mgmt/pfp_batch.html]]
In the body of the email you can see details about the reason for failure, usually a decline (as in this example).

'''Action to take:'''Make sure it's a standard decline and nothing else wrong. Customer is in arrears, they'll be emailed. Delete email.


== "Subscription cancelled for S-1111111111111" ==
'''Action to take:''' See [[Payment_System#Cancelled_PayPal_Subs|Cancelled PayPal Subs]]. Delete email.

== "successful pmt for col01111" ==

<pre>
RESPMSG:Approved;PPREF:0RH20660AL5779445;AUTHCODE:111111;X-VPS-REQUEST-ID:1349524679Scol0
2154;CVV2MATCH:Y;AVSADDR:Y;PROCCVV2:M;PROCAVS:Y;CORRELATIONID:20f200c78b60e;PNREF:ESYP9EC
9E9FF;RESULT:0;AVSZIP:Y;IAVS:N;
</pre>

This shows that we have a successful payment ('pmt') from this customer. You may search for the payment in PayFlow via the PNREF ID ('ESYP9EC9E9FF'). You can also see some fraud filter results in this email:

<tt>CVV2MATCH:Y</tt> cvv matches (Y=match, N=no match, X=not supported by bank)

<tt>AVSADDR:Y</tt> address verification matches (Y=match, N=zip match, X=not supported)

<tt>PROCCVV2:M</tt> verbose cvv match info (S=not supported, U=unavailable, W=whole zip, X=exact match, Y=yes, Z=zip)

<tt>PROCAVS:Y</tt> verbose address verification info (M=match, N=no match, P=not processed, S=not supported, U=unavailable, X=no response)

'''Action to take''': Clear arrears for customer. Delete email.

== "successful S for 68479f46" ==
This means a new customer paid via cc. '''S''' means we collected $. '''A''' means it's only an auth (in the case of a colo) and we will need to collect funds later.

'''Action to take''': rename the cc info file (see [[#.22New_ccard_order_68479f46.22|New ccard order 68479f46]]). Delete email

== "New ccard order 68479f46" ==

<pre>
From: Chad Whitacre
gpg --decrypt /usr/local/www/ccard_orders/done/43b7214f

-----BEGIN PGP MESSAGE-----
Version: Crypt::OpenPGP 1.03

hQEOA/J4/DszoRXaEAQAiNS5gAlrM0XQLMvUnJvq8GWQUptOZvXbIInoCYlWUrMG
ZMLoIuNLua6IlBjV2yJg+r0f8jhsMfsiD+kIZq7xo8sEVfSXaKtGNsi1K8KejUYh
ZKclJh4DULOeTRiumg0rsgbvldgs7JlHa/WfyawJjhD4oV8YJy5c6KyDic4hFmoD
/jmsi60I8bfkgMQ+5SRM8FcMKL4evuheRLvvFbI4f8SoOzR+LsQPsn+hfTsC/Qp8
X2YjCp6w2Oyxz5TZE4SMeVOP70aR1RK7dhr2NQPTr6pFNM3b3zGIgSx8AEs8pgsy
Yv+cVEjV/iUv+lFpBxqqoid53YNTx9pP+kPMjLLKJk6b0sAdAbxG68FtgnBybMui
gMbf92ji+IR87q0D16/nPjzsAv3s7zRw/nzZIOlgQ1/GAFEF7VSyQHzOkd9UQuS0
kU0XXrUpVi0v0PGc9nMWjBA5d2YsaqDrZRxFgzCqwBmhxMHAQqQMzfaEyQIL4EF0
LUpVe4cWiI3aSjPx0aC7bFrioqqXl8vJNfiFMgt1gY6J1PQ4S/wRgmLDNcJrejAA
483biJUsDF4S02JK3QLbUcYN/2NJE2M0/cO88DXXZvm6B7jc0URMN5ytYrv3SYHu
VGuNRCbdaicekD6VnF9EkUA=
=zKlm
-----END PGP MESSAGE-----
</pre>

This is the encrypted cc info. It's viewable in the email and placed in a file (<tt>/usr/local/www/ccard_orders/done/43b7214f</tt>) on mail. It needs to be renamed to the customer's final CID:

<tt>mv /usr/local/www/ccard_orders/done/43b7214f /usr/local/www/ccard_orders/done/col0NNNN.gpg</tt>

This file can be decrypted (gpg --decrypt /path/to/file) to get at the info.

'''Action to take''': rename the file. Delete email.

== "failed pmt for col01111" ==
<pre>
RESPMSG:Duplicate trans: 10536-The transaction was refused as a result of a duplicate
invoice ID supplied.  Attempt with a new invoice
ID;PNREF:ETHPA078CA93;RESULT:30;X-VPS-REQUEST-ID:1349657543Scol01034;HOSTCODE:10536;
</pre>

Pretty self explanatory. Their payment failed, and they do know about it. This is sent to us so we know it happened, in case (in the case above) the fault was our own. Most of the time the reason will be a plain old DECLINE. 

'''Action to take''': None, unless the fault is our own. The customer should go back to the payment page and try to pay again. Delete email.

== "Unknown IPN type:" ==

<pre>payer_email => lenderreviews@gmail.com
first_name => Randall
item_number => 0003
payment_gross => -39.00
mc_currency => USD
receiver_id => 8EKTVPV9MKWF4
ipn_track_id => 15729a938d26a
invoice => a9ca993f
subscr_id => S-5SK10643PA3743414
reason_code => other
business => payments@johncompanies.com
charset => windows-1252
mc_gross => -39.00
custom => type=pp
last_name => Marquis
notify_version => 3.7
payer_id => 9VGJXDXGDW2GC
residence_country => US
mc_fee => -0.74
payer_business_name => Lender Reviews, LLC
txn_id => 0N451285L6563193U
cmd => _notify-validate
verify_sign => AhWl7ACVsSRPc7TyALD6xAJDmOYcAWCn9nISbtkuorhGfhawdKvf6fsV
parent_txn_id => 4SC12038JA710930G
receiver_email => payments@johncompanies.com
item_name => JohnCompanies.com Colocation - $39.00/1 month(s)
payment_status => Reversed
protection_eligibility => Ineligible
payment_date => 12:02:18 Sep 26, 2012 PDT
payment_fee => -0.74
transaction_subject =>
payment_type => instant
</pre>

Paypal sends us notifications (IPN) for everything that happens with our Paypal account. Most of these IPNs are quietly handled by our billing system. Occasionally, something happens that our billing system doesn't recognize or our billing system wasn't made/meant to handle so it sends this email to let you decide what to do.

Looking through the parameters we see that this was a funds reversal: <tt>payment_status => Reversed</tt>

You can login to paypal and get more info about this by [https://history.paypal.com/us/cgi-bin/webscr?cmd=_history-search searching] on one of several items:<br />
payer email: <tt>lenderreviews@gmail.com</tt><br />
transaction ID: <tt>0N451285L6563193U</tt><br />
subscription ID: <tt>S-5SK10643PA3743414</tt><br />


'''Action to take:''' customer needs to be re-invoiced and likely the sub was cancelled as well.