• 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.