深圳智汇创想科技有限公司

[步骤]

自定义导出  161719 161718 无法导出 

 SELECT   b.SKU AS '系统sku',     b.发货月份,     b.SellerSKU AS '渠道sku',     b.ASINorItemID AS 'asin',  p.ProductNameCN AS '产品中文名称',  ep.一级类目,  ep.二级类目,  ep.三级类目,     os.OrderSourceName AS '来源渠道',  apb.OrderSourceID,     b.UserName AS '销售人员',  b.部门,     b.DepartmentName AS '部门小组',  a.销售额 AS '销售额',     b.总收入,     ISNULL(b.总利润,0) - ISNULL(c.累计广告费,0) AS '总利润',     b.退款金额,     b.销售数量,  b.总订单数量,  b.退款数量,  B.退款订单数量,     b.促销折扣,     b.交易佣金,     b.FBA操作费,     b.采购成本,     b.本地仓运费,     b.海外仓派送运费,     b.头程运费,  pb.BrandName AS '品牌名字',   STUFF((           SELECT ',' + ISNULL(ssh.HolidaysName,'')  FROM RB_Amazon_Holiday (NOLOCK) ah  LEFT JOIN RB_SalesSactorHolidays (NOLOCK) ssh   ON ssh.CustomerID = ah.CustomerID    AND ssh.ID = ah.HolidayID            WHERE     apb.OrderSourceSKUID = ah.OrderSourceSKUID    AND ah.CustomerID = 1  FOR XML PATH('')), 1, 1, '') AS '节假日',  CASE apb.IsFBA WHEN 0 THEN '否'     WHEN 1 THEN '是'     ELSE '' END AS '是否FBA',    apb.OrderSourceSkuOrderTime AS '渠道sku首单时间',  apb.AsinOrderTime AS 'asin首单时间',  apb.PublishTime AS 'listing上架时间',  case     when apb.OnShelfMode = 1 then '一键上架'     when apb.OnShelfMode = 2 then '草稿上架'     when apb.OnShelfMode = 3 then '表格上架'     when apb.OnShelfMode = 4 then '关联导入'     when apb.OnShelfMode = 5 then '批量跟卖'     when apb.OnShelfMode = 6 then '凤凰重刊'     when apb.OnShelfMode = 7 then '复制上架'     when apb.OnShelfMode = 8 then '智能刊登'  WHEN apb.OnShelfMode = 9 THEN '自动刊登'     else ''   end as '上架方式',     CASE     apb.IsOffShelf     WHEN 0 THEN '在线'     WHEN 1 THEN '下架'     WHEN 2 THEN '售完'     WHEN 3 THEN '草稿'     WHEN 4 THEN '刊登中'     WHEN 5 THEN '刊登失败'   END listing状态,   apb.ListingPrice AS '原价',   apb.OrderSourceCountry AS '市场',   apb.AddAdminName AS '上架人员',   apbl.OrderSourceSkuFirstTime AS '渠道SKU首次到货时间',   apbl.AsinFirstTime AS 'asin首次到货时间',  pa.OnlineTime AS '产品上架时间',  pa.CheckTime [终审时间],  CASE   WHEN apb.ProductProperty = 0 THEN '未选择'   WHEN apb.ProductProperty = 1 THEN '非仿牌'   WHEN apb.ProductProperty = 2 THEN '仿牌'   WHEN apb.ProductProperty = 3 THEN '灰色产品'   ELSE '未知(' + CAST(apb.ProductProperty AS VARCHAR(10)) + ')'  END AS '是否仿牌',  CASE p.DevelopType   WHEN 1 THEN '自主开发'   WHEN 2 THEN '供应商后台'   WHEN 3 THEN '指定开发'   WHEN 4 THEN '智能选品'   WHEN 5 THEN '销售提报_FBA新品'   ELSE ''  END [开发类型],  dc.name [物流属性],  p.IsGroup [是否组合产品],  STUFF((     SELECT ',' + T.SKU     FROM dbo.RB_Product_GroupSku T (NOLOCK)     WHERE b.SKU=T.GroupSku     FOR XML PATH('')), 1, 1, '') as [子SKU],  CASE WHEN ISNULL(p.Pack_Length,0) > 0 THEN p.Pack_Length ELSE p.Length END  AS [158产品长],  CASE WHEN ISNULL(p.Pack_Width,0) > 0  THEN p.Pack_Width ELSE  p.Width END AS [158产品宽],  CASE WHEN ISNULL(p.Pack_Height,0) > 0 THEN p.Pack_Height ELSE p.Height END  AS [158产品高],  CASE WHEN ISNULL(p.PackWeight,0) > 0  THEN p.PackWeight ELSE  p.GrossWeight END  AS [158重量],   -- 后台     fr.长 [后台长],     fr.宽 [后台宽],     fr.高 [后台高],     fr.长度单位,     fr.重量,     fr.重量单位,  CASE WHEN apb.AvgDailySales > 0 THEN apb.KykcNum*1.0/apb.AvgDailySales ELSE 0 END AS '可售天数',  apb.KykcNum AS '当前库存',  apb.WeekSaleNum AS '7天销量',  apb.msaleNum AS '30天销量'  --CASE WHEN aml.Id > 0 THEN '是' ELSE '否' END AS '是否智能运营'  INTO #t FROM #tmp_saleprice a LEFT JOIN #tmp_other_price b   ON a.发货月份=b.发货月份  AND a.sku=b.SKU  AND a.OrderSourceID=b.OrderSourceID  AND a.ASINorItemID=b.ASINorItemID  AND a.SellerSKU=b.SellerSKU  AND a.UserName=b.UserName  AND a.DepartmentName=b.DepartmentName  AND a.CustomerID=b.CustomerID LEFT JOIN #ad2 AS c ON a.发货月份 = c.月份 AND a.OrderSourceID = c.OrderSourceID AND a.ASINorItemID = c.Asin AND a.SellerSKU = c.OrderSourceSKU LEFT JOIN dbo.RB_Product p (NOLOCK) ON a.CustomerID=p.CustomerID AND a.SKU=p.SKU LEFT JOIN dbo.RB_Product_Brand pb (NOLOCK) ON p.CustomerID=pb.CustomerID AND p.BrandID=pb.ID LEFT JOIN dbo.RB_Amazon_Product_Base apb (NOLOCK)  ON a.CustomerID=apb.CustomerID  AND a.OrderSourceID=apb.OrderSourceID  AND a.SellerSKU=apb.OrderSourceSKU  AND apb.IsDelete = 0  -- 剔除被删除的  LEFT JOIN RB_Amazon_Holiday (NOLOCK) ah ON apb.OrderSourceSKUID = ah.OrderSourceSKUID AND ah.CustomerID = apb.CustomerID LEFT JOIN RB_SalesSactorHolidays (NOLOCK) ssh ON ssh.CustomerID = ah.CustomerID AND ssh.ID = ah.HolidayID LEFT JOIN dbo.RB_OrderSource os (NOLOCK) ON a.CustomerID=os.CustomerID AND a.OrderSourceID=os.ID LEFT JOIN #t1 AS ep ON a.CustomerID = 1 AND a.SKU = ep.SKU AND ep.rowid = 1 --LEFT JOIN dbo.RB_Product_Class pc1 (NOLOCK) ON p.CustomerID=pc1.CustomerID AND p.ClassID1=pc1.ID --LEFT JOIN dbo.RB_Product_Class pc2 (NOLOCK) ON p.CustomerID=pc2.CustomerID AND p.ClassID2=pc2.ID --LEFT JOIN dbo.RB_Product_Class pc3 (NOLOCK) ON p.CustomerID=pc3.CustomerID AND p.ClassID=pc3.ID LEFT JOIN dbo.RB_Admin ad (NOLOCK) ON a.CustomerID=ad.CustomerID AND os.SaleAdminID=ad.ID LEFT JOIN dbo.RB_Department d (NOLOCK) ON ad.CustomerID=p.CustomerID AND ad.DepartmentID=d.ID LEFT JOIN RB_Product_Admin pa (NOLOCK) ON a.SKU=pa.SKU AND d.CustomerID=pa.CustomerID LEFT JOIN #temp_bd_datadictionary dc ON p.WithBattery=dc.id LEFT JOIN dbo.RB_Amazon_Product_Base_Label(NOLOCK) AS apbl ON apb.CustomerID = apbl.CustomerID AND apb.ID = apbl.ProductBaseID  LEFT JOIN (  SELECT   fr.CustomerId,   fr.OrderSourceSKUID,   fr.LongestSide '长',   fr.MedianSide '宽',   fr.ShortestSide '高',   fr.UnitOfDimension '长度单位',   fr.ItemPackageWeight '重量',   fr.UnitOfWeight '重量单位',   ROW_NUMBER() OVER(PARTITION BY fr.OrderSourceSKUID,fr.CustomerId ORDER BY fr.AddTime DESC) [rank]   FROM dbo.RB_Amazon_FbaFeePreview_Report fr (NOLOCK)  WHERE fr.IsRemoved=0 ) fr  ON fr.CustomerId = apb.CustomerID  AND fr.OrderSourceSKUID=apb.OrderSourceSKUID  AND fr.rank = 1 --LEFT JOIN dbo.RB_Amazon_Modify_Listing(NOLOCK) AS aml ON a.CustomerID = aml.CustomerId AND aml.OrderSourceId = a.OrderSourceID --AND a.SellerSKU = aml.OrderSourceSku WHERE a.CustomerID=1  --AND b.SellerSKU='1240CW9592W2' GROUP BY   b.SKU,     b.发货月份,     b.SellerSKU,     b.ASINorItemID ,   p.ProductNameCN,   ep.一级类目,  ep.二级类目,  ep.三级类目,     os.OrderSourceName,  apb.OrderSourceID,     b.UserName ,  b.部门,     b.DepartmentName ,  a.销售额,     b.总收入,     ISNULL(b.总利润,0) - ISNULL(c.累计广告费,0),     b.退款金额,     b.销售数量,  b.总订单数量,  b.退款数量,  B.退款订单数量,     b.促销折扣,     b.交易佣金,     b.FBA操作费,     b.采购成本,     b.本地仓运费,     b.海外仓派送运费,     b.头程运费,  pb.BrandName,  apb.OrderSourceSKUID,  CASE apb.IsFBA WHEN 0 THEN '否'     WHEN 1 THEN '是'     ELSE '' END ,     apb.OrderSourceSkuOrderTime ,  apb.AsinOrderTime ,  apb.PublishTime ,  case     when apb.OnShelfMode = 1 then '一键上架'     when apb.OnShelfMode = 2 then '草稿上架'     when apb.OnShelfMode = 3 then '表格上架'     when apb.OnShelfMode = 4 then '关联导入'     when apb.OnShelfMode = 5 then '批量跟卖'     when apb.OnShelfMode = 6 then '凤凰重刊'     when apb.OnShelfMode = 7 then '复制上架'     when apb.OnShelfMode = 8 then '智能刊登'  WHEN apb.OnShelfMode = 9 THEN '自动刊登'     else ''   end ,   CASE     apb.IsOffShelf     WHEN 0 THEN '在线'     WHEN 1 THEN '下架'     WHEN 2 THEN '售完'     WHEN 3 THEN '草稿'     WHEN 4 THEN '刊登中'     WHEN 5 THEN '刊登失败'   END ,   apb.ListingPrice,   apb.OrderSourceCountry ,   apb.AddAdminName ,   apbl.OrderSourceSkuFirstTime,   apbl.AsinFirstTime,  pa.OnlineTime,  pa.CheckTime,  CASE   WHEN apb.ProductProperty = 0 THEN '未选择'   WHEN apb.ProductProperty = 1 THEN '非仿牌'   WHEN apb.ProductProperty = 2 THEN '仿牌'   WHEN apb.ProductProperty = 3 THEN '灰色产品'   ELSE '未知(' + CAST(apb.ProductProperty AS VARCHAR(10)) + ')'  END,  CASE p.DevelopType   WHEN 1 THEN '自主开发'   WHEN 2 THEN '供应商后台'   WHEN 3 THEN '指定开发'   WHEN 4 THEN '智能选品'   WHEN 5 THEN '销售提报_FBA新品'   ELSE ''  END,  dc.name,  p.IsGroup,  CASE WHEN ISNULL(p.Pack_Length,0) > 0 THEN p.Pack_Length ELSE p.Length END,  CASE WHEN ISNULL(p.Pack_Width,0) > 0  THEN p.Pack_Width ELSE  p.Width END,  CASE WHEN ISNULL(p.Pack_Height,0) > 0 THEN p.Pack_Height ELSE p.Height END ,  CASE WHEN ISNULL(p.PackWeight,0) > 0  THEN p.PackWeight ELSE  p.GrossWeight END  ,  fr.长,     fr.宽,     fr.高,     fr.长度单位,     fr.重量,     fr.重量单位,  CASE WHEN apb.AvgDailySales > 0 THEN apb.KykcNum*1.0/apb.AvgDailySales ELSE 0 END ,  apb.KykcNum,  apb.WeekSaleNum,  apb.msaleN

[结果]

[期望]