requête SQL pour une plage d'IDs de commande

Créé par vistalid r&d, Modifié le Jeu, 7 Mai à 4:00 H par vistalid r&d
-- Remplacez les valeurs des IDs par les limites de votre plage
SET @id_order_min = 100; -- ID de départ
SET @id_order_max = 200; -- ID de fin

-- Supprimer les détails des commandes
DELETE FROM ps_order_detail WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les paiements associés
DELETE FROM ps_order_payment WHERE order_reference IN (
    SELECT reference FROM ps_orders WHERE id_order BETWEEN @id_order_min AND @id_order_max
);

-- Supprimer les factures associées
DELETE FROM ps_order_invoice WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les messages associés
DELETE FROM ps_message WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les transporteurs liés
DELETE FROM ps_order_carrier WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les retours produits associés
DELETE FROM ps_order_return WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les détails des retours produits
DELETE FROM ps_order_return_detail WHERE id_order_return IN (
    SELECT id_order_return FROM ps_order_return WHERE id_order BETWEEN @id_order_min AND @id_order_max
);

-- Supprimer l'historique des statuts des commandes
DELETE FROM ps_order_history WHERE id_order BETWEEN @id_order_min AND @id_order_max;

-- Supprimer les paniers associés
DELETE FROM ps_cart WHERE id_cart IN (
    SELECT id_cart FROM ps_orders WHERE id_order BETWEEN @id_order_min AND @id_order_max
);

-- Supprimer les données de personnalisation associées
DELETE FROM ps_customized_data WHERE id_cart IN (
    SELECT id_cart FROM ps_orders WHERE id_order BETWEEN @id_order_min AND @id_order_max
);

-- Supprimer les commandes principales
DELETE FROM ps_orders WHERE id_order BETWEEN @id_order_min AND @id_order_max;