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/23 03:30:00

数据区间

2026-04-23 至 2026-07-21

来源脚本

build… · cf7f37745bb8

自动刷新

每日 03:30 · Asia/Shanghai

订单利润明细

276300 条,共 6,384

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

店铺订单号下单时间订单状态结算金额净 GMV预计收入平台费用产品成本尾程扣减毛利润毛利率
Jollychefus07/14 22:38DELIVERED$27.64$45.99--$18.35$12.20$0.00$14.9132.4%
Jollychefus07/14 22:24DELIVERED$20.63$23.99--$3.36$4.33$11.98$3.1513.1%
Jollychefus07/14 22:20DELIVERED$16.80$27.99--$11.19$5.98$0.00$7.4326.6%
Jollychefus07/14 21:56DELIVERED$25.83$33.99--$8.16$12.64$16.84-$5.35-15.7%
Jollychefus07/14 21:21DELIVERED----$4.13---
Jollychefus07/14 20:59DELIVERED$8.15$19.99--$11.84$3.79$0.00$2.5612.8%
Jollychefus07/14 20:21DELIVERED$20.63$23.99--$3.36$4.33$11.98$3.1513.1%
Jollychefus07/14 20:04DELIVERED$11.98$19.99--$8.01$3.79$0.00$6.3932.0%
Jollychefus07/14 18:55CANCELLED$0.00$0.00-$0.00$0.00$8.74-$8.74-
Jollychefus07/14 15:55DELIVERED$8.77$19.99--$11.22$3.89$0.00$3.0115.1%
Jollychefus07/14 14:23DELIVERED$20.63$23.99--$3.36$4.29$11.98$3.1813.3%
Jollychefus07/14 13:54DELIVERED$16.19$26.99--$10.80$5.50$0.00$8.9333.1%
Jollychefus07/14 13:48DELIVERED$8.15$19.99--$11.84$3.89$0.00$2.3912.0%
Jollychefus07/14 13:46DELIVERED$10.38$19.99--$9.61$3.89$0.00$4.6223.1%
Jollychefus07/14 13:40DELIVERED$10.38$19.99--$9.61$3.89$0.00$4.6223.1%
Jollychefus07/14 13:30DELIVERED$20.01$23.27--$3.26$7.17$11.37$0.743.2%
Jollychefus07/14 13:18DELIVERED$18.23$23.99--$5.76$4.29$9.16$3.4714.5%
Jollychefus07/14 12:54CANCELLED$0.00$0.00-$0.00$0.00$0.00$0.00-
Jollychefus07/14 12:42DELIVERED$20.01$23.27--$3.26$7.17$11.37$0.371.6%
Jollychefus07/14 12:14DELIVERED$20.63$23.99--$3.36$4.29$11.98$3.0512.7%
Jollychefus07/14 12:06DELIVERED$18.23$23.99--$5.76$4.29$11.98$0.652.7%
Jollychefus07/14 11:44DELIVERED$19.80$23.27--$3.47$7.17$11.37$0.160.7%
Jollychefus07/14 10:53CANCELLED-$0.68$0.00--$0.68$0.00$7.04-$7.72-
Jollychefus07/14 10:41DELIVERED$21.49$24.99--$3.50$5.55$12.61$2.228.9%
Jollychefus07/14 10:38DELIVERED$23.57$32.99--$9.42$6.13$0.00$14.0642.6%
12 / 256

最近刷新记录

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

状态触发方式店铺数据区间开始时间耗时写入订单错误
失败计划任务Jollychefus2026-04-252026-07-232026/07/23 03:30:004 分 34 秒0CalledProcessError: 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.
失败计划任务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.