If you need to delete all WooCommerce bookings that have the custom post type wc_booking you can use the MySQL query below:
Category: Knowledge Base
MySQL Query: How to Delete all WooCommerce Orders
Use this MySQL query to delete all woocommerce orders at once from the MySQL command line. This can be useful if you want to delete all orders on your staging site and then import all orders again from the live site to make the staging site up to date before pushing it to the live … Continue reading “MySQL Query: How to Delete all WooCommerce Orders”
Revolution Slider X Theme Record not found
Did you install the X Theme by theme.co and got the message “Record not found” after installing the demo content or activating the slider revolution plugin? A bug causes this in the X Theme WordPress theme, which you can resolve very quickly. The reason for that issue is that X Theme expects at least one previously … Continue reading “Revolution Slider X Theme Record not found”
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 which contain the WooCommerce products data. Products are located mainly in 2 tables: … Continue reading “Where Are WooCommerce Products Stored In The WordPress Database?”
Serialized Data, What Does That Mean And Why is it so Important?
Note: This article is for people interested in how WordPress technically stores its data. If you just like to use WP Staging, you do not need to read or understand the article below. WordPress core and most of its plugins are storing data in the database in a particular format, so-called serialized data representation. That … Continue reading “Serialized Data, What Does That Mean And Why is it so Important?”