原因：没有自动建单的SKU是因为没有运输方式被排除掉了
服务名称：Task_Amazon_CreateStockOrderFromCart
1H
二：头程物流优选 明磊交接的功能 ——同步海运、空运类型 功能导出与修改
1.修改功能代码逻辑：运输类型（空运传“空运”，海运传“普船”，如果“普船查不到”，再传“海运”）
2.将海运空运运费等字段跑到新表里给业务确认：
5.5H
相关服务：AmazonFbaHeaderTransportMapService
跑出来的数据结果相关Sql:
SELECT
pb.ProductNameCn,
pb.OrderSourceName,
pb.OrderSourceSku,
pb.ASINorItemID,
CASE
am.OrderSourceID
WHEN 0 THEN
'空运' ELSE '海运'
END '推荐运输类型',
pb.ListingSoldNum 'FBA库存',
pb.WeekSaleNum '一周销量',
pb.TwoWeekSaleNum '两周销量',
pb.msaleNum '近30天销量',
pb.ThreeMonthSaleNum '近90天销量',
ad.UserName '首选业务员',
d.DepartmentName '三级部门',
rp.NetWeight '净重g',
rp.GrossWeight '毛重g',
rp.Length '长',
rp.Width '宽',
rp.Height '高',
rp.Pack_Length '包装长',
rp.Pack_Width '包装宽',
rp.Pack_Height '包装高',
am.[__Api] '海运运费',
am.[__ApiType] '海运运费(含风险)',
am.[__StepName] '空运运费',
am.[__LoginUserName] '空运运费(含风险)'
FROM
RB_Crawler_Wish_AccountMoney ( nolock ) am
INNER JOIN RB_Amazon_Product_Base ( nolock ) pb ON am.id = pb.id
LEFT JOIN RB_OrderSource ( nolock ) os ON pb.CustomerID = os.CustomerID
AND pb.OrderSourceID = os.ID
LEFT JOIN RB_Admin ( nolock ) ad ON os.SaleAdminID = ad.ID
AND os.CustomerID = ad.CustomerID
LEFT JOIN RB_Department ( nolock ) d ON ad.DepartmentID = d.ID
LEFT JOIN RB_Product ( nolock ) rp ON pb.SKU = rp.SKU
AND pb.CustomerID = rp.CustomerID
