Workflow
The system:
- Receives new sales orders from Shopify or WooCommerce
- Normalizes order data from different sales channels
- Finds product and warehouse inventory records automatically
- Updates available stock after every completed sale
- Calculates inventory health, daily demand, and estimated days remaining
- Routes products based on healthy, reorder, critical, or out of stock conditions
- Logs inventory events and stock risk data in Google Sheets
- Searches other warehouses when inventory becomes critically low
- Calculates transferable stock without affecting source warehouse safety levels
- Selects the most suitable warehouse for internal stock transfers
- Creates and tracks warehouse transfer requests automatically
- Sends stock transfer approvals through Slack
- Retrieves supplier information when external replenishment is required
- Analyzes historical sales and demand trends
- Generates demand forecasts and stockout probability
- Calculates recommended reorder quantities using safety stock, lead time, MOQ, and incoming inventory
- Creates replenishment requests automatically
- Routes high value replenishment orders for manager and finance approval
- Creates supplier replenishment orders after approval
- Sends confirmed stock orders to suppliers through Gmail
- Creates Google Drive folders for supplier and shipment documentation
- Receives supplier confirmations and expected delivery information
- Calculates delivery risk against projected stockout dates
- Generates alternative inventory actions when supplier deliveries are delayed
- Sends critical stockout alerts to the operations team
- Reconciles received stock against supplier orders
- Updates warehouse inventory after successful receiving
- Detects damaged, partial, or incorrect deliveries
- Updates supplier performance using delivery and order accuracy data
- Scans inventory weekly for slow moving, excess, and dead stock
- Generates redistribution recommendations across warehouse locations
- Updates inventory analytics and operational reporting automatically



