orliejohn
所有指南
  • 运营
  • 阅读需 6 分钟

TikTok Shop 电子表格:要追踪什么、如何搭建

了解 TikTok Shop 电子表格中该追踪什么(订单、利润、创作者、库存),以及如何一步步搭建,不用在多个工具之间来回切换。

分步说明

6步搭建跟踪表

第 1 步,共 6 步
新建工作表将工作表命名为订单、利润、创作者、库存、周报。

一个 TikTok Shop 电子表格就是一个文件,用来追踪你的订单、利润和创作者表现,而不用在五个工具之间来回切换。我把我的表格设置成五个标签页:订单、利润、创作者、库存和每周总结。下面就是具体要追踪什么,以及如何搭建。

TikTok Shop 电子表格应该追踪什么?

TikTok Shop 电子表格应该追踪你每周会依据行动的数字:订单、每笔订单利润、创作者销售额、库存水平和每周总结。每个部分单独一个标签页,这样你就不用在一个巨大的表格里滚来滚去。

区域追踪内容为什么重要
订单订单号、日期、产品、SKU、数量、折扣后收入、收取的运费、订单状态让你看到卖出了什么、什么时候卖出,以及订单是否已履约
利润收入、平台费用、联盟佣金、产品成本、运费、每笔订单广告费、利润显示出在扣除所有成本后哪些产品真正赚钱
创作者创作者名称、用户名、推广的产品、佣金率、带来的销售额、发布的视频、寄出的样品、状态告诉你哪些创作者能带来订单,哪些只是浪费样品
库存SKU、产品名称、期初库存、已售数量、已到货数量、现有库存、补货点防止缺货,并显示什么时候该补货
每周GMV、订单数、最畅销产品、最佳创作者、问题、下一步行动给你一页纸的视图,用于周五报告

GMV 指商品交易总额:退款前的订单总价值。AOV 指平均订单价值:GMV 除以订单数。两者都放在 Weekly 标签页上。

如何搭建 TikTok Shop 电子表格?

搭建一个 TikTok Shop 电子表格大约需要一个小时,只要按以下步骤操作。我用 Google 表格,因为它免费,而且可以分享给团队。

1. 新建一个 Google 表格并命名标签页

新建一个 Google 表格,添加五个标签页:订单、利润、创作者、库存和每周。把默认工作表重命名为“订单”,然后用底部的加号添加其余标签页。

2. 搭建订单标签页

在订单标签页中,在第 1 行添加以下列:

  • 订单号
  • 订单日期
  • 产品名称
  • SKU
  • 数量
  • 收入(折扣后实付价格)
  • 收取的运费
  • 订单状态(已支付、已发货、已退货)
  • 备注

从 TikTok Shop Seller Center 将订单导出为 CSV 文件,粘贴到这个标签页。如果你愿意,也可以手动输入。这篇如何每周看懂你的 TikTok Shop 数据分析文章解释了在哪里找到导出功能。

3. 搭建利润标签页

利润标签页是你计算每笔订单真实利润的地方。添加以下列:

  • 订单号
  • 产品名称
  • 收入(与订单标签页相同)
  • 平台费用
  • 联盟佣金
  • 产品成本
  • 运费
  • 每笔订单广告费
  • 利润

你可以用公式计算利润:=Revenue - Platform fee - Affiliate commission - Product cost - Shipping cost - Ad cost per order。平台费用和佣金率经常变化,所以请查看 TikTok Shop Seller University 中的当前费率并使用这些数值。对于产品成本和运费,使用你自己的数字。我还单独写了一篇指南,详细介绍了如何在 TikTok Shop 上计算每笔订单的真实利润。如果你想快速计算,可以用我的免费 TikTok Shop 利润计算器一次检查一笔订单。

4. 搭建创作者标签页

创作者标签页追踪谁在为你卖货。添加以下列:

  • 创作者名称
  • 用户名
  • 推广的产品
  • 佣金率
  • 带来的销售额
  • 发布的视频数
  • 寄出的样品数
  • 状态(合作中、待定、已拒绝)

