How to see who is waiting for an item on back order

[madpugger]

Hi and thanks for any help.

We quite often have products purchased that are out of stock for quite some time (it's just the nature of our industry).

PrestaShop 1.7 shows "Reserved" quantities in the "Stocks" page where we add stock as it arrives. I can't seem to find a way to be shown who has actually ordered them so we can ship them out. Am I missing something? Is there a workaround or module?

Currently I am going into the database with PHP MyAdmin to see who has ordered these items which is very labor intensive. We're also now keeping a spreadsheet of orders on back order which is extremely time consuming.

Thanks!

[puffdade]

Could you not do this with status's  set up a status "Backorder"   and mark that order as backorder when the order is not complete, From your orders page you can then pull up all the backorders  and customers name will be next to it, 

its still a lot of searching matching products to orders but thats how we have to do it until we find something automated fortunately we only ever have 10 or so 

[madpugger]

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?

Edited November 7, 2020 by madpugger (see edit history)

[musicmaster]

Try Prestools. It can do that. And it is free,