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_commentmetawp_commentswp_optionsOption 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_idwp_postmetawp_postsCustom post type:
productCustom post type:product_formCustom post type:product_variationCustom post type:shop_couponCustom post type:shop_webhookwp_termmetawp_termsCustom 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_providerwp_usermeta