Products are located mainly in 2 tables: wp_posts table with a post_type product or product_variation, wp_postmeta table with the corresponding post_id by product (the product ID). Product types, categories, subcategories, tags, attributes and all other custom taxonomies for particular products are located in the tables below: wp_terms wp_termmeta wp_term_taxonomy wp_term_relationships wp_woocommerce_termmeta wp_woocommerce_attribute_taxonomies (for product attributes only) Product types are handled by custom taxonomy product_type with the following default terms: simple grouped variable external Reply