Clear Customer Baskets

[miller75]

I have just Migrating to 2.3.2 from 1.9, I need to clear all the existing customer baskets as I have deleted some products and voucher codes

Can anyone confirm its all the quote tables I need to truncate?

Thanks

[Vimal Kumar · Accepted solution]

Hi @miller75,

You can delete all the records from quote table using below query.

Take a db backup before execute the query.

Delete from quote;

It will delete all quote data from main table quote and its related tables automatically.

I hope it will help you!

[miller75]

Thanks worked great

[Vimal Kumar]

Great... Glad to help you!

[Manthan Dave]

Hi @miller75 

Yes - its confirm that you need to truncate all the quote tables.

Basically When you add product to the cart, magento will have entries in sales_flat_quote,sales_flat_quote_item and sales_flat_quote_address

The items in the basket are saved to sales_flat_quote_item, linked by the quote's entity_id

So delete from the quote table will truncate everything - you can use delete query posted by @Vimal Kumar  it will helps you to delete the same.

Hope it helps !