sql to export orders periodically

Hi @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
3. Joining our WooCommerce Slack community (it does have a developer channel where you can ask coding questions): https://woo.com/community-slack/

Hope it helps!