Where does WooCommerce keep records related to products?

Created:

2017-06-13 19:00:20 UTC

Modified:

2017-08-16 16:02:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Where does WooCommerce keep records related to products?

Applicable to:

  • Plesk for Windows
  • Plesk for Linux

Question

Where does WooCommerce keep records related to products?

Answer

WooCommerce keeps such records in <prefix>_posts table of WordPress's database.

  1. Find out what database is used for a WordPress website (e.g. wordpress_e ).

  2. Log into MySQL server and open wordpress_e for editing:

    # plesk db
    MariaDB [psa]> use wordpress_e;
  3. Use this database to find the required information.

    For example, to count the number of products use the following query:

    mysql> select count(*) from f6X802aV_posts where post_type='product';
    +----------+
    | count(*) |
    +----------+
    |       47 |
    +----------+
Have more questions? Submit a request
Please sign in to leave a comment.