I am a bit confused as to why my category has the right product count for the category, but when I look at Category Products there are 0 products in there. Why is this happening? When I go to the Front-end all the products are there.
Be sure to re-index your data. We had a similar issue where category counts were right but all the products didn't show and it was imply that the category was pulling from the index, yet the category count wasn't.