Dear Merav,
Bryan's answer is spot on. I would like to introduce you to one more great web part that I really like from Kentico. We have used it often, may be our functionality demanded.
The webpart is "Random products" webpart. Let's say you have 6 products in your particular category and you would like to show breadth of your products. In those cases it would be nice to use it and it will show random products from that. On every page refresh it will show 3 out 5 remaining products. It's a really cool web part.
All settings suggested by Bryan can be applied here
WhereCondition = NodeID <> {%NodeID%}
**Only random N products = 3**
Order By = NodeOrder,NodeLevel,NodeName
Path= "../%"
Page Type ?
Added a SS for your reference.
Random Webpart Screen Shot
Cheers,
Chetan