你可以从 Seller Center 的 Affiliate Center 中填写这个标签页。这篇关于用电子表格还是应用来追踪 TikTok Shop 创作者的文章比较了两种方法,但对于单个电子表格来说,这个结构就很有效。

5. 搭建库存标签页

库存标签页可以防止缺货。添加以下列:

  • SKU
  • 产品名称
  • 期初库存
  • 已售数量
  • 已到货数量
  • 现有库存
  • 补货点

根据产品的销售速度和供应商交货时间,为每个产品设置补货点。我的补货点计算器可以帮助你选择正确的数字。然后用公式计算现有库存:=Starting stock - Units sold + Units received。当现有库存低于补货点时,就该补货了。

6. 搭建每周标签页

每周标签页是你的一页总结。添加以下行,或者用一个简单的表格:

  • 本周 GMV
  • 订单数
  • 按收入排名的畅销产品
  • 按销售额排名的最佳创作者
  • 店铺健康问题
  • 下周要解决的问题

你可以使用 SUMIF 等公式从其他标签页提取数字,或者直接复制总数。如需完整的每周流程,使用我的每周 TikTok Shop 运营清单。它说明了每周要在 Seller Center 中检查什么,电子表格就是你记录结果的地方。

如何保持电子表格更新?

我每天更新一次订单,每周更新一次其他内容。每天,我把 Seller Center 中的新订单行粘贴到订单标签页,并将新销售添加到利润标签页。每周,我用新视频和销售更新创作者标签页,调整库存标签页,并填写每周标签页。

你还可以使用公式和数据透视表来节省时间。例如,SUMIF 公式可以按产品或创作者从订单标签页汇总收入。一开始保持简单。我的真实看法是,对于每月订单量在几百以下的店铺,带手动更新的基础电子表格就很好用。只有手动工作变得麻烦时,才添加自动化。

最好的 TikTok Shop 电子表格模板是什么?

没有单一的最佳模板,因为每家店铺追踪的东西不同。一个拥有 10 个产品和 3 位创作者的店铺需要的列数,比拥有 100 个产品和 50 位创作者的店铺少。从上面的五个标签页开始,只在需要时添加更多。

如果你想看看电子表格与专门用于创作者追踪的应用相比如何,请阅读用电子表格还是应用来追踪 TikTok Shop 创作者。对于大多数卖家来说,电子表格在简单性和成本上更胜一筹。

如果你对 TikTok Shop 电子表格的设置有疑问,请在下方聊天中提问。这是免费的。告诉我你的情况、你卖什么,以及你目前尝试过什么。

常见问题

我需要一个 TikTok Shop 电子表格吗?
需要,如果你在 TikTok Shop 上销售,并且想在一个地方查看订单、利润和创作者表现。这是停止在多个工具之间来回切换、保持单一数据来源的最简单方法。
我应该在 TikTok Shop 电子表格中追踪什么?
追踪订单、每笔订单的利润、创作者销售额、库存水平,以及每周总结。每一项单独一个标签页,这样你不用每次打开 Seller Center 就能看到整个店铺的情况。
如何搭建一个 TikTok Shop 电子表格?
新建一个 Google 表格,并添加 Orders、Profit、Creators、Inventory 和 Weekly 标签页。列出每个标签页的列,然后从 Seller Center 的订单导出文件中填充。使用 SUMIF 等公式计算总数。
我可以用 Google 表格来追踪 TikTok Shop 吗?
可以,Google 表格免费,而且对大多数 TikTok Shop 卖家来说很好用。你可以和团队共享,并且它会实时更新。在考虑付费工具之前,先从一个简单的表格开始。
有没有可以下载的 TikTok Shop 电子表格模板?
我没有提供单一模板,因为每家店铺追踪的东西不同。但你可以根据本指南中的结构自己搭建。大约需要一个小时。

作者
Orlie John Deferia

我是 Orlie John Deferia,TikTok Shop 运营和应用开发者,住在菲律宾宿务。我运营 orliejohn.com,一个免费、无广告的卖家 TikTok Shop 学习站:教程、新闻、指南、对比和工具。我从 2023 年 4 月起每天都在运营 TikTok Shop,所以每篇指南都来自真实的 Seller Center 工作。

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.