Title: sql to export orders periodically
Last modified: February 22, 2024

---

# sql to export orders periodically

 *  Resolved [johannashiri](https://wordpress.org/support/users/johannashiri/)
 * (@johannashiri)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/sql-to-export-orders-periodically/)
 * Hi,
 * I need to export all order data once a day (and send it to somewhere).
 * I’m planning to do it with php & sql on the backend.
 * Is there a place where I can see how all the order data is stored in wordpress
   tables? can you provide me with such an sql?
 * Thanks

Viewing 1 replies (of 1 total)

 *  [ckadenge (woo-hc)](https://wordpress.org/support/users/ckadenge/)
 * (@ckadenge)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/sql-to-export-orders-periodically/#post-17448032)
 * Hi [@johannashiri](https://wordpress.org/support/users/johannashiri/),
 * I understand you would like to export all WooCommerce order data with the help
   of MySQL and PHP.
 * Helping out with custom coding of this nature is outside the scope of support,
   although I would recommend the following:
    1. Running the exact question you’re asking, through an AI platform like ChatGPT,
       for recommendations.
    2. Checking online for possible results. A quick search pointed out some good results
       here: [https://gist.github.com/lukecav/60836976190e2f1ccd8ab15564cbfe9c](https://gist.github.com/lukecav/60836976190e2f1ccd8ab15564cbfe9c)
    3. Joining our WooCommerce Slack community (it does have a developer channel where
       you can ask coding questions): [https://woo.com/community-slack/](https://woo.com/community-slack/)
 * Hope it helps!

Viewing 1 replies (of 1 total)

The topic ‘sql to export orders periodically’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [phpadmin](https://wordpress.org/support/topic-tag/phpadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * 1 reply
 * 2 participants
 * Last reply from: [ckadenge (woo-hc)](https://wordpress.org/support/users/ckadenge/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/sql-to-export-orders-periodically/#post-17448032)
 * Status: resolved