1、修改View_Amazon_Product_Base_Merge 视图：
SELECT a.ID, a.OrderSourceSKUID, a.AUID, a.ImageUrl, a.ClientSKU, a.ProductNameCN, a.PID, a.SalePrice, a.LastBuyPrice,
a.LastSupplierPrice, a.GrossWeight, a.PackWeight, a.IsGroup, a.ProductProperty, a.OrderSourceCountry,
a.OrderSourceName, a.cgzNum, a.ystzNum, a.ProductNum, a.ReadyLibraryNum, a.todaysaleNum, a.zsaleNum,
a.qsaleNum, a.sqsaleNum, a.WeekSaleNum, a.TwoWeekSaleNum, a.APIID, a.DevIDSellerId, a.Cycle, a.SafetyDays,
a.WPID, a.LastUPdateTime, a.AddCycle, a.HaulageTime, a.BuyTime, a.IsBuyBox, a.RobBuyBox, a.Kl, a.BuyBoxNum1,
a.BuyBoxNum2, a.AllBuyBoxNum1, a.BuyBoxNum3, a.AllBuyBoxNum2, a.AllBuyBoxNum3, a.AvgDailySales,
a.ToBuyBoxProduct, a.IsTiming, a.WID, a.CustomerID, a.OrderSourceID, a.UpdateTime, a.IsFBA, a.OrderSourceSKU,
a.WareHouseName, a.ASINorItemID, a.SellerType, a.SKU, a.KykcNum, a.CnKyNum, a.CnWPID, a.WareHouseType,
a.msaleNum, a.lastmsaleNum, a.zhanyong, a.IsActive, a.AddTime, a.daysNum, a.BuyBoxUpdateTime,
a.SyncLastUpdateTime, a.isBeiKu, a.LastUpTiming, a.LastDownTiming, a.rankNum, a.rankZTNum, a.rankQTNum,
a.rankSQNum, a.rankClassName, a.bhnum, a.IsOffShelf, a.ListingPrice, a.ListingSoldNum, a.StopProduct,
a.StopAndNullStockProduct, a.BusinessAdminID, a.BusinessUserName, a.Currency, a.ExchangeRMB, a.FBASeller_Num,
a.ThreeMonthSaleNum, a.OrdinaryBuyBoxNum1, a.OrdinaryAllBuyBoxNum1, a.OrdinaryBuyBoxNum2,
a.OrdinaryAllBuyBoxNum2, a.OrdinaryBuyBoxNum3, a.OrdinaryAllBuyBoxNum3, a.RobBuyBoxType, a.Attention,
a.LowestPriceBuyBoxNum1, a.LowestPriceAllBuyBoxNum1, a.LowestPriceBuyBoxNum2,
a.LowestPriceAllBuyBoxNum2, a.LowestPriceBuyBoxNum3, a.LowestPriceAllBuyBoxNum3, a.ProductName,
a.ProductVitalityType, a.UnsalableDayNum, a.AmazonShelvesNum, a.EbayShelvesNum, a.SMTShelvesNum,
a.WishShelvesNum, a.OtherShelvesNum, a.TotalShelvesNum, a.ProductNewType, a.FirstLegShippingType,
a.BasePrice, a.IsRemind, a.IsAmazonListingReview, a.ReviewNum, a.ReviewUnReadNum, a.ReviewStar,
a.LastSynReviewTime, a.FNSKU, a.LastReviewCollectionTime, a.ThreeDayReviewNum, a.SevenDayDayReviewNum,
a.BadReviewNum, a.ReviewOneStar, a.ReviewTwoStar, a.ReviewThreeStar, a.ReviewFourStar, a.ReviewFiveStar,
a.IsAmazonKeywordRank, a.LockNum, a.FBA_Reserved_CustomerOrders, a.FBA_Reserved_Transfers,
a.FBA_Reserved_Processing, a.YesterdaySessions, a.BeforeYesterdaySessions, a.HeretoforeSessions,
a.YesterdayUnitSessionPercentage, a.BeforeYesterdayUnitSessionPercentage, a.HeretoforeUnitSessionPercentage,
a.TaxPoint, a.TaxRate, a.IsFBABarCode, a.isEmergencyStock, a.ExpectedArrivalDays, a.DeliveryDay,
a.DefaultWarehouseID, a.IsRecommendOcean, a.YesterdaySpend, a.TotalSpend, a.YesterdayAvgCPC, a.TotalAvgCPC,
a.YesterdayClicks, a.TotalClicks, a.YesterdayImpressions, a.TotalImpressions, a.BusinessTeam,
a.BusinessTeamName, a.BrandType, a.IsEFN, a.EFNCountry, a.IsCheckDeclarationCode, a.IsCheckTransport,
a.IsSalesRank, a.HolidaysID, a.EstimatedSaleNum, a.FbaOrderSourceSKU, a.IsVariation, a.ParentASIN, a.ParentID,
a.IsSaleProduct, a.IsFirstLevelProduct, a.AddAdminID, a.AddAdminName, a.SynTime, a.TheWareHouseId,
a.WareHouseId, a.IsSetNoSupplyReason, a.IsEmergencyStockReminder, a.TranslateStatus, a.ProductUpdateTime,
a.WareHouseProductUpdateTime, a.IsAdvertising, a.VariantGroup, a.RecommendedBrowseNodeName, a.TemplateID,
a.LableColor, a.LableName, a.BrowsePathByID, a.DismountedTime, a.ProfitMargin, a.PublishTime, a.PreDiscountPrice,
a.DiscountSalesPrice, a.DiscountStartTime, a.MonthAvgProfits, a.DiscountEndTime, a.LocalStockNum,
a.ProductCheckTime, a.IsAmazonSale, a.TranslateGuid, a.PlanId, a.BrandAddTitle, a.PlanDetailId, a.PlanName,
a.OnShelfMode, b.ProductGroupSKU AS ProductSku, b.ClassID1 AS ClassId, c.ClassName, b.BrandID,
a.OrderSourceSkuOrderTime, a.AsinOrderTime, d.BrandName, b.ClassID2, b.ClassID AS ClassID3, b.ClassPath,
b.WithBattery, b.PlugRelateType,b.DevelopType
FROM dbo.RB_Amazon_Product_Base AS a WITH (NOLOCK) LEFT OUTER JOIN
dbo.RB_Product AS b WITH (NOLOCK) ON a.CustomerID = b.CustomerID AND a.SKU = b.SKU LEFT OUTER JOIN
dbo.RB_Product_Class AS c WITH (NOLOCK) ON c.CustomerID = b.CustomerID AND c.ID = b.ClassID1 LEFT OUTER JOIN
dbo.RB_Product_Brand AS d WITH (NOLOCK) ON d.CustomerID = b.CustomerID AND d.ID = b.BrandID
2、对接 接口：http://showdoc.zhcxkj.com/web/#/18/1890 新增筛选条件：开发类型
3、修改策略 试运行
4、修改JOB服务
页面现在能够进行增删改查，服务也写好了，但是得到正式环境跑服务策略