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
订单利润明细
第 351–375 条，共 6,443 条
点击订单号查看 sheet 完整字段
| 店铺 | 订单号 | 下单时间 | 订单状态 | 结算金额 | 净 GMV | 预计收入 | 平台费用 | 产品成本 | 尾程扣减 | 毛利润 | 毛利率 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jollychefus | 07/14 13:18 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.29 | $9.16 | $3.47 | 14.5% | |
| Jollychefus | 07/14 12:54 | CANCELLED | $0.00 | $0.00 | - | $0.00 | $0.00 | $0.00 | $0.00 | - | |
| Jollychefus | 07/14 12:42 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.37 | 1.6% | |
| Jollychefus | 07/14 12:14 | DELIVERED | $20.63 | $23.99 | - | -$3.36 | $4.29 | $11.98 | $3.05 | 12.7% | |
| Jollychefus | 07/14 12:06 | DELIVERED | $18.23 | $23.99 | - | -$5.76 | $4.29 | $11.98 | $0.65 | 2.7% | |
| Jollychefus | 07/14 11:44 | DELIVERED | $19.80 | $23.27 | - | -$3.47 | $7.17 | $11.37 | $0.16 | 0.7% | |
| Jollychefus | 07/14 10:53 | CANCELLED | -$0.68 | $0.00 | - | -$0.68 | $0.00 | $7.04 | -$7.72 | - | |
| Jollychefus | 07/14 10:41 | DELIVERED | $21.49 | $24.99 | - | -$3.50 | $5.55 | $12.61 | $2.22 | 8.9% | |
| Jollychefus | 07/14 10:38 | DELIVERED | $23.57 | $32.99 | - | -$9.42 | $6.13 | $0.00 | $14.06 | 42.6% | |
| Jollychefus | 07/14 10:08 | DELIVERED | $8.16 | $25.99 | - | -$17.83 | $4.95 | $12.61 | -$10.64 | -40.9% | |
| Jollychefus | 07/14 09:52 | DELIVERED | $17.44 | $24.99 | - | -$7.55 | $5.55 | $12.61 | -$1.82 | -7.3% | |
| Jollychefus | 07/14 09:35 | DELIVERED | $6.75 | $19.99 | - | -$13.24 | $3.95 | $0.00 | $0.86 | 4.3% | |
| Jollychefus | 07/14 09:31 | DELIVERED | $18.99 | $24.99 | - | -$6.00 | $5.55 | $12.61 | -$0.27 | -1.1% | |
| Jollychefus | 07/14 08:42 | DELIVERED | $36.27 | $56.99 | - | -$20.72 | $14.80 | $0.00 | $19.24 | 33.8% | |
| Jollychefus | 07/14 08:18 | DELIVERED | $20.01 | $23.27 | - | -$3.26 | $7.17 | $11.37 | $0.30 | 1.3% | |
| Jollychefus | 07/14 08:17 | DELIVERED | $15.74 | $23.99 | - | -$8.25 | $4.46 | $0.00 | $9.46 | 39.4% | |
| Jollychefus | 07/14 08:03 | DELIVERED | $14.32 | $29.99 | - | -$15.67 | $5.98 | $0.00 | $4.95 | 16.5% | |
| Jollychefus | 07/14 07:59 | DELIVERED | $9.33 | $23.27 | - | -$13.94 | $7.17 | $11.37 | -$10.38 | -44.6% | |
| Jollychefus | 07/14 07:26 | DELIVERED | $57.61 | $66.99 | - | -$9.38 | $25.28 | $25.77 | $3.17 | 4.7% | |
| Jollychefus | 07/14 07:25 | DELIVERED | $19.75 | $25.99 | - | -$6.24 | $4.95 | $12.61 | $1.07 | 4.1% | |
| Jollychefus | 07/14 06:55 | DELIVERED | $15.74 | $23.99 | - | -$8.25 | $4.58 | $0.00 | $9.17 | 38.2% | |
| Jollychefus | 07/14 06:53 | DELIVERED | $22.79 | $29.99 | - | -$7.20 | $7.20 | $11.37 | $3.22 | 10.7% | |
| Jollychefus | 07/14 06:23 | IN_TRANSIT | - | - | $36.99 | -$2.22 | $14.54 | - | $18.39 | 49.7% | |
| Jollychefus | 07/14 06:09 | DELIVERED | $21.49 | $24.99 | - | -$3.50 | $5.55 | $12.61 | $2.22 | 8.9% | |
| Jollychefus | 07/14 06:01 | DELIVERED | $8.98 | $19.99 | - | -$11.01 | $3.89 | $0.00 | $3.22 | 16.1% |
最近刷新记录
每日定时任务和页面手动任务共用运行历史。
| 状态 | 触发方式 | 店铺 | 数据区间 | 开始时间 | 耗时 | 写入订单 | 错误 |
|---|---|---|---|---|---|---|---|
| 成功 | 手动 | 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 | - |