Display orders where ONLY Product X was purchased

Hi,

I don't see a way to do that with either the reports system or the mass actions system.
It will require a custom MySQL query.
Something like that for example (to be tested):
SELECT o.*, op1.* FROM #__hikashop_order as o LEFT JOIN #__hikashop_order_product as op1 ON o.order_id = op1.order_id AND op1.product_id = XXX LEFT JOIN #__hikashop_order_product as op2 ON o.order_id = op2.order_id AND op2.product_id != XXX WHERE op2.product_id IS NULL;

Here with load all the orders with a product with the id XXX and with no products with the id different from XXX.