TK 订单利润
TikTok 订单利润
每日重算最近 90 天并覆盖同店铺同订单;更早的历史订单继续保留。已结算毛利率使用 TK 结算单净 GMV。
订单数
6,384
6,188 条已结算
结算单净 GMV
$183,674.97
TK结算单净GMVUSD
未结算预计收入
$7,846.14
预计收入口径
毛利润
$12,038.91
当前筛选订单合计
综合毛利率
6.3%
毛利润 /(净 GMV + 预计收入)
最新任务
失败2026/07/22 03:30:00
数据区间
2026-04-23 至 2026-07-21
来源脚本
build… · cf7f37745bb8
自动刷新
每日 03:30 · Asia/Shanghai
订单利润明细
第 76–100 条,共 6,384 条
点击订单号查看 sheet 完整字段
| 店铺 | 订单号 | 下单时间 | 订单状态 | 结算金额 | 净 GMV | 预计收入 | 平台费用 | 产品成本 | 尾程扣减 | 毛利润 | 毛利率 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jollychefus | 07/18 00:31 | AWAITING_COLLECTION | - | - | $27.54 | -$21.65 | $3.24 | - | $1.43 | 5.2% | |
| Jollychefus | 07/17 22:49 | AWAITING_SHIPMENT | - | - | $81.99 | -$19.68 | $27.74 | - | $31.42 | 38.3% | |
| Jollychefus | 07/17 22:18 | AWAITING_COLLECTION | - | - | $53.27 | -$16.18 | $14.54 | - | $20.71 | 38.9% | |
| Jollychefus | 07/17 22:06 | AWAITING_SHIPMENT | - | - | $83.59 | -$16.71 | $27.74 | - | $35.99 | 43.0% | |
| Jollychefus | 07/17 20:38 | AWAITING_SHIPMENT | - | - | $59.83 | -$17.20 | $8.86 | - | $31.29 | 52.3% | |
| Jollychefus | 07/17 20:37 | IN_TRANSIT | - | - | $175.98 | -$10.56 | $47.91 | - | $99.61 | 56.6% | |
| Jollychefus | 07/17 19:22 | AWAITING_COLLECTION | - | - | $53.19 | -$7.45 | $14.54 | - | $29.36 | 55.2% | |
| Jollychefus | 07/17 15:19 | DELIVERED | $25.18 | $36.99 | - | -$11.81 | $6.13 | $0.00 | $15.67 | 42.4% | |
| Jollychefus | 07/17 13:36 | AWAITING_SHIPMENT | - | - | $87.99 | -$12.32 | $27.74 | - | $44.78 | 50.9% | |
| Jollychefus | 07/17 13:06 | DELIVERED | - | - | - | - | $3.38 | - | - | - | |
| Jollychefus | 07/17 11:59 | AWAITING_COLLECTION | - | - | $28.99 | -$5.74 | $4.58 | - | $7.63 | 26.3% | |
| Jollychefus | 07/17 11:38 | IN_TRANSIT | - | - | $28.99 | -$1.74 | $3.69 | - | $13.91 | 48.0% | |
| Jollychefus | 07/17 11:20 | DELIVERED | $20.76 | $22.08 | - | -$1.32 | $7.20 | $9.16 | $2.99 | 13.5% | |
| Jollychefus | 07/17 11:10 | DELIVERED | - | - | - | - | $14.54 | - | - | - | |
| Jollychefus | 07/17 10:56 | IN_TRANSIT | - | - | $37.99 | -$5.50 | $6.85 | - | $13.37 | 35.2% | |
| Jollychefus | 07/17 10:23 | IN_TRANSIT | - | - | $37.99 | -$2.28 | $5.98 | - | $18.05 | 47.5% | |
| Jollychefus | 07/17 10:00 | DELIVERED | - | - | $28.99 | -$1.74 | $4.58 | - | $11.63 | 40.1% | |
| Jollychefus | 07/17 07:31 | IN_TRANSIT | - | - | $29.99 | -$6.07 | $6.14 | - | $5.00 | 16.7% | |
| Jollychefus | 07/17 06:36 | IN_TRANSIT | - | - | $49.99 | -$12.00 | $14.54 | - | $21.61 | 43.2% | |
| Jollychefus | 07/17 05:03 | DELIVERED | $20.35 | $28.99 | - | -$8.64 | $4.63 | $0.00 | $13.94 | 48.1% | |
| Jollychefus | 07/17 04:22 | DELIVERED | - | - | $55.99 | -$7.84 | $14.54 | - | $31.77 | 56.7% | |
| Jollychefus | 07/17 04:02 | IN_TRANSIT | - | - | $87.99 | -$12.32 | $27.74 | - | $37.04 | 42.1% | |
| Jollychefus | 07/17 03:26 | DELIVERED | $48.66 | $59.99 | - | -$11.33 | $14.11 | $0.00 | $33.70 | 56.2% | |
| Jollychefus | 07/17 01:21 | AWAITING_COLLECTION | - | - | $49.99 | -$3.24 | $14.54 | - | $30.37 | 60.7% | |
| Jollychefus | 07/17 01:20 | IN_TRANSIT | - | - | $28.99 | -$4.06 | $3.24 | - | $20.47 | 70.6% |
最近刷新记录
每日定时任务和页面手动任务共用运行历史。
| 状态 | 触发方式 | 店铺 | 数据区间 | 开始时间 | 耗时 | 写入订单 | 错误 |
|---|---|---|---|---|---|---|---|
| 失败 | 计划任务 | 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 | - |
| 失败 | 计划任务 | Jollychefus | 2026-04-20 至 2026-07-18 | 2026/07/18 03:30:00 | 11 秒 | 0 | CalledProcessError: Command '['python', '/app/upstream/tools/sync_tiktok_shop_orders.py', '--config', '/runtime/config.local.json', '--site', 'jollychef', '--start-date', '2026-04-20', '--end-date', '2026-07-18', '--timezone', 'America/Los_Angeles', '--output-dir', '/app/artifacts/tiktok_order_profit/2026-07-18_44a50e3f-d47a-4334-95d0-0730c5b30c45']' 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 231, 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/sync_tiktok_shop_orders.py', '--config', '/runtime/config.local.json', '--site', 'jollychef', '--start-date', '2026-04-20', '--end-date', '2026-07-18', '--timezone', 'America/Los_Angeles', '--output-dir', '/app/artifacts/tiktok_order_profit/2026-07-18_44a50e3f-d47a-4334-95d0-0730c5b30c45']' returned non-zero exit status 1. |
| 成功 | 计划任务 | Jollychefus | 2026-04-19 至 2026-07-17 | 2026/07/17 03:30:00 | 7 分 58 秒 | 6,271 | - |