sweetjaime Posted December 4, 2006 Posted December 4, 2006 Please help me, i had a customer place a large order on my site, but i hqave no idea what they bought! I got the paypal statement saying i recived the funds-but no email saying what they bought??? And when i go into admin and order total/customers orders, it shows nothing!!!!! Please help!
abra123cadabra Posted December 4, 2006 Posted December 4, 2006 The customer most likely didn't click on the return to merchant link after paying with paypal. The order is only logged once the customers comes back to your shop and the checkout_success.php is displayed. You can see what the customer has in his shopping cart if you check your database. For the future I would recommend to install order logging or paypal IPN contribution so that orders are logged before the customer is redirected to your payment gateway. abra The First Law of E-Commerce: If the user can't find the product, the user can't buy the product. Feedback and suggestions on my shop welcome. Note: My advice is based on my own experience or on something I read in these forums. No guarantee it'll work for you! Make sure that you always BACKUP the database and the files you are going to change so that you can rollback to a working version if things go wrong.
sweetjaime Posted December 5, 2006 Author Posted December 5, 2006 Please help me, i had a customer place a large order on my site, but i hqave no idea what they bought! I got the paypal statement saying i recived the funds-but no email saying what they bought??? And when i go into admin and order total/customers orders, it shows nothing!!!!!Please help! Thank you very much for your response. How would i check my database to see what is in their cart ?
abra123cadabra Posted December 5, 2006 Posted December 5, 2006 Go into your phpMyAdmin and open table customers to find the customer id, then open customers_basket and check for this customers products in the shopping cart. 187{1}12 means product_id 187, product_options_id 1 and product_options_value_id 12. Or you could install a master password contribution and log into the customers account and have a look what's still in there. abra The First Law of E-Commerce: If the user can't find the product, the user can't buy the product. Feedback and suggestions on my shop welcome. Note: My advice is based on my own experience or on something I read in these forums. No guarantee it'll work for you! Make sure that you always BACKUP the database and the files you are going to change so that you can rollback to a working version if things go wrong.
WEBMISSIE Posted December 5, 2006 Posted December 5, 2006 Im having the same problem, I did check the database and the orders arent there. I DO have paypal IPN installed and it is only some orders not all of them that come through paypal that dont appear in the admin. It is getting embarrassing to have to contact customers to say"what did you order". Im using the Thanksgiving server overload excuse for now but that wont last much longer.
Wiggins Posted December 5, 2006 Posted December 5, 2006 We installed the pay pal processing mod, this fixed that problem.
WEBMISSIE Posted December 5, 2006 Posted December 5, 2006 I installed the order logging contrib. Works great.
abra123cadabra Posted December 5, 2006 Posted December 5, 2006 If the customer returns to the shop, the shopping cart is emptied. That's why you don't see them in customers_basket but you can check if they are included in the orders tables. I had a few issues with my reward points and the IPN payment notification but at least all my orders are already logged before the redirect to paypal. abra Im having the same problem, I did check the database and the orders arent there. I DO have paypal IPN installed and it is only some orders not all of them that come through paypal that dont appear in the admin. It is getting embarrassing to have to contact customers to say"what did you order". Im using the Thanksgiving server overload excuse for now but that wont last much longer. The First Law of E-Commerce: If the user can't find the product, the user can't buy the product. Feedback and suggestions on my shop welcome. Note: My advice is based on my own experience or on something I read in these forums. No guarantee it'll work for you! Make sure that you always BACKUP the database and the files you are going to change so that you can rollback to a working version if things go wrong.
fterreri Posted December 6, 2006 Posted December 6, 2006 I installed the order logging contrib. Works great. Which version did you install? 2.0 ? Thanks.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.