Cart Comes To Its Knees With 200+ Products

I am using 2.25 and my server has 6 gb"s of ram.

After a customer has 200 or more products, the cart really starts to slow down. With 300+ it takes a long time to update. And with 400+ products a customer can no longer make changes while viewing the cart contents. It just times out. Viewing the cart does display a thumbnail but the thumbnails are only about 5kb each

Any ideas anybody??

Who is your hosting provider?

My Provider is Knownhost. One of their best plans. 16 cpu's equal share. and 6 gigs ram.The site is pretty snappy and responds well. That is, until a customer has a large order. Then It really struggles when they hit view cart. At 400 products it just times out. All the other parts of the site still cruise right along. Clearing the cache is ineffective in helping as well. Boo

OK. I've not experienced anything like that because my customers don't put that much stuff in their carts....30 would probably be the max. Maybe someone else will chime in here. Have you considered upgrading to the latest version of the cart?

I Definitely want to upgrade to the latest version. Especially since the PHP version limitations of 2.25. With all my custom mods tho, I'm sure I'm looking at more than a few bucks for someone to do the upgrade and transfer the hole site to my other server. (SSD) Also will probably take a hit on SEO. That is whats really causing me to put it off. Im ranked very high in many of my important search terms.

Btway, Thanks for replying King!

There are several factors with large carts:

  1. Every time one is added, a full cart recalculate is done
  2. Promotions are also processed for each add to cart and there are some recent bug fixes to address promotions continuing to process even when one of the "all these are true" is false. If you have a large number of promotions, disable those not in use.
  3. Shipping quote may/may not be requested for add to cart (depends on your config) but if this is a realtime quote, it can be quite expensive.
  4. If you use buy-together, this could also be slowing you down.

Question: How is checkout speed with 200+ items in a cart? Or is it only the add-to-cart that is problematic?

I think very little performance work has been done on large carts (number of items in cart). The greatest effort has been put into larger order volume, concurrent users (customer volume) and large product counts.

In the config.php file you can enabled the debugger and check possible reasons of the performance issue

I am not using any promotions. Also, only 1 shipping price for shipments. No buy-together or things like that.

With 200+ Items, adding more products to the cart happens ok, just a little slow. View cart bogs way down and updating any changes to the cart contents are slow to take.

With 300+ items, adding additional items to the cart takes 5-10 seconds. view cart and updating changes to the cart are very slow.

with 400+ items adding more products or view cart changes simply time out.

it isnt often I recieve an order with this many products. The bummer is my customer who does spend all the time with this many products added is super pissed off they cant complete the order or make any changes.

How about recommending to the customer that they order twice, 200 products each time?

Yes, I definetly did that. She was quick to point out (rightfully so) that my competitors carts do not have this issue.

Her order is $5000+ and i had to convince her that this is an isolated incedent. She wants to make changes to the order before placing it, but is unable to do any cart updates. Simply times out before updating.

I sure hope this problem is a resolvable problem vs. a weakness in the cart architecture that will be an ongoing issue. If not, could be a deal breaker. Super bummed out.

Do these products have product options?

Yes, Each product has 2 options

I am using 2.25 and my server has 6 gb"s of ram.

After a customer has 200 or more products, the cart really starts to slow down. With 300+ it takes a long time to update. And with 400+ products a customer can no longer make changes while viewing the cart contents. It just times out. Viewing the cart does display a thumbnail but the thumbnails are only about 5kb each

Any ideas anybody??

Let me inform you that Simtech Development provides a full range of Server Management & Server administration services for CS-Cart store owners. Our DevOps specialists are ready to configure the server up to your needs, enhance your website

performance and make the system secure.

If you need Server Management & Server Administration service, please do not hesitate to contact us at: sales@simtechdev.com and get a free quote.

Every time the cart contents are changed, the cart is recalculated. I'm guessing this is the overhead you are seeing.

How much memory is configured for your server? Also, can you (or your hosting) look at the server load and other performance data while a user is trying to manipulate a 200+ item cart?

My customer was not willing to wait for a fix. I had to delete about 100 products to get the order to place. Then place an additional order. The deleting was excruciating as it took the cart about 1 minute per item to remove. Good news is the order was placed.

I did some testing on an additional site I am building. It's on a separate server, 4 gigs of ram, SSD. Its the latest version 4.36. With 300+ items, the cart does bog down some but is still responsive. Placing my test order on 4.36 took the cart about 30 seconds, but it did it. Its becoming clear i need to upgrade my old reliable 2.25. BOOOOO Thanks for all the input everyone who offered help!