Exporting customer order notes natively?

Hi @dajuan54,

I’m afraid WooCommerce’s built-in order export doesn’t include customer order notes as an export column out of the box. However, a couple of options that won’t cost much:

• The free version of this plugin does allow you to include order notes as an export column, which may be exactly what you need.
• If you’re comfortable with phpMyAdmin or have WP-CLI access, customer order notes are stored in the wp_comments table where comment_type = 'order_note'. A simple query filtered by date can pull all of last month’s notes alongside the order ID.

SELECT
c.comment_post_ID AS order_id,
c.comment_date AS note_date,
c.comment_content AS order_note
FROM wp_comments c
WHERE c.comment_type = 'order_note'
AND c.comment_date >= DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01')
AND c.comment_date < DATE_FORMAT(NOW(), '%Y-%m-01')
ORDER BY c.comment_post_ID ASC;

A couple of notes to include when sharing:

• Replace wp_ with your actual database prefix if it’s different (you can check in WooCommerce → Status → Database)
• If you’re on HPOS, order notes are still stored in wp_comments with comment_type = 'order_note' so this query works regardless
• This can be run in phpMyAdmin → SQL tab, and the result can be exported directly as CSV from there using the Export button at the bottom of the results

I hope that helps. Let me know if you need anything else.

• This reply was modified 1 day, 21 hours ago by Frank Remmy (woo-hc).
• This reply was modified 1 day, 21 hours ago by Frank Remmy (woo-hc).