2025/4/30 11:38:58 请求体:[{"SPUId":558918980436037,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":29,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"TWO TREES TS1 Mini 3W激光雕刻机小型树叶刻字机全自动打标机","ProductShortName":"","ProductEName":"Twotrees TS1 Mini Laser Engraver Machine 3W DIY Laser Engraver Machine Paper Leather Wooden Engraving Tools Painted Dog Tag","EAN":null,"BrandEName":"TWO TREES","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.aliexpress.com/item/3256808491923572.html?spm=a2g0o.productlist.main.3.2f4c65oE65oEub&algo_pvid=0ba1e69b-385b-4178-95c0-f3c2ea0bad9c&algo_exp_id=0ba1e69b-385b-4178-95c0-f3c2ea0bad9c-2&pdp_ext_f=%7B%22order%22%3A%22-1%22%2C%22eval%22%3A%221%22%7D&pdp_npi=4%40dis%21USD%21184.29%21129.00%21%21%21184.29%21129.00%21%40213fa24617459138309704602e1c29%2112000046205769087%21sea%21US%212778379770%21ABX&curPageLogUid=tOoPSySxwXEo&utparam-url=scene%3Asearch%7Cquery_from%3A","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
无
","EHighlights":"Name: TS1mini laser engraving machine
\nMain body material: injection molding + aluminum
\nProduct size: 157X157x167mm
\nSupported engraving area: 80X80mm (the machine cavity can support objects 0-30mm high)
\nLaser power: 3W
\nCompatible materials: plywood/density board/solid wood board/paper/painted metal/kraft paper/leather/plastic/bamboo
\nPackaging size: 203x210x196mm
\nPower supply: 12V/2A
\nWorking power consumption of the whole machine: 17.5W
\nEngraving accuracy 0.1mm
\nMaximum engraving speed: 3000mm/min
\nMaximum acceleration: 320mm/min
\nSupported systems: Windows/IOS
\nSoftware languages: Chinese/English/Spanish/German/French/Russian/Italian/Japanese/Korean
\nCompatible software: Lightburn/laserGRBL/MKSLaser (mobile APP)
","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\tGeneral \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tBrand: \nType: \nModel: \nColor: \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tSpecification \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tWeight & Size \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct Weight: \nPackage Weight: \nProduct Size(L x W x H): \nPackage Size(L x W x H): \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPackage Contents \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\t1 x \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[{"Code":1380,"CName":"激光雕刻机类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Desktop Laser Engravers","ValueCode":4633,"Color":null},{"Code":0,"EName":"","CName":"Portable Laser Engravers","ValueCode":4634,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"美国,欧洲","LimitPriceType":2,"LimitPrice":241.0800,"LimitPriceCurrency":"0002","PurchasePrice":590.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2405","PStocker":"2054","Supplier":"V4406","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":302,"Weight":1.4000,"GrossWeight":1.4000,"BoxWeight":1.4000,"BoxQuantity":1,"ProductL":21.0,"ProductW":20.3,"ProductH":19.6,"PackgeL":21.0,"PackgeW":20.3,"PackgeH":19.6,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":559192713744453,"Color":"规格","ColorCode":"1381","ColorValueCode":"4635","CName":"TWO TREES TS1 Mini 3W激光雕刻机小型树叶刻字机全自动打标机 欧规","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":241.0800,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":550,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V4406\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":302,\"Weight\":1.4000,\"GrossWeight\":1.4000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":21,\"ProductW\":20.3,\"ProductH\":19.6,\"PackgeL\":21,\"PackgeW\":20.3,\"PackgeH\":19.6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Twotrees mini雕刻机 TS1 欧标\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":559192713789509,"Color":"规格","ColorCode":"1381","ColorValueCode":"4636","CName":"TWO TREES TS1 Mini 3W激光雕刻机小型树叶刻字机全自动打标机 美规","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":241.0800,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":590,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V4406\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":302,\"Weight\":1.4000,\"GrossWeight\":1.4000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":21,\"ProductW\":20.3,\"ProductH\":19.6,\"PackgeL\":21,\"PackgeW\":20.3,\"PackgeH\":19.6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Twotrees mini雕刻机 TS1 美标\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":12}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1_99999999999_558924242894917.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924257181765.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+2_99999999999_558924272050245.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+1_99999999999_558924289814597.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+3_99999999999_558924302147653.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+4_99999999999_558924327714885.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+5_99999999999_558924347875397.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+6_99999999999_558924363386949.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+7_99999999999_558924379934789.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924478353477.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/3_99999999999_558924490817605.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/5_99999999999_558924504387653.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/6_99999999999_558924525604933.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/8_99999999999_558924541001797.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/9_99999999999_558924554424389.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/11_99999999999_558924569067589.jpg"}]},"SKUPictureInfos":[{"SrmSKU":559192713744453,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1_99999999999_558924242894917.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924257181765.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+2_99999999999_558924272050245.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+1_99999999999_558924289814597.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+3_99999999999_558924302147653.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+4_99999999999_558924327714885.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+5_99999999999_558924347875397.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+6_99999999999_558924363386949.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+7_99999999999_558924379934789.jpg","ImgSort":8}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924478353477.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/3_99999999999_558924490817605.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/5_99999999999_558924504387653.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/6_99999999999_558924525604933.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/8_99999999999_558924541001797.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/9_99999999999_558924554424389.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/11_99999999999_558924569067589.jpg","ImgSort":6}]},{"SrmSKU":559192713789509,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1_99999999999_558924242894917.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924257181765.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+2_99999999999_558924272050245.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+1_99999999999_558924289814597.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+3_99999999999_558924302147653.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+4_99999999999_558924327714885.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+5_99999999999_558924347875397.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+6_99999999999_558924363386949.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e7%94%bb%e6%9d%bf+7_99999999999_558924379934789.jpg","ImgSort":8}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/2_99999999999_558924478353477.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/3_99999999999_558924490817605.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/5_99999999999_558924504387653.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/6_99999999999_558924525604933.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/8_99999999999_558924541001797.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/9_99999999999_558924554424389.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/11_99999999999_558924569067589.jpg","ImgSort":6}]}]},"UserId":"2054"}]
2025/4/30 11:38:58 GetSPUId方法内部,CategoryCode:60,sql:
2025/4/30 11:38:58 GetSPUId获取到结果:SPUId:I002824,CategoryCode:60,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/4/30 11:39:08 响应体:{"Status":200,"Result":",TWO TREES TS1 Mini 3W激光雕刻机小型树叶刻字机全自动打标机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":558918980436037,"ErpSPU":"I002824","SKURelations":[{"SrmSKU":"559192713744453","ErpSKU":"1291408"},{"SrmSKU":"559192713789509","ErpSKU":"1291409"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/4/30 17:53:15 请求体:[{"SPUId":559290509156421,"BaseInfo":{"Category1":10,"Category2":1003,"Category3":100301,"Category4":null,"TemplateId":6,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"欧规 ULTIMEA Nova S90 7.1.4声霸 + 环绕箱支架","ProductShortName":"","ProductEName":"ULTIMEA Nova S90 7.1.4 Soundbar + Surround Stands","EAN":null,"BrandEName":"Ultimea","VideoLink":"https://www.youtube.com/watch?v=ZHPrsnp3BxE","IsPackage":true,"OtherPlatformLink":"https://www.ultimea.com/products/nova-s90-7-1-4-soundbar","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"真正的高端无线 7.1.4 环绕声系统: Nova S90 soundbar 配备了 12 个先进的驱动器,包括 5 个全频单元、2 个侧发声扬声器、1 个专用 8 英寸低音炮和 4 个上发声驱动器,可提供高达 740W 的峰值功率。它专为营造杜比全景声(Dolby Atmos)影院体验而设计,以令人惊叹的沉浸式空间音频效果改变您的客厅。(注:Nova S90 不支持 DTS 解码。)
360° ASL-听觉空间定位技术: 体验各个方向(包括头顶)的精确音频。ULTIMEA 的球形声场原理与 DSP 驱动的实时分析相结合,可重建三维音频。这项创新技术可让您从任何角度感知音源,获得无与伦比的身临其境的听觉体验。
4 个上射式驱动器,让您身临其境: Nova S90 的 4 个上射式驱动器可均匀地反射和传播声音,创造精确的空间定位和渲染效果。升级后的无线后置环绕扬声器可灵活摆放,提供多层次、多方位的音效,让您沉浸在丰富、身临其境的音效中。
\n8 英寸无线巨型低音炮:先进的低音炮采用尖端的磁路系统和 25L 音箱,振膜振幅达 18 毫米,低音深沉有力。该低音炮采用 ULTIMEA 的 BassMX 技术,可确保低频声音产生有冲击力的共振,提供雷鸣般的动态低音性能。
面向未来的连接和标准: Nova S90 配备 2 个 HDMI 输入和 1 个 HDMI eARC 输出,可确保无缝音频和视频传输,带来卓越品质。支持 4K HDR 和杜比全景声(Dolby Atmos),打造黄金标准的影院体验,使用随附的第二代多功能遥控器即可轻松激活,即时享受家庭影院的乐趣。
","EHighlights":"\n- True High-End Wireless 7.1.4 Surround Sound System: The Nova S90 soundbar is equipped with 12 advanced drivers, including 5 full-range units, 2 side-firing speakers, a dedicated 8-inch subwoofer, and 4 up-firing drivers, delivering up to 740W peak power. Designed to create a Dolby Atmos cinematic experience, it transforms your living room with stunning spatial audio immersion. (Note: Nova S90 does not support DTS decoding.)
\n- 360° ASL-Aural Spatial Localization Technology: Experience pinpoint audio precision in every direction, including overhead. ULTIMEA's spherical sound field principles, combined with real-time DSP-driven analysis, reconstruct audio in three dimensions. This innovative technology lets you perceive sound sources from any angle for an unparalleled immersive listening experience.
\n- 4 Up-firing Drivers for Overhead Immersion: Nova S90's 4 up-firing drivers are engineered to reflect and distribute sound evenly, creating accurate spatial positioning and rendering. With upgraded wireless rear surround speakers that can be placed flexibly, the soundbar delivers layered and multidirectional audio, enveloping you in a rich, immersive soundscape.
\n- 8\" Wireless Jumbo Subwoofer: Featuring a cutting-edge magnetic circuit system and a 25L cabinet, the advanced subwoofer achieves a diaphragm amplitude of 18mm for deep, powerful bass. Enhanced by ULTIMEA's BassMX technology, the subwoofer ensures low-frequency sounds resonate with impact, delivering thunderous and dynamic bass performance.
\n- Future-proof Connectivity and Standards: Equipped with 2 HDMI inputs and an HDMI eARC output, the Nova S90 ensures seamless audio and video transfer for superior quality. Support for 4K HDR and Dolby Atmos creates a gold-standard cinematic experience, easily activated with the included 2nd Gen multifunctional remote for instant home theater enjoyment.
\n
","Specification":"\n\n\nGeneral | \n\n Brand: ULTIMEA Type: 7.1.4 Soundbar Model: U4420+UBCA2 Color: Black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 12 KG Package Weight: 14.6 KG Product Size(L x W x H): 50 x 7.6 x 3.8 cm Package Size(L x W x H): 56.8 x 45 x 33 cm | \n
\n\nPackage Contents | \n\n \n1 x Soundbar \n1 x Wireless Subwoofer \n2 x Surround Speakers \n1 x Soundbar Adapter \n2 x Surround Speaker Adapters \n1 x 59in(1.5m) Optical Cable \n1 x 59in(1.5m) 3.5mm-RCA Cable \n1 x 59in(1.5m) HDMI Cable \n1 x Remote Control (Battery not included) \n1 x User Manual \n6 x Wall Brackets \n12 x Screws \n12 x Nuts \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Buchenring 57, Hamburg,DE,22359","LimitPriceType":1,"LimitPrice":499.0000,"LimitPriceCurrency":"0002","PurchasePrice":377.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":1,"AfterSaleMethodNote":null,"CertificateIds":"CE","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2406","PStocker":"2364","Supplier":"V6088","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1 x Soundbar\n1 x Wireless Subwoofer\n2 x Surround Speakers\n1 x Soundbar Adapter\n2 x Surround Speaker Adapters\n1 x 59in(1.5m) Optical Cable\n1 x 59in(1.5m) 3.5mm-RCA Cable \n1 x 59in(1.5m) HDMI Cable\n1 x Remote Control (Battery not included) \n1 x User Manual\n6 x Wall Brackets \n12 x Screws\n12 x Nuts","WLEmbargoType":100,"Weight":10.0000,"GrossWeight":14.6000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":50.0,"ProductW":7.6,"ProductH":3.8,"PackgeL":56.8,"PackgeW":45.0,"PackgeH":33.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":559291326890053,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"ULTIMEA Nova S90 7.1.4声霸 + 环绕箱支架 黑","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":499.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":377,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":1,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2406\",\"PStocker\":\"2364\",\"Supplier\":\"V6088\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1 x Soundbar\\n1 x Wireless Subwoofer\\n2 x Surround Speakers\\n1 x Soundbar Adapter\\n2 x Surround Speaker Adapters\\n1 x 59in(1.5m) Optical Cable\\n1 x 59in(1.5m) 3.5mm-RCA Cable\\u00A0\\n1 x 59in(1.5m) HDMI Cable\\n1 x Remote Control (Battery not included)\\u00A0\\n1 x User Manual\\n6 x Wall Brackets\\u00A0\\n12 x Screws\\n12 x Nuts\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":10.0000,\"GrossWeight\":14.6000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":50,\"ProductW\":7.6,\"ProductH\":3.8,\"PackgeL\":56.8,\"PackgeW\":45,\"PackgeH\":33,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"U4420+UBCA2\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/20250430-170847_99999999999_559291761614917.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e4%b8%bb%e5%9b%be07_99999999999_559291823763525.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e4%b8%bb%e5%9b%be04_99999999999_559291843113029.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559291926708293.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559291943096389.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1200_1500-2_99999999999_559297337552965.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1200_1500-1_99999999999_559297337540677.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1200_1500_99999999999_559297337573445.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1200_1500-3_99999999999_559297338331205.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/1200_1500-4_99999999999_559297337557061.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_25_%e5%a5%97%e5%9b%be1200_EN_99999999999_559296072175685.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_36_%e5%a5%97%e5%9b%be1200_EN_99999999999_559296088367173.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_42_%e5%a5%97%e5%9b%be1200_EN_99999999999_559296102674501.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_51_%e5%a5%97%e5%9b%be1200_EN_99999999999_559296115707973.jpg"}]},"SKUPictureInfos":[{"SrmSKU":559291326890053,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/20250430-170847_99999999999_559291761614917.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e4%b8%bb%e5%9b%be07_99999999999_559291823763525.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e4%b8%bb%e5%9b%be04_99999999999_559291843113029.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559291926708293.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559291943096389.jpg","ImgSort":4}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN-%e5%a5%97%e5%9b%be1500_1500-58_99999999999_559293322915909.jpg","ImgSort":0}]}]},"UserId":"2364"}]
2025/4/30 17:53:15 GetSPUId方法内部,CategoryCode:10,sql:
2025/4/30 17:53:15 GetSPUId获取到结果:SPUId:E002268,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/4/30 17:53:18 响应体:{"Status":200,"Result":",欧规 ULTIMEA Nova S90 7.1.4声霸 + 环绕箱支架操作成功","SuccessSPUSKUResponse":[{"SrmSPU":559290509156421,"ErpSPU":"E002268","SKURelations":[{"SrmSKU":"559291326890053","ErpSKU":"1291426"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/4/30 17:56:22 请求体:[{"SPUId":559294633451589,"BaseInfo":{"Category1":10,"Category2":1003,"Category3":100301,"Category4":null,"TemplateId":6,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"ULTIMEA Steady S90 环绕箱支架","ProductShortName":"","ProductEName":"ULTIMEA Steady S90 Surround Stands","EAN":null,"BrandEName":"Ultimea","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.ultimea.com/products/steady-s90-surround-speaker-stands-for-nova-s90","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"完美兼容性: 专为 Ultimea Nova S90 打造,确保完美贴合。将扬声器调整到理想的耳朵高度,可获得更清晰、更身临其境的环绕音效。它能优化您的家庭影院设置,为您带来更好的视听体验。
高度可调,音质卓越: 轻松调节高度(24.4 英寸至 36.6 英寸),获得最佳音效。只需旋转旋钮,即可将 Ultimea Nova S90 环绕声扬声器置于与耳朵水平的位置,提供更丰富、更清晰、更身临其境的环绕声,带来非凡的听觉体验。
易于存放: 扬声器支架采用可折叠三脚架底座,具有稳定性和耐用性,可确保扬声器得到稳固的支撑。不使用时,支架可轻松折叠起来,以便紧凑存放,帮您节省宝贵的空间。
快速简便的组装: 不需要复杂的工具,只需按照简单的指南进行操作,就能立即组装好支架。除了详细的使用手册外,还有简单易懂的视频教程指导您完成每一个步骤,让组装几乎不费吹灰之力。
整洁的线缆管理: 为了安全和美观,请将扬声器支架靠近沙发或墙壁放置,避免走道。使用附带的尼龙搭扣带整齐地固定线缆,减少杂乱并提高安全性,同时将儿童或宠物绊倒的风险降至最低。
","EHighlights":"\n- Perfect Compatibility: Crafted for the Ultimea Nova S90, it guarantees a flawless fit. Adjusting your speaker to the ideal ear level unlocks clearer and more immersive surround sound. It optimizes your home theater setup, transforming your entire audio-visual experience for the better.
\n- Adjustable height for Superior Sound: Easily adjust the height (24.4\" to 36.6\") for optimal sound. Simply twist the knob to position your Ultimea Nova S90 surround speakers at ear level, delivering richer, clearer, and more immersive surround sound for an exceptional listening experience.
\n- Easy Storage: The speaker stand features a foldable tripod base that offers stability and durability, ensuring your speakers are securely supported. When not in use, the stand folds up easily for compact storage, helping you save valuable space.
\n- Quick and Easy Assembly: No complicated tools are required—just follow the simple guide, and you’ll have your stand ready in no time. In addition to the detailed manual, easy-to-follow video tutorials are available to walk you through every step, making assembly virtually effortless.
\n- Neat Cable Management: For safety and aesthetic appeal, place the speaker stand near a sofa or wall, avoiding walkways. Use the included Velcro straps to neatly secure the cables, reducing clutter and enhancing safety, while minimizing the risk of tripping for children or pets.
\n
","Specification":"\n\n\nGeneral | \n\n Brand: ULTIMEA Type: Surround Stands Model: UBCA2 Color: Black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 0.65 KG Package Weight: 1.48 KG Product Size(L x W x H): 43.7 x 4.3 x 4.3cm Package Size(L x W x H): 43.5 x 33.6 x 6.7 cm | \n
\n\nPackage Contents | \n\n 2 x Height-adjustable Tripod Speaker Stand \n2 x Horizontal Adjustment Component \n2 x KM5 × 13mm Screw \n1 x Simple Screwdriver \n10 x Velcro Strap \n1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Buchenring 57, Hamburg,DE,22359","LimitPriceType":1,"LimitPrice":45.0000,"LimitPriceCurrency":"0002","PurchasePrice":37.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":1,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2406","PStocker":"2364","Supplier":"V6088","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"2 x Height-adjustable Tripod Speaker Stand \n2 x Horizontal Adjustment Component\n2 x KM5 × 13mm Screw\n1 x Simple Screwdriver\n10 x Velcro Strap\n1 x User Manual","WLEmbargoType":100,"Weight":0.6500,"GrossWeight":1.4800,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":43.7,"ProductW":4.3,"ProductH":4.3,"PackgeL":43.5,"PackgeW":33.6,"PackgeH":6.7,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":559295274369093,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"ULTIMEA Steady S90 环绕箱支架 黑","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":45.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":37,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":1,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2406\",\"PStocker\":\"2364\",\"Supplier\":\"V6088\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"2 x Height-adjustable Tripod Speaker Stand\\u00A0\\n2 x Horizontal Adjustment Component\\n2 x KM5 × 13mm Screw\\n1 x Simple Screwdriver\\n10 x Velcro Strap\\n1 x User Manual\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.6500,\"GrossWeight\":1.4800,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":43.7,\"ProductW\":4.3,\"ProductH\":4.3,\"PackgeL\":43.5,\"PackgeW\":33.6,\"PackgeH\":6.7,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"UBCA2\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+14_99999999999_559295378673734.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559295391846469.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+14_99999999999_559295405346885.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_9_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495708741.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_25_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495761989.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_21_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495704645.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_36_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495983173.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_26_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495929925.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_42_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295496024133.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_48_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295496679493.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_51_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295497232453.jpg"}]},"SKUPictureInfos":[{"SrmSKU":559295274369093,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+14_99999999999_559295378673734.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+13_99999999999_559295391846469.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/Frame+14_99999999999_559295405346885.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_9_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495708741.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_25_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495761989.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_21_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495704645.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_36_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495983173.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_26_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295495929925.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_42_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295496024133.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_48_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295496679493.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/EN_51_%e5%a5%97%e5%9b%be1200_EN_99999999999_559295497232453.jpg","ImgSort":7}]}]},"UserId":"2364"}]
2025/4/30 17:56:22 GetSPUId方法内部,CategoryCode:10,sql:
2025/4/30 17:56:22 GetSPUId获取到结果:SPUId:E002269,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/4/30 17:56:26 响应体:{"Status":200,"Result":",ULTIMEA Steady S90 环绕箱支架操作成功","SuccessSPUSKUResponse":[{"SrmSPU":559294633451589,"ErpSPU":"E002269","SKURelations":[{"SrmSKU":"559295274369093","ErpSKU":"1291427"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/4/30 19:22:56 请求体:[{"SPUId":559269019639877,"BaseInfo":{"Category1":11,"Category2":1101,"Category3":110107,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"JIMMY H10 Pro 前风道组件","ProductShortName":"","ProductEName":"JIMMY H10 Pro air path inlet","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"H10 Pro前风道组件
","EHighlights":"H10 Pro air path inlet
","Specification":"\n\n\nGeneral H10 Pro air path inlet | \n\n Brand: Type: Model: Color: \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: Package Weight: Product Size(L x W x H): Package Size(L x W x H): | \n
\n\nPackage Contents | \n\n 1 x 1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"苏州","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":3.6,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"0638","PStocker":"0211","Supplier":"V4051","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.0080,"GrossWeight":0.0085,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":5.0,"ProductW":5.5,"ProductH":0.1,"PackgeL":6.0,"PackgeW":6.5,"PackgeH":0.1,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":559270265180229,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"B0XF1400001R JIMMY H10 Pro 前风道组件","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0.0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":3.6,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"0638\",\"PStocker\":\"0211\",\"Supplier\":\"V4051\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0080,\"GrossWeight\":0.0085,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":5,\"ProductW\":5.5,\"ProductH\":0.1,\"PackgeL\":6,\"PackgeW\":6.5,\"PackgeH\":0.1,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"H10 pro\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/B0XF1400001R_99999999999_559270347657285.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20220429163850(1)_99999999999_559272149184581.jpg"}]},"SKUPictureInfos":[{"SrmSKU":559270265180229,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/B0XF1400001R_99999999999_559270347657285.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20220429163850(1)_99999999999_559272149184581.jpg","ImgSort":0}]}]},"UserId":"0211"}]
2025/4/30 19:22:56 GetSPUId方法内部,CategoryCode:11,sql:
2025/4/30 19:22:56 GetSPUId获取到结果:SPUId:O002075,CategoryCode:11,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/4/30 19:22:57 响应体:{"Status":200,"Result":",JIMMY H10 Pro 前风道组件操作成功","SuccessSPUSKUResponse":[{"SrmSPU":559269019639877,"ErpSPU":"O002075","SKURelations":[{"SrmSKU":"559270265180229","ErpSKU":"1291430"}],"Msg":null}],"FailSPUSKUResponse":[]}