Google Sheets Business Systems: Orders, Stock and Team Tasks

Three complete business systems built inside Google Sheets, so a team can run its daily work from one file.

1. Orders and returns tracker

• Synced with Shopify, with a barcode scan screen: scan the order, then the airway bill

• Dashboard for delivery rate, return rate, shipped value, cash collected and cash in transit

• Breakdown by city, by product and size, return reasons and late parcels

2. Fabric warehouse with barcodes

• Create barcodes, record incoming and outgoing quantities from their own screens

• Live balance by metre, kilo and roll, by fabric, supplier and zone

• Low-stock alerts, and an issue bigger than the balance is blocked

3. Team task tracker

• Owner, department, priority, due date, days left, repeat and a sub-checklist for every task

• Permissions decide who edits what; comments, chats and a change log

• Dashboard with per-person completion, late tasks and tasks due today

Built in Arabic for the client. The screenshots are shown in English with sample data.