My client added all of his products into eCommerce but with the way he set things up all of the products are showing up in the dynamic drop down navigation. I was trying to think of the easiest way to clean this up and my first thought is to go into the table and put Exclude from Nav onto each product page but I haven't found which table this is stored in. I tried doing the same by adding Exclude From Nav on the default page and although now the exclude from nav check box is checked it doesn't actually apply it until you submit it in properties.

If anyone can tell me what table the Exclude from Nav is stored in that would be great or if anyone has any other good suggestions I would appreciate it.