What needed to be done.
The team needed to track customer items from purchasing to dispatch, spot delays and unanswered questions, and keep a history of completed items.
- Connected orders, questions, a summary and an archive in Google Sheets.
- Added statuses and highlighting for items waiting seven days or more.
- Highlighted questions unanswered for two days and orders containing multiple units.
- Built archiving and restoration that preserve original dates and fields.
How it works.
- Record an item
Customer, product, brand, quantity and date.
- Resolve delays and questions
An employee reviews the issue, records the answer and updates the status.
- Preserve history
Completed rows are archived manually; restoration keeps the original date.
Restoring an item preserves its history.
Items return with their original date and status so staff can see how long they have been waiting.
New columns must not mix up records.
The system checks column positions when fields are added. I also checked data entry, formulas and archiving after the change.
Implementation and example.
The web example illustrates the completed Google Sheets project. All products and buyers are fictional. It is a portfolio illustration, not the client spreadsheet.
Try the status, archive and restore.
An interactive demo with fictional items. Demo date: September 23, 2026. The real system runs in Google Sheets. Changes here last until you reload the page.
Change the lamp's status or move the notebook to the archive. Then bring it back.
An employee changes the status. Setting "Shipped" does not archive the item on its own. Restoring keeps the original date and status.
The result.
Staff can see purchases, delays and questions in one list. They update statuses themselves; the spreadsheet highlights items needing attention and keeps completed records in the archive.
Technologies and implementation details
Google Sheets, formulas and Apps Script. The automation fills empty service fields and moves records. When a new field is added, the script checks the headers and stops if the columns are not where it expects them. In the original system, control is visible in the sheet and on the dashboard; there are no external notifications.
Let's discuss your task.
Show me how you track purchases and delays today. We can review one order and discuss the tracking your team needs.
Discuss purchase tracking ↗︎