Your Guide to How To Check Woocommerce Product Data Table
What You Get:
Free Guide
Free, helpful information about Payments, Billing & Commerce and related How To Check Woocommerce Product Data Table topics.
Helpful Information
Get clear and easy-to-understand details about How To Check Woocommerce Product Data Table topics and resources.
Personalized Offers
Answer a few optional questions to receive offers or information related to Payments, Billing & Commerce. The survey is optional and not required to access your free guide.
How to Check WooCommerce Product Data Tables: A Complete Guide
Understanding where WooCommerce stores product information — and how to access it — is essential for anyone managing an online store, debugging pricing issues, or building custom queries. Whether you're a store owner, developer, or site admin, knowing how to read and interpret WooCommerce product data tables gives you far greater control over your catalog. 🛒
What Is the WooCommerce Product Data Table?
WooCommerce stores product information across multiple database tables within WordPress's MySQL database. There isn't a single monolithic "product data table" — instead, data is distributed across several related tables that work together.
The core tables involved in product data include:
| Table | What It Stores |
|---|---|
| wp_posts | Core product records (title, status, post type) |
| wp_postmeta | Product metadata (price, SKU, stock, dimensions) |
| wp_wc_product_meta_lookup | Optimized lookup table for product queries |
| wp_wc_order_product_lookup | Sales data linked to products |
| wp_terms / wp_term_relationships | Categories, tags, and attributes |
The wp_postmeta table is where most product-specific fields live — stored as key-value pairs tied to a product's post ID. Fields like _price, _regular_price, _sale_price, _sku, _stock, and _manage_stock all live here.
The wp_wc_product_meta_lookup table was introduced in WooCommerce 3.7+ to improve query performance. It mirrors key product fields in a structured, indexed format specifically optimized for catalog filtering and sorting.
How to Access the WooCommerce Product Data Table
Via phpMyAdmin
The most direct method for most users is through phpMyAdmin, typically accessible through your hosting control panel (cPanel, Plesk, or similar).
- Log into your hosting control panel
- Open phpMyAdmin
- Select your WordPress database from the left sidebar
- Browse to wp_postmeta (your prefix may differ — e.g., mystore_postmeta)
- Use the Search tab to filter by meta_key values like _price or _sku
To view all data for a specific product, note its post ID from the WordPress admin URL (e.g., post.php?post=42) and then query: