douwei6478 2011-03-27 14:45 采纳率: 100%
浏览 109
已采纳

如何删除Magento中所有客户的所有购物车项目?

I want to delete all shopping cart items (products added to cart) of all customers in Magento.

How can I do that?

In detail:-

Suppose, I have total 10 registered customers in my shop. They might have items (products) added to cart. I want to clear all items added to cart for all the 10 registered customers.

  • 写回答

2条回答 默认 最新

  • dongyuanguang3893 2011-03-28 00:47
    关注

    My first guess would be something like,

    $items = Mage::getResourceModel('sales/quote_item_collection');
    
    foreach ($items as $item) {
        $item->delete();
    }
    

    The cart items are stored as part of a 'quote'. Looping through them all like this might be slow, doing it in SQL is quicker but not as safe.

    TRUNCATE `sales_flat_quote_item`;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?