Daily Warehouse Stats
The warehouse's daily numbers, filled in from three systems before the shift starts.
Problem
The warehouse manager tracked a daily sheet by hand: packages shipped by USPS, FedEx and UPS, consumer orders waiting at the start of the shift, and back orders. Each number came from a different screen in Business Central or Shopify, and each one had to be looked up and typed in every morning.
Approach
The first job was working out exactly where each number came from, down to the saved filters the team used on each screen. I rebuilt each one so it matches what they see. The consumer order count, for example, mirrors their saved Shopify view exactly, including which shipping methods count and which orders it hides.
Every weekday morning the tool pulls shipped packages by carrier from the shipping manifests, counts open consumer orders and back orders, and writes the row straight into the live shared workbook. The notes column stays with the team.
Result
- The daily sheet fills itself every weekday morning
- Numbers match the team’s own screens
- Missed days can be backfilled
- Runs unattended, with a backup check if the morning run is late