4 posts tagged with "ecommerce"

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