When managing a WooCommerce site, especially in a development or staging environment, there may be times when you need to delete all orders. This could be to refresh the database during testing or before syncing data from a live environment. Using MySQL to delete orders is efficient and direct but should be handled with care … Continue reading “MySQL Query: How to Delete all WooCommerce Orders”
Tag: woocommerce
Where Are WooCommerce Products Stored In The WordPress Database?
Sometimes you add new WooCommerce products on your staging site and just want to add those new products to the live site without affecting other data like orders and transactions. Therefore you need to make sure to copy only the relevant tables that contain the WooCommerce product data. Why Knowing Product Storage Locations Matters Understanding … Continue reading “Where Are WooCommerce Products Stored In The WordPress Database?”
MySQL Query – Delete all WooCommerce Bookings
If you need to delete all WooCommerce bookings that have the custom post type wc_booking you can use the MySQL query below: