Running 5–50 shops means 5–50 sets of deadlines — and the platforms don't remind you about any of them. This tracker puts every shop's authorisation expiry, health score, open violations, and appeal deadlines in one sheet, with a colour-alert system that flags trouble 30 days out.

What you get

- ✅ Ready-to-use spreadsheet (XLSX + CSV — opens in Excel & Google Sheets) with 14 columns built for multi-shop operations: shop, country, operator, authorisation expiry, health score, open violations, case type/ID, appeal status & deadline, evidence pack status, orders (last 30 days), stock/fulfilment note, last checked, notes

- ✅ 10 fictional example rows showing exactly how to fill it in — including a shop mid-appeal, a shop mid-rectification, and a shop with a deadline inside 15 days

- ✅ Expiry alert setup (10 minutes) — red/amber conditional-formatting formulas for Sheets/Excel so anything expiring within 7 or 30 days lights up automatically

- ✅ The 15-minute weekly review ritual — a fixed checklist: renewals, health scores, violation deadlines, evidence packs

- ✅ Standard responses for every alert — what to do when an authorisation, a health score, or an appeal deadline fires, in the right order

Who this is for

- Sellers running 3+ TikTok Shop / Amazon / eBay shops, especially with a small operator team

- Anyone who has ever lost an appeal window or let an authorisation lapse because "nobody saw the date"

- Agencies/operators managing shops for multiple clients

Who this is NOT for

- Single-shop sellers (your platform dashboard is enough)

- Anyone looking for account-recovery services — this is an organisational deadline tracker, not a workaround product

FAQ

Q: What software do I need?

A: Any spreadsheet app — Excel, Google Sheets, Numbers, LibreOffice. You get both XLSX and CSV; the usage guide includes the alert formulas for Sheets and Excel.

Q: Is the sample data real?

A: No — all 10 example rows are fictional (invented shop names, people, and figures). Replace them with your own data in minutes.

Q: Does it send reminders automatically?

A: It's a template, not an app. The sheet itself does not ship with conditional formatting built in — the included guide gives you the exact red/amber formulas to set up in about 10 minutes, and once set up the colour alerts update every time you open the sheet. No subscriptions, no third-party tool holding your shop data.

Q: Should I put passwords in it?

A: Never. The guide is explicit: the tracker records what needs doing and when it expires — credentials belong in a password manager.

Q: Can I use it for a team?

A: Yes — the Operator column is designed for it. Keep one master copy everyone edits the same day something changes.

Disclaimer

This template is an organisational aid provided for general information. It is not affiliated with or endorsed by TikTok, Amazon, or any platform. Renewal, authorisation, and appeal requirements vary by platform and market and change over time — always confirm the current terms in your Seller Center. Sample data is fictional. No business outcome is guaranteed or implied.