Page 1 of 1
3. Level Categories
Posted: Thu Sep 10, 2009 6:39 am
by learnerbm
Hi everybody, how can I get 3rd level Categories of a root category?
Re: 3. Level Categories
Posted: Fri Sep 11, 2009 8:38 am
by Logan Rhodehamel
If you are comfortable doing some custom queries (
http://wiki.ablecommerce.com/index.php/Custom_Queries) then you can get a list of 3rd level category IDs in a single query from the ac_CategoryParents table.
Code: Select all
SELECT CategoryId FROM ac_CategoryParents WHERE ParentId = @yourRootCategoryId AND ParentNumber = 2