Title: connect to order data in database / mysql
Last modified: July 27, 2017

---

# connect to order data in database / mysql

 *  [haiflosse2](https://wordpress.org/support/users/haiflosse2/)
 * (@haiflosse2)
 * [9 years ago](https://wordpress.org/support/topic/order-data-in-database/)
 * I use wordpress 4.8 with woocommerce 3.1.1 and Need the order data from database
   to create invoices.
    Where (in which table) can I find the orders. I Need the
   Name, Adresse, phonenumber, email from the customer, ordernumber and ordered 
   items. I will connect from a MS-Access to the mysql database to creaate the invoices.
 * Or there exist an possibility (plugin) that the data will automaticle Export 
   to an XML or xls or Textfile to a ftp Server.
 * Hope somebody can help me there.
    kindly regards.
    -  This topic was modified 9 years ago by [haiflosse2](https://wordpress.org/support/users/haiflosse2/).

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

 *  [kursora](https://wordpress.org/support/users/kursora/)
 * (@kursora)
 * [9 years ago](https://wordpress.org/support/topic/order-data-in-database/#post-9369361)
 * Orders are stored in posts table (it depends on database prefix, default wp_posts).
   Details are stored i postmeta table (wp_postmeta).
 *  Thread Starter [haiflosse2](https://wordpress.org/support/users/haiflosse2/)
 * (@haiflosse2)
 * [9 years ago](https://wordpress.org/support/topic/order-data-in-database/#post-9390410)
 * Kindly regards for your answer.
    I Need also the items which will be ordered.
 * I notice a record _woocommerce_t4m_discount_coeffs with the data {“243”:{“coeff”:
   0,”orig_price”:”89.9″,”quantity”:1},”307″:{“coeff”:0,”orig_price”:”12.9″,”quantity”:
   1}}
 * But I Need also my itemnumber and the item description.
    Where can I find this
   Information in the database. kindly regards

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

The topic ‘connect to order data in database / mysql’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3640790)
 * [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/)

 * 2 replies
 * 2 participants
 * Last reply from: [haiflosse2](https://wordpress.org/support/users/haiflosse2/)
 * Last activity: [9 years ago](https://wordpress.org/support/topic/order-data-in-database/#post-9390410)
 * Status: not resolved