Pages: (2) 1 [2]  ( Go to first unread post ) Reply to this topicStart new topicStart Poll

> Order - Pay - Invoice - Status, Understanding the whole process
Posted: March 11, 2013 12:00 pm
Quote Post


Group: Members
Posts: 15
Member No.: 4,583
Joined: November 01, 2012

Yes, the invoice ID is included but the client ID is coming back as zero if there is no email or buyer name match.

Therefore, since we have the invoice ID, would it not make more sense to query the clients table with cl_id = inv_cl_id first before we try to match the client on email or name?

I'm away from my desk just now so am theorising a bit about field and variable names but you know what I mean.

Also or alternatively, could we not just post the client_id in the PayPal form and read in the result from PayPal?
PMEmail Poster
Posted: March 11, 2013 01:50 pm
Quote Post

The Janitor

Group: Admin
Posts: 3,638
Member No.: 3
Joined: August 25, 2006

If you look at the data being returned in your example above you will note:


Since PayPal is sending all the data back - you can use either of the 'IPN: Select Invoice By Name' to determine what client to apply the transaction to ............. provided that the data is indeed correct, and matches, in both your phpCOIN, and in the sandbox dummy account smile.gif

***** Unless otherwise stated, all replies refer to the following *****
--- The latest unmodified version of phpCOIN available from the phpCOIN download page on the date and time of this post.
--- All relevant HotFix files applied - One of the four included unmodified themes - The original language files .
--- Help will be given to install/configure/use phpCOIN, but not programming help to modify phpCOIN operations. If you are competent enough to make programming changes, you should be competent enough to read the source code and figure things out :)
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

Topic OptionsPages: (2) 1 [2]  Reply to this topicStart new topicStart Poll


Inscrita el Registro Mercantil de Mallorca Tomo 2140, Hoja No. PM-51034, Folio 135
This website owned and operated by: Technology Services RPVW S.L. CIF# B57345084
Avda Constitucion 48 Bajos Alaro 07340 Baleares SPAIN
Tel:+34 971518362    Fax: +34 971518368    eMail: