Quick Links
Troubleshoot
Guide for WooCommerce Products
WooCommerce Database Table
- actionscheduler_actions
Stores information on actions that will be executed by Action Scheduler. - actionscheduler_claims
- actionscheduler_groups
- actionscheduler_logs
Logs Action Scheduler execution. - woocommerce_sessions
Stores customer session data, such as carts. - woocommerce_api_keys
Stores API Keys used for the REST API. - woocommerce_attribute_taxonomies
Stores global attribute taxonomy names for products. - woocommerce_downloadable_product_permissions
Stores product access permissions for downloadable products (granted
after purchase). - woocommerce_order_items
Stores line items which are associated with orders. - woocommerce_order_itemmeta
Stores meta data about order line items. - woocommerce_tax_rates
Stores tax rates you define in the admin area. - woocommerce_tax_rate_locations
Stores locations (postcodes and cities) associated with the above tax rates. - woocommerce_shipping_zones
Stores shipping zones you create in the settings area. - woocommerce_shipping_zone_locations
Stores locations associated with your shipping zones. - woocommerce_shipping_zone_methods
Stores shipping methods linked to your shipping zones. - woocommerce_payment_tokens
Stores customer payment tokens (used by gateways). - woocommerce_payment_tokenmeta
Stores meta data about payment tokens. - woocommerce_log
General logging table (alternative to file based logging). - wc_webhooks
Stores any webhooks that have been setup on the store. - wc_download_log
Logs user downloads of downloadable products. - wc_product_meta_lookup
Lookup table that indexes order meta data to speed up requests. - wc_tax_rate_classes
Stores tax classes data. - wc_reserved_stock
Stores reserved stock and is used to prevent race conditions during checkout.
WordPress and WooCommerce store orders, products, customer data, and other data like posts and pages:
- wp_posts and wp_postmeta store orders and products separated by a custom post type field called ‘orders.’
- In wp_posts and wp_postmeta, WordPress keeps much of its data, including pages, posts, menu entries, and more.
- Users data are stored in wp_users and wp_usermeta.