== 单文件建单：匹配成功、解析两行 ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=PENDING taskMode=PYTHON_QUEUE sourceFileCount=1 successFileCount=0 failedFileCount=0 userId=7 createdBy=user:7 deviceId=device-1 errorMessage=null finishedAtSet=false requestJson.keys=[files,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=d94395576c95 resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/shop-a.xlsx sourceFilename=shop-a.xlsx relativePath=shop-a.xlsx shopName=shop-a matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=2 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
item.insertBatch count=2 taskId=1001 fileId=2001 rowIndex=[1,2] asins=[B001,B002] brands=[耐克,Adidas] itemCreatedAtEqualsTaskNow=false
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=shop-a.xlsx sourceFileUrl=uploads/shop-a.xlsx resultContentType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet rowCount=2 success=0 errorMessage=null userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=1 totalRows=2 pageSize=50
  vo.file fileId=2001 fileKey=uploads/shop-a.xlsx shopName=shop-a matched=true status=PENDING totalRows=2 percent=0 errorMessage=null

== 双文件聚合：结果类型换 zip、URL 取首文件、行号逐文件重计 ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=PENDING taskMode=PYTHON_QUEUE sourceFileCount=2 successFileCount=0 failedFileCount=0 userId=7 createdBy=user:7 deviceId=device-2 errorMessage=null finishedAtSet=false requestJson.keys=[files,fileKey,originalFilename,relativePath,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=02e9718f0b2b resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/a.xlsx sourceFilename=a.xlsx relativePath=a.xlsx shopName=a matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=1 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
item.insertBatch count=1 taskId=1001 fileId=2001 rowIndex=[1] asins=[B001] brands=[Nike] itemCreatedAtEqualsTaskNow=false
file.insert taskId=1001 fileId=2002 fileKey=uploads/b.xlsx sourceFilename=b.xlsx relativePath=b.xlsx shopName=b matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=2 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
item.insertBatch count=2 taskId=1001 fileId=2002 rowIndex=[1,2] asins=[B002,B003] brands=[Puma,Asics] itemCreatedAtEqualsTaskNow=false
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=a.xlsx 等 2 个文件 sourceFileUrl=uploads/a.xlsx resultContentType=application/zip rowCount=3 success=0 errorMessage=null userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=2 totalRows=3 pageSize=50
  vo.file fileId=2001 fileKey=uploads/a.xlsx shopName=a matched=true status=PENDING totalRows=1 percent=0 errorMessage=null
  vo.file fileId=2002 fileKey=uploads/b.xlsx shopName=b matched=true status=PENDING totalRows=2 percent=0 errorMessage=null

== 店铺未匹配：文件行 FAILED 但任务仍 PENDING（有一个可用就进队列） ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=PENDING taskMode=PYTHON_QUEUE sourceFileCount=2 successFileCount=0 failedFileCount=1 userId=7 createdBy=user:7 deviceId=null errorMessage=null finishedAtSet=false requestJson.keys=[files,fileKey,originalFilename,relativePath,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=e0166e85bd50 resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/a.xlsx sourceFilename=shop-a.xlsx relativePath=a.xlsx shopName=shop-a matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=1 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
item.insertBatch count=1 taskId=1001 fileId=2001 rowIndex=[1] asins=[B001] brands=[Nike] itemCreatedAtEqualsTaskNow=false
file.insert taskId=1001 fileId=2002 fileKey=uploads/b.xlsx sourceFilename=shop-b.xlsx relativePath=b.xlsx shopName=shop-b matched=0 shopId=null matchedUserId=null platform=null companyName=null matchStatus=null matchMessage=null status=FAILED totalRows=0 processedRows=0 errorMessage=店铺未匹配到紫鸟索引 finishedAtSet=true createdAtEqualsTaskNow=true
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=shop-a.xlsx 等 2 个文件 sourceFileUrl=uploads/a.xlsx resultContentType=application/zip rowCount=1 success=0 errorMessage=null userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=2 totalRows=1 pageSize=50
  vo.file fileId=2001 fileKey=uploads/a.xlsx shopName=shop-a matched=true status=PENDING totalRows=1 percent=0 errorMessage=null
  vo.file fileId=2002 fileKey=uploads/b.xlsx shopName=shop-b matched=false status=FAILED totalRows=0 percent=100 errorMessage=店铺未匹配到紫鸟索引

== 匹配服务抛异常：全文件失败 ⇒ 任务直接 FAILED 并封口 ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=FAILED taskMode=PYTHON_QUEUE sourceFileCount=1 successFileCount=0 failedFileCount=1 userId=7 createdBy=user:7 deviceId=d errorMessage=全部文件解析或店铺匹配失败 finishedAtSet=true requestJson.keys=[files,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=9982fc0a2d4f resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/a.xlsx sourceFilename=shop-a.xlsx relativePath=a.xlsx shopName=shop-a matched=0 shopId=null matchedUserId=null platform=null companyName=null matchStatus=PENDING matchMessage=紫鸟索引不可用 status=FAILED totalRows=0 processedRows=0 errorMessage=紫鸟索引不可用 finishedAtSet=true createdAtEqualsTaskNow=true
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=shop-a.xlsx sourceFileUrl=uploads/a.xlsx resultContentType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet rowCount=0 success=0 errorMessage=全部文件解析或店铺匹配失败 userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=1 totalRows=0 pageSize=50
  vo.file fileId=2001 fileKey=uploads/a.xlsx shopName=shop-a matched=false status=FAILED totalRows=0 percent=100 errorMessage=紫鸟索引不可用

== 解析出 0 行：不调 insertBatch，但文件仍 PENDING、任务仍建起来 ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=PENDING taskMode=PYTHON_QUEUE sourceFileCount=1 successFileCount=0 failedFileCount=0 userId=7 createdBy=user:7 deviceId=d errorMessage=null finishedAtSet=false requestJson.keys=[files,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=0f201eecd7e5 resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/empty.xlsx sourceFilename=shop-a.xlsx relativePath=empty.xlsx shopName=shop-a matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=0 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=shop-a.xlsx sourceFileUrl=uploads/empty.xlsx resultContentType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet rowCount=0 success=0 errorMessage=null userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=1 totalRows=0 pageSize=50
  vo.file fileId=2001 fileKey=uploads/empty.xlsx shopName=shop-a matched=true status=PENDING totalRows=0 percent=0 errorMessage=null

== 行含 null：计数含 null 而落库跳 null，品牌落库前过 BrandLabel.strip ==
tx.begin
task.insert taskNo=PUBLISH-<snowflake> moduleType=PUBLISH status=PENDING taskMode=PYTHON_QUEUE sourceFileCount=1 successFileCount=0 failedFileCount=0 userId=7 createdBy=user:7 deviceId=d errorMessage=null finishedAtSet=false requestJson.keys=[files,fileKey,originalFilename,relativePath,user_id,publish_country,sync_countries] requestJson.digest=f87ffd176e5e resultJson={"ownerInstanceId":"node-A"}
file.insert taskId=1001 fileId=2001 fileKey=uploads/null-row.xlsx sourceFilename=shop-a.xlsx relativePath=n.xlsx shopName=shop-a matched=1 shopId=shop-9 matchedUserId=42 platform=amazon companyName=ACME 有限公司 matchStatus=MATCHED matchMessage= status=PENDING totalRows=3 processedRows=0 errorMessage=null finishedAtSet=false createdAtEqualsTaskNow=true
item.insertBatch count=2 taskId=1001 fileId=2001 rowIndex=[1,2] asins=[B001,B002] brands=[NIKE: X,李宁] itemCreatedAtEqualsTaskNow=false
result.insert taskId=1001 moduleType=PUBLISH sourceFilename=shop-a.xlsx sourceFileUrl=uploads/null-row.xlsx resultContentType=application/vnd.openxmlformats-officedocument.spreadsheetml.sheet rowCount=3 success=0 errorMessage=null userId=7 createdAtEqualsTaskNow=true
tx.commit
vo: taskId=1001 taskNo=PUBLISH-<snowflake> sourceFileCount=1 totalRows=3 pageSize=50
  vo.file fileId=2001 fileKey=uploads/null-row.xlsx shopName=shop-a matched=true status=PENDING totalRows=3 percent=0 errorMessage=null

== 建单被拒的七格：事务未开、一次库都不碰 ==
request=null -> BusinessException: 请求不能为空
userId=null -> BusinessException: user_id 不合法
userId=0 -> BusinessException: user_id 不合法
files=null -> BusinessException: 请先上传 Excel 文件
files=空 -> BusinessException: 请先上传 Excel 文件
publishCountry=空白 -> BusinessException: 发布国家不能为空
fileKey 重复 -> BusinessException: 上传文件重复: shop-a.xlsx
events=0（重复 fileKey 那格已 prepare 过首文件，但落库与事务都未开始）
