Dynamic Menu Not Pulling Subset

We have Super Suite and Power Store. Our website is www.funphotobooks.com. We are experiencing two errors:

1. When you click on the products menu the query returns all products every time. When we post categories, such as "photo books", we only want to see those products.
2. When you click on the product detail, it returns the message that the product is not available to puchase. When we look at the product in the Admin Manager, the products are check to be avaiable to be sold with no inventory.

I am attaching the various product*.php pages that effect this.

1) The links to the results page in the menu are not passing the propper query string variables.
In the origianl version of the CSSMenuWriter/cssmw_home/menu.php the links are created on line 69 using the following code:

<li><a href="<?php echo($assumedRoot); ?>Products_Results.php?Search=true&CategoryID=<?php echo $row_menuwriter_productcategories["CategoryID"]; ?>"><?php echo $row_menuwriter_productcategories["CategoryName"]; ?></a></li>

2) make sure to check the Available Online option. If this option is not checked, the items will show that message.

The problem with the menu is that you are missing the extra attributes that are normally present by default. If you have altered this you should take a look at the or original unmodified menu files to see what these links should look like. They should be passing along a category id and a search parameter like this:

Products_Results.php?Search=true&CategoryID=1

This would allow it to display a particular category and is the default behavior of the menu.

As for the item not showing up it looks like it is the correct id for an item, in your products table in the db look at a particular item as an example and examine the product stock, product unlimited, and product live columns. A 1 in live or unlimited indicates true. If it is not unlimited there will need to be a stock associated with it.