Paypal email link

[dottor]

I have added successfully a email link on the invoice email page.

I can pull invoice number or any info i wish to the paypal link and have it fill the info in on the paypal page it is linked to except amount due.

The problem is the currency symbol is stored with the number in the database so a pull of

<invoice_balance_due>
<invoice_total>

both pull the symbol is there a possibility to store it in a field without the symbol or is there a field already with raw number only for total ?

I don't think I can use a strip function to pull the symbol out for the field.
Any suggestions ?

[K Software]

Where are you putting the link - in the invoice notes area?

I can add a macro that doesn't currency-format the number if that is the case.

[dottor]

I am putting it right in the email body
this is what it looks like



Dear JMHServices Customer:

Attached is a copy of your latest invoice for services.

Your current amount due is <invoice_balance_due>

NOTE: ALL PAYMENTS MUST BE MADE IN EURO"S

Please remit PayPal payment to paypal@jmhservices.com or

You can follow this link and enter the payment amount listed in the attached invoice.

https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=SPJRF3UHTG63N&lc=US&item_name=Invoice%20Number%20<invoice_number>&button_subtype=services&cn=Add%20special%20instructions%20to%20the%20selle r&no_shipping=1&currency_code=EUR&bn=PP%2dBuyNowBF%3abtn_buynowCC_LG%2egif%3aNonHost ed

Notice: Not paying outstanding debts will cause suspension of all provided services.

You can contact billing@xxxxx if there are any questions about this bill.

Please email support@xxxxx for any support issues you may have. You can create a support ticket and our staff will look into your issue.





I can add the amount due to the email with the <invoice_balance_due> and invoice number with <invoice_number> to the link and add the due amount if it didn't call the currency symbol also.

Its a simple add to the link if there was a call to database without the symbol.

it would look like this

https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=SPJRF3UHTG63N&lc=US&item_name=Invoice%20Number%20<invoice_number>&amount=<ammount_without_symbol>&currency_code=EUR&button_subtype=services&cn=Add%20special%20instructions%20to%20the%20selle r&no_shipping=1&rm=1&return=http%3a%2f%2fjmhservices%2ecom&cancel_return=http%3a%2f%2fjmhservices%2ecom&bn=PP%2dBuyNowBF%3abtn_buynowCC_LG%2egif%3aNonHost ed

and it would work fine

[hostu]

Interesting, is there any update to this idea, i have it working by using a donation link but the customer has to put the invoice # and amount in... NOT the best idea....

[K Software]

Putting a PayPal link in is possible to do now, you just have to put the link in the Body section and hope that the customer has HTML email support.

There is an alternative that I discussed with a customer on the phone today that would allow kBilling to automatically track payments via PayPal. Unfortunately it means adding an IPN script to your PayPal account that would point to a K Software server, where I would store that result until your kBilling install on your desktop was turned on and contacted the server to get the list of payments received. The invoice number and such could be passed in to PayPal links in that case and the whole thing could be automated. The question is - will kBilling users trust a 3rd party (K Software, in this case), to get *all* of their IPN notifications? I could do it, and I could do it honestly and securely so that I could never actually decipher any of the data myself, but would anyone buy into that? Would they believe such a system was safe and secure?

There is a competing billing software on the market now that does exactly what I'm describing, I'm just not sure I want to go that route and assume the risk and liability that comes with receiving payment notifications on behalf of kBilling customers.

[hostu]

This would work for me, but i have a question, if we have the ipn set at paypal for some other application, can or will paypal allow for more than one app, iam not sure but does the ipn point to a particular return url... anyway this or some type of paypal integration would make kbilling even greater, if a working example of a link in the email body would be a good start ... :D

[K Software]

I've been thinking about PayPal integration for years and there is only one way to do it. To have an IPN script on the kBilling server and have kBilling "phone home" to get any transactions. Unfortunately you can't send IPN notifications straight to the desktop.