|
|
 |
 |
Joined: 6/1/2010
Posts: 179
|
|
|
Hi,
Maybe a continuation of some of the stuff I reported earlier, but when checking out via PayPal, and only clicking the PayPal button but not finishing the order at the PayPal site, in the customer view using the MyAccount module, the Status appears as "Open". In the Manage Customer Orders screen the Pay Status shows as "false" and in Manage Payment History the Message shows as "Awaiting Payment". The main problem is that the order is showing as Open in the customers MyAccount screen and they would believe that they had a successful order via PayPal even if they do not do things correctly.
|
|
|
|
 | |
|
|
 |
 |
Joined: 3/11/2010
Posts: 1979
|
|
|
In the my accounts module if the user clicks the "select" button on the order they will see that the payment status of "Awaiting Payment" indicating that they did not successfully complete the order. In cart version 3.9 the my account has its own stored procedure "Smith_ListMyAccountOrdersByFilter" which you can modify to exclude payment status of "Awaiting Payment"
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Thanks for the reply. I will look to add a filter. As it is now, users also get a link to the download product without purchasing the product. With it like this, there is no secure way of selling download products. Hopefully modifying the stored procedure will work. I am not an expert in that area, but I will toy around with it.
One problem I see is that Smith_StoreOrders does not have Awating Payment, however in Smith_PayHist I see the Awating Payment, but there is no way I can see to link an order from Smith_StoreOrders to Smith_PayHist as the Smith_PayHist data adds no reference information to the main order number. So the only thing I can see is to block any Open order from the customer, which is not really good because download orders always appear as Open.
One more note: In the MyAccount module it shows Account No as "************ded." and status as "false". This is from the customer view after they press select.
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Hi,
I could not figure out a way to handle this. Maybe I am missing something so if there are any tips on doing this then it would be great.
Again, as it is now, incomplete paypal orders give customers the full download link and serial number without them having to purchase in the MyAccount module.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
You would need to join the "smith_payhist" table and add the following where clause:
paystatus != 'Awaiting Payment'
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
But a join is not possible in this case as far as I can tell because the PayHistID in Smith_PayHist does not match the OrderID in the other tables.... So there is no way to accurately apply a filter. It seems that the PayHistID is not tied to Smith_StoreOrders or Smith_StoreOrderDetails with any connectable information, such as OrderId. Since there is no OrderID, you cannot query the Smith_Payhist table. There are a different number of records in the tables for example, so of course you could not rely on that.
The problem is because PayHistID is an auto-incremented int, and there is no second colum entry for OrderID to match things up.
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
The payhistid is in the smith_storeorders table.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
|
Joined: 6/1/2010
Posts: 179
|
|
|
Great! That was the link I would need.
Please do try to change this in the cart system though as it does expose download orders for free and I am concerned that an upgrade or something could overwrite the procedure.
I will mess around more with the filters now.
Steve
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
If you modify the stored proc and add the filter paystatus != 'Awaiting Payment' so it filters out the paystatus of awaiting payment post your modified stored proc and I will send it into programming to update the main buiild so that its included in future upgrades.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
 |
Joined: 9/5/2010
Posts: 48
|
|
|
Can you tell me if there is a way for a returning customer as described above to follow a link back out to Paypal to complete an order that is "Awaiting Payment" or will we have to complete an order like this manually?
Thanks,
Christian
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Not sure I follow what you mean can you explain the scenario a bit more?
Thanks,
Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 9/5/2010
Posts: 48
|
|
|
No problem.
Assuming a customer was logged in and say they buy a product and completes all the steps on our site and then clicks the link to go to Paypal, but then for whatever reason they don't finish at paypal. In this case, the order has 'Awaiting Payment' status. When they return to our site and log back in at a later time, is there a way for them to finish the purchase from where they left off i.e. get a link again with the order details back to paypal? Or, do we now have to manually proccess that order or have the customer start over?
I hope that is clearer. Thank you for your help and great support.
CM
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
If the user doesnt complete the order in the cart or paypal then when they return to the cart the item should still be in the cart and there customer info would be pre populated in the checkout so they would just have to click next thru the checkout then go to paypal and enter their credit card info and process their credit card at paypal then when they return to the cart their order status would be updated.
-Scott
Scott Kelly
Project Manager
|
|
|
|
| |
|
|
|
Joined: 9/5/2010
Posts: 48
|
|
|
Could I try to recreate this on your demo site? i haven't done anything there before, so I'm not sure how to access it.
CM
|
|
|
|
| |
|
|
|
|
Joined: 3/11/2010
Posts: 1979
|
|
|
Yes the test cart url is http://www7.smith-consulting.com/ . Please send an email to support@smith-consulting.com if you need a login.
-Scott
Scott Kelly
Project Manager
|
|
|
|