> ## Content Index
> Fetch the complete content index at: https://blog.tsd.digital/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to hide a tree node in uCommerce or Umbraco
- URL: https://blog.tsd.digital/how-to-hide-a-tree-node-in-ucommerce-or-umbraco/
- Published: 2011-08-31T08:37:04.000Z
- Updated: 2011-08-31T08:37:04.000Z
- Author: Tim Gaunt
- Tags: SQL, Ucommerce, Umbraco, The Site Doctor, #Import 2025-04-01 05:37

Have you ever needed to hide a node in the Umbraco or [uCommerce](http://www.ucommerce.dk/?ref=blog.tsd.digital) 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

![HideTreeNodesBefore](https://storage.ghost.io/c/64/5b/645b11c2-b436-444c-a523-58dca4ca7bd8/content/images/tim/images/Hide-a-uCommerce_8E40/HideTreeNodesBefore_thumb.jpg)

#### uCommerce tree after

![HideTreeNodesAfter](https://storage.ghost.io/c/64/5b/645b11c2-b436-444c-a523-58dca4ca7bd8/content/images/tim/images/Hide-a-uCommerce_8E40/HideTreeNodesAfter_thumb.jpg)

Couldn't be any easier could it!