Installed Database Tables

Installed database tables

↑ Back to top

WooCommerce creates several custom database tables during installation to store order, product, and customer data. This reference describes each table and its purpose, covers table prefix requirements, and explains how to remove tables when uninstalling WooCommerce.

Core tables

↑ Back to top

WooCommerce adds the following custom tables to your WordPress database. Each table name is prefixed with your WordPress database prefix (typically wp_). The tables below cover order storage, product data, customer records, and other operational data that WooCommerce needs.

Order tables

↑ Back to top

These tables store order-related data, including order details, addresses, operational records, and metadata:

• wc_orders — Stores core order records, including order status, currency, totals, and dates.
• wc_orders_meta — Stores additional metadata associated with orders.
• wc_order_addresses — Stores billing and shipping addresses for each order.
• wc_order_operational_data — Stores operational details such as payment and shipping data for orders.
• wc_order_stats — Stores aggregated order statistics used by WooCommerce Analytics.
• wc_order_product_lookup — Links orders to products for reporting and lookup purposes.
• wc_order_tax_lookup — Stores per-order tax data for analytics.
• wc_order_coupon_lookup — Links orders to applied coupons for reporting.

Product tables

↑ Back to top

These tables store product-specific information used for lookups, downloads, and attributes:

• wc_product_meta_lookup — Stores a flattened version of key product metadata for faster queries.
• wc_product_attributes_lookup — Stores product attribute data used for layered navigation and filtering.
• wc_product_download_directories — Stores approved directories for downloadable product files.
• woocommerce_downloadable_product_permissions — Tracks which customers have permission to access downloadable products.

Customer tables

↑ Back to top

These tables store customer session and lookup data:

• wc_customer_lookup — Stores customer data used by WooCommerce Analytics for reporting.
• woocommerce_sessions — Stores customer session data, including cart contents and session variables.

Shipping and tax tables

↑ Back to top

These tables store configuration data for shipping zones and tax rates:

• woocommerce_shipping_zones — Stores shipping zone definitions.
• woocommerce_shipping_zone_locations — Stores the geographic locations assigned to each shipping zone.
• woocommerce_shipping_zone_methods — Stores the shipping methods assigned to each shipping zone.
• woocommerce_tax_rates — Stores tax rate definitions.
• woocommerce_tax_rate_locations — Stores location-based tax rate rules.

Other tables

↑ Back to top

WooCommerce also creates the following tables for logging, category data, and API access:

• woocommerce_log — Stores internal log entries generated by WooCommerce.
• wc_category_lookup — Stores a lookup table for product category relationships.
• wc_webhooks — Stores webhook definitions configured in your store.
• woocommerce_api_keys — Stores REST API keys for authentication.
• wc_rate_limits — Stores rate-limiting data for API requests.
• wc_reserved_stock — Tracks temporarily reserved stock during the checkout process.
• woocommerce_payment_tokens — Stores payment tokens for saved payment methods.
• woocommerce_payment_tokenmeta — Stores metadata associated with payment tokens.

For a complete technical description of each table and its schema, refer to the WooCommerce database description on GitHub.

Table prefix requirements

↑ Back to top

WooCommerce uses your WordPress database table prefix when creating its tables. If you define a custom SQL table prefix, keep it under 20 characters. A prefix that is 20 characters or longer prevents WooCommerce from creating all of its tables, which can cause problems such as completed order emails missing download links.

Remove tables on uninstall

↑ Back to top

WooCommerce does not remove its database tables when you deactivate the extension. Tables are only removed during a full uninstall, and this does not happen automatically. To delete all WooCommerce tables from your database, follow the instructions in Uninstalling WooCommerce.

Questions and support

↑ Back to top

Do you still have questions and need assistance? 

• If you’re looking to extend the core functionality shown here, we recommend reviewing available extensions in the WooCommerce Marketplace.
• Need ongoing advanced support or a customization built for WooCommerce? Hire a Woo Agency Partner.
• Are you a developer building your own WooCommerce integration or extension? Check our Developer Resources.

If you weren’t able to find the information you need, please use the feedback thumbs below to let us know.