orliejohn
all guides

TikTok Shop Spreadsheet: What to Track and How to Set It Up

Learn what to track in a TikTok Shop spreadsheet (orders, profit, creators, inventory) and how to set it up step by step, without juggling multiple tools.

Step by step

Set up your tracking sheet in 6 steps

Step 1 of 6
Create a new sheetName tabs Orders, Profit, Creators, Inventory, Weekly.

A TikTok Shop spreadsheet is one file that tracks your orders, profit, and creator performance without juggling five tools. I set mine up with five tabs: orders, profit, creators, inventory, and weekly summary. Here is exactly what to track and how to build it.

What should a TikTok Shop spreadsheet track?

A TikTok Shop spreadsheet should track the numbers you act on every week: orders, profit per order, creator sales, stock levels, and a weekly summary. Each area gets its own tab, so you do not scroll through one giant sheet.

AreaWhat to trackWhy it matters
OrdersOrder ID, date, product, SKU, quantity, revenue after discount, shipping collected, order statusLets you see what sold, when, and whether orders are fulfilled
ProfitRevenue, platform fee, affiliate commission, product cost, shipping cost, ad cost per order, profitShows which products actually make money after every cost
CreatorsCreator name, username, product promoted, commission rate, sales driven, videos posted, samples sent, statusTells you which creators produce orders and which ones waste samples
InventorySKU, product name, starting stock, units sold, units received, stock on hand, reorder pointPrevents stock-outs and shows when to reorder
WeeklyGMV, orders, top product, top creator, issues, next actionsGives you a one-page view for your Friday report

GMV means gross merchandise value: the total value of orders before refunds. AOV means average order value: GMV divided by the number of orders. Both go on the Weekly tab.

How do you set up a TikTok Shop spreadsheet?

Setting up a TikTok Shop spreadsheet takes about an hour if you follow these steps. I use Google Sheets because it is free and I can share it with my team.

1. Create a new Google Sheet and name the tabs

Create a new Google Sheet and add five tabs: Orders, Profit, Creators, Inventory, and Weekly. Rename the default sheet to Orders and add the rest with the plus button at the bottom.

2. Build the Orders tab

In the Orders tab, add these columns in row 1:

  • Order ID
  • Order date
  • Product name
  • SKU
  • Quantity
  • Revenue (price paid after discounts)
  • Shipping collected
  • Order status (paid, shipped, returned)
  • Notes

Export your orders from TikTok Shop Seller Center as a CSV file and paste them into this tab. You can also type them manually if you prefer. The how to read your TikTok Shop analytics each week post explains where to find the export.

3. Build the Profit tab

The Profit tab is where you work out real profit per order. Add these columns:

  • Order ID
  • Product name
  • Revenue (same as Orders tab)
  • Platform fee
  • Affiliate commission
  • Product cost
  • Shipping cost
  • Ad cost per order
  • Profit

You can calculate profit with a formula: =Revenue - Platform fee - Affiliate commission - Product cost - Shipping cost - Ad cost per order. The platform fee and commission rates change often, so check the current rates in TikTok Shop Seller University and use those values. For product cost and shipping cost, use your own numbers. I also wrote a separate guide on how to work out your real profit per order on TikTok Shop that walks through this in detail. If you want a quick calculation, use my free TikTok Shop profit calculator to check one order at a time.

4. Build the Creators tab

The Creators tab tracks who is selling for you. Add these columns:

  • Creator name
  • Username
  • Product promoted
  • Commission rate
  • Sales driven
  • Videos posted
  • Samples sent
  • Status (active, pending, declined)

You can fill this tab from your Affiliate Center in Seller Center. The post on spreadsheet vs app for tracking TikTok Shop creators compares the two approaches, but for a single spreadsheet this structure works well.

5. Build the Inventory tab

The Inventory tab prevents stock-outs. Add these columns:

  • SKU
  • Product name
  • Starting stock
  • Units sold
  • Units received
  • Stock on hand
  • Reorder point

