Eliminar pedidos, carritos y cliente de Prestashop 1.7 por id_shop (multitienda)

delete_orders_cart_and_customer_ps17.sql

# Script SQL para eliminar pedidos, carritos y clientes de Prestashop 1.7 y todas sus tablas relacionadas. 
# Este script sirve para cuando queres desactivar una multitienda que tuvo pedidos hechos o clientes creados y por este motivo no te deja eliminar la tienda.
# Luego de ejecutar este script te va a permitir eliminar la tienda sin problemas.
#
# HACER BACKUP de la base de datos porque una vez ejecutado este script no hay vuelta a atrás.

# Seteo el ID de la tienda a eliminar los pedidos.
set @idShop = 999;

DELETE FROM ps_customer WHERE id_shop = @idShop;
DELETE FROM ps_message WHERE id_cart IN (SELECT id_cart FROM ps_cart WHERE id_shop = @idShop);
DELETE FROM ps_cart_product WHERE id_shop = @idShop;
DELETE FROM ps_order_detail WHERE id_shop = @idShop;
DELETE FROM ps_cart WHERE id_shop = @idShop;
DELETE FROM ps_order_history WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_order_carrier WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_order_cart_rule WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_order_invoice WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_order_return WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_order_slip WHERE id_order IN (SELECT id_order FROM ps_orders WHERE id_shop = @idShop);
DELETE FROM ps_orders WHERE id_shop = @idShop;