Support » Plugin: WooCommerce » Attributes ID

  • Resolved esquipulas


    Hi there, looking for a way to get a CSV export of the variations attributes name and terms including the attributes name and terms ID. The built-in export tool do not give this information : is there a way to get it directly from the database and, in that case, what is the search request I have to do ?

    Thanks by advance,



Viewing 1 replies (of 1 total)
  • Caleb Burks


    Automattic Happiness Engineer

    Global attributes are a taxonomy, stored in the wp_term_taxonomy database table. They will be called pa_termName. From there, you can get the attribute/taxonomy ID.

    Then the terms for each attribute are in the wp_terms table.

    And lastly, wp_term_relationships table stores the relations of the taxonomy to the term.

    So you can build SQL queries from those tables, or you could find a plugin that does taxonomy exports like you’re looking for.

Viewing 1 replies (of 1 total)
  • The topic ‘Attributes ID’ is closed to new replies.