One of my clients uses the plugin Woocommerce Order/Customer CSV Export to export his customers’ orders into a spreadsheet for managing a mailing list. The other day, he emailed me to tell me that instead of being prompted to download the CSV when he clicked the “Export” button, he was getting a nasty screen-full of text.
It took a while to troubleshoot, but it turned out the problem was caused by the 34,000+ records that CSV Export had inserted into the WordPress comments and commentmeta tables. Each time the client was clicking that “Export” button, a new record was added to each table for each exported order, and as the number of orders added up, the records were increasing proportionally. Not only was it causing serious database-bloat, but it was also cluttering up the Order Notes box for each order with “Order exported to CSV and successfully downloaded” notes that the client neither wanted or needed.Continue reading “Turn Off Pesky Order Notes for Woocommerce Order/Customer CSV Export”