If this is your first visit, check our documentation. To post, register or login.
Forums / Addon Payment Modules / Moneris eSELECTplus Hosted Payment Page?

Moneris eSELECTplus Hosted Payment Page?

Started by mcwilliams on 14 Oct 2010, 8:50 PM · Views: 13,746

Results 1 to 14 of 14
14 Oct 2010, 8:50 PM
#1
mcwilliams avatar

mcwilliams

New Zenner

Join Date:
Oct 2010
Posts:
3
Plugin Contributions:
0

Moneris eSELECTplus Hosted Payment Page?

I am looking for a payment processing option for a new application for Zen Cart version 1.3.9d. Has anyone used the eSELECT plus hosted payment page from Moneris? If yes, how is it intergrated with Zen Cart?

Thanks for your help

5 Sep 2011, 9:36 PM
#2
rick_bakker avatar

rick_bakker

New Zenner

Join Date:
Sep 2011
Location:
Surrey, BC
Posts:
4
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

I have been looking at this as well, did you make any progress on this?

15 Nov 2011, 6:49 PM
#3
bonniedevil avatar

bonniedevil

New Zenner

Join Date:
Jun 2011
Posts:
20
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

Hello, I too have been trying to find a solution to this, did either of you or anyone else find a hosted paypage option for moneris?

3 Oct 2012, 9:36 AM
#4
elize avatar

elize

New Zenner

Join Date:
Oct 2012
Posts:
2
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

Hi there

we are trying to use the Moneris eselect Plus HPP and getting a fatal error.
Has anyone had a similar error and been able to resolve it?

Fatal Error - please contact Merchant for support.

The Moneris account details etc being submitted is below :
<input type="hidden" name="hdnAmount" id="hdnAmount" />
<input type="hidden" name="charge_total" id="charge_total" />
<input type="hidden" name="hdnStoryId" id="hdnStoryId" value="<?php echo $id; ?>" />
<input TYPE="hidden" NAME="order_id" VALUE="hpp_mr_test_12015045405">
<input TYPE="HIDDEN" NAME="ps_store_id" VALUE="ZG6RYg2691">
<input TYPE="HIDDEN" NAME="hpp_key" VALUE="hpMPJ1UHUJJ3">
<!-- Additional Optional Details -->
<input type="hidden" name="cust_id" value="customer num">

23 Oct 2013, 8:18 PM
#5
riomaha avatar

riomaha

New Zenner

Join Date:
Oct 2013
Location:
MTL
Posts:
66
Plugin Contributions:
1

Re: Moneris eSELECTplus Hosted Payment Page?

Have you gotten it working yet? has anyone figured out how to do it? Could someone tell me which pages that need to be edited for starters?

4 Nov 2013, 2:53 PM
#6
riomaha avatar

riomaha

New Zenner

Join Date:
Oct 2013
Location:
MTL
Posts:
66
Plugin Contributions:
1

Re: Moneris eSELECTplus Hosted Payment Page?

For those interested. I have built a moneris Hosted Paypage that you can install on your zen cart 1.3.9 or 1.5.1. I will soon post my contribution.

13 Jan 2016, 8:47 PM
#7
margecc avatar

margecc

Zen Follower

Join Date:
Feb 2007
Location:
Ontario, Canada
Posts:
234
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

I am trying to figure out if anyone has used riomaha's contribution on 1.5.4?

Thanks, Colleen
www.af-company.com
To err is human, but to really foul things up requires a computer. Farmers' Almanac, 1978

18 Jan 2016, 7:00 PM
#8
margecc avatar

margecc

Zen Follower

Join Date:
Feb 2007
Location:
Ontario, Canada
Posts:
234
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

I would really appreciate a bit of help on this. I decided to try and go ahead and install it on 1.5.4 since it's not a working site yet. When I go to install the sql patch I am getting "WARNING: An Error occurred, please refresh the page and try again.".

This is the current Sql patch:

DROP TABLE IF EXISTS moneris_orderids;
CREATE TABLE IF NOT EXISTS moneris_orderids (
moneris_orderid varchar(99) NOT NULL,
orders_id int(11) NOT NULL,
trans_name varchar(20) NOT NULL,
bank_approval_code varchar(8) NOT NULL,
bank_transaction_id int(18) NOT NULL,
response_code varchar(3) NOT NULL,
iso_code int(2) NOT NULL,
message varchar(100) NOT NULL,
cardholder varchar(40) NOT NULL,
response_variables blob NOT NULL,
bank_transaction_id int(10) NOT NULL,
f4l4 varchar(11) NOT NULL,
PRIMARY KEY (orders_id,moneris_orderid),
KEY idx_moneris_orderids_orders_id (orders_id)
);

Is there something that doesn't work with 1.5.4 here?

Thanks in advance for any help!

Thanks, Colleen
www.af-company.com
To err is human, but to really foul things up requires a computer. Farmers' Almanac, 1978

19 Jan 2016, 10:58 PM
#9
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Moneris eSELECTplus Hosted Payment Page?

margecc:

I am getting "WARNING: An Error occurred, please refresh the page and try again.".
You'll find the exact MySQL error in your /logs/ folder. Ref: http://www.zen-cart.com/content.php?311-warning-an-error-occurred-please-refresh-the-page-and-try-again

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

16 Mar 2016, 4:59 PM
#10
margecc avatar

margecc

Zen Follower

Join Date:
Feb 2007
Location:
Ontario, Canada
Posts:
234
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

Just in case anyone is interested, the Moneris plugin worked great with 1.5.4. The only issue being that you need to add the table yourself.

Thanks, Colleen
www.af-company.com
To err is human, but to really foul things up requires a computer. Farmers' Almanac, 1978

16 Mar 2016, 6:58 PM
#11
cvhainb avatar

cvhainb

Zen Follower

Join Date:
Sep 2008
Posts:
212
Plugin Contributions:
19

Re: Moneris eSELECTplus Hosted Payment Page?

I am having a client use this module and sometimes the order is duplicated. I am checking with Moneris about this.

Our Site: http://zucando.com
Marketing Plugins: Marketing Modules
Free Response Templates: Responsive Templates

24 Mar 2017, 8:19 PM
#12
el56 avatar

el56

New Zenner

Join Date:
Mar 2011
Posts:
6
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

margecc:

I would really appreciate a bit of help on this. I decided to try and go ahead and install it on 1.5.4 since it's not a working site yet. When I go to install the sql patch I am getting "WARNING: An Error occurred, please refresh the page and try again.".

This is the current Sql patch:

DROP TABLE IF EXISTS moneris_orderids;
CREATE TABLE IF NOT EXISTS moneris_orderids (
moneris_orderid varchar(99) NOT NULL,
orders_id int(11) NOT NULL,
trans_name varchar(20) NOT NULL,
bank_approval_code varchar(8) NOT NULL,
bank_transaction_id int(18) NOT NULL,
response_code varchar(3) NOT NULL,
iso_code int(2) NOT NULL,
message varchar(100) NOT NULL,
cardholder varchar(40) NOT NULL,
response_variables blob NOT NULL,
bank_transaction_id int(10) NOT NULL,
f4l4 varchar(11) NOT NULL,
PRIMARY KEY (orders_id,moneris_orderid),
KEY idx_moneris_orderids_orders_id (orders_id)
);

Is there something that doesn't work with 1.5.4 here?

Thanks in advance for any help!

The above command, found in the file Moneris.sql includes two requests to create the field 'bank_transaction_id'. That duplicate field creation will make this command fail under Tools->Install SQL patches without useful output. Running it manually under the mysql command line reveals the error in the redundant field creation.
I took out the shorter of the two (one is defined as 18-digit, the other as 10-digit) and am hoping it works.

27 Mar 2017, 3:27 PM
#13
margecc avatar

margecc

Zen Follower

Join Date:
Feb 2007
Location:
Ontario, Canada
Posts:
234
Plugin Contributions:
0

Re: Moneris eSELECTplus Hosted Payment Page?

I ended up paying someone to make some changes to this module so that it would work correctly with 1.5.4 There were several problems with it.

Thanks, Colleen
www.af-company.com
To err is human, but to really foul things up requires a computer. Farmers' Almanac, 1978

19 Mar 2019, 8:32 PM
#14
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,140
Plugin Contributions:
56

Re: Moneris eSELECTplus Hosted Payment Page?

Just a note for anyone looking to upgrade their Moneris-HPP installation to use a more recent version of MySQL. The file Moneris.sql, besides the double-declaration mentioned above:

DROP TABLE IF EXISTS `moneris_orderids`;
CREATE TABLE IF NOT EXISTS `moneris_orderids` (
  `moneris_orderid` varchar(99) NOT NULL,
  `orders_id` int(11) NOT NULL,
  `trans_name` varchar(20) NOT NULL,
  `bank_approval_code` varchar(8) NOT NUL  L,
[B]  `bank_transaction_id` int(18) NOT NULL,[/B]
  `response_code` varchar(3) NOT NULL,
  `iso_code` int(2) NOT NULL,
  `message` varchar(100) NOT NULL,
  `cardholder` varchar(40) NOT NULL,
  `response_variables` blob NOT NULL,
[B]  `bank_transaction_id` int(10) NOT NULL,[/B]
  `f4l4` varchar(11) NOT NULL,
  PRIMARY KEY (`orders_id`,`moneris_orderid`),
  KEY `idx_moneris_orderids_orders_id` (`orders_id`)
);
```
also defines the bank_transaction_id as an integer value.  Unfortunately, MySQL integer values can range from +/- 2147483647, but those values come back as 18-character values.

When you try to stuff those values into that integer-defined field for those more recent versions of MySQL, you might receive error logs similar to

PHP Fatal error: 1264:Out of range value for column 'bank_transaction_id' at row 1

You'll also notice (viewing the moneris_orderids table) that all the bank_transaction_id values are 2147483647!

The correction is to define that field as either **char(18)** or, for some expansion, **varchar(20)**.  You can safely make the field format change in phpMyAdmin, since that value is recorded but never used.