Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Customer Bought items- but no record of what they are in Customer Orders!


sweetjaime

Recommended Posts

Posted

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!

Posted

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.

Posted
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 ?

Posted

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.

Posted

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.

Posted

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...