Cleaning up the db after old Shopp install
-
Does anybody have a set of sql statements for removing all Shopp data from all db tables?
ChatGPT says the following, does it look complete?
-- Delete Shopp orders DELETE FROM wp_posts WHERE post_type = 'shopp_order'; -- Delete Shopp order items DELETE FROM wp_postmeta WHERE meta_key = '_shopp_order_items'; -- Delete Shopp customers DELETE FROM wp_posts WHERE post_type = 'shopp_customer'; -- Delete Shopp customer data DELETE FROM wp_postmeta WHERE meta_key LIKE '_shopp_customer_%'; -- Delete Shopp products DELETE FROM wp_posts WHERE post_type = 'shopp_product'; -- Delete Shopp product data DELETE FROM wp_postmeta WHERE meta_key LIKE '_shopp_product_%'; -- Delete Shopp product attributes DELETE FROM wp_terms WHERE term_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_attributes'); DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_attributes'); DELETE FROM wp_term_taxonomy WHERE taxonomy = 'shopp_attributes'; DELETE FROM wp_woocommerce_attribute_taxonomies WHERE attribute_name LIKE 'shopp_%'; -- Delete Shopp categories DELETE FROM wp_terms WHERE term_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_category'); DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_category'); DELETE FROM wp_term_taxonomy WHERE taxonomy = 'shopp_category'; -- Delete Shopp tags DELETE FROM wp_terms WHERE term_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_tag'); DELETE FROM wp_term_relationships WHERE term_taxonomy_id IN (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE taxonomy = 'shopp_tag'); DELETE FROM wp_term_taxonomy WHERE taxonomy = 'shopp_tag'; -- Delete Shopp settings DELETE FROM wp_options WHERE option_name LIKE 'shopp_%';
- The topic ‘Cleaning up the db after old Shopp install’ is closed to new replies.