Supertex Posted October 31, 2014 Share Posted October 31, 2014 OSC 2.3.1, PayPal Standard - newest release: 3.2 TLDR: Look at the last text section. I've read quite a few posts about how this works, but I'm still very unclear about how this "should" flow. If there's a definitive post that would clear me up, could someone point me to it? Here's how it currently does flow for me: Customer populates a cart, moves through shipping and arrives at checkout_payment. They have 2 options - Money Order and PayPal. A) Money Order - No order exists until they click "confirm order" on checkout_confirmation. Then the order is set to "Awaiting Money Order", stock is deducted, and emails sent. B) PayPal - Order exists immediately when they click "continue" to move to checkout_confirmation. - Order in admin list is set to "Preparing [PayPal Standard]" - Order status within the order itself shows "No Order Status History Available" - No stock deducted. 1) They click on "Confirm Order" & are taken to PayPal site. - No order status change. - No stock deducted. **Here is where the order should come into existence** 2) They actually submit a payment on the PayPal site. - Order status in admin order list changes to "Pending" - Order status within the order itself shows "PayPal [Transactions]" with comment PayPal IPN Verified. - No stock is deducted - Cart is not cleared - No emails dispatched, either to me or the customer, from my store 3) After the transaction, 2 things can happen: Customer is either auto-returned, or shown a "return to store" button. 4a) They're auto-returned - Order status in admin order list remains "Pending." - Order status within the order itself now shows 3 status lines: 1 - PayPal [Transactions], with comment PayPal IPN Verified. 2 - PayPal [Transactions], with comment PayPal Verified. 3 - Pending, with no comment. - Customer & store notification emails are sent. - Stock is deducted. - Cart is cleared. 4b) They click "Return to Store." - Same as above. 4c) They do not return to the store, whether they closed the browser, hit the 'back' button, fumbled the keyboard and got hung up...whatever. - Order status in admin order list remains "Pending." - Order status within the order itself shows "PayPal [Transactions]" with comment PayPal IPN Verified. - No stock is deducted - No emails are sent. Question about "B": I have several orders that never progress beyond this point. Is there not a way to prevent these "stale" orders from acquiring an order id, and therefore appearing in the admin orders list before they actually click to move to PayPal? Or better yet, until payment has been submitted? It just makes unnecessary clutter in the list, and there's no need to actually SEE them, that I can think of, except it's been an indicator that the customer has cookies disabled, and had issues with the process. Even being able to filter these out of the order list without altering the order query would be nice, but I can't readily alter the drop-down filter to exclude only this type of order, since it just adds a status type to the url. It's either all types or a single type. As I understand, this is somehow necessary to the functionality of the IPN. Question about "3": Why is this different for some customers? I've run transactions on Windows, Mac, Chrome, FF, IE, and Safari, and have had mixed outcomes. I realize this doesn't directly have anything to do with OSC, but surely someone has some insight on, or experience with, this oddity. Is it a browser/OS combination, or is it the way my store is set up? Question about "4a": Should I be seeing both IPN Verified, AND Verified, or do I have some redundancy at work? Question about "4c": Perhaps this is related to the previous question. I thought the IPN had functionality built in, to "finish" the order even if the customer did not return to the site, And by "finish" I mean send notification emails to the customer and to me, and more importantly, deduct stock. If that is in fact how it should be working, can someone suggest where I've gone wrong? Harald Ponce de Leon 1 Quote osC v2.3.1 MySQL v8.0.32 PHP v5.6.40 Installed addons: . Attribute Sets Plus .. Create Account & Manual Order Maker .. Customer Testimonials 2.3.4 .. Customer Blacklist .. Dynamic Info Pages .. FedEx Web Svcs v9 .. Filtered Sales Report .. Generic Box .. Google XML Sitemap SEO .. Maximum Order Value .. Modular Front Page .. Monthly Sales & Tax Report .. Multiple Products Manager .. Must Accept Terms & Conditions .. Order Editior .. PDF Customer Invoice .. Price in Cart Only .. Product Sort/Order .. Product Sort in Cart .. Quantity Discounts .. Restrict Delivery Methods .. SEO Header Tags - Reloaded .. Separate Pricing Per Customer .. Simpler Admin Session Length Control .. Sitemap SEO .. Show Free Ship + Modules .. Specials by Category for SPPC .. Store Mode (open|closed|maintenance) .. Store Pickup Shipping .. Theme Switcher .. Ultimate SEO URLs 5 Pro .. UPS XML Rates & Svcs 1.4 .. USPS methods 7.3.1 .. Who's Online Dashboard . Fixes: Add to cart -> 'product not found' : FIX Login issues with IE 11 : FIX Tools: Incredibly Handy: osC Xref Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted October 31, 2014 Share Posted October 31, 2014 The stock deduction in the IPN call is being looked into for the next PayPal module update. The temporary "Preparing" orders are necessary to keep track of the order information. These can be safely deleted when you know the customer is not going to finalize the order. If you wish to avoid this altogether, try replacing the PayPal Payments Standard module with PayPal Express Checkout. Quote , osCommerce Link to comment Share on other sites More sharing options...
Supertex Posted October 31, 2014 Author Share Posted October 31, 2014 @@Harald Ponce de Leon Thank you for the response, and for your many hours of dedication. Then it is normal to see on the order invoice, both PayPal IPN Verified, AND Paypal Verified, and I am not misconfigured? I thought perhaps only one or the other should show. Quote osC v2.3.1 MySQL v8.0.32 PHP v5.6.40 Installed addons: . Attribute Sets Plus .. Create Account & Manual Order Maker .. Customer Testimonials 2.3.4 .. Customer Blacklist .. Dynamic Info Pages .. FedEx Web Svcs v9 .. Filtered Sales Report .. Generic Box .. Google XML Sitemap SEO .. Maximum Order Value .. Modular Front Page .. Monthly Sales & Tax Report .. Multiple Products Manager .. Must Accept Terms & Conditions .. Order Editior .. PDF Customer Invoice .. Price in Cart Only .. Product Sort/Order .. Product Sort in Cart .. Quantity Discounts .. Restrict Delivery Methods .. SEO Header Tags - Reloaded .. Separate Pricing Per Customer .. Simpler Admin Session Length Control .. Sitemap SEO .. Show Free Ship + Modules .. Specials by Category for SPPC .. Store Mode (open|closed|maintenance) .. Store Pickup Shipping .. Theme Switcher .. Ultimate SEO URLs 5 Pro .. UPS XML Rates & Svcs 1.4 .. USPS methods 7.3.1 .. Who's Online Dashboard . Fixes: Add to cart -> 'product not found' : FIX Login issues with IE 11 : FIX Tools: Incredibly Handy: osC Xref Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted October 31, 2014 Share Posted October 31, 2014 (edited) Both transaction entries should definitely show. PayPal IPN Verified = An IPN has been received and the transaction has been verified with the order. PayPal Verified = The customer has returned back to the store and the transaction has been verified with the order. PayPal Payments Standard sends parameters to and receives parameters from PayPal which the customer can modify. This is the way Payments Standard works and we strictly verify all transactions to make sure they are valid. It's best to actually use the encrypted website payments settings in the module as described here: http://library.oscommerce.com/Package&en&paypal&oscom23&payments_standard If neither transaction is logged, that means a valid IPN was not received (or none was received at all), or that the customer did not return back to the store. Edited October 31, 2014 by Harald Ponce de Leon Quote , osCommerce Link to comment Share on other sites More sharing options...
radhavallabh Posted November 7, 2014 Share Posted November 7, 2014 Hi Using oscommerce 2.3.4 and Paypal 3.2 I am having same issue as 4c -but slightly variation 4c) They return to the store - Order status in admin order list remains "Pending." - Order status within the order itself shows "PayPal [Transactions]" with comment PayPal IPN Verified. - No stock is deducted - No emails are sent. -Shopping Cart not empty Could you please help me too... On how can this be resolved Quote Link to comment Share on other sites More sharing options...
Supertex Posted November 7, 2014 Author Share Posted November 7, 2014 Best I can find at the moment, is to edit checkout_confirmation.php or the associated language file to include something like: "You must return to this store after PayPal is completed to finalize your order." I plan on adding it to the code that display the PayPal logo at the bottom of the page. Quote osC v2.3.1 MySQL v8.0.32 PHP v5.6.40 Installed addons: . Attribute Sets Plus .. Create Account & Manual Order Maker .. Customer Testimonials 2.3.4 .. Customer Blacklist .. Dynamic Info Pages .. FedEx Web Svcs v9 .. Filtered Sales Report .. Generic Box .. Google XML Sitemap SEO .. Maximum Order Value .. Modular Front Page .. Monthly Sales & Tax Report .. Multiple Products Manager .. Must Accept Terms & Conditions .. Order Editior .. PDF Customer Invoice .. Price in Cart Only .. Product Sort/Order .. Product Sort in Cart .. Quantity Discounts .. Restrict Delivery Methods .. SEO Header Tags - Reloaded .. Separate Pricing Per Customer .. Simpler Admin Session Length Control .. Sitemap SEO .. Show Free Ship + Modules .. Specials by Category for SPPC .. Store Mode (open|closed|maintenance) .. Store Pickup Shipping .. Theme Switcher .. Ultimate SEO URLs 5 Pro .. UPS XML Rates & Svcs 1.4 .. USPS methods 7.3.1 .. Who's Online Dashboard . Fixes: Add to cart -> 'product not found' : FIX Login issues with IE 11 : FIX Tools: Incredibly Handy: osC Xref Link to comment Share on other sites More sharing options...
Supertex Posted November 10, 2014 Author Share Posted November 10, 2014 @@Harald Ponce de Leon A thought for the next release... Add into admin module options: Force address override: Y/N $parameters['address_override'] = '0'; Reasonable request? I've had problems for certain customers if left to "1". Quote osC v2.3.1 MySQL v8.0.32 PHP v5.6.40 Installed addons: . Attribute Sets Plus .. Create Account & Manual Order Maker .. Customer Testimonials 2.3.4 .. Customer Blacklist .. Dynamic Info Pages .. FedEx Web Svcs v9 .. Filtered Sales Report .. Generic Box .. Google XML Sitemap SEO .. Maximum Order Value .. Modular Front Page .. Monthly Sales & Tax Report .. Multiple Products Manager .. Must Accept Terms & Conditions .. Order Editior .. PDF Customer Invoice .. Price in Cart Only .. Product Sort/Order .. Product Sort in Cart .. Quantity Discounts .. Restrict Delivery Methods .. SEO Header Tags - Reloaded .. Separate Pricing Per Customer .. Simpler Admin Session Length Control .. Sitemap SEO .. Show Free Ship + Modules .. Specials by Category for SPPC .. Store Mode (open|closed|maintenance) .. Store Pickup Shipping .. Theme Switcher .. Ultimate SEO URLs 5 Pro .. UPS XML Rates & Svcs 1.4 .. USPS methods 7.3.1 .. Who's Online Dashboard . Fixes: Add to cart -> 'product not found' : FIX Login issues with IE 11 : FIX Tools: Incredibly Handy: osC Xref Link to comment Share on other sites More sharing options...
Supertex Posted November 10, 2014 Author Share Posted November 10, 2014 @@radhavallabh May help: catalog/includes/languages/(your language)/modules/payment/paypal_standard.php: define('MODULE_PAYMENT_PAYPAL_STANDARD_TEXT_PAYPAL_RETURN_BUTTON', 'Complete My Order'); // Maximum length 60 characters, otherwise it is ignored. This replaces "Return to (store name)" button text on the PayPal site with "Complete My Order" indicating more clearly the need to return to the store. Original text implies nothing. radhavallabh 1 Quote osC v2.3.1 MySQL v8.0.32 PHP v5.6.40 Installed addons: . Attribute Sets Plus .. Create Account & Manual Order Maker .. Customer Testimonials 2.3.4 .. Customer Blacklist .. Dynamic Info Pages .. FedEx Web Svcs v9 .. Filtered Sales Report .. Generic Box .. Google XML Sitemap SEO .. Maximum Order Value .. Modular Front Page .. Monthly Sales & Tax Report .. Multiple Products Manager .. Must Accept Terms & Conditions .. Order Editior .. PDF Customer Invoice .. Price in Cart Only .. Product Sort/Order .. Product Sort in Cart .. Quantity Discounts .. Restrict Delivery Methods .. SEO Header Tags - Reloaded .. Separate Pricing Per Customer .. Simpler Admin Session Length Control .. Sitemap SEO .. Show Free Ship + Modules .. Specials by Category for SPPC .. Store Mode (open|closed|maintenance) .. Store Pickup Shipping .. Theme Switcher .. Ultimate SEO URLs 5 Pro .. UPS XML Rates & Svcs 1.4 .. USPS methods 7.3.1 .. Who's Online Dashboard . Fixes: Add to cart -> 'product not found' : FIX Login issues with IE 11 : FIX Tools: Incredibly Handy: osC Xref Link to comment Share on other sites More sharing options...
MrPhil Posted November 10, 2014 Share Posted November 10, 2014 Hasn't there been a chronic problem with customers failing to return from PayPal (and perhaps other Third Party payment systems), resulting in their PP accounts being charged, but osC being unaware of this? You wouldn't want to clear/cancel the order until you're sure that they didn't actually pay. As I've said before, osC really, really needs (as a standard feature) something to slap customers upside the head before they go offsite to make a Third Party payment, if osC is counting on getting a success/failure indication from the payment system. I would go so far as to make a full screen message reminder requiring an acknowledgment before proceeding offsite. @@Shawn's rewording of the prompt would be a good start, but I'm not sure it's enough. If that fails to work, does osC have a means to periodically look for hanging transactions and either automatically check with the payment system, or at least email the store admin that they should investigate this? Quote Link to comment Share on other sites More sharing options...
radhavallabh Posted November 11, 2014 Share Posted November 11, 2014 @@Supertex Thanx that code will surely help get them returning for now ..... :) Quote Link to comment Share on other sites More sharing options...
Harald Ponce de Leon Posted November 11, 2014 Share Posted November 11, 2014 @@MrPhil that's no longer necessary as stock deduction and order emails are now handled by the IPN too. Those that are able to help test the updated modules should review this topic: http://www.oscommerce.com/forums/topic/398299-looking-for-testers-new-paypal-app/ Quote , osCommerce Link to comment Share on other sites More sharing options...
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.