I sell lots of products, some of which include preorder items (stock NOT on hand) and also sell items where I do have stock on hand.
What I'd like to do is find those that ordered the IN STOCK items ONLY. I don't want to see the customers that ordered both (as the CSV file would obviously include everyone that ordered mixed preorder / stock on hand items).
For example;
Customer 1 buys: T-shirt (preorder) a patch (preorder) and 2 stickers (stock on hand) Customer 2 buys: 2 stickers (stock on hand)
I'd like to be able to find customer 2 and those similar and then I can pack their things and send them out, rather than go through manually and find these orders.
Filter orders by MULTIPLE specific products
in Commerce
Posted
Hello!
I sell lots of products, some of which include preorder items (stock NOT on hand) and also sell items where I do have stock on hand.
What I'd like to do is find those that ordered the IN STOCK items ONLY. I don't want to see the customers that ordered both (as the CSV file would obviously include everyone that ordered mixed preorder / stock on hand items).
For example;
Customer 1 buys: T-shirt (preorder) a patch (preorder) and 2 stickers (stock on hand)
Customer 2 buys: 2 stickers (stock on hand)
I'd like to be able to find customer 2 and those similar and then I can pack their things and send them out, rather than go through manually and find these orders.
Any help would be amazing!