Clean up commission table

cleanup.sql

-- DO NOT RUN THIS ON YOUR PRODUCTION SYSTEM WITHOUT TESTING IT 

-- REVERSE Commissions RUN THIS ONE ONLY. DO NOT RUN THE SECOND COMMAND
-- FIRST COMMAND HERE
UPDATE `wp_pv_commission` SET `status`='reversed' WHERE `order_id` NOT IN ( SELECT `ID` as `order_id` from `wp_posts` where `post_type` = 'shop_order' and `post_status` != 'trash' );

-- DESTRUCTIVE - USE AS LAST RESORT
-- SECOND COMMAND
-- Deletes all commission rows from the database that doesn't have a corresponding order in the database
DELETE FROM `wp_pv_commission` WHERE `order_id` NOT IN ( SELECT `ID` as `order_id` from `wp_posts` where `post_type` = 'shop_order' and post_status != 'trash' );