where does woocommerce store orders?

Question

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

score 22 · Accepted Answer · edited Feb 17 '22 at 07:40

22

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

edited Feb 17 '22 at 07:40

Adrian

2,233
1
22
33

answered Jul 31 '15 at 12:39

jacks

4,614
24
34

I was looking for _billing_address and fields like this, but I can see these references in the code are actually functions that are drawing data from several tables :/ – Ke. Jul 31 '15 at 12:47
2

`_billing_address` is in `wp_postmeta` as it is simply meta for the `order` post. – helgatheviking Jul 31 '15 at 14:31
Omg, thank you, but wp dev is so tricky... Architecture? No, did not hear... – Oleg Reym Sep 07 '21 at 14:06

score 18 · Answer 2 · edited Feb 17 '22 at 07:41

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

score 5 · Answer 3 · answered Mar 15 '16 at 17:38

5

WooCommerce orders are "custom post" they are stored in "wp_posts" under "post_type" -> ""shop_order"

if you want to select shop orders with sql query you can do something like below.

global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'shop_order'", ARRAY_A );

answered Mar 15 '16 at 17:38

Aamer Shahzad

2,617
1
27
25

this does not include items - you also need wp_woocommerce_order_items wp_woocommerce_order_itemmeta – Peter Kionga-Kamau Nov 28 '18 at 22:10

csandreas1 · Answer 4 · 2019-02-20T18:50:16.583

3

You can find them inside wp_posts table.

In PhpMyAdmin:

Click wp_posts table, then click SQL Tab and run the following query, assuming wp_posts is your table name:

Select * from wp_posts where post_type='shop_order'

Then you have all the data regarding woocommerce orders

click "Show all" checkbox

Search for "completed" for completed orders

edited Feb 20 '19 at 18:50

answered Feb 18 '19 at 16:52

csandreas1

2,026
1
26
48

score 0 · Answer 5 · answered Jul 31 '15 at 12:41

0

wp_woocommerce_order_itemmeta
wp_woocommerce_order_items
wp_posts

Depending on the kind of data your looking for you have to look in diffrent places. If you have PHPMyAdmin try and find the data your looking for.

answered Jul 31 '15 at 12:41

Dylan Wijnen

219
3
13

score 0 · Answer 6 · answered Mar 01 '18 at 09:27

I recently restored the orders data manually and here is the table I found.

wp_posts //post_type = shop_order
wp_postmeta 
wp_woocommerce_order_items
wp_woocommerce_order_itemmeta

Make sure your order_id/order_item_id reference is correct on postmeta and itemmeta.

where does woocommerce store orders?

6 Answers6