How to hide a tree node in uCommerce or Umbraco
Wednesday, August 31, 2011 10:37:04 AM (GMT Daylight Time, UTC+01:00)
Have you ever needed to hide a node in the Umbraco or uCommerce trees? It's actually very easy, we needed to hide the Orders, Marketing and Analytics nodes of a new uCommerce install we were working on. All you need to do is set the "treeInitialize" value in the umbracoAppTree to false. This will then hide the entire tree.
The Update SQL
BEGIN TRAN
UPDATE dbo.umbracoAppTree SET treeInitialize = '0' WHERE appAlias = 'uCommerce' AND treeTitle = 'Analytics'
ROLLBACK TRAN
To use the SQL you will need to know the appAlias (this is the bit after the # in the Umbraco admin url once you've clicked the section icon e.g. in "http://www.domain.com/umbraco/umbraco.aspx#uCommerce" the appAlias is uCommerce). If you know the treeAlias it might be better to use that but it's probably easier to use the tree's title (in our case this would be Orders, Marketing and Analytics).
Not sure what tree you should be hiding? Just open the umbracoAppTree table and you'll have the trees from all sections there.
uCommerce tree before
uCommerce tree after
Couldn't be any easier could it!