Remotely Hosted Payment Page - Possible?!?!

Merlinpa1969:

looks like you missed an addition the the DB insert in the origional checkout_process.php file from OSC

You mean to get the e-Path order value into the DB? I didn't even think about that one. can you tell me where and how?

Hi Merlinpa1969 and Vger,

Just an update on trying to get ZC to handle the returning customer from a remotely hosted payment page the same as OSCommerce does, no luck I'm afraid.

There is no way to include the returning payment receipt number in the string from the remotely hosted payment page and have zen treat the order as complete.

I hope this will be addressed in some future version of Zen because OSCommerce seems to have a clear advantage here - as much as I hate to admit it.

But thanks for your feedback and help.

Thanx

I doubt that zen cart is going to totally redesign the cart from the center out so that your module can add ?ord=

you can strip the ?ord= off of the return url. and this will let the otders complete.

Merlinpa1969,

If the ord field does not come back holding the unique receipt number - which is included in the order emails to the admin, then admin will never know what payment is for what order.

It is my understanding that ZC can not include the actual order number to ANY remotely hosted payment page at checkout because it hasn't created it yet - hence the need for the time function in the module so ZC can send a unique order number to the remotely hosted payment page which it gets back to associate the order with the payment. So the admin gets this.....

The Fruit Box Shop - E-Path Demo

Order Number: 39
E-Path Receipt Number: 1150087904
Detailed Invoice: http://thefruitboxshop.com/oscommerce2/account_history_info.php?order_id=9
Date Ordered: Monday 12 June, 2006

The admin then knows that e-Path's payment authourisation 1150087904 relates to order 39 (the above snippet taken from the OSCommerce order email)

Otherwise admin would get order confirmations and won't be able to figure out what payments are for what.

Either I'm missing something or this is how it is with ZC. I don't think its a matter of them having to rewrite everything. Its really only a matter of ZC needs an order number when you send to a remotely hosted payment page so it can be returned and dealt with by ZC as order completed. At the moment ZC can't do this, this is why I have ZC send a time stamp number which is cleanly sent back to it and recorded in the confirmation email. But, as you've pointed out, ZC can't do this.

Can you think of any other way? I can't and I've been on it non stop for the last 24 hours.

But I appreciate your continued thoughts on it.

Just because you need an order id returned to match up with order received it doesn't mean that the order id has to be in the url - which is the problem (as far as I can see). It only needs to be added to the order confirmation email which is generated upon return.

Vger

Well in your example the admin would get plenty of orders from Zen all saying the right stuff.

He'd then go to collect all this E-Path payemts and not one of them would have a corresponding order number, how is he/she going to know what payment authourisation belongs to what order?

Without that unique order number going to the remotely hosted payment page, which is also used to identify that payment, it all would be lost. And you can't really have two time functions creating a uniqe order because they would be created at slightly different times thereby both would be different.

I just can't see a solution.

I told you how to be able to get it back to the site with the ord number attached

use & rather than ?

I tried that before and no order numbr came through on the emails, but I've just asked e-Path to do it again and leave it there so you can see.

Just make one, and here is the order email that comes through...

Order Number: 5
E-Path Receipt Number:
Date Ordered: Thursday 15 June, 2006

Note no numbers for the E-Path Receipt Number.

Putting the "&" strips the ord=xxxxxxx from the string soere are no numbers for ZC to pick up and put in the email - nobody knows what payment is for what order. So putting the "&" is a no go I'm afraid.

Thanks for your thought though.

The reason you can't see a solution is not our fault.

All that you need to do is to pass a field with the Order Id in to the payment processor (it can be a hidden field which does not appear in the html output nor get displayed on the payment form page), which then gets passed back to you unchanged. The Order Id is then added to the Order Confirmation email, but does not appear in the url.

Vger

jumbuck2:

Well in your example the admin would get plenty of orders from Zen all saying the right stuff.

He'd then go to collect all this E-Path payemts and not one of them would have a corresponding order number, how is he/she going to know what payment authourisation belongs to what order?

Without that unique order number going to the remotely hosted payment page, which is also used to identify that payment, it all would be lost. And you can't really have two time functions creating a uniqe order because they would be created at slightly different times thereby both would be different.

I just can't see a solution.

Vger:

The reason you can't see a solution is not our fault.

All that you need to do is to pass a field with the Order Id in to the payment processor (it can be a hidden field which does not appear in the html output nor get displayed on the payment form page), which then gets passed back to you unchanged. The Order Id is then added to the Order Confirmation email, but does not appear in the url.

Vger

Easier said than done. Here is my thought flow in attacking this....

ZC does not create a unique order number that can be sent to a remotely hosted payment page. It is my understanding the order number is created after this point.

Now, the remotely hosted payment gateway (all of them not just e-Path) needs to know what order it is accepting payment for, so it can tell the merchant, quite apart from ZC. This is a pretty basic thing.

OK. because ZC can't give that order a unique number at the time when the person clicks "check out" I make ZC create a unique order number with the time function (contained within the payment module). This means that a particular number can then be a ZC number assigned to that order and it will go to the gateway so the gateway has a number to quote to its merchant in its own advice.

OK, so far so good. The last step is to ensure this same unique order number gets included in ZC order confirmation emails.

Bottom line is there needs to be a single number that goes to the remotely hosted payment page that also must appear in the order confirmation email so the merchant knows what payment is for what order, or visa versa.

This is my line of thinking, please correct me if I am wrong here.

Thanks

Vger presented you with the solution,
have epath pass the number back as a hidden variable, then you dont have to worry about it not returning to checkout_process and it will then be readable by the code you are installing.....

and for the record paypal passes the order number 1 on every order.

Hi Merlinpa1969,

Understand however the e-Path receipt page that passes the customer back is not a form function, its a straight link so I can't use hidden variables.

You need to look at some other payment modules, which assign a unique order id based on a random number generation code in the payment module itself - which then gets passed to the payment processor, returned to the website, inserted into the database and into the order confirmation email. At no time does it appear in the url e.g.

//Generation of the order_id
      srand ((float) microtime() * 10000000);
      $r1 = rand(100,999);
      $t1 = date("yz-his");

      $sequence = "Company Name order $t1";
      $ordernum = $t1;
      if (!empty($_POST['OrderId'])) $ordernum=$_POST['OrderId'];

This is from an HSBC e-Secure Payment Module.

Vger

Just had a form function installed on the e-Path receipt action is the returning address as supplied by ZC and the hidden variable containing the order number

POST = ZC closed off the order OK but number not passed to confirmation email.

GET = ZC fails to close off the order.

I've tried the code above as well as quite a few other varieties and methods from other modules but with no luck.

I should qualify my last sentence. No luck meaning getting it included in the ZC confirmation email. Generating a unique number in the payment module is simple but getting that same number in the ZC confirmation email is not possible from what I can see.

Did you actually edit the order confirmation email to echo the $order_num variable?

Vger

jumbuck2:

I should qualify my last sentence. No luck meaning getting it included in the ZC confirmation email. Generating a unique number in the payment module is simple but getting that same number in the ZC confirmation email is not possible from what I can see.

I'm looking for a slight variation of the Remotely Hosted Payment Page, basically manually processed credit cards on a remote secure service.

Just like cheques and COD, I don't need the payment page to report back that a payment has been successful or not, just that payment is pending.

But I do want to pass the cart total, order number, etc, to my secure server (like the Paypal page does).

The OfflinePayment module doesn't link through to the remote site. Any suggestions?

Regards,
Ian Tresman

Once again the order MUST be returned to the cart to trigger the order creation.
The return url to checkout_process trigers a successsful order Just like cod or MO or stock credit card.

a return to checkout_payment means something failed and needs to trigger a response.

Merlinpa1969:

Once again the order MUST be returned to the cart to trigger the order creation.
The return url to checkout_process trigers a successsful order Just like cod or MO or stock credit card.

a return to checkout_payment means something failed and needs to trigger a response.

OK, I think I can get my remotely hosted payment page to return to the appropriate page. I assume that the Cheque payment option does this in one step.

Is a module available that will let me pass the customer's order details to my remote server?

Regards,
Ian Tresman

yes check money order. CC and COD all pass this information to checkout process then trigger checkout success

I dont know who your processor is,
there might be a module, but as others have found out mods for other carts dont always work, and even the ones that do require lots of work