where does woocommerce store orders?

Updated plug-in version information 8/10/2018

Orders are a custom post type. From WooCommerce Post Types:

  • Shop Order (shop_order)

Orders live in the wp_posts table (post_type = 'shop_order'). More data is available by looking up the order's post_id in the wp_postmeta table.

In addition, from the WooCommerce GitHub Wiki Database Description

  • woocommerce_order_items – Stores line items which are associated with orders.
  • woocommerce_order_itemmeta – Stores meta data about order line items.

Currently the WordPress WooCommerce plug-in version is 3.4.x


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