Jump to content
Supertex

order status, stock change, & returning after paypal ... soo confused

Recommended Posts

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?

 

 

 

 

Share this post


Link to post
Share on other sites

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.


:heart:, osCommerce

Share this post


Link to post
Share on other sites

@@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.  

Share this post


Link to post
Share on other sites

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 by Harald Ponce de Leon

:heart:, osCommerce

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

@@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".

Share this post


Link to post
Share on other sites

@@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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

@@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://forums.oscommerce.com/topic/398299-looking-for-testers-new-paypal-app/


:heart:, osCommerce

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×