Skip to content

Instantly share code, notes, and snippets.

@tivnet

tivnet/woocommerce_category_list.sql

Created May 29, 2014 03:22
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save tivnet/d9cca4a4f4cfebe143bc to your computer and use it in GitHub Desktop.
Save tivnet/d9cca4a4f4cfebe143bc to your computer and use it in GitHub Desktop.
Download ZIP
WooCommerce category list SQL query
Raw
woocommerce_category_list.sql
--
-- @author Gregory Karpinsky, http://www.tiv.net/
-- @version 14.05.28
--
SELECT
tp.name Cat,
t.name Subcat
FROM
wp_term_taxonomy tt,
wp_terms t,
wp_terms tp
WHERE
tt.taxonomy = 'product_cat'
AND tt.term_id = t.term_id
AND tt.parent = tp.term_id
ORDER BY
Cat,
Subcat
@master-roma
Copy link

Thanx!!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment