Woocommerce Question posted in
The official Woocommerce documentation can be found here.

How do I delete orders from a cloned WooCommerce site?

I have used NS Cloner to clone site within WooCommerce. This has worked extremely well but the existing orders have been duplicated in the cloned site; I obviously would like remove all of these. In total there are 17,000 or more that I need to remove so doing this in the Admin area isn’t an option as it does in 20 batches. There isn’t an option to do a bulk delete. I have a suspicion I make have to do this at a mysql level. There is a plugin out there (WC Delete All Orders) but the reviews are less than favourable.

Could some one point me in the right direction please?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    So I used SQL query for this one:

    UPDATE wp_posts SET post_status = 'trash' WHERE post_type = 'shop_order';

    from this link - how to delete completed orders in woocommerce using a my sql query


  2. 0

    You can use this plugin in order to delete in bulk
    https://wordpress.org/plugins/woocommerce-store-toolkit

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search