Hi Craig,

Thank you for your reply.

Correct me if I’m wrong (or if you have a colleague named Greg), but you said the exact same thing when I asked this question over your Live Chat many weeks ago.

I’ll try some test orders again to see if I’m incorrect about the return script issue.

Thank you!
Kind Regards,

- Bjorn

No problem.
I legitimately believed somebody was looking into this issue and gave it a rest for a while. Only to see no change.

I will set everything up again according to the provided instructions and will keep you posted on the problems.

I hope some other users might share their experiences, because I can imagine they’ve seen a lot of snippets of code and forums trying to get this working.

Thanks

- Bjorn

I’ve set everything up again and it seems my payments still show up as pending.

Let me take you thru my settings:

- 2Co Payment method chosen in Virtuemart. (Comes with the virtuemart package)

- In the payment method form I have the payment method type set to “HTML-Form Based”

- In the Configuration Tab, I’ve entered my Vendor ID, Secret word, Confirmed status for completed orders, Pending status for failed orders and test mode is off.

- I have the following script:

f("user_info_id")."'";
$dbbt = new ps_DB;
$dbbt->setQuery($q);
$dbbt->query();
$dbbt->next_record();
// Get ship_to information
if( $db->f("user_info_id") != $dbbt->f("user_info_id")) {
$q2 = "SELECT * FROM #__vm_user_info WHERE user_info_id='".$db->f("user_info_id")."'";
$dbst = new ps_DB;
$dbst->setQuery($q2);
$dbst->query();
$dbst->next_record();
}
else {
$dbst = $dbbt;
}

In 2checkout, I have the approved and pending URL’s set to http://www.my_site.org/2checkout_notify.php

Every time I complete an order using 2CO, It remains listed as pending in my Virtuemart store.
So download links don’t get sent out.

Any idea where I went wrong?

Ehrm.. These code tags didn’t work too well.

Anyway, here are a few links to forums discussing these problems.
If you want I can give many more links. I’m not the only person who has been trying to set this up for many weeks without any luck.
We need 2Co to help us out.

http://forum.virtuemart.net/index.php?topic=13874.msg109118

https://dev.virtuemart.net/cb/issue/1364

https://forum.virtuemart.net/index.php?topic=46438.msg154361

Kind Regards

- Bjorn

It seems to be already in there.

_(’VM_CHECKOUT_ORDERIDNOTSET’);
else {

/* Load the 2Checkout Configuration File */
require_once( CLASSPATH. ‘payment/ps_twocheckout.cfg.php’ );

/* x_invoice_num is the name of the variable that holds OUR order_number */
$order_number = vmGet( $_REQUEST, “x_invoice_num” );

// In Demo Mode the MD5 Hash is built using a “1″
if( isset($_REQUEST['demo']) )
if($_REQUEST['demo']== “Y”)
$_REQUEST['order_number'] = “1″;

/* Concat some variables for MD5 Hashing (like 2Checkout does online)
* order_number is the 2Checkout Order Number, not our one!
*/
$compare_string = TWOCO_SECRETWORD . TWOCO_LOGIN . $_REQUEST['order_number'] . $_REQUEST['x_amount'];

// make it md5
$compare_hash1 = strtoupper(md5($compare_string));
$compare_hash2 = $_REQUEST['x_MD5_Hash'];

/* If both hashes are the same, the post should come from 2Checkout */
if ($compare_hash1 != $compare_hash2) {
?>
<img src=”images/button_cancel.png” align=”middle” alt=”_(’VM_CHECKOUT_FAILURE’); ?>” border=”0″ />
_(’PHPSHOP_PAYMENT_ERROR’) ?>query($qv);
$dbbt->next_record();
$d['order_id'] = $dbbt->f(”order_id”);

if ($_REQUEST['x_2checked'] == ‘Y’) {

// UPDATE THE ORDER STATUS to ‘VALID’
$d['order_status'] = TWOCO_VERIFIED_STATUS;
require_once ( CLASSPATH . ‘ps_order.php’ );
$ps_order= new ps_order;
$ps_order->order_status_update($d);

?>
<img src=”images/button_ok.png” align=”middle” alt=”_(’VM_CHECKOUT_SUCCESS’); ?>” border=”0″ />
_(’PHPSHOP_PAYMENT_TRANSACTION_SUCCESS’) ?>
order_status_update($d);

?>
<img src=”images/button_cancel.png” align=”middle” alt=”_(’VM_CHECKOUT_FAILURE’); ?>” border=”0″ />
_(’PHPSHOP_PAYMENT_ERROR’) ?>

<a href=”purl( SECUREURL.”index.php?option=com_virtuemart&page=account.order_details&order_id=”.$d['order_id'] ) ?>”>
_(’PHPSHOP_ORDER_LINK’) ?>

<?php
}

Any other ideas what might be the problem?

Is there any chance to get somebody at 2Co to get this up and running for themselves?
I wish this were user error…

Thank you very much.

I’ve honestly tried all other avenues. Some of the forum threads I linked date over a year back. Hence the outdated script adjustment tips.

I’m currently just using PayPal on my new site, but its slowly but surely reminding me why I used 2Co for the last 2 years. Paypal is smoothly integrated from my perspective, but it scares the daylight out of some potential customers.
I really enjoy doing business with 2Co, so I hope this issue can be resolved.

Thank you for looking into this!

Kind Regards

- Bjorn

Hi,

Is there anything I can do to help?
I have the 2co plugin installed in an active store that is working smoothly, but its currently deactivated.

Cheers

- Bjorn

Any updates regarding this subject?

So is there a final word on this wetter or not you’re going to support virtuemart?

So basically the next time somebody asks about this, they’ll get the same reply. You stated about a year ago that you are looking into this “in depth”. http://www.2checkout.com/community/public/getting-started/virtuemart/

I find it hard to believe that the developers can’t be reached by phone or email for all this time. But yeah, you’re right. Its not up to you to support something like this. Even if the whole appeal of the service is 2co support.

http://virtuemart.net/documentation/User_Manual/Payment_Methods.html

Anyway. I suppose I’ll have to concede. Lord knows I tried sorting this out with the virtuemart developers too. 2 companies pointing fingers. This will never get resolved.
The only reason I complained harder here is because virtuemart isn’t the one losing customers.

Thanks for trying.

- Bjorn

Hi,

to fix the issue, the VirtueMart Store owner must update their 2Checkout Payment Method using the Store’s Payment Method Form.
In the payment method form for the 2Checkout payment method, select the tab “Configuration”. After that fill in this new text (completely replace the old text) in the field “Payment Extra Info”:


f("user_info_id") != $dbbt->f("user_info_id")) {
$q2 = "SELECT * FROM #__vm_user_info WHERE user_info_id='".$db->f("user_info_id")."'";
$dbst = new ps_DB;
$dbst->setQuery($q2);
$dbst->query();
$dbst->next_record();
}
else {
$dbst = $dbbt;
}

ciao, Sören

there’s something missing at the beginning of the code!

this:
###
f

###

ok, see here: 2Checkout in VM 1.1.3