Most TikTok Shop sellers check their profit numbers once a month, if at all. The profitable ones check them every week. The difference between a seller who discovers a problem after it has cost them $10,000 and a seller who catches it before it costs them $1,000 is a 30-minute weekly profit review This is not a theory. It is the most consistent operational pattern I have observed across hundreds of TikTok Shop sellers. The ones who survive the first year do not have better products, more capital, or better creators. They have a better weekly review habit
This article is a template for the 30-minute weekly profit review that every TikTok Shop seller should run. It covers what to look at, what to ignore, and what to do when you find a problem
What to ignore in the weekly review
Most sellers spend their weekly review time looking at the wrong numbers. They check total GMV, total orders, and total revenue. These are vanity metrics. They look good when the business is doing well and bad when the business is doing poorly, but they do not tell you what to do next. The weekly profit review should focus on the numbers that tell you where to take action, not the numbers that make you feel good or bad
Ignore: total GMV, total orders, total revenue, total new followers, total video views. These are outputs. They are the result of actions you took in the past. The weekly review should focus on the inputs that drive future profit
The five numbers that matter
Number one: net profit per SKU — the revenue minus COGS, platform fees, effective affiliate commission, shipping, and proportional ad spend. This is the single most important number in the weekly review. If a SKU is below 10 percent net margin, flag it. If it is below 5 percent, it is in the danger zone
Number two: return rate by SKU — the percentage of orders that were returned in the last 7 days, segmented by SKU. Return rate is a leading indicator of margin erosion. If a SKU’s return rate has increased by 20 percent or more in the last 7 days, there is a problem that needs to be addressed
Number three: effective affiliate commission rate — the actual commission paid (including unclawed-back commissions) divided by the net revenue. If this number is more than 2 percentage points above your listed commission rate, the silent commission loss is growing
Number four: cash available vs. pending settlement — the cash in your bank account compared to the revenue from orders that have been delivered but not yet paid. If your available cash is less than your pending settlement, you are technically insolvent. This is the number that indicates whether you can afford to order more inventory
Number five: inventory turnover ratio — the number of days of inventory on hand for each SKU. A ratio above 60 days means the product is not selling fast enough and the cash is tied up. A ratio below 14 days means the product is at risk of stockout
The 30-minute weekly review template
Minute 0-5: open the Seller Center and export the last 7 days of order data. Copy the data into your tracking spreadsheet or dashboard. This is the setup step that takes the longest in the first week and gets faster with practice
Minute 5-15: calculate the five numbers for each SKU. Net profit, return rate, effective commission rate, cash gap, and inventory turnover. The calculation should take 10 minutes once the data is exported. If it takes longer, your tracking system is not efficient enough
Minute 15-20: identify the SKUs that are in the danger zone. Any SKU with a net margin below 10 percent, a return rate above 20 percent, an effective commission rate more than 2 points above the listed rate, or an inventory turnover ratio above 60 days. These SKUs are the priority for the week
Minute 20-25: decide what to do about the danger zone SKUs. For each one, choose one of three actions: fix the cost structure (reduce returns, reduce shipping cost, negotiate supplier terms), raise the price, or discontinue the SKU. Write the action down and assign it to a specific day of the week
Minute 25-30: review the cash position. If the available cash is less than the pending settlement plus the next week’s expected inventory costs, the cash position is weak. Decide whether to reduce ad spend, reduce sample seeding, or delay inventory orders to protect the cash position
Common patterns that the weekly review reveals
Pattern one: the “GMV hero that is a profit zero.” The SKU with the highest revenue is the most unprofitable. The seller is investing the most time and money in a product that is destroying value. The fix is to either raise the price or discontinue the product
Pattern two: the “creeping return rate.” The return rate has been increasing by 1 to 2 percent per week for 4 weeks. The seller did not notice because the weekly change is small. The cumulative change is 6 to 8 percent, which is a significant margin erosion. The fix is to investigate the root cause of the return rate increase before it becomes a major problem
Pattern three: the “cash gap that is growing faster than revenue.” The revenue is growing at 20 percent per month, but the cash gap is growing at 30 percent per month. The seller is running a profitable business on paper but is going to run out of cash in 60 days. The fix is to slow the growth rate until the cash position stabilizes
Frequently asked questions
Do I need a spreadsheet or a dashboard tool
A spreadsheet is sufficient for the first 6 months. After 6 months, a dashboard tool that connects to the Seller Center API and automatically calculates the five numbers is worth the investment. The cost of a dashboard tool is typically $50 to $150 per month
What if I have more than 20 SKUs
Focus the weekly review on the top 10 SKUs by revenue. The bottom 10 SKUs generate less than 20 percent of the revenue, and their profit impact is small. Review them monthly instead of weekly
Should I review on Monday or Friday
Monday is better. The Monday review sets the priorities for the week. A Friday review provides a summary of the past week, but the action items are delayed until the next week
What is the most common reason sellers skip the weekly review
The review is uncomfortable. The weekly review reveals problems that the seller does not want to see. The seller who skips the review is the seller who discovers the problem after it has already cost them significant money. The discipline of the weekly review is the difference between catching problems early and catching them late
