connect to order data in database / mysql

  • haiflosse2

    (@haiflosse2)


    9 years ago

    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.
Viewing 2 replies - 1 through 2 (of 2 total)
  • kursora

    (@kursora)

    9 years ago

    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

    (@haiflosse2)

    9 years ago

    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.