Edit History

Thanks for the reply.

Yes that is how we are doing it but its crazy that this isn't a built in feature yet! With 400 orders on back order, trying to search through for one or two with a product in it?

My workaround flow is:

1. Log in to PHP MyAdmin
2. Find "Order Detail"
3. Sort by "Product ID"
4. Search for the product ID that has just come into stock (eg 3044)
5. Note all "Order ID"s for lines with 3044
6. Back to PS Back Office and search for the order by entering Order ID into the ID Filter.

I am no expert in the SQL Query in PS but I'd even just like a query that allows my staff to search by running the query where they just need to enter the Product ID at the top and they get a list of order numbers. Can anyone help with this?