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
Solved! Go to Solution.
Thanks worked great
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 !