Delete all carts in administration

[WEBDVL]

Hello.

How can I add items to the administration the option to delete all the carts?

[rocky]

See this topic.

[WEBDVL]

Hello.

This I knew and I set up ... just like there to add the option to delete all at once?

[rocky]

The only way I can think of to delete all your carts is to run an SQL query. For example, the following query will delete all carts that didn't end up as order:

DELETE FROM `ps_cart` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_orders`);
DELETE FROM `ps_cart_discount` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_orders`);
DELETE FROM `ps_cart_product` WHERE `id_cart` NOT IN (SELECT `id_cart` FROM `ps_orders`);

Change ps_ to your database prefix. Make a backup of your ps_cart, ps_cart_discount and ps_cart_product tables in case something goes wrong. The only problem with this is that all your customers will lose whatever they currently have in their cart and will have to start over.

[Woutermesker]

Go to adminorders.php @ admin/tabs/...............

under $this->colorOnBackground = true;

add this line $this->delete = true;

you can delete all orders you want!...

$this->colorOnBackground = true;
$this->delete = true;

[kolamap]

I added $this->delete = true; and I didn't see a difference in the cart (Back Office >> Customers >> Carts)

/admin/tabs/AdminOrders.php

class AdminOrders extends AdminTab
{
   public function __construct()
   {
       global $cookie, $currentIndex;

        $this->table = 'order';
        $this->className = 'Order';
        $this->view = true;
       $this->colorOnBackground = true;
       $this->delete = true;

Am I doing something incorrectly?

[adu81]

@kolamap
I have the same problem

[archproject]

gosh you guys just edited the wrong file it's suppose to be admincarts.php not adminorders.php .

adminorder.php is to enable delete of orders

admincarts.php is to enable delete of carts