Turn Off "open" Carts? On Orders Page

Just upgraded to 4.3.1, and now seeing "Open" Carts listed on my "Orders" page. How can I prevent these from being shown? How can I prevent these "Open" orders from being listed on our Orders page? The customers didn't finish their purchase and these are filling up our Orders page.

Before I upgrade to 4.3.1, only "Complete" Green orders were listed.

Thank you for your help and support!

Please provide a screen shot.

1) You shouldn't see incompleted orders. They would be accessible from the menu on the orders page.

2) Abandoned carts are not even orders yet. They can't be displayed on your orders page. An abandoned cart will NOT have an order_id.

Why did you stop at 4.3.2 rather than continuing your upgrade through 4.3.4 so you'd be current?

After updating, We now get these Orange "Open" orders. No payment is recorded in Paypal. I presumed these were Abandoned carts. I'd like to turn these off, so they're not filling up our Orders page.

CS-Cart description:

Open – Order has been placed and created in the store database, but it hasn't been processed yet.

CS-Cart told us our Host's Server is timing out when attempting to upgrade to 4.3.4. I checked with Gator Hosting, they checked everything and confirmed server is ok. Here is support ticket dialogue, with names removed
Thank you for the message.
We will contact you at the first opportunity. However, I am afraid that our technical support department is loaded heavily at the moment. You should expect our answer not earlier than in 1-2 business days. We apologize for any possible inconvenience.
Most probably, this issue will require additional examination on your server. If the temporary operational FTP or cPanel/SSH access credentials have not been provided to us yet, please add them by clicking on the Add record link on the Access information page of your Help Desk account and let us know about it in this ticket so that we can check the problem.
Thank you.
---
Sincerely yours,
Technical support engineer
CS-Cart Knowledge Base: http://kb.cs-cart.com
CS-Cart Reference Guide: https://www.cs-cart.com/reference-guide.html
CS-Cart Community Forums: http://forum.cs-cart.com
Our technical support team works Monday - Friday, 9 a.m. - 6 p.m., our local time is UTC+3
compose.gifreply_bw.gif
Posted by: Staff time: Oct 2, 2015, 02:39 Client time: Oct 1, 2015, 18:39 ID: #101352261
Dear
I also provided a cs-cart admin access too.
Thanks
compose.gifreply_bw.gif
Posted by: Staff time: Oct 2, 2015, 02:35 Client time: Oct 1, 2015, 18:35 ID: #101352259
Dear,
We contacted hostgator to figure out the upgrade problem. They added code for no abort in .htaccess so they script could run without php timing out. Unfortunately, that didn't work. The upgrade still fails.
I created an ftp access for you and posted it on my account. Please take a look.
THanks
compose.gifreply_bw.gif
Posted by: Staff time: Sep 28, 2015, 10:53 Client time: Sep 28, 2015, 02:53 ID: #101350077
Dear
I tried several times to upgrade from 4.3.1 to 4.3.2 but it fails every time.
I tried suggestions in http://forum.cs-cart.com/topic/42009-upgrade-from-431-432-fails-silently/
but no luck.
What can I do to upgrade?
Thank you for your patience and sorry for the delay in answering.
As far as I understand, the upgrade stops on backup in your case, too? The issue is most likely caused by server-side timeouts. We recommend to contact your server administrator and ask to increase the script execution timeouts. If you are using the FastCGI server API, pay attention to the FastCGI timeouts.
We can examine this issue more carefully if you provide FTP access to the server. In this case please make a backup of the installation files and database first. You can provide the FTP credentials on the Access information page of your Help desk account.
Thank you.
---
Sincerely yours,
Technical support engineer
CS-Cart Knowledge Base: http://kb.cs-cart.com
CS-Cart Reference Guide: https://www.cs-cart.com/reference-guide.html
CS-Cart Community Forums: http://forum.cs-cart.com
Our technical support team works Monday - Friday, 9 a.m. - 6 p.m., our local time is UTC+3
compose.gifreply_bw.gif
Posted by Staff time: Sep 24, 2015, 21:17 Client time: Sep 24, 2015, 13:17 ID: #101349334
I tried several times to upgrade from 4.3.1 to 4.3.2 but it fails every time.
I tried suggestions in http://forum.cs-cart.com/topic/42009-upgrade-from-431-432-fails-silently/
but no luck.
What can I do to upgrade?

We had this happen when we were using a custom status and then the status gets deleted. The system doesn't know what to assign the status to so it sets it to "Open."

In our case, we have an add-on that requires a few custom statuses. there was a bug in the addon that required us to uninstall and re-install the new version as the old one simply could not be patched.

Tbirnseth might be able to tell if custom statuses are removed for some upgrade scenarios as I don't know but I wouldn't think they would be.

Is what I'm experiencing, a default setting CS-Cart implemented in 4.3.1 - 4.3.2?

i don't think so. If you are using only the order statuses provided by CSC on 4.3.1, there should be no changes to 4.3.2.

What i'm saying is if you did not use custom statuses in 4.3.1 then there should be no issues. What I don't know is if the upgrade wipes out custom statuses or not.

Our issue was the add-on that we had to remove and re-install to upgrade. Our "custom" statuses we were using for the add-on were installed by it and then got wiped out by the UN-install of the add-on, which then set all of our orders using the statuses set by the add-on to "Open" because their statuses got deleted and the system didn't know what else to do so it said "All orders are now OPEN" lol.

It makes sense, we should have thought about it first but this would only apply to you IF you were using custom order statuses in CSC v4.3.1 AND the upgrade to 4.3.2 overwrites your statuses to CSC Default (effectively deleting your custom statuses)

You can see how this works by creating a new status called "Test" then creating a phone order. Assign the order to status "Test" then save. Delete Order status "Test" then check your phone demo order. You will see the status should set to "Open" because the system has no idea what's going on and "Open" is the safest status to default to.

Are you sure you didn't have a custom status that was deleted manually? you may not have noticed the impact if you did it just before trying to upgrade.

You're mixing two separate issues in this one thread.

  1. Orders in Open status - This is caused when you use paypal and the customer doesn't complete the payment. Either they changed their mind or they had difficulty on paypal. Contact the customer to find out what their issues is/was. Order is created and customer sent to paypal. But they never return.
  2. Upgrade failure - Given what you've posted (and I'm surprised helpdesk didn't respond with the same), you should be able to use the solution here: http://forum.cs-cart.com/topic/41860-upgading-from-433sp1-434/?hl=app.php#entry230111

Is what I'm experiencing, a default setting CS-Cart implemented in 4.3.1 - 4.3.2?

No, this has been the way that paypal has behaved since at least V2.x.

My apologies, he made it sound like they were in status other than "Open" before the upgrade and after they were "Open."

Thanks for the correction!

My comments weren't directed to your response. Sometimes it's hard to tell exactly what people mean. Language, culture, technical knowledge, familiarity with cs-cart terms, etc. all play into trying to get meaning on the forums.

As for PayPal issue, there are two possible reasons:

1. IPN is not received from PayPal and the payment information is not changed

2. IPN is received, but the incorrect status conversion map is used

Please check the settings of the PayPal module:

http://prntscr.com/8nx8ag

@eComLabs

Before the upgrade to 4.3.1, Orders appeared as either

"Processed" - Until we've changed it to "Completed"

"Open" - Meaning it's an ECheck or ?

Now, almost everything comes into our Orders page as "Open" ....Could our issue be related to not being compliant with Paypal's IPN change? I don't know how to check and confirm whether or not our site is conforming to their new requirements


1. Discontinue use of the VeriSign G2 Root Certificate
2. Update your integration to support certificates using the SHA-256 algorithm

https://www.paypal-knowledge.com/resources/sites/PAYPAL/content/live/FAQ/1000/FAQ1766/en_US/2015%20Merchant%20Security%20System%20Upgrade%20Guide%20%28U.S.%20English%29.pdf

@tbirnseth, I will have my Web Dev look into your suggestion solution link

Thanks again for your patience and support!

Paypal was completely revamped in V4. I don't believe that IPN is required to be used. Using it eliminates the issue of the user not clicking the return-to-xxx.com link to get the orders from Open to Processed.

Look up the paypal instructions for your version in the knowledge base. When I converted from V2.2.5 to V4.3.4, I didn't touch my paypal settings and all works as it should. But if a customer doesn't click the return-to-website link then the order shows paid in paypal and open in the cart.

So in your case I would suggest you seup and use IPN per the paypal instructions in the knowledge base. http://kb.cs-cart.com/paypal

.Could our issue be related to not being compliant with Paypal's IPN change?

Hi, were you able to verify if this has something to do with the new algorithm? 1.gif

Try the following solution and inform us about the result

http://forum.cs-cart.com/topic/42197-paypal-standard-not-working-correctly/?hl=connection#entry232259