Order has already been placed using this cart **SOLVED**

[Track]

Hi everyone, I've been trying to get to the bottom of this for some time. But I think that I'm getting somewhere now.

Some customers are randomly getting Cart and Payment Errors. Sometimes it won't give an option to pay and other times they'll make it as far as Paypal before not being able to pay.

The logs are saying "Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart"

Having just spoken with a customer who was having this problem, I traced the Object ID through the "Active Shopping Carts" section. I found that the cart number is associated with an order placed when using Prestashop 1.6 back in 2022. The on screen product differs to the one placed in 2022 and the customer associated with the 2022 order hasn't logged in since then.

I paid someone to help with updating to 1.7 and they transferred all the old customers and orders into the new 1.7 shop. I believe that when some new customers put something in a Cart, that cart is being assigned a number used previously on the 1.6 shop.

Another interesting point is that the customer can overcome the problem by switching to Incognito mode in their browser.

Having lived with this problem for nearly a year, it makes me feel sick to wonder how much business we've lost because of it.

I suppose that my question is, what is the easiest way to fix this please?

 

 

Edited August 7, 2024 by Track
Solved (see edit history)

[Track]

I really didn't need the 1.6 carts and customers swapping over. 

Is there a way to just remove the 1.6 data, without upsetting the 1.7 site?

 

[Track]

Are there any moderators operating on here?

Katelyn Shirley responded to this yesterday, in great detail. But that post and my post thanking them has just been removed?

 

[endriu107]

Those response was incorrect also generated by AI and this user was spammer.

This issue "Cart cannot be loaded or an order has already been placed using this cart" means that some process is triggered after order is placed but there is no more access to cart object. In most cases is coused by payment or delivery module.

If issue is not present in incognito mode maybe this is only browser cache to clear.

You should also clear cache by deleting content from var/cache catalog on server.

[Track]

Wow! That's crazy!

I did wonder how someone could come up with all that with their first post.

Thanks for the suggestions but everything in the logs is showing that it's something to do with new cart numbers conflicting with ones already used in the data transferred from the old shop in 1.6

I've witnessed it again in the last 24hrs. 

A Cart was created but the Order number it created was the same as one from 3 years ago in the 1.6 shop. Because of this, the website wouldn't let the customer pay.

 

[endriu107]

In that case you need to alter tables cart and orders, set auto_increment to value that is larger then in last record.

[Track]

Thanks @endriu107

Would that be found in MySQL?

[endriu107]

You must do it in mysql.

[Track]

Thanks for the guidance.

I've done as you suggested and it has sorted the duplicate cart and orders problem.

We're still getting errors in the logs from old cached carts in customer browsers. But I suppose that as time goes by, those will fade out.

There are still other problems within the PayPal checkout process, but that's probably a different issue, so I'll thank you once again and mark this as solved!