Categories: Magento

How To Clear / Delete Shopping Cart Items of Single or All Customers in Magento.?

Clear or Delete Shopping Cart Items of Single users in Magento:-

With the following code one can remove the cart items of the currently logged in single customers respectively:

$cart = Mage::getSingleton('checkout/cart'); 
$quoteItems = Mage::getSingleton('checkout/session')
                  ->getQuote()
                  ->getItemsCollection();
 
foreach( $quoteItems as $item ){
    $cart->removeItem( $item->getId() );    
}
$cart->save();

Clear or Delete Shopping Cart Items of all customers in Magento:-

With this code one can remove all cart items for all users from Magento shopping cart accordingly:

$quoteCollection = Mage::getModel('sales/quote')
            ->getCollection()
            ->addFieldToFilter('is_active', 1);
                        
foreach ($quoteCollection as $item) {
    $item->delete();    
}

Large number of customer quotes can be time consuming and resources can hand the server so use the following SQL query that can delete all Magneto all customer cart items:

DELETE FROM sales_flat_quote WHERE is_active = 1;

is_active = 0 means those quotes have been converted into orders, i.e. customer has placed order for those quotes.
is_active = 1 means quotes that have not been ordered, i.e. quotes present in the shopping cart of customers


Running this query will automatically delete the related rows (quote ‘items’) from sales_flat_quote_item table through foreign key constraint accordingly.

Rohan pathak

Recent Posts

Modern Toys, Magical Moments: Why the Best Toy Shop in Noida Is More Than Just a Store

When it comes to children, there’s one universal truth: the right toy can spark imagination, build skills, and make memories…

6 months ago

Rediscovering Joy: A New Era of Creativity & Comfort in Toy Stores

In today’s digital age, where screens and gadgets dominate our children’s lives, there’s something heartwarming about a well-loved plush toy…

6 months ago

Unboxing Imagination: Discovering the Joy of Play at a Toy Store in Noida

In a world dominated by screens and fast-paced routines, it’s easy to forget the simple magic of a toy in…

6 months ago

Imagination Unboxed: Discover Joy at the Toy Shop in Delhi

In the heart of Delhi’s vibrant streets lies a world where imagination meets innovation — the magical universe of toys.…

7 months ago

Play with Purpose: Discovering the Ultimate Toy Store in Noida

When was the last time a toy truly amazed you—not just as a product, but as a thoughtful tool for…

7 months ago

From Tears to Toys: Exploring Modern Childhood through Delhi’s Favorite Toy Shop

In the digital age, the way we experience childhood has changed, but the essence remains the same—imagination, exploration, and joy.…

7 months ago