Woocommerce DB Struktur

Orders

• Table:

  wp_posts

• post_type:

  shop_order

Order Item:

• Table:

  wp_woocommerce_order_items

Order Item Meta:

• Table:

  wp_woocommerce_order_itemmeta

Query:

SELECT * FROM wp_woocommerce_order_items i
JOIN wp_woocommerce_order_itemmeta m ON i.order_item_id = m.order_item_id
WHERE i.order_id = <order_number>;