Efficient SQL query for exporting typical order and line item data from WooCommerce
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
LICENSE
README.md
export-orders.sql

README.md

WooCommerce Export Orders SQL

Efficient SQL query for exporting typical order and line item data from WooCommerce

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.

Credit to contributors at this Code Charismatic blog post for the base SQL code. Modified to include further order data.

Todo

  • Add column for total order discount amount

Author

License

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