We have a inventory text file that we generate daily. It includes UPC, SKU, product name, quantity along with other information that is not applicable. We would like to upload this file every day in the system and it should shoot back which items are out of stock, meaning they are no longer on the file, and items that are under 15 should be a separate report, from 15-50 should be another report, and another report for items that are 50-100 in quantity. The items that are newly in this filter should be on top. Meaning the items that were yesterday also below 15 should be on the bottom of the file. As opposed to items that became 15 today should be on top)
Also another report just to highlight of what items got changed from yesterday until today. should highlight more and less in different colors. (for example more should be red, and less should be yellow)
Also want another report what wasn't there yesterday but is there today.
I should also be able to select an older file and compare to todays file. Or compare any two files that we need.
Reports should be in xls