- Plesk for Windows
- Plesk for Linux
Where does WooCommerce keep records related to products?
WooCommerce keeps such records in
<prefix>_posts table of WordPress's database.
Find out what database is used for a WordPress website (e.g.
Log into MySQL server by running the following command (in CMD or Putty):
# plesk db
Open the database (for example, wordpress_e) for editing:
MariaDB [psa]> use wordpress_e;
Use this database to find the required information.
For example, to count the number of products use the following query:
MYSQL_LIN: mysql> select count() from f6X802aV_posts where post_type='product';
| count() |
| 47 |