2CheckOut for Zen 1.3.0.2 Released

This module is being sent to the contributions section today. This is the support thread for any problems regarding to the module.

The site wiki has been updated with the install file.

Absolute

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

Absolute

BUG FIX RELEASED

A bug has been detected when using FireFox. The problem is with the redirect URL. This has now been found, and updated, with thanks to godin5150 for finding the issue.

The updated files have just been posted tp the contribs section, but in the meantime, here is the fix:

• Open process_2checkout.php
• Goto Line 46, where you will find

?>
<body>

Insert a new line before the ?>, and paste the following line of code:

$redirect_url = str_replace('&', '&', $redirect_url);

Many thanks, and if anyone should find anything further, please let me know.

Absolute

I read the reade file. it mentions that in order for products to be dispayed on the 2co website, we need to upload csv of our products. we will need to do this each time we change our cataog?

Unfortunately, with 2CO, yes you do. There is no way of sending the products with each transaction. 2CO insist that they have an up-to-date list of your products, with a short description and a price.

If 2CO alter this procedure, then we'll keep an eye out, and release an updated version.

Absolute

Another little bug has just been reported and solved.

Bug: 2CheckOut refuses orders over 999.99

Solution:

Please edit the following code:

includes/modules/payment/as2checkout.php
Line 160
Replace : ```
zen_draw_hidden_field('x_amount', number_format($cOrderTotal, 2)) .

with 

zen_draw_hidden_field('x_amount', number_format($cOrderTotal, 2, '.', '')) .

This update has just been submitted to the contributions section.

Absolute

what does happen when the list is not kept uptodate and a customer buys something not on 2co's list?

I want to write my own contribution to enable checkout for zen cart and one more cart which doesnt have 2checkout
How can I start?
Is there any tutorial for that?
What are the thing which should be taken care of while writing a module for a payment gateway like 2checkout?
Thanks

There are various "how-tos" on the 2CO site. Unforunately, there aren't any definitive lists, so you have to read through the whole site and get the relevant information.

Have a look through my module, and you may get the rough idea. 2CO is not the easiest company to start with, as they're slightly unique!

Good luck

Absolute

Absolute:

There are various "how-tos" on the 2CO site. Unforunately, there aren't any definitive lists, so you have to read through the whole site and get the relevant information.

Have a look through my module, and you may get the rough idea. 2CO is not the easiest company to start with, as they're slightly unique!

Good luck

Absolute
Thanks Absolute, I am reading the contributions
Will let you know in case I have any questions!
San

Hi there,

well i haven't buy the 2co account yet but i was thinking of using 2co as for my cart gateway. So, i have download the module from your place & i'm thinking of that i could of install the 2co module first instead of buying the account first since i haven done all my stock up to date. I was following the installation from the readme file until the 2nd part that it say + Run the database_update.sql file so i go into the mysql control centre to run it but unfortunately it came out :

"ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
return_md5 t"

so i can't get to update the update_database.sql file. Is there anything i have done wrong or i need to do something on the setting or do i need to buy the gateway account first on the 2co only that i can make the 2co file? sorry that i'm still kind of a new user of the zen cart but i do study around the forum to do it my self in not that i really can't solve the problem i will try to not disturbing anyone.

Thanks in advance.

You could edit the database_update.sql file with a text editor, and remove this part:```
collate latin1_general_ci

Some more restrictive database setups don't like you setting a collation method at the per-table level.

DrByte:

You could edit the database_update.sql file with a text editor, and remove this part:```
collate latin1_general_ci

> 
> 
> Some more restrictive database setups don't like you setting a collation method at the per-table level.

DrByte thanks for your advice but is not working. It still giving me the :

"[e-market] ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL default '',
  `return_md5` t"

is there anything wrong with my SQL? since it mention about my SQL Version will it anything do with the SQL? Well i'm using Version MySql 4.3.11. Or do i have to follow the update_database.sql to update manually?

DrByte,

Thank You for your advice that i have done it with your advice. This is what i have done to create the data base :

Original Sql file :

CREATE TABLE `2checkout` (
  `2co_id` int(11) NOT NULL auto_increment,
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(50) collate latin1_general_ci NOT NULL default '',
  `return_md5` text collate latin1_general_ci NOT NULL,
  `amount` float NOT NULL default '0',
  `2co_order_id` int(11) NOT NULL default '0',
  `session_id` varchar(50) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`2co_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

After Deleting some command:

CREATE TABLE `2checkout` (
  `2co_id` int(11) NOT NULL auto_increment,
  `start_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `finish_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `status` varchar(50) NOT NULL default '',
  `return_md5` text NOT NULL,
  `amount` float NOT NULL default '0',
  `2co_order_id` int(11) NOT NULL default '0',
  `session_id` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`2co_id`)
) ENGINE=MyISAM;

i'm not sure if there will be any problem by deleting off all of the collate. I was thinking if there is anyone who having the same problem as me i think this could help abit. Please advice will there be any problem with the SQL file i change. Thank You.

The edit to the SQL you made will be fine. My version of MySQL is the latest version, which includes the collate statements at the end. All you actually need for this is the CREATE TABLE xxxxxx ( ............. ) . The rest of the SQL after the ')' is not strictly necessary.

Good luck with the module. Looking forward to some feedback from those who are curently using it.

Absolute

ThankYou for your advise Absolute. :thumbsup: & Thanks for your time to making this modules i really appreciate it.

It states in 2checkout that the currency is in USD will the module accept an order in GBP and convert this to USD and so on. or must my site be all done in USD

The module can be setup to send the order in any currency, as long as 2CO accept it. You need to set the receiving currency through the 2CO checkout admin page to GBP, and then set your 2CO checkout module to GBP also. Then your orders will be sent as Pounds, rather than dollars. If you have dual currencies setup on your store, the module will convert any currency to GBP before sending, but can display the current price in the other currency on the 2CO checkout page.

Basically, you can choose which currency to receive, but this has to be the same on the 2CO admin page, and the module admin.

When your customer checks out, if you have more than 1 currency installed, then the currency your customer sees on the 2CO checkout page can stay the same as they used in your store, but the price sent to 2CO is always sent in the same currency, regardless of the shoppers preference.

Absolute

I have a stupid question. I downloaded the module but am uncertain as to where I should be uploading it to. Should I be putting in the modules folder? The readme file doesn't really say and this will be the first module that I am installing.

Thanks,
Bonnie

Never mind. I think I figured it out and I think it works. At least the demo works!