where does woocommerce store orders?

sql database wordpress woocommerce
Ke. picture Ke. · Jul 31, 2015 · Viewed 35.5k times · Source

I'm looking in the sql db and I can see something that resembles orders inside wp_posts . However, I would expect them to be inside the tables beginning with wp_woocommerce.

Can anyone shed some light on this phenomenon?

Cheers

Answer

jacks picture jacks · Jul 31, 2015

In woocommerce orders are modelled as a custom post type so they are stored in wp_posts as you found. See WooCommerce taxonomies and post types for a list of the custom post types that woocommerce uses. Orders are stored as the type shop_order

Separate items within an Order are stored as separate records in the custom table woocommerce_order_items

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More