TK 订单利润
TikTok 订单利润
每日重算最近 90 天并覆盖同店铺同订单；更早的历史订单继续保留。已结算毛利率使用 TK 结算单净 GMV。
订单数
6,443
6,297 条已结算
结算单净 GMV
$187,656.70
TK结算单净GMVUSD
未结算预计收入
$4,862.07
预计收入口径
毛利润
$12,109.80
当前筛选订单合计
综合毛利率
6.3%
毛利润 /（净 GMV + 预计收入）
最新任务
成功2026/07/23 10:02:37
数据区间
2026-04-25 至 2026-07-23
来源脚本
build… · cf7f37745bb8
自动刷新
每日 03:30 · Asia/Shanghai
订单利润明细
第 401–425 条，共 6,443 条
点击订单号查看 sheet 完整字段
| 店铺 | 订单号 | 下单时间 | 订单状态 | 结算金额 | 净 GMV | 预计收入 | 平台费用 | 产品成本 | 尾程扣减 | 毛利润 | 毛利率 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jollychefus | 07/14 00:08 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.29 | $11.98 | $3.17 | 13.2% | |
| Jollychefus | 07/13 23:20 | DELIVERED | $25.24 | $36.98 | - | -$11.74 | $7.58 | $0.00 | $14.05 | 38.0% | |
| Jollychefus | 07/13 23:02 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $4.29 | $11.98 | $5.09 | 21.2% | |
| Jollychefus | 07/13 22:41 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.29 | $11.98 | $0.65 | 2.7% | |
| Jollychefus | 07/13 22:05 | DELIVERED | $22.49 | $23.99 | - | -$1.50 | $4.29 | $11.98 | $4.91 | 20.5% | |
| Jollychefus | 07/13 21:43 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $4.29 | $11.98 | $5.17 | 21.6% | |
| Jollychefus | 07/13 21:42 | COMPLETED | -$12.85 | $0.00 | - | -$12.85 | $23.67 | $0.00 | -$38.08 | - | |
| Jollychefus | 07/13 21:02 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.29 | $11.98 | $3.05 | 12.7% | |
| Jollychefus | 07/13 17:01 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.30 | 1.3% | |
| Jollychefus | 07/13 15:41 | DELIVERED | $14.17 | $26.99 | - | -$12.82 | $5.51 | $0.00 | $6.61 | 24.5% | |
| Jollychefus | 07/13 14:56 | IN_TRANSIT | - | - | $39.98 | -$5.60 | $7.89 | - | $14.17 | 35.4% | |
| Jollychefus | 07/13 14:47 | DELIVERED | $16.77 | $27.99 | - | -$11.22 | $5.98 | $0.00 | $8.85 | 31.6% | |
| Jollychefus | 07/13 13:32 | DELIVERED | $28.11 | $36.99 | - | -$8.88 | $12.64 | $16.84 | -$2.71 | -7.3% | |
| Jollychefus | 07/13 13:30 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.37 | 1.6% | |
| Jollychefus | 07/13 13:28 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.29 | $11.98 | $0.77 | 3.2% | |
| Jollychefus | 07/13 13:08 | DELIVERED | $17.00 | $26.99 | - | -$9.99 | $5.51 | $0.00 | $9.44 | 35.0% | |
| Jollychefus | 07/13 12:41 | DELIVERED | $18.46 | $36.99 | - | -$18.53 | $12.64 | $16.84 | -$12.83 | -34.7% | |
| Jollychefus | 07/13 12:39 | CANCELLED | $0.00 | $0.00 | - | $0.00 | $0.00 | $0.00 | $0.00 | - | |
| Jollychefus | 07/13 12:38 | DELIVERED | $31.81 | $36.99 | - | -$5.18 | $12.64 | $16.84 | $0.99 | 2.7% | |
| Jollychefus | 07/13 12:25 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $4.29 | $11.98 | $5.09 | 21.2% | |
| Jollychefus | 07/13 11:56 | DELIVERED | $12.31 | $26.99 | - | -$14.68 | $3.55 | $0.00 | $7.39 | 27.4% | |
| Jollychefus | 07/13 11:48 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.29 | $11.98 | $0.77 | 3.2% | |
| Jollychefus | 07/13 11:40 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $4.29 | $11.98 | $5.09 | 21.2% | |
| Jollychefus | 07/13 11:32 | DELIVERED | $174.07 | $206.97 | - | -$32.90 | $75.84 | $63.92 | $26.23 | 12.7% | |
| Jollychefus | 07/13 11:31 | DELIVERED | $22.55 | $23.99 | - | -$1.44 | $3.83 | $11.98 | $5.42 | 22.6% |
最近刷新记录
每日定时任务和页面手动任务共用运行历史。
| 状态 | 触发方式 | 店铺 | 数据区间 | 开始时间 | 耗时 | 写入订单 | 错误 |
|---|---|---|---|---|---|---|---|
| 成功 | 手动 | Jollychefus | 2026-04-25 至 2026-07-23 | 2026/07/23 10:02:37 | 10 分 3 秒 | 6,129 | - |
| 失败 | 计划任务 | Jollychefus | 2026-04-25 至 2026-07-23 | 2026/07/23 03:30:00 | 4 分 34 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-25', '--end-date', '2026-07-23', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.summary.json', '--max-pages', '100']' returned non-zero exit status 1. Traceback (most recent call last): File "/app/tiktok_order_profit_worker/main.py", line 614, in run_once paths, output_shop_slug = execute_pipeline(start, end, output_directory) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tiktok_order_profit_worker/main.py", line 261, in execute_pipeline run_command( File "/app/tiktok_order_profit_worker/main.py", line 170, in run_command subprocess.run(command, cwd=cwd, check=True) File "/usr/local/lib/python3.12/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-25', '--end-date', '2026-07-23', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-23_86ac5ed2-8ec5-4b4c-8fe9-159b07bb12b1/Jollychefus_lingxing_profit_all_2026-04-25_2026-07-23.summary.json', '--max-pages', '100']' returned non-zero exit status 1. |
| 失败 | 计划任务 | Jollychefus | 2026-04-24 至 2026-07-22 | 2026/07/22 03:30:00 | 4 分 28 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-24', '--end-date', '2026-07-22', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.summary.json', '--max-pages', '100']' returned non-zero exit status 1. Traceback (most recent call last): File "/app/tiktok_order_profit_worker/main.py", line 614, in run_once paths, output_shop_slug = execute_pipeline(start, end, output_directory) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/app/tiktok_order_profit_worker/main.py", line 261, in execute_pipeline run_command( File "/app/tiktok_order_profit_worker/main.py", line 170, in run_command subprocess.run(command, cwd=cwd, check=True) File "/usr/local/lib/python3.12/subprocess.py", line 571, in run raise CalledProcessError(retcode, process.args, subprocess.CalledProcessError: Command '['python', '/app/upstream/tools/query_lingxing_profit.py', '--start-date', '2026-04-24', '--end-date', '2026-07-22', '--date-type', 'order', '--platform-code', '10011', '--site', 'TikTok-Jollychefus', '--mapping-file', '/runtime/data/lingxing_tiktok_sku_mapping.csv', '--output-csv', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.csv', '--summary-json', '/app/artifacts/tiktok_order_profit/2026-07-22_d785d89d-cfe3-40c4-80a0-d335b4c08556/Jollychefus_lingxing_profit_all_2026-04-24_2026-07-22.summary.json', '--max-pages', '100']' returned non-zero exit status 1. |
| 成功 | 计划任务 | Jollychefus | 2026-04-23 至 2026-07-21 | 2026/07/21 03:30:00 | 8 分 17 秒 | 6,304 | - |
| 成功 | 计划任务 | Jollychefus | 2026-04-22 至 2026-07-20 | 2026/07/20 03:30:00 | 8 分 7 秒 | 6,298 | - |
| 成功 | 计划任务 | Jollychefus | 2026-04-21 至 2026-07-19 | 2026/07/19 03:30:00 | 7 分 49 秒 | 6,285 | - |