2 Responses
  1. 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 or Comment

Your email address will not be published.


You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>