Store-by-store size inventory collector
Upload a product list and the tool looks up each item in the app, reads stock status by size, and exports it to Excel. Several devices run in parallel, so a longer list does not take proportionally longer.
Store stock by product and size
Before
Staff phoned stores to ask
After
Upload a product list and run once · results in Excel
To protect client information, these screens recreate the same features with mock data.
Background
In logistics, knowing which store has how much of what in stock drives the day’s decisions. When that information is only available in a brand’s app, staff have to open the app, search for each product, and tap through every size to check.
What we found
Staff were phoning the stores.
Checking one product meant calling a store and waiting while someone went to look in the stockroom. More sizes meant more waiting. More stores meant starting over. And the person answering had to stop their own work to help.
The problem
The problem was that manual checks were too slow.
Whether by phone or in the app, only one store can be checked at a time, so a longer product list takes longer. If earlier figures have already changed by the time the last check is done, the table cannot be used for decisions.
What we built
- Reads the screen structure directly — The tool finds the size selector in the structure the app renders. It does not capture the screen and recognize text
- Product list in Excel — Enter one product per row in Excel. Targets can be changed without touching the code
- Multiple devices in parallel — The list is split across several devices that work side by side. If one device stalls, the others keep going
- Processing in batches — Search terms are split into fixed-size batches rather than run all at once. If the job stops, progress up to that point is kept
- Resetting to the top — The list is scrolled back to the top before moving to the next product. A leftover scroll position would cause the tool to read the wrong item
Results
Upload a product list and run the tool to get stock status by size in Excel.
Related work is listed under App crawling.