cancel
Showing results for 
Search instead for 
Did you mean: 

Clear Customer Baskets

SOLVED

Clear Customer Baskets

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Clear Customer Baskets

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!

View solution in original post

4 REPLIES 4

Re: Clear Customer Baskets

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!

Re: Clear Customer Baskets

Thanks worked great

Re: Clear Customer Baskets

Great... Glad to help you!

Re: Clear Customer Baskets

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 !

 

 

if issue solved,Click Kudos & Accept as Solution