Andrew R
|
| Posted: 01/27/2003, 6:33 PM |
|
Does anyone have a working shopping cart that does not leave blank transactions when the user exits?
|
|
|
 |
ronb
|
| Posted: 01/28/2003, 1:48 AM |
|
I solved this problem in two stages:
1- products arent set on sold untill the transaction(including payment by creditcard via paypal) is completed. If a user aborts the transaction the nice way (in paypal clicking cancel) they are redirected to a cancelpage wich runs an update on the order table removing the order.
2- if they just close the window I have a query that runs when opening the admin page that checks the status of the order. If payment transaction was not completed and they order is still there it automatically removes any order that was done before today with status "payment pending"
it's a bit dirty but I didn't want to rely on javascript since not everyone
has javascript activated in their browser. Javascript is an option if you decide they have to activate javascript to be able to use the site. An event is triggered when is closed you could use that event to call a page that handles the removal of the unfinished transaction.
Ron
|
|
|
|
Andrew R.
|
| Posted: 01/28/2003, 6:08 AM |
|
Thanks Ron!! I would love to see the files if you wouldn't mind sending them. areilley@huntermaclean.com Either way, thanks a million!
|
|
|
|
ronb
|
| Posted: 01/28/2003, 9:31 AM |
|
Sorry can't send you the files. It was contract work but I can send you the sql statements and point you in the general direction if you like?
RonB
|
|
|
|
Andrew R
|
| Posted: 01/29/2003, 7:40 AM |
|
I would appreciate that very much. Thank you!
|
|
|
|
