Find WooCommerce Products in the WP Database
WooCommerce product data can be found in the following tables:
- wc_product_meta_lookup (product ID or product_variation ID)
- wc_order_product_lookup (product ID or product_variation ID)
- posts (product ID or product_variation ID)
- postmeta (product or product_variation)
- posts (product ID or product_variation ID)
Find WooCommerce Orders in the WP Database
WooCommerce order data can be found in the following tables:
HPOS
_wc_order_addresses
_wc_order_operational_data
_wc_orders_meta
Find WooCommerce Orders in the WP Database
WooCommerce order data can be found in the following tables:
- woocommerce_order_items
- woocommerce_order_itemmeta
- posts (shop_order ID)
- postmeta (shop_order)
- comments (order_note)
| Function Name | Functionality |
| actionscheduler_actions | To complete a list of functions ‘Action Scheduler’ function is used. |
| actionscheduler_claims | |
| actionscheduler_groups | |
| actionscheduler_logs | Actions completed by ‘Action Scheduler’ are stored at ‘Action Scheduler Logs.’ |
| woocommerce_sessions | Contains the consumer’s cart. |
| woocommerce_api_keys | API keys storage. |
| woocommerce_attribute_taxonomies | Categories, tags, etc. |
| woocommerce_downloadable_product_permissions | Downloads access permissions. |
| woocommerce_order_items | Line items linked to orders. |
| woocommerce_order_itemmeta | Line items meta-data. |
| woocommerce_tax_rates | Manual setup of tax rate list. |
| woocommerce_tax_rate_locations | Location-based tax rates data. |
| woocommerce_shipping_zones | List of custom shipping zones. |
| woocommerce_shipping_zone_locations | Shipping zones location. |
| woocommerce_shipping_zone_methods | Shipping methods for each zone. |
| woocommerce_payment_tokens | Payment tokens for WooCommerce. |
| woocommerce_payment_tokenmeta | Metadata of WooCommerce payment token. |
| woocommerce_log | Event log. |
| wc_webhooks | Webhooks |
| wc_download_log | Download log |
| wc_product_meta_lookup | Metadata of product’s lookup table. This function makes it quicker to search for products inside orders. |
| wc_tax_rate_classes | Tax classes |
| wc_reserved_stock | Reserved stock to ensure availability at checkout. |
