Woocommerce DB Struktur

Aus Primatenwiki
Zur Navigation springen Zur Suche springen

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>;