Search your WooCommerce site database

Searching the WordPress database on your WooCommerce site can help you quickly find and manage important information, like product details, order histories, and customer data.

Note: This document is meant to serve as a helpful guide for advanced troubleshooting; however, the procedures described are beyond the scope of our support policy and we cannot provide direct assistance with implementing them. 

If you would like to seek assistance from a qualified WordPress/WooCommerce Developer, we highly recommend Codeable, or a Certified WooExpert

Where does your site database store WooCommerce information?

↑ Back to top

In your WooCommerce database, specific tables organize and store key information. Here’s a quick look at where to find essential data:

  • Orders and Order Information: If you have HPOS (High Performance Order Storage) enabled custom order tables store order information. Otherwise, order information is stored in tables like wp_posts (for order data) and wp_postmeta (for order details like item prices, order status, etc.).
  • Products and Variations: Found in the wp_posts table (for product listings) and wp_postmeta (for details like prices, SKU, and attributes). The table also stores variations as separate entries.
  • Shipping Settings: Typically located in wp_options (for general shipping settings) and wp_postmeta (for order-specific shipping details).
  • Tax Settings: Stored in wp_options, including tax rates, rules, and other configurations.
  • Customer Information: Found in wp_users (for registered users) and wp_usermeta (for additional user details like billing and shipping addresses).

Some WooCommerce extensions such as WooCommerce Subscriptions, AutomateWoo, Product Bundles and Composite Products create additional custom post types or custom tables. For more information, refer to the documentation pages of the extension you are using.

Finding information in your site’s database

↑ Back to top

Please note that making changes to your site’s database can have major effects on the entire site. Always back up your site before making any database changes, and contact your hosting provider for guidance if you’re unsure.

Most hosting providers offer a tool called phpMyAdmin to access your site’s database. However, it’s a good idea to check with your hosts to confirm which tools they provide.

In this example, we are going to search for a product in the database.

In the below example, the product “T-Shirt With Logo” has a permalink t-shirt-with-logo and the browser address bar shows the product’s post ID is 35.

Screenshot of the WordPress admin area showing a WooCommerce product with title "T-shirt with logo", the address bar showing product ID 35 and the URL permalink slub as t-shirt-with-logo

As mentioned, products are stored in the wp_posts table of the database.

  1. When you have accessed your site’s database, find the wp_posts table:
Screenshot of the wp_posts table in phpMyAdmin
  1. Click on Search, enter “product” in the post_type and click on “Go”. This will filter your view of the rows in wp_posts to just products.
Screenshot of the search tool in phpMyAdmin, highlighting searching for product as the post_type
  1. You can then enter your search query in the “Filter rows” box. For the product “T-shirt with logo”, the search term “logo” will load products with that search term in the title. Searching for the product’s post ID (35) or the permalink (“t-shirt-with-logo”) would also load this product.
Screenshot of search results for product with the search term logo in phpMyAdmin

4. Once you have found the product you’re looking for, you can then edit, copy or delete directly from within the database.

Questions and Support

↑ Back to top

Do you still have questions and need assistance? 

  • Get in touch with a Happiness Engineer via our Help Desk. We provide support for extensions developed by and/or sold on WooCommerce.com, and Jetpack/WordPress.com customers.
  • If you are not a customer, we recommend finding help on the WooCommerce Support Forum or hiring a WooExpert agency. They are trusted agencies with a proven track record of building highly customized, scalable online stores. Learn more about WooExpert agencies.
Use of your personal data
We and our partners process your personal data (such as browsing data, IP Addresses, cookie information, and other unique identifiers) based on your consent and/or our legitimate interest to optimize our website, marketing activities, and your user experience.