2025/6/25 9:30:45 请求体：[{"SPUId":578754326798405,"BaseInfo":{"Category1":40,"Category2":4004,"Category3":400402,"Category4":40040204,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"8BitDo RetroR8 鼠标N版","ProductShortName":"","ProductEName":"8BitDo Retro R8 Mouse-N","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

2.4G 无线连接 蓝牙连接（低功耗蓝牙） USB 有线连接  

","EHighlights":"

2.4G wireless connection Bluetooth connection (low-power Bluetooth) USB wired connection

","Specification":"

85CB02

","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳","LimitPriceType":2,"LimitPrice":49.9900,"LimitPriceCurrency":"0002","PurchasePrice":205.0,"PurchasePriceCurrency":"0001","MinOrder":5,"DeliveryTime":2,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2054","Supplier":"V5421","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":404,"Weight":537.0000,"GrossWeight":537.0000,"BoxWeight":11.5000,"BoxQuantity":20,"ProductL":17.8,"ProductW":13.7,"ProductH":7.5,"PackgeL":17.8,"PackgeW":13.7,"PackgeH":7.5,"BoxL":395.0,"BoxW":375.0,"BoxH":300.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578758147153989,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"8BitDo RetroR8 鼠标N版","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":49.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":205,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":5,\"DeliveryTime\":2,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5421\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":537.0000,\"GrossWeight\":537.0000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":17.8,\"ProductW\":13.7,\"ProductH\":7.5,\"PackgeL\":17.8,\"PackgeW\":13.7,\"PackgeH\":7.5,\"BoxL\":395,\"BoxW\":375,\"BoxH\":300,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"85CB02\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01Ywb9Op28czMiGdYDg_!!2292347954-0-cib_99999999999_578759285309509.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01ubSu2C28czMiA0iPd_!!2292347954-0-cib_99999999999_578759904641093.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01nHTrUQ28czMhhSu8D_!!2292347954-0-cib(1)_99999999999_578760176275525.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01jrLfGW28czMbaAueb_!!2292347954-0-cib(1)_99999999999_578760353452101.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01ubSu2C28czMiA0iPd_!!2292347954-0-cib(1)_99999999999_578767556513861.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01jrLfGW28czMbaAueb_!!2292347954-0-cib(1)(1)_99999999999_578767858479173.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578758147153989,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01Ywb9Op28czMiGdYDg_!!2292347954-0-cib_99999999999_578759285309509.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01ubSu2C28czMiA0iPd_!!2292347954-0-cib_99999999999_578759904641093.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01nHTrUQ28czMhhSu8D_!!2292347954-0-cib(1)_99999999999_578760176275525.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01jrLfGW28czMbaAueb_!!2292347954-0-cib(1)_99999999999_578760353452101.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01ubSu2C28czMiA0iPd_!!2292347954-0-cib(1)_99999999999_578767556513861.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/O1CN01jrLfGW28czMbaAueb_!!2292347954-0-cib(1)(1)_99999999999_578767858479173.jpg","ImgSort":1}]}]},"UserId":"2054"}] 2025/6/25 9:30:45 GetSPUId方法内部，CategoryCode：40，sql： 2025/6/25 9:30:45 GetSPUId获取到结果：SPUId:N002506,CategoryCode:40,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql: declare @CategoryShortCode varchar(5), @Max varchar(6), @NewMax varchar(6) select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%' select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6) select (@CategoryShortCode + @NewMax) SPUId 2025/6/25 9:30:47 响应体：{"Status":200,"Result":",8BitDo RetroR8 鼠标N版操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578754326798405,"ErpSPU":"N002506","SKURelations":[{"SrmSKU":"578758147153989","ErpSKU":"1293355"}],"Msg":null}],"FailSPUSKUResponse":[]} 2025/6/25 9:34:36 请求体：[{"SPUId":578769414664261,"BaseInfo":{"Category1":10,"Category2":1005,"Category3":100504,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"8BitDo 猎户座X-Pro三模游戏手柄","ProductShortName":"","ProductEName":"8BitDo Ultimate 3-mode Controller for Xbox + Game Pass Code ","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

2.4G 无线连接 Windows
2.4G 无线连接 PC 时支持扳机振动

","EHighlights":"

2.4G Wireless Connection to Windows
2.4G wireless connection to the PC supports trigger vibration

","Specification":"

81HB03D

","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳","LimitPriceType":2,"LimitPrice":69.9900,"LimitPriceCurrency":"0002","PurchasePrice":255.0,"PurchasePriceCurrency":"0001","MinOrder":2,"DeliveryTime":2,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2054","Supplier":"V5421","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":404,"Weight":716.0000,"GrossWeight":716.0000,"BoxWeight":15.2000,"BoxQuantity":20,"ProductL":16.5,"ProductW":16.0,"ProductH":8.2,"PackgeL":16.5,"PackgeW":16.0,"PackgeH":8.2,"BoxL":425.0,"BoxW":345.0,"BoxH":345.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578770221740101,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"8BitDo 猎户座X-Pro三模游戏手柄(Xbox-绿透) 81HB03D","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":69.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":255,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":2,\"DeliveryTime\":2,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5421\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":716.0000,\"GrossWeight\":716.0000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":16.5,\"ProductW\":16,\"ProductH\":8.2,\"PackgeL\":16.5,\"PackgeW\":16,\"PackgeH\":8.2,\"BoxL\":425,\"BoxW\":345,\"BoxH\":345,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"81HB03D\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%99%bd%e5%ba%95_99999999999_578774464843845.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250624183732_99999999999_578774497513541.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578770221740101,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%99%bd%e5%ba%95_99999999999_578774464843845.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250624183732_99999999999_578774497513541.jpg","ImgSort":0}]}]},"UserId":"2054"}] 2025/6/25 9:34:36 GetSPUId方法内部，CategoryCode：10，sql： 2025/6/25 9:34:36 GetSPUId获取到结果：SPUId:E002323,CategoryCode:10,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql: declare @CategoryShortCode varchar(5), @Max varchar(6), @NewMax varchar(6) select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%' select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6) select (@CategoryShortCode + @NewMax) SPUId 2025/6/25 9:34:39 响应体：{"Status":200,"Result":",8BitDo 猎户座X-Pro三模游戏手柄操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578769414664261,"ErpSPU":"E002323","SKURelations":[{"SrmSKU":"578770221740101","ErpSKU":"1293356"}],"Msg":null}],"FailSPUSKUResponse":[]}