Title: Exporting customer order notes natively?
Last modified: May 12, 2026

---

# Exporting customer order notes natively?

 *  [dajuan54](https://wordpress.org/support/users/dajuan54/)
 * (@dajuan54)
 * [1 day, 23 hours ago](https://wordpress.org/support/topic/exporting-customer-order-notes-natively/)
 * Just wondering if there is a way to easily export all customer order notes from
   last month? I need to share them with my shipping team but don’t want to buy 
   an expensive addon for that.

Viewing 1 replies (of 1 total)

 *  Plugin Support [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/)
 * (@frankremmy)
 * [1 day, 22 hours ago](https://wordpress.org/support/topic/exporting-customer-order-notes-natively/#post-18905505)
 * Hi [@dajuan54](https://wordpress.org/support/users/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](https://wordpress.org/plugins/order-import-export-for-woocommerce/)
      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_noteFROM wp_comments cWHERE 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, 22 hours ago by [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/).
    -  This reply was modified 1 day, 22 hours ago by [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/).

Viewing 1 replies (of 1 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexporting-customer-order-notes-natively%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Frank Remmy (woo-hc)](https://wordpress.org/support/users/frankremmy/)
 * Last activity: [1 day, 22 hours ago](https://wordpress.org/support/topic/exporting-customer-order-notes-natively/#post-18905505)
 * Status: not resolved