We have a pretty big catalogue and fairly high turnover. This results in stockouts of key SKUS no matter how hard we try.
What we’d really like to do is once we have ordered from our supplier, format the CSV we get (we can do that bit!) into a simple CSV which has a SKU column, an incoming quantity column and a date expected column, to then import into an app which can display something like “18 expected on 1st July” and then allow the customer to set up an alert and or preorder. We would only want to take preorders or back in stock requests on items we know are actually inbound.
All the apps like this I’ve seen require you to manually set up products one by one which is not ideal when we have 150+ SKUs on a supplier order at a time.
Any ideas on this one?