10 posts tagged with "google-sheets"

An Amazon business isn't one stream of packages — it's three. Customer orders you fulfill yourself (FBM). Inbound shipments you send to Amazon's fulfillment centers (FBA). And the supplier purchase orders — from Alibaba, wholesalers, your manufacturer — that feed everything upstream.

Seller Central gives you a partial view of the first, a checkpoint view of the second, and nothing at all for the third. Yet your account health, your restock timing, and your cash flow depend on all three arriving on time.

This guide puts all three streams in one Google Sheet with live, auto-updating tracking — one tab each, one formula for everything.

Every Etsy seller past their first dozen sales knows the two-front shipping war. Outbound: buyer orders that need to arrive on time, because late deliveries mean "where is my order?" messages, bad reviews, and a dented Star Seller badge. Inbound: the beads, fabric, packaging, and blanks you ordered from suppliers — the purchase orders your whole production schedule depends on.

Etsy's dashboard shows you neither side well. It tells you a label was purchased, not where the package actually is. And it knows nothing at all about your supply orders.

This guide shows you how to run both sides — every buyer order and every inbound PO — in a single Google Sheet with live, auto-updating tracking statuses.

Shopify is excellent at taking orders and printing labels. It's surprisingly weak at answering the question that fills your support inbox: where is every order right now?

The admin shows "Fulfilled" — which only means a label exists. Whether the package is moving, stuck in a sort facility, bouncing back to you, or sitting on a porch since Tuesday is hidden behind a per-order click to the carrier's site. Multiply by a hundred open orders, a dropship supplier or two, and the inventory POs coming into your warehouse, and you're managing a delivery operation with no delivery view.

This guide builds that view in Google Sheets: every outbound order and every inbound shipment, live statuses, one formula.

If you've ever set up package tracking in Google Sheets — with any add-on — you've hit the same wall. You drop a formula, it returns In Transit, you nod, and you move on. A day later you check back and... it still says In Transit. The package was actually delivered six hours ago, but the cell never refreshed.

Every other tracking add-on we've seen has this problem. The formula evaluates once and then sits frozen, until you re-enter it, run a script, click some "refresh" button, or worse — write an Apps Script trigger that pulls new data on a schedule and inevitably breaks. Your Package Tracker is different: our PKG_STATUS_LIVE formula keeps your sheet current on its own.

This guide explains how it works, how to use it, and why it's a meaningful difference for anyone tracking packages at any scale.

Here's the situation most shipping teams eventually land in. Monday's outbound: 40 packages via UPS Ground, 20 via USPS Priority, 8 via FedEx Express, 3 international via DHL, one oversized item via Estafeta, and two inbound supplier shipments via SF Express. That's six carriers, six tracking portals, and exactly zero good ways to see all of them in one place.

You don't actually need six tools. You need one column. This guide shows how to track packages from every carrier you use — side by side, in a single Google Sheet, with one formula that doesn't care who the carrier is.

"DHL" is really four different carriers sharing a logo. DHL Express is the air-freight giant that competes with FedEx Priority. DHL eCommerce (now "DHL eCommerce Solutions") is the lower-cost parcel service that hands off to local posts. Deutsche Post is the German postal service DHL is part of. DHL Parcel runs domestic in Europe. Each has its own tracking number format, its own system, and — until a sheet can query all of them — its own silo.

This guide shows how to track every DHL brand from a single Google Sheet column. One formula, every format, every country.

FedEx splits its tracking across half a dozen internal systems — Ground, Express, Home Delivery, SmartPost (now Ground Economy), Freight, International — and each has its own tracking number format. If you've ever pasted a batch of FedEx numbers into a spreadsheet and tried to sort them by status, you know the problem: ups.com and fedex.com don't talk to each other, and neither talks to your sheet.

This guide shows how to consolidate every FedEx service into one Google Sheet using a single formula, so all your FedEx shipments live in one place — next to your order IDs, customer names, and everything else you already track.

If you ship even a few packages a week, you have probably lived this scene: fifteen browser tabs open to carrier websites, a spreadsheet on one screen, and you manually copy‑pasting statuses back and forth. It is slow, error‑prone, and it does not scale.

There is a much simpler approach. You can track every shipment — across UPS, FedEx, USPS, DHL, and 3,000+ other carriers — directly inside a single Google Sheet using a tracking formula. This guide walks through exactly how to set it up, copy it to bulk rows, and keep the data fresh.

UPS is still the default carrier for an enormous amount of US e‑commerce — and anyone shipping at volume eventually hits the same wall: you have 80 UPS tracking numbers in a spreadsheet and no sane way to check their status without opening 80 browser tabs.

This guide shows how to pull live UPS tracking data — status, last location, delivery events — directly into any Google Sheet using a single formula. No UPS developer account, no API key, no Apps Script.

USPS volume has a flavor all its own: lots of packages, small margins, long tails of "where's my thing?" customer emails. If you sell on eBay, Etsy, Poshmark, Mercari, or run a small Shopify store, USPS is probably 60–80% of your shipments — and the tracking experience at usps.com has not meaningfully improved in a decade.

Google Sheets + one formula fixes it. This guide is the practical version — how to set it up, which USPS products it handles (Priority, First-Class, Media, Certified, Registered, international), and the quirks that come with USPS's own tracking inconsistencies.