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

订单利润明细

76100 条,共 6,384

点击订单号查看 sheet 完整字段

店铺订单号下单时间订单状态结算金额净 GMV预计收入平台费用产品成本尾程扣减毛利润毛利率
Jollychefus07/18 00:31AWAITING_COLLECTION--$27.54-$21.65$3.24-$1.435.2%
Jollychefus07/17 22:49AWAITING_SHIPMENT--$81.99-$19.68$27.74-$31.4238.3%
Jollychefus07/17 22:18AWAITING_COLLECTION--$53.27-$16.18$14.54-$20.7138.9%
Jollychefus07/17 22:06AWAITING_SHIPMENT--$83.59-$16.71$27.74-$35.9943.0%
Jollychefus07/17 20:38AWAITING_SHIPMENT--$59.83-$17.20$8.86-$31.2952.3%
Jollychefus07/17 20:37IN_TRANSIT--$175.98-$10.56$47.91-$99.6156.6%
Jollychefus07/17 19:22AWAITING_COLLECTION--$53.19-$7.45$14.54-$29.3655.2%
Jollychefus07/17 15:19DELIVERED$25.18$36.99--$11.81$6.13$0.00$15.6742.4%
Jollychefus07/17 13:36AWAITING_SHIPMENT--$87.99-$12.32$27.74-$44.7850.9%
Jollychefus07/17 13:06DELIVERED----$3.38---
Jollychefus07/17 11:59AWAITING_COLLECTION--$28.99-$5.74$4.58-$7.6326.3%
Jollychefus07/17 11:38IN_TRANSIT--$28.99-$1.74$3.69-$13.9148.0%
Jollychefus07/17 11:20DELIVERED$20.76$22.08--$1.32$7.20$9.16$2.9913.5%
Jollychefus07/17 11:10DELIVERED----$14.54---
Jollychefus07/17 10:56IN_TRANSIT--$37.99-$5.50$6.85-$13.3735.2%
Jollychefus07/17 10:23IN_TRANSIT--$37.99-$2.28$5.98-$18.0547.5%
Jollychefus07/17 10:00DELIVERED--$28.99-$1.74$4.58-$11.6340.1%
Jollychefus07/17 07:31IN_TRANSIT--$29.99-$6.07$6.14-$5.0016.7%
Jollychefus07/17 06:36IN_TRANSIT--$49.99-$12.00$14.54-$21.6143.2%
Jollychefus07/17 05:03DELIVERED$20.35$28.99--$8.64$4.63$0.00$13.9448.1%
Jollychefus07/17 04:22DELIVERED--$55.99-$7.84$14.54-$31.7756.7%
Jollychefus07/17 04:02IN_TRANSIT--$87.99-$12.32$27.74-$37.0442.1%
Jollychefus07/17 03:26DELIVERED$48.66$59.99--$11.33$14.11$0.00$33.7056.2%
Jollychefus07/17 01:21AWAITING_COLLECTION--$49.99-$3.24$14.54-$30.3760.7%
Jollychefus07/17 01:20IN_TRANSIT--$28.99-$4.06$3.24-$20.4770.6%
4 / 256

最近刷新记录

每日定时任务和页面手动任务共用运行历史。

状态触发方式店铺数据区间开始时间耗时写入订单错误
失败计划任务Jollychefus2026-04-242026-07-222026/07/22 03:30:004 分 28 秒0CalledProcessError: 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.
成功计划任务Jollychefus2026-04-232026-07-212026/07/21 03:30:008 分 17 秒6,304-
成功计划任务Jollychefus2026-04-222026-07-202026/07/20 03:30:008 分 7 秒6,298-
成功计划任务Jollychefus2026-04-212026-07-192026/07/19 03:30:007 分 49 秒6,285-
失败计划任务Jollychefus2026-04-202026-07-182026/07/18 03:30:0011 秒0CalledProcessError: 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.
成功计划任务Jollychefus2026-04-192026-07-172026/07/17 03:30:007 分 58 秒6,271-