On your products page you'd need to setup URL aliases. For instance

/Products/{CategoryName}
/Products/{CategoryName}/{Product}

Then on your products page, your repeater looks at those querystring parameters and dynamically loads the categories and/or products based on what it finds. Technically you won't have a physical page you set up for categories or products, those will be dynamically generated based on the parameters (or querystring values). You can then retrieve those querystring values in your WHERE clause by using the macro {%CategoryName%} or {%Product%}