reed_bird Posted May 7, 2007 Share Posted May 7, 2007 I just looked at my Paypal account and a customer has paid for an item. All of the info is there except what the item is!! I haven't received an email that I have a sale and there are no orders showing anywhere on my admin site. I don't want to email this guy and look like an idiot "thanks for your money. UH by the way...what did you order?" Please help!!! Quote Link to comment Share on other sites More sharing options...
Jack_mcs Posted May 7, 2007 Share Posted May 7, 2007 Unfortunately, that is what you will have to do. What you describe is a common problem with the stock paypal module. Install the paypal IPN one to prevent it from happening again. But there is no hope for this one. Jack Quote Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
reed_bird Posted May 7, 2007 Author Share Posted May 7, 2007 But shouldn't something in my basic OsCommerce setup say that I have an order? What I have is a basic install only a few color changes. If I hadn't checked my PayPal account, I never would have known that there was an order. I don't think this is a paypal error, it looks like an OSC error... Quote Link to comment Share on other sites More sharing options...
squalid Posted May 7, 2007 Share Posted May 7, 2007 reread jack mcs's reply. you could also install master password to see what was in customers basket http://www.oscommerce.com/community/contri...master+password Quote Link to comment Share on other sites More sharing options...
oschellas Posted May 7, 2007 Share Posted May 7, 2007 Can't you see the order in your: admin - customers - orders? Did you specify your e-mail at: admin - Configuration - My Store - Send Extra Order Emails To? Quote Link to comment Share on other sites More sharing options...
crash3903 Posted May 7, 2007 Share Posted May 7, 2007 But shouldn't something in my basic OsCommerce setup say that I have an order? What I have is a basic install only a few color changes. If I hadn't checked my PayPal account, I never would have known that there was an order. I don't think this is a paypal error, it looks like an OSC error... Sorry Susan it is not an error of osc (Although it shouldn't have been designed that way ;) ) What happens is when your customer goes to paypal to pay for the goods the order table in the database is not updated with the order. This happens when the customer returns to the store. If they close the window or go to a site other than yours after payment is complete the order is not inserted in your store orders section What Jack is suggesting is to install the Paypal IPN (IPN Stands for Instant Payment Notification). This inserts the order into the order table in the database so if the previous happens the order is logged - Make sense? The master password is a good idea for this order HTH Quote Regards Mark A Reynolds Link to comment Share on other sites More sharing options...
Guest Posted May 8, 2007 Share Posted May 8, 2007 Sorry Susan it is not an error of osc (Although it shouldn't have been designed that way ;) ) What happens is when your customer goes to paypal to pay for the goods the order table in the database is not updated with the order. This happens when the customer returns to the store. If they close the window or go to a site other than yours after payment is complete the order is not inserted in your store orders section What Jack is suggesting is to install the Paypal IPN (IPN Stands for Instant Payment Notification). This inserts the order into the order table in the database so if the previous happens the order is logged - Make sense? The master password is a good idea for this order HTH I have the same problem, (and I didn't know it untill I read this thread)! But I have one question for anyone please. When I go to install paypal IPN it asks me for a url that it will use to notify me on?? Can anyone please tell me in layman speak what this means? What address do I type in? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
Guest Posted May 9, 2007 Share Posted May 9, 2007 I have the same problem, (and I didn't know it untill I read this thread)! But I have one question for anyone please. When I go to install paypal IPN it asks me for a url that it will use to notify me on?? Can anyone please tell me in layman speak what this means? What address do I type in? Thanks in advance. I have the same problem. Which URL to you right? Is it the URL that takes you to the Order module in admin? Somebody must know! Thanks! Quote Link to comment Share on other sites More sharing options...
imback_pagalkutta Posted July 10, 2007 Share Posted July 10, 2007 hi always happens 2 us newbies july 11, guess its way 2 late 2 help but im sure more ppl are gonna stuff up like us problem: you receive the money via paypal, but you don;t know the order: Temporary solution: if u dont intend to use a master pwd: download your sql file, (Tools>backup database>download(Carefull) ) open it with excel so that data is easy to manage, from the database, note the 'customer id' of the customer who ordered>>>'insert into customers' field find this field: insert into customers_basket (customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added) values ('1212', '15', '393', '1', NULL, '271276822212'); say customer id is 15 as above, you will have multiple lines of 15 with different products, note 'products_id' of all those lines and match with your product. in the end, total em products up and tally the amount you received U r done this time, download hold order for paypal module Quote Link to comment Share on other sites More sharing options...
Guest Posted July 11, 2007 Share Posted July 11, 2007 hialways happens 2 us newbies july 11, guess its way 2 late 2 help but im sure more ppl are gonna stuff up like us problem: you receive the money via paypal, but you don;t know the order: Temporary solution: if u dont intend to use a master pwd: download your sql file, (Tools>backup database>download(Carefull) ) open it with excel so that data is easy to manage, from the database, note the 'customer id' of the customer who ordered>>>'insert into customers' field find this field: insert into customers_basket (customers_basket_id, customers_id, products_id, customers_basket_quantity, final_price, customers_basket_date_added) values ('1212', '15', '393', '1', NULL, '271276822212'); say customer id is 15 as above, you will have multiple lines of 15 with different products, note 'products_id' of all those lines and match with your product. in the end, total em products up and tally the amount you received U r done this time, download hold order for paypal module Much easier to install the pending order email contrib. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 2, 2007 Share Posted August 2, 2007 Much easier to install the pending order email contrib. We have the same problem...i don't know how to install anything but have figured out that the items show up in the unsold cart. If I have an item that needed a color choice or such, I contact the customer. My web designer says there is now way to fix this. Apparently that is another issue we need to talk about. Thanks for starting the thread. Quote Link to comment Share on other sites More sharing options...
erniethemilk Posted August 2, 2007 Share Posted August 2, 2007 I have this very same problem, and am glad its not just me who has not thought they were going round the twist! I'll try installing Paypal IPN Sorry Susan it is not an error of osc (Although it shouldn't have been designed that way ;) ) Not sure how someone can say its not an error of OSC - if an order from the ecommerce site isn't showing then how is this not an error of OSC's??? Quote Link to comment Share on other sites More sharing options...
♥Loaded Commerce Posted August 6, 2007 Share Posted August 6, 2007 I have the same problem. Which URL to you right? Is it the URL that takes you to the Order module in admin? Somebody must know! Thanks! I you can leave this blank in your paypal IPN settings. The payment module - paypal IPN passes the IPN url during checkout. If you do need the url we use /checkout_process.php, meaning https://YOURSECUREURLHERE.COM/checkout_process.php Also i advise that you read the intructions in the paypal IPN download - they prob speak to this directly. Quote Best Regards, Salvatore Iozzia Loaded Commerce - Oscommerce - All Loaded Up. Link to comment Share on other sites More sharing options...
erniethemilk Posted August 7, 2007 Share Posted August 7, 2007 OK, I thought the Paypal IPN was already included - but it isn't is it - obviously thinking about another software program that does include it, something else you've gotta go away and find and then figure out when it doesn't work :rolleyes: Dunno about anyone else, but I'm finding OSC to be a real ballache at the moment.... it really isn't for the feinthearted who want to get on and use an online shop is it?? It seems to be more for those who want an online shop they can tinker with constantly :( :( :( Quote Link to comment Share on other sites More sharing options...
Guest Posted August 25, 2007 Share Posted August 25, 2007 I have this very same problem, and am glad its not just me who has not thought they were going round the twist! I'll try installing Paypal IPNNot sure how someone can say its not an error of OSC - if an order from the ecommerce site isn't showing then how is this not an error of OSC's??? Simple. It's because Paypal does not send the information back to your database. That's why you need to install the IPN (Instant Paymet Notification) module. This will cure the problem. :thumbsup: Quote Link to comment Share on other sites More sharing options...
satish Posted August 25, 2007 Share Posted August 25, 2007 go for the recover cart solution. Satish Quote Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.