Hi @wpguillaume! There is a script that should remove those if you deactivate and remove the plugin via WP Admin. How did you uninstall it?
If you didn’t do it that way, you should be able to reinstall and deactivate it that way to remove those tables/entries.
WooCommerce Admin created database tables are as follows.
wp_wc_admin_note_actions
wp_wc_admin_notes
wp_wc_category_lookup
wp_wc_customer_lookup
wp_wc_download_log
wp_wc_order_coupon_lookup
wp_wc_order_product_lookup
wp_wc_order_stats
wp_wc_order_tax_lookup
Deactivate and delete of WooCommerce Admin plugin from wp-admin did not remove any of the WooCommerce Admin created database tables this was with version 0.24.0 of WooCommerce Admin.
@apmwebdev I had disabled then uninstalled WooCommerce Admin from the WP dashboard.
I just installed it again, enabled, disabled then uninstalled, and experienced the same behaviour as @lukefiretoss : tables are still there. Thank you for the complete list, btw!
Wouldn’t an identical wc_admin_ prefix for all tables be nice? Some of the names introduce confusion with tables from the WooCommerce plugin.
I removed all tables and all WooCommerce admin related scheduled actions.
Could you let me know if there is any other data I should clean from other database tables?
Thank you.
wp_wc_category_lookup
wp_wc_customer_lookup
wp_wc_download_log
wp_wc_order_coupon_lookup
wp_wc_order_product_lookup
wp_wc_order_stats
wp_wc_order_tax_lookup
Are all WooCommerce Admin feature plugin created custom database tables and not ones from WooCommerce.
Yes, that’s what I had understood from your first post.
I was pointing out that because they all are WooCommerce Admin tables, they could all begin with the same prefix.
I was also wondering if WooCommerce Admin could have written into other tables than its own.
Sorry for not being clear about this!
OK, thanks for the heads up @lukefiretoss and @wpguillaume . I’ve alerted our devs to the issue and hope to hear back from them soon.
Any news yet? Will these tables be used when we upgrade woocommerce to 4.0?
Hi there,
– For the plugin, the tables are only removed if you delete the plugin through the plugin screen. If they are not getting removed when going through this process, there may be a different plugin that is holding onto the tables themselves.
– For the tables themselves, they will be added back in WC 4.0. With 4.0 scheduled here in the next month or so, you can leave them in the site as they should not cause any conflicts themselves.
I hope this information helps!
Greetings,
We have not heard back from you in a bit, so I will go ahead and close this thread.
If you continue to have the current issue please reply and let us know, otherwise if you have a new issue open a new thread.
