sinryder Posted June 17, 2004 Share Posted June 17, 2004 hello guys i have opend new osc store , and now after getting few orders and customers i cant manage nothing. below are few screen shots of my admin pannel in my paypal ipn section thats all what i am getting. i have 14 customers and never received any email when they registerd their account. these are all the orders but i never received any notification with any of the order details. also it keep saying payment pending when few of the payments i already have received in my paypal account this is when i click on the invoice details . any help is greatly apprecaited , i have no idea how to manage all these orders :( Link to comment Share on other sites More sharing options...
djs Posted June 17, 2004 Share Posted June 17, 2004 I'm not sure which version of PayPal module you are using, but in general, this type of problem is caused by: 1. Not having IPN enabled on your Paypal account. You have to turn this on. or 2. The location of paypal_notify.php has been setup wrong, so the cart never receives (or reacts to) the IPN to finish the order. To solve the order problem, if you log into your PayPal account, are the transactions listed? If not, then they didn't happen. If so, manually change the orders to Pending, and process them. Dan Dan Stevens Link to comment Share on other sites More sharing options...
vasttech Posted June 17, 2004 Share Posted June 17, 2004 Your images did not come through, so I will do my best to help you. You need to go into your PayPal account and setup the auto return feature to point back to checkout_process.php on your site. That way when a customer completes payment on PayPal they are redirected back to your site and the everything is entered into the db. As far as e-mails go, you will not get e-mails by default. To get extra e-mails you need to set Send Extra Order E-Mails To your e-mail address. To get an e-mail when a customer creates an account you will need to edit create_account.php to send an additional message. osCommerce Knowledge Base osCommerce Documentation Contributions Link to comment Share on other sites More sharing options...
djs Posted June 17, 2004 Share Posted June 17, 2004 To help prevent confusion, since vasttech didn't see the images, he gave great answers for PayPal issues, but this is an IPN issue. To clarify, when you use PayPal IPN, a customer does not have to return to the site for the order to finalize. The IPN trigger takes care of this, so the auto return function will not make a difference (it's still worth setting up) on the orders changing status. With the emails in the pending paypal notification status, the emails will not go out. They will be sent when the status is changed to pending, which should happen automatically when the IPN trigger is received. Dan Dan Stevens Link to comment Share on other sites More sharing options...
sinryder Posted June 17, 2004 Author Share Posted June 17, 2004 thanyou so much for replying fast . Ok in my paypal account i have chagned the IPN option to On Instant Payment Notification Preferences Back to Profile Summary PayPal's Instant Payment Notification (IPN) allows you to integrate PayPal payments with your website back-end operations. Instant Payment Notification (IPN) On Instant Payment Notification (IPN) URL: None i created a test account on my site and placed the order and confirmed it. but i didnt pay for it. now just to check , i changed the order status to pending. After few min i received this email MG Hat World------------------------------------------------------ Order Number: 8 Detailed Invoice: http://mghatworld/catalog/account_history_....php?order_id=8 Date Ordered: Thursday 17 June, 2004 The comments for your order are Your order has been updated to the following status. New status: Pending Please reply to this email if you have any questions. this is the error i get when i click on the link 1054 - Unknown column 'products_options_values_id' in 'field list' select products_options_id, products_options, products_options_values_id, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '8' and orders_products_id = '33' [TEP STOP] Link to comment Share on other sites More sharing options...
pup Posted June 17, 2004 Share Posted June 17, 2004 So what URL do we put in the IPN URL? The main domain or http://www.mydomain.com/catalog/checkout_success.php Just a newbie trying to save the world!:) Link to comment Share on other sites More sharing options...
djs Posted June 19, 2004 Share Posted June 19, 2004 Yikes.... neither URL. The IPN is sent to a separate file on your website that will process the order, regardless of the person returning to a particular page. The actual URL you use depends on what version of PayPal IPN you are using, though I think in all cases, the URL is sent from your store and overrides the settings in PayPal. This used to go to http://www.mydomain.com/catalog/paypal_notify.php though I'm not sure what the current versions file name is. Dan Dan Stevens Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.