Barclays ePDQ help please:)

Hi there, I'm currently installing the ePDQ module on my 1.3.8 zencart and the final step is to password protect the /epdq/ directory. How do I do that?? Honestly, you'd think I'd be able to figure it out but no...:frusty:

I have a H-Sphere host control panel and Ipswitch WS-FTP pro FTP program...

Thankies!

Try using a .htpasswd file.

I used to have ePDQ, updated the site from 1.2.4 to 1.3.8 and now, obviously ePDQ is broken. Any chance you could share your files, if you think you've got it working?

Thanks,

Tryf

OK, so one thing I've just found is that both epdqresponse.php and epdq_response.php refer to this database table: tblTransLog, however, my table is actually called tbltranslog - so I have to simply change the name to lower case in both files.

This ePDQ situation is ridiculous, we really do need to get the mod on here as one set of files for 1.3.8 - does anyone actually have them, or are we all about to get there at the same time?

Im having problems with the final return to the store. I can take payment, but the final return doesnt work. I get a problem with the translog thing to.

When im looking at my database though, i cant see tblTransLog...

Where is yours?

Cheers Rob

Hi Guys i have just installed a new zencart and the epdq mod.
Havin major problems with this mod and not really getting anywhere.

When submitting an order to epdq all i get is:

**Sorry, there has been a problem processing your payment.

Mandatory information not present.**

Not sure weather its a security thing or the mod isn't working correctly or i have installed wrong, any ideas?

@rtnewton - Did you fill out all the information requested when you installed the mod? In particular the passphrase?

@thesoapycaldron - if you're using the current Zen Cart mod for the CPI service there is no need to password protect any directories.

everybody else ... no idea what this translog table is. What ePDQ services are you trying to access? What mod are you using? Where did you get it from?

@thesoapycaldron

Are you using CPI? If so the references in the ePDQ documentation to password protecting a directory are to protect the script that would be executed when transaction information is returned from ePDQ. However, the ePDQ mod in the free add-ins area above, doesn't support this. Presumably store owners would need to reconcile orders with payments via their CPI admin page.

Moreover, there seems to be a gaping compatibility issue between ePDQ and Zen Cart. ePDQ CPI assumes that an order is created prior to calling it to to process the payment. Zen Cart is built on the assumption that you don't want your database cluttered up with faled orders, so doesn't create one until payment is received.

And it gets worse.

ePDQ assumes that you already have the order recorded, takes the payment but doesn't force the customer to return, so you have money, but no order. The information is sitting there (at least temporarily) in the customer's basket recorded in the database - but may be lost or changed if the customer subsequently returns to the site.

Can it get worse? Well, yes!

If a client returns to the site from ePDQ, the mod in its current treats that as a success, even if the payment was declined. Order for processing, but no money. Ouch. Those reconciliation processes that the ePDQ docs bang on about are rather important. BUT, worse still, the only reference that ePDQ has for the transaction is a random number generated by the mod and then thrown away. Aie, aie, aie.

The only way that I can see to get around this at the present, is to re-order the Zen Cart checkout, to create an order with a new "unpaid" status before going to ePDQ, and expand the ePDQ mod to take full advantage of the POST information.

If somebody has a better idea, I'd really love to hear it!!!

I see what you mean and yuck, those are nasty scenarios.

I've just finished (well so I thought) a site for a guy using the epdq system and so far the site's quiet so there haven't been any problems but if someone can come up with a solution - maybe a few of us can club together to pay for someone to come up with one then I'd be happy to. If, and hopefully when, his business grows the last thing I want is for there to be payment problems.

Thanks,

Richard

Hi Richard

We actually sorted this. After several long and sometimes useful, sometimes unproductive conversations with Barclays we got to the bottom of all that what was happening.

For the record, the earlier statement has proven to be completely accurate. And don't be fooled by the message on the final ePDQ page that implies that in fact a transaction is only confirmed if a customer presses that last button. This is not the case, the transaction has been done and the wording is just to try to encourage customers to return to your store.

We therefore built a version that notified Zen Cart as soon as the transaction had gone, and had Zen Cart immediately create a corresponding order. Perfect. Except that after working perfectly on our test server, it reused to work in the same way on the client's web host's server (a Zen Cart-certified host).

So we ended up building two process flows with a switch. One of the flows is optimal, the other has a hole, but with a way to catch and deal with anything falling through it.

Along the way we added an audit trail table and took advantage of more of the ePDQ options (such as not requiring that customers re-enter their shipping information).

I'll post this as an add-in. I'd be interested to know how it works for other people. Won't be supporting it though. I was glad to see the back of it and wouldn't recommend ePDQ unless absolutely necessary.

Thanks for your reply. Just to check, I'm using this module:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=1040

I presume this is the correct one? The add in would be really helpful and gratefully appreciated. Thanks for your help - I agree, this has been the most problematic of all the payment providers I've used.

Thanks,

Richard

rpain:

Thanks for your reply. Just to check, I'm using this module:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_48&products_id=1040

I presume this is the correct one? The add in would be really helpful and gratefully appreciated. Thanks for your help - I agree, this has been the most problematic of all the payment providers I've used.

Thanks,

RichardRight add-in. Wrong version. I've had confirmation that my update (well more of a replacement really) has been approved, but it's not appeared where it should. I'll follow up with the Zen Cart team and see if we can find out where it's hiding.

My bad. Didn't read the email properly, it was the confirmation rather than the approval. But it's up now.

Thanks - I'm now so nearly there. I get through the checkout and all is well. The details appear in the epdq boxes which is great. The problem is that I get the technical problem page. The payment registers in the epdq admin area but the order doesn't appear in the zen admin area. Not ideal I think you'll agree.

I've looked at the log table all through the order process and no temporary order is created. The log file says:
temporary order ID c3-o1 not recognised in ePDQ log table.

I also then tried:

http://www.websiteaddress.co.uk/epdq_cpi_handler.php?oid=c3-o1 (the order id from the epdq area) and still get the technical problem page.

Help please!

Also - step 1:

The "Allowed URL" will usually be https://YOUR-SITE-URL/index.php?main_page=checkout_confirmation and the "POST URL" will be http://YOUR-SITE-URL/epdq_result.php.

should be:

The "Allowed URL" will usually be https://YOUR-SITE-URL/index.php?main_page=checkout_confirmation and the "POST URL" will be http://YOUR-SITE-URL/epdq/epdq_result.php.

• I'm guessing :-?

I really think you're doing a great job - it's just a shame the epdq system is so horrible.

Richard

Anyone?

I won't bump again it's only because I've currently taken the payment option down as it's not working.

Thanks,

Richard

What do you have in the epdq_log table?

And you're right about the installation instructions.

The log table remains empty all the way through.

Richard

OK - I think I know where the problem lies.

The header_php.php file has the following code:

if (isset($$_SESSION['payment']->form_action_url)) {
$form_action_url = $$_SESSION['payment']->form_action_url;
} else {
$form_action_url = zen_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');
}

The system seems to just want to send me straight to the barclaycard site and avoids the checkout_process page which is why it's not adding a temporary order to the epdg_log table I'm guessing. I tried just changing the code to:

$form_action_url = zen_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL');

• to force it to go to the checkout process page but that came up with the technical_problem.html page. The error in the log is 'Temporary order ID not passed as parameter from ePDQ'.

I'm really confused? :-(

I may have to go back to the other plug in but I'd really rather get this working.

Thanks for any ideas.

Richard

If you go straight to checkout_process bypassing ePDQ the process will fail. This is a good thing since you are completely bypassing ePDQ so attempting to create an order without collecting a payment.

It is correct to go to ePDQ after checkout confirmation, hopefully get a success indicator back from there, and then return to create the order.

If you bypass ePDQ then the log table will remain empty since it is the automated callback from ePDQ that populates it.

Ah - so at what point in the process should the log table be populated? I've tried going through the process from start to finish (even through the live payment) and the table has remained empty at every stage.

It's populated by the autoresponse from ePDQ. Can't remember the exact name, but the section that you set up at the bottom of your ePDQ control panel. If it's not coming back and populating the table you may have these details slightly wrong.

It's actually quite hard to get them right, since much of what you type is obscured, so you're typing blind and have to wait 15 minutes for it to propogate across their servers.

However, if the message returned from ePDQ doesn't connect, that gets recorded by ePDQ and they should be able to tell you (via their helpdesk) whether they are receiving success (200) or failure (300 series) confirmations.