Skip to content

Instantly share code, notes, and snippets.

@MitsuhaKitsune

MitsuhaKitsune/prestashop_cleanup.sql

Created December 3, 2018 06:32
Show Gist options
  • Save MitsuhaKitsune/9a1b99e577d938670e02882629589f3a to your computer and use it in GitHub Desktop.
Save MitsuhaKitsune/9a1b99e577d938670e02882629589f3a to your computer and use it in GitHub Desktop.
Download ZIP
Cleanup for prestashop database
Raw
prestashop_cleanup.sql
DELETE FROM `ps_orders` WHERE `id_order` IN (0);
DELETE FROM `ps_order_carrier` WHERE `id_order` NOT IN (SELECT `id_order` FROM `ps_orders` WHERE `id_order` IS NOT NULL);
DELETE FROM `ps_order_cart_rule` WHERE `id_order` NOT IN (SELECT `id_order` FROM `ps_orders` WHERE `id_order` IS NOT NULL);
DELETE FROM `ps_order_detail` WHERE `id_order` NOT IN (SELECT `id_order` FROM `ps_orders` WHERE `id_order` IS NOT NULL);
DELETE FROM `ps_order_detail_tax` WHERE `id_order_detail` NOT IN (SELECT `id_order_detail` FROM `ps_order_detail` WHERE `id_order_detail` IS NOT NULL);
DELETE FROM `ps_order_history` WHERE `id_order` NOT IN (SELECT `id_order` FROM `ps_orders` WHERE `id_order` IS NOT NULL);
DELETE FROM `ps_order_invoice` WHERE `id_order` NOT IN (SELECT `id_order` FROM `ps_orders` WHERE `id_order` IS NOT NULL);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment