WooCommerce

Everything you need to launch an online store in days and keep it growing for years. From your first sale to millions in revenue, Woo is with you.

38 database tables

Table Name	Description	Method
wp_actionscheduler_actions	Stores actionscheduler actions data created by this plugin.	Static
wp_actionscheduler_logs	A logging table that records activity, events, or audit history.	Static
wp_wc_admin_note_actions	Stores wc admin note actions data created by this plugin.	Static
wp_wc_admin_notes	Stores wc admin notes data created by this plugin.	Static
wp_wc_category_lookup	Stores wc category lookup data created by this plugin.	Static
wp_wc_customer_lookup	Stores wc customer lookup data created by this plugin.	Static
wp_wc_download_log	A logging table that records activity, events, or audit history.	Static
wp_wc_order_addresses	Stores order records and related transaction data.	Static
wp_wc_order_coupon_lookup	Stores order records and related transaction data.	Static
wp_wc_order_fulfillment_meta	Stores additional metadata (key-value pairs) for wc order fulfillment records.	Static
wp_wc_order_fulfillments	Stores order records and related transaction data.	Static
wp_wc_order_product_lookup	Stores order records and related transaction data.	Static
wp_wc_order_stats	Stores order records and related transaction data.	Static
wp_wc_order_tax_lookup	Stores order records and related transaction data.	Static
wp_wc_orders_meta	Stores additional metadata (key-value pairs) for wc orders records.	Static
wp_wc_product_attributes_lookup	Stores product records and related data.	Static
wp_wc_product_download_directories	Stores product records and related data.	Static
wp_wc_product_meta_lookup	Stores additional metadata (key-value pairs) for wc product meta lookup records.	Static
wp_wc_rate_limits	Stores wc rate limits data created by this plugin.	Static
wp_wc_reserved_stock	Stores wc reserved stock data created by this plugin.	Static
wp_wc_tax_rate_classes	Stores wc tax rate classes data created by this plugin.	Static
wp_wc_webhooks	Stores wc webhooks data created by this plugin.	Static
wp_woocommerce_api_keys	Stores woocommerce api keys data created by this plugin.	Static
wp_woocommerce_attribute_taxonomies	Stores woocommerce attribute taxonomies data created by this plugin.	Static
wp_woocommerce_downloadable_product_permissions	Stores product records and related data.	Static
wp_woocommerce_log	A logging table that records activity, events, or audit history.	Static
wp_woocommerce_order_itemmeta	Stores order records and related transaction data.	Static
wp_woocommerce_order_items	Stores order records and related transaction data.	Static
wp_woocommerce_payment_tokenmeta	Stores access tokens for authentication or API access.	Static
wp_woocommerce_payment_tokens	Stores access tokens for authentication or API access.	Static
wp_woocommerce_sessions	Stores session data for tracking user or visitor state.	Static
wp_woocommerce_shipping_flat_rate_boxes	Stores woocommerce shipping flat rate boxes data created by this plugin.	Static
wp_woocommerce_shipping_table_rates	Stores woocommerce shipping table rates data created by this plugin.	Static
wp_woocommerce_shipping_zone_locations	Stores woocommerce shipping zone locations data created by this plugin.	Static
wp_woocommerce_shipping_zone_methods	Stores woocommerce shipping zone methods data created by this plugin.	Static
wp_woocommerce_shipping_zones	Stores woocommerce shipping zones data created by this plugin.	Static
wp_woocommerce_tax_rate_locations	Stores woocommerce tax rate locations data created by this plugin.	Static
wp_woocommerce_tax_rates	Stores woocommerce tax rates data created by this plugin.	Static

Core Table Usage

This plugin stores data in WordPress core tables rather than creating its own. These records may become orphaned if the plugin is uninstalled without a proper cleanup routine.

wp_commentmeta

Comment meta

wp_comments

Direct access

wp_options

Option key:costOption key:cost_per_orderOption key:feeOption key:minimum_feeOption key:page_commentsOption key:require_name_emailOption key:shop_Option key:versionOption key:woocommerce_Option key:woocommerce_allow_trackingOption key:woocommerce_calc_discounts_sequentiallyOption key:woocommerce_calc_shippingOption key:woocommerce_cart_page_idOption key:woocommerce_category_archive_displayOption key:woocommerce_change_password_page_idOption key:woocommerce_checkout_page_idOption key:woocommerce_currencyOption key:woocommerce_default_customer_addressOption key:woocommerce_edit_address_page_idOption key:woocommerce_enable_reviewsOption key:woocommerce_hide_products_when_showing_subcategoriesOption key:woocommerce_local_tax_ratesOption key:woocommerce_local_tax_rates_backupOption key:woocommerce_lock_down_adminOption key:woocommerce_logout_page_idOption key:woocommerce_lost_password_page_idOption key:woocommerce_myaccount_page_idOption key:woocommerce_pay_page_idOption key:woocommerce_permalinksOption key:woocommerce_prepend_category_to_productsOption key:woocommerce_prepend_shop_page_to_productsOption key:woocommerce_prepend_shop_page_to_urlsOption key:woocommerce_product_category_slugOption key:woocommerce_product_slugOption key:woocommerce_product_tag_slugOption key:woocommerce_review_rating_verification_requiredOption key:woocommerce_ship_to_billingOption key:woocommerce_ship_to_billing_address_onlyOption key:woocommerce_ship_to_countriesOption key:woocommerce_ship_to_destinationOption key:woocommerce_shop_page_displayOption key:woocommerce_shop_page_idOption key:woocommerce_shop_show_subcategoriesOption key:woocommerce_show_subcategoriesOption key:woocommerce_store_pages_onlyOption key:woocommerce_tax_ratesOption key:woocommerce_tax_rates_backupOption key:woocommerce_thanks_page_idOption key:woocommerce_tracker_uaOption key:woocommerce_view_order_page_id

wp_postmeta

Post meta

wp_posts

Custom post type:productCustom post type:product_formCustom post type:product_variationCustom post type:shop_couponCustom post type:shop_webhook

wp_termmeta

Term meta

wp_terms

Custom taxonomy:pos_product_visibilityCustom taxonomy:product_brandCustom taxonomy:product_catCustom taxonomy:product_shipping_classCustom taxonomy:product_tagCustom taxonomy:product_typeCustom taxonomy:product_visibilityCustom taxonomy:wc_fulfillment_shipping_provider

wp_usermeta

User meta