Return From 2checkout

[mlcwork]

I'm having trouble with the passback from 2checkout.com. It doesnt seem to be picking up the passback variables, and it keeps trying to insert a blank record in the orders table. I thought I had this working because some of my earlier tests successfully added a row into the Orders table. Any help would be wonderful.

This is the error i'm receiving on the way back from 2checkout.com: Query Failed: INSERT INTO Orders (record_number, Order_Number,Ordered_By,Product_Total,Tax_Total,Sh ipping_Total,Grand_Total,Order_Date,Payment_Method ,Ship_Special_Instructions,Shipping_Details,Packin g_Details,Bill_First_Name,Bill_Last_Name,Bill_Comp any,Bill_Street,Bill_Street_2,Bill_City,Bill_State _or_Province,Bill_Postal_Code,Bill_Country,Bill_Em ail_Address,Bill_Phone,Bill_Fax,Ship_First_Name,Sh ip_Last_Name,Ship_Company,Ship_Street,Ship_Street_ 2,Ship_City,Ship_State_or_Province,Ship_Postal_Cod e,Ship_Country,Ship_Email_Address,Ship_Phone,Ship_ Fax,Ship_Address_Is) VALUES ('', '','','0.00','',' TBD','0.00','','','','','Shipping Breakdown:\r-----------------------------------------------\r Ship using: - \r Cost: $\r\r','','','','','','','','','','','','','','',' ','','','','','','','','','','')


It does not look like it passes the order details back from 2checkout. is squirrelcart supposed to read the temp_sessions table to get the order details when coming back from 2checkout???

[Jamie]

Hi,

We've put an update in your helpdesk ticket regarding this. The temp_sessions table is not used for that. It is used to assist in tracking things such as inventory control.

Thanks,
Jamie

[codeman43]

Hello,

It looks like this is a long standing problem because I have the same problem. Is there a fix for this?

[codeman43]

Hello,

I recently purchased his product and in fact I do like it. However, I'm not really very satisfied at the moment with support. I recently completed a support request for this particular problem. Received one response and that was it. I also asked on the support ticket if the problem is being worked on, and still I received no response.

I surely hope this is not going to become a nightmare like the former product I purchased, DreamAccount. The support from them was horrible! This is why I purchased Squirrelcart.

Even when something cannot be fixed right away, it is good customer relations when you respond to your clients. Personally, I do not want to ask for a refund, but no response surely drives me to doing so.

Does anybody have an idea just how long it takes for support ? To either respond or complete a job/fix?

[Jamie]

Someone will get back to you shortly on this. This is not a long standing problem. The person that posted this was getting the error for a completely different reason.

Thanks,
Jamie

[codeman43]

Hello,

It seems after the upgrade to the new version I now have the same problem again. See below, but the only problem I'm having is that now my suport expired. To fix this problem you had to enter my server and correct the problem. You said that you would update the new versions so this problem would not happen. :-(

Anyway, what can I do now...?

Thanks.

Error is:

Query Failed: INSERT INTO Orders (Order_Number,Ordered_By,Product_Total,Tax_Total,S avings_Total,Shipping_Total,Grand_Total,Order_Date ,Transaction_ID,Payment_Method,Ship_Special_Instru ctions,Shipping_Details,Packing_Details,IP_Address ,User_Agent,Host_Name,Referring_URL,Referral_Date, Bill_First_Name,Bill_Last_Name,Bill_Company,Bill_S treet,Bill_Street_2,Bill_City,Bill_State_or_Provin ce,Bill_Postal_Code,Bill_Country,Bill_Email_Addres s,Bill_Phone,Bill_Fax,Ship_First_Name,Ship_Last_Na me,Ship_Company,Ship_Street,Ship_Street_2,Ship_Cit y,Ship_State_or_Province,Ship_Postal_Code,Ship_Cou ntry,Ship_Email_Address,Ship_Phone,Ship_Fax,Ship_A ddress_Is) VALUES ('','32','0.00','','0',' TBD','0.00','','','','','','','24.161.123.76','Moz illa/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.40607)','','https://www.2checkout.com/cgi-bin/Abuyers/purchase3.2c?MD=29405526','2005-02-17 22:37:59','','','','','','','','','','','','','',' ','','','','','','','','','','','')

[Jamie]

Hi,

I'm testing this now on a new install of 1.5.3, and will let you know if we can recreate it. The problem is that the session is not being reestablished when 2Checkout returns. What version of 2Checkout are you on? Version 1 or 2?

[codeman43]

Thanks Jamie for the reply.

I'm using version 1. Also, if I select non-secure I get an error as well.

(Order_Number,Ordered_By,Product_Total,Tax_Total,S avings_Total,Shipping_Total,Grand_Total,Order_Date ,Transaction_ID,Payment_Method,Ship_Special_Instru ctions,Shipping_Details,Packing_Details,IP_Address ,User_Agent,Host_Name,Referring_URL,Referral_Date, Bill_First_Name,Bill_Last_Name,Bill_Company,Bill_S treet,Bill_Street_2,Bill_City,Bill_State_or_Provin ce,Bill_Postal_Code,Bill_Country,Bill_Email_Addres s,Bill_Phone,Bill_Fax,Ship_First_Name,Ship_Last_Na me,Ship_Company,Ship_Street,Ship_Street_2,Ship_Cit y,Ship_State_or_Province,Ship_Postal_Code,Ship_Cou ntry,Ship_Email_Address,Ship_Phone,Ship_Fax,Ship_A ddress_Is)

[Jamie]

Hi,

I have been working on this with 2Checkout. I have a support request into them for this. I have a v1 test account with them, and for some strange reason it refuses to even attempt to return to the store.php page. As soon as I resolve that issue, I can test this fully. After that is fixed, if I can test without the session being lost, I will need you to open a ticket for this so I can checkout your site. I'll let you know when I'm done testing with my test account, and whether or not it has the same problem.

[codeman43]

Okay, thanks Jamie.

Will I have to renew at this time, because this is a old problem. If so, then I may have to wait because my money is a little low right now. This would also mean that I can not use the cart.

Thanks

[Jamie]

Hi Codeman43,

Are you still experiencing this problem?

Thanks,
Jamie

[codeman43]

Yes I am, I have been unable to use the check out. No sales made... :(

[Jamie]

Hi Codeman43,

I wasn't able to help you much with this before because I couldn't get 2Checkout to return in my test install. After several tickets, they said that the domain name that is returned to must match the domain they have on file. I was testing using a shared SSL cert for the return, and it definitely didn't match the domain they had on our test account. I did some testing yesterday with the domain name matching and it still would not return. I finally tried specifying the return URL in the wrong routine section in their control panel. We use their "purchase.2c" routine, and our instructions state to add the return URL to that section on their "return" page. This used to work fine when we first wrote it.

Now, for my test, I put the return URL in the "cartpurchase.2c" section instead, and it returns fine. I have a ticket into them to find out why this is.

I've changed some things in the 2Checkout v1 file that I'd like you to try. Rename your current "squirrelcart/payment_gateways/2checkout-v1.php" and replace it with the one attached. Then, please follow these instructions:

Login to your cart as admin, and open the 2Checkout v1 record. Enter your seller id number for 2Checkout in the "Account Name" field and then follow along below. These instructions are different from the ones you initially followed. Steps 3 and 5 are different.

1. Log into your 2Checkout.com control panel

2. Click "Account Details > Return"

3. Find the section titled "cartpurchase.2c Passback Parameters."

4. Find the field labeled "Return to a routine on your site after credit card processed?:" and set it to "yes".

5. In the Return URL field, enter the following:
http://www.YOURSITE.COM/store.php

6. Find the section labeled "Overall Passback Parameters."

7. Set the "Direct return" field to "yes"

8. Click "Save Parameters"

9. Make sure that "Return to Storefront" is checked on this record

10. Check the "Enabled" field.

11. Click "Submit Record"

Demo mode is enabled in the attached file. Try a test order, with credit card # 5454545454545454, and let me know how it works. If this file works OK for you, you will need to open it and remark out the line that enabled demo mode. To do this, change this line:
$info['demo'] = 'Y';
to this:
//$info['demo'] = 'Y';