I needed to put up a sale the other day; I needed to change sale prices. The criteria was all items with a certain setting in one of the Product Fields that were above $500 dollars.
I could not do a multi-level filter/search; I had to download the products into my access db; sort within access and make pricing changes there; and then upload the products again.
Ideally I would have liked to have been able to say
Fileter products where the price is greater than 500 and the product field X = 2.
Then, in Power Edit, do a global edit by setting the sale price to [Price]-$100