Skip to content

Latest commit

 

History

History
28 lines (16 loc) · 1.11 KB

File metadata and controls

28 lines (16 loc) · 1.11 KB

Useful SQL queries for WooCommerce

  • Database cleanup wp_options
  • Exporting order data
  • InnoDB conversion query
  • Reporting counts on Post Types and Post Meta

Usage

Use your favorite SQL application such as Sequel Pro or PhpMyAdmin to execute this query against your WooCommerce database.

Many SQL clients can save the output in CSV format for easy reference or other possible usages.

Author

License

This project is licensed under the MIT License - see the LICENSE file for details.

Credits

Credit to Code Charismatic article for base Export Orders SQL code.

Credit to Kinsta's wp_options cleanup article inspiring the major diagnostic query.

Credit to ModX article on using PhpMyAdmin for easy InnoDB conversion.