A client of mine has a rather large WooCommerce database. We’ve been trying to run reports using the WooCommerce Customer/Order CSV Export plugin but have been running into timeout issues—the glorious WordPress white screen of death. I got fed up…
Tag: sql
SQL Script To Get All WooCommerce Orders Including Metadata
Posted in: Code Samples, Development | Tagged with: e-commerce, reporting, sql, woocommerce | Leave a comment
WooCommerce: How To “Trash” All Orders Really Fast
Some context I am working on a WooCommerce installation where I’m dealing with literally thousands of historical orders. All of which I am programmatically importing (including user accounts!) and doing a bunch of special updates, which are numerous and complicated,…
WordPress: How To Update Site URL And Home URL Using SQL
I do this often enough. You think it’d be committed to memory by now. Alas, my memory doesn’t need to be bothered with things like this. That’s what my blog is for. So here blog, remember this. I also, like…