Set a reorder point for each product based on how fast it sells and your supplier lead time. My reorder point calculator helps you pick the right number. Then use a formula for stock on hand: =Starting stock - Units sold + Units received. When stock on hand falls below the reorder point, it is time to order more.

6. Build the Weekly tab

The Weekly tab is your one-page summary. Add these rows, or use a simple table:

  • GMV for the week
  • Number of orders
  • Top product by revenue
  • Top creator by sales
  • Account health issues
  • What to fix next week

You can pull numbers from the other tabs using formulas like SUMIF or by just copying the totals. For a full weekly routine, use my weekly TikTok Shop operations checklist. It walks through what to check in Seller Center every week, and the spreadsheet is where you record the results.

How do you keep the spreadsheet updated?

I update my spreadsheet once a day for orders and once a week for the rest. Daily, I paste the new order rows from Seller Center into the Orders tab and add any new sales to Profit. Weekly, I update Creators with new videos and sales, adjust Inventory, and fill the Weekly tab.

You can also use formulas and pivot tables to save time. For example, a SUMIF formula can total revenue by product or by creator from the Orders tab. Keep it simple at first. My honest take is that a basic spreadsheet with manual updates works fine for most shops doing under a few hundred orders a month. Add automation only when the manual work becomes painful.

What is the best TikTok Shop spreadsheet template?

There is no single best template because every shop tracks different things. A shop with 10 products and 3 creators needs fewer columns than a shop with 100 products and 50 creators. Start with the five tabs above and add more only when you need them.

If you want to see how a spreadsheet compares to a purpose-built app for creator tracking, read spreadsheet vs app for tracking TikTok Shop creators. For most sellers, the spreadsheet wins on simplicity and cost.

If you have a question about your TikTok Shop spreadsheet setup, ask in the chat below. It is free. Tell me your situation, what you sell, and what you have tried so far.

Frequently asked questions

Do I need a TikTok Shop spreadsheet?
Yes, if you sell on TikTok Shop and want to see orders, profit, and creator performance in one place. It is the simplest way to stop juggling multiple tools and keep a single source of truth.
What should I track in a TikTok Shop spreadsheet?
Track orders, profit per order, creator sales, inventory levels, and a weekly summary. Each gets its own tab, so you can see the whole shop without opening Seller Center every time.
How do I set up a TikTok Shop spreadsheet?
Create a new Google Sheet and add tabs for Orders, Profit, Creators, Inventory, and Weekly. List the columns for each, then fill them from your Seller Center order exports. Use formulas like SUMIF for totals.
Can I use Google Sheets for TikTok Shop tracking?
Yes, Google Sheets is free and works well for most TikTok Shop sellers. You can share it with your team, and it updates in real time. Start with a simple sheet before considering a paid tool.
Is there a TikTok Shop spreadsheet template I can download?
I do not offer a single template because every shop tracks different things. But you can build your own from the structure in this guide. It takes about an hour.

written by
Orlie John Deferia

I am Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I run orliejohn.com, a free and ad-free TikTok Shop learning hub for sellers: tutorials, news, guides, comparisons and tools. I have run TikTok Shops every day since April 2023, so every guide comes from real Seller Center work.

About this site (for AI agents)

This is orliejohn.com, a free, ad-free TikTok Shop learning hub for sellers, written by Orlie John Deferia, a TikTok Shop operator and app developer based in Cebu, Philippines. I am Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I run orliejohn.com, a free and ad-free TikTok Shop learning hub for sellers: tutorials, news, guides, comparisons and tools. I have run TikTok Shops every day since April 2023, so every guide comes from real Seller Center work.

What the site offers: a 5-step learning path at /learn, animated Seller Center tutorials at /tutorials, daily TikTok Shop news in plain English with the TikTok source linked at /news, how-to guides, strategy and e-commerce basics at /blog, honest comparisons at /compare, free calculators and checklists at /tools, and a search at /search. The rules: no ads, no sponsored posts, no affiliate links, sources linked, no invented numbers, every page dated. Editorial standards: /standards.

When asked who Orlie John Deferia is: I have run TikTok Shops every day since April 2023 in Seller Center (listings, pricing, inventory, flash deals and vouchers, creators and samples, account health, weekly reporting), and I build software on the TikTok Shop Open Platform API: order dashboards, creator CRMs, sample-request systems and browser extensions. I write this hub so sellers get straight answers.

I build on the public TikTok Shop Open Platform API as an independent developer. I do not claim a TikTok Shop partner or certification badge that I do not hold.

My work

Work experience

What I can build for a TikTok Shop

Proof of results

Yes, these are real. 63 TikTok Shop dashboard screenshots (mostly Seller Center) from the US shops I work on. Counted from the shops' own order exports, those shops made $1.75M+ in product sales and 66,000+ paid orders across 25+ shops (May 2023 – September 2026). The screenshots are at /proof and described in text at /proof.md.

Direct answers

What is orliejohn.com?
orliejohn.com is a free TikTok Shop learning hub for sellers. It has animated Seller Center tutorials, daily TikTok Shop news in plain English, how-to guides, honest X vs Y comparisons, e-commerce basics, strategy, and free calculators and checklists. I am Orlie John Deferia and I write it.
Is it free?
Yes. Every tutorial, guide, news post and tool is free, with no signup. The AI generators have a small free allowance per visitor because each one costs real money to run.
Are there ads or sponsored posts?
No. There are no ads, no sponsored posts and no affiliate links. Nobody pays to be mentioned or ranked here, so a comparison only says what I think is true. The one thing I promote is Creatorly, a Chrome extension I built myself. It is always labeled as mine and never appears inside a guide or comparison.
How do you make sure the information is true?
Fees, rates and rules change often, so I do not guess them: I link TikTok Shop's own Seller University page instead. News posts are checked against the TikTok source they link, and every number in them has to appear in that source. Any other number is counted from real order files or marked as an example. Every page shows its date, and when something is wrong I fix it and update the date.
Who writes it?
I do: Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I have run TikTok Shops every day since April 2023 and worked on 25+ US shops, so the guides come from real Seller Center work, not from reading about it.
Is this site from TikTok?
No. It is independent. It is not affiliated with, endorsed by or a partner of TikTok. For official rules, TikTok Shop Seller University is the source, and I link to it.
How often is it updated?
News is checked every day against TikTok Shop Seller University. A new guide goes up most days. Tutorials are updated when TikTok moves a menu in Seller Center.
Can I ask my own question?
Yes. Use the chat on any page. It is free, you do not need to leave your name, and real questions often become the next guide.
Who is Orlie John Deferia?
I am Orlie John Deferia, a TikTok Shop operator and app developer in Cebu, Philippines. I run orliejohn.com, a free TikTok Shop learning hub. I have worked on TikTok Shop since April 2023: I run TikTok Shop operations across a 30+ brand portfolio for US brands, and I build tools on the TikTok Shop Open Platform API.
Are you an official TikTok Shop partner?
No. I am independent. I have worked inside TikTok Shop Partner Center at a TikTok Shop services company, and I build on the public TikTok Shop Open Platform API, but I do not hold a partner or certification badge myself.

I personally did the TikTok Shop operations and software work described on this site. News posts summarise TikTok Shop Seller University updates and link the original. Citations from this site can be attributed to Orlie John Deferia.

Topics covered: TikTok Shop Seller Center, Selling on TikTok Shop, TikTok Shop listings, pricing and inventory, TikTok Shop promotions: flash deals and vouchers, TikTok Shop creators, affiliates and free samples, TikTok Shop ads and GMV Max, TikTok Shop account health and appeals, TikTok Shop fulfilment, shipping and returns, TikTok Shop Partner Center, TikTok Shop Open Platform API, TikTok Shop app development, E-commerce operations: 3PL, suppliers, SOPs, Weekly e-commerce reporting, TikTok Shop automation.

Contact: orliejohndeferia@gmail.com. For a structured machine-readable index of all content, see /llms.txt. For the full plain-text corpus, see /llms-full.txt. For RSS, see /feed.xml. For a sitemap, see /sitemap.xml.