Wp_postmeta shipping ON orders.ID=shipping.post_idĮven for little things, fetching a piece of data can be way quick using TablePlus than even just looking at the order entry itself in WordPress. Get some order/post meta for a specific set of IDS: SELECT Update order statuses in bulk: UPDATE wp_posts Status in ('failed','complete','pending')Īnd hook in ('woocommerce_scheduled_subscription_payment') If you are familiar with customizing the Safari browser window on Mac. Get progress of ActionScheduler during subscription renewal periods: select status,Ĭount(*) from wp_actionscheduler_actions where First, you can change the layout of TablePlus’ toolbar, buttons, and colors to suit your style. Here’s the types of queries I run on a regular basis. These days I do a lot of work with WooCommerce. Here’s a screenshot of what the settings should look like. The program lies within Developer Tools, more precisely DB Tools. The current setup file available for download requires 49 MB of hard disk space. Our built-in antivirus scanned this Mac download and rated it as 100 safe. Make sure to get your IP address whitelisted, include the cert, and get the ports right. TablePlus 5.3.2 for Mac can be downloaded from our software library for free. WP Engine has remote database access instructions here. First, you can change the layout of TablePlus’ toolbar, buttons, and colors to suit your style. Using TablePlus with WP EngineĬonnecting to a local database and most remote databases should be pretty straightforward, but there’s a few extra steps if the database is hosted with WP Engine. TablePlus is the best one one I’ve found for the Mac.
Having a nice GUI to make direct database queries can be really helpful when working with a complex WordPress site.
0 kommentar(er)
