CLIENT PROJECT / COMMERCE · GOOGLE SHEETS · APPS SCRIPT

Purchasing: items, delays, questions and archive.

I build purchasing and order tracking systems, including in Google Sheets. Staff can see which items still need purchasing, where delays occur and which questions need an answer. This project also lets them archive and restore items with their history.

My role
Development, acceptance and changes based on feedback
What is inside
Items, purchasing, shipping, questions and archive
Result
Items waiting for purchase and problem items are visible in a shared list.

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.

  1. Record an item

    Customer, product, brand, quantity and date.

  2. Resolve delays and questions

    An employee reviews the issue, records the answer and updates the status.

  3. 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.

3rows in progress
1overdue 7+ days
0with "Problem" status
Lamp "Sphere-01"Added 16.09 · 1 pcs
Not purchased
7 days
Overdue
Organizer "Module-02"Added 21.09 · 2 pcs
Purchased
2 days
Several units
Notebook "Line-03"Added 20.09 · 1 pcs
Shipped
3 days
On track

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 ↗︎
PROJECT SCREEN