Does anyone know a good way to track “days with 0 ...
# inventoryd
Dave Furman
10/07/2021, 5:22 PMDoes anyone know a good way to track “days with 0 available stock” within a date-range in inventory reports?
k
KevinJ of Kansas
10/07/2021, 7:01 PMMap/Reduce Script -> Runs 1x a day -> creates a custom record with date stamp and item field for knowing when items were out of stock - then you can run search on the custom record.
🤔 1
KevinJ of Kansas
10/07/2021, 7:02 PMIf you need - I can help you with that. Otherwise - most competent developers can probably run with it.
KevinJ of Kansas
10/07/2021, 7:02 PMIf you want to get really cheap and don't have boatloads of items out of stock - you could do a scheduled workflow that runs every day to create the records.
KevinJ of Kansas
10/07/2021, 7:04 PMHeck - now that I think about it - I could probably write a scheduled workflow to do this in way less time than a map/reduce.
KevinJ of Kansas
10/07/2021, 7:04 PMMaybe 5-10 hours.
d
Dave Furman
10/07/2021, 7:06 PMThanks very much--its not a ton of sku’s, roughly 500, but its enough that I really, really dont want to do anything with them individually or have to create a new one for each new sku, if thats what you mean. I appreciate the help, will look into on my end and will contact if it looks like it would make sense to have someone do this for us.
k
KevinJ of Kansas
10/07/2021, 7:10 PMIt'd be a workflow that ran of a saved search looking at items that were out of stock. Probably want to do a couple unconventional things to make sure it creates for all of them, but doesn't create duplicates, but otherwise it's a pretty simple workflow to write.
KevinJ of Kansas
10/07/2021, 7:10 PMSo then you could just run a search "Show me items that were out of stock between these dates"
👍 1
2 Views