Title: sql to export customer/order source
Last modified: August 31, 2016

---

# sql to export customer/order source

 *  Resolved [joaquinv](https://wordpress.org/support/users/joaquinv/)
 * (@joaquinv)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-to-export-customerorder-source/)
 * I would like to export the source for the Customer and Orders data. What is the
   easiest way to do this? I would think sql, but please tell me if I am incorrect.
   Thanks Joaquin
 * [https://wordpress.org/plugins/woocommerce-hear-about-us/](https://wordpress.org/plugins/woocommerce-hear-about-us/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [PieterC](https://wordpress.org/support/users/siteoptimo/)
 * (@siteoptimo)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-to-export-customerorder-source/#post-7004068)
 * Hi Joaquin,
 * The easiest way depends on your skills. In [this thread](https://wordpress.org/support/topic/reports-export-spreadsheet),
   Caroline exported everything to a CSV.
 * We’re planning to add exporting/reporting as a future feature.
 * Regards,
 * Pieter
 *  Thread Starter [joaquinv](https://wordpress.org/support/users/joaquinv/)
 * (@joaquinv)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-to-export-customerorder-source/#post-7004070)
 * Thanks. I am more comfortable at the database level can you provide an sql statement
   that would help? Thanks.
 *  Plugin Author [PieterC](https://wordpress.org/support/users/siteoptimo/)
 * (@siteoptimo)
 * [10 years, 4 months ago](https://wordpress.org/support/topic/sql-to-export-customerorder-source/#post-7004261)
 * Hi Joaquinv,
 * It’s added as a simple metafield to the product posttype so you can definitely
   get it that way, but you should probably try it for yourself, it depends on how
   you want to use it.
 * The way Caroline did is is the easiest way right now.
 * Regards
 * P.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘sql to export customer/order source’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/woocommerce-hear-about-us_81a22d.
   svg)
 * [WooCommerce Hear About Us](https://wordpress.org/plugins/woocommerce-hear-about-us/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-hear-about-us/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-hear-about-us/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-hear-about-us/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-hear-about-us/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-hear-about-us/reviews/)

## Tags

 * [Customer](https://wordpress.org/support/topic-tag/customer/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [order](https://wordpress.org/support/topic-tag/order/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 3 replies
 * 2 participants
 * Last reply from: [PieterC](https://wordpress.org/support/users/siteoptimo/)
 * Last activity: [10 years, 4 months ago](https://wordpress.org/support/topic/sql-to-export-customerorder-source/#post-7004261)
 * Status: resolved