2025/5/26 8:57:08 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":123,"CountryShort":"FR","TotalWeight":30.000,"Length":129.0,"Width":28.2,"Height":64.0,"Postcode":"67500","DepartureNo":"PLFLYDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 8:57:08 SQL_ShipViaList: and svp.PlatFormId='123' and CHARINDEX(',324,',','+sv.MangoFlag+',')>0 2025/5/26 8:57:08 postcodestr:67500,countryId:40,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('FYL1+PLGLS','FYL1+PLGLSEU','FYL1+PLDPD','FYL1+EUDPD','FYL1+PLDPDBZ','FYL1+PLDPDEUBZ') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 08:57:08'>=TakeEfficacyDate and '2025-05-26 08:57:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 08:57:08'>=TakeEfficacyDate)) and '67500'>=UPPER(StartPostcode) and '67500'<=UPPER(EndPostCode) 2025/5/26 8:57:08 postcodestr:675,countryId:40,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('FYL1+PLGLS','FYL1+PLGLSEU','FYL1+PLDPD','FYL1+EUDPD','FYL1+PLDPDBZ','FYL1+PLDPDEUBZ') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 08:57:08'>=TakeEfficacyDate and '2025-05-26 08:57:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 08:57:08'>=TakeEfficacyDate)) and '675'>=UPPER(StartPostcode) and '675'<=UPPER(EndPostCode) 2025/5/26 8:57:08 countryId:40,SQL_ShipPrice_Country: and p.ForwarderByID in ('FYL1+PLGLS','FYL1+PLGLSEU','FYL1+PLDPD','FYL1+EUDPD','FYL1+PLDPDBZ','FYL1+PLDPDEUBZ') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 08:57:08'>=TakeEfficacyDate and '2025-05-26 08:57:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 08:57:08'>=TakeEfficacyDate)) 2025/5/26 8:57:08 GetShipVia 重量计算结果 ForwarderByID:FYL1+PLGLSEU ActualWeight:30.000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLGLSEU,,ActualWeight:30.000,CalculationFormula:{标准价格}*1.25+13+4+1.2,FuelRates:1.3,Discount:0,RegisteredFee:0.0000,PriceMethod:366.29,SignatureFee:0.00 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLGLSEU,TotalPrice:476.0625 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLGLSEU,freightCurrency:PLN,TotalPrice:871.194375000000,CNYExchangeRate:1.83000000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLGLSEU,showShipViaTotalPrice:871.194375000000,surcharge:0,TotalPrice:871.194375000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 8:57:08 GetShipVia 重量计算结果 ForwarderByID:FYL1+EUDPD ActualWeight:30.000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+EUDPD,,ActualWeight:30.000,CalculationFormula:{标准价格}*1.25+3+3.2,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:45.78,SignatureFee:0.00 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+EUDPD,TotalPrice:63.4250 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+EUDPD,freightCurrency:EUR,TotalPrice:488.372500000000,CNYExchangeRate:7.70000000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+EUDPD,showShipViaTotalPrice:488.372500000000,surcharge:0,TotalPrice:488.372500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 8:57:08 GetShipVia 重量计算结果 ForwarderByID:FYL1+PLDPDEUBZ ActualWeight:30.000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLDPDEUBZ,,ActualWeight:30.000,CalculationFormula:{标准价格}*1.3+15,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:87.72,SignatureFee:0.00 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLDPDEUBZ,TotalPrice:129.036 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLDPDEUBZ,freightCurrency:PLN,TotalPrice:236.13588000000,CNYExchangeRate:1.83000000 2025/5/26 8:57:08 GetShipVia ForwarderByID:FYL1+PLDPDEUBZ,showShipViaTotalPrice:236.13588000000,surcharge:0,TotalPrice:236.13588000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":125,"CountryShort":"US","TotalWeight":0.650,"Length":14.3,"Width":14.3,"Height":10.0,"Postcode":"75056","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 9:45:36 SQL_ShipViaList: and svp.PlatFormId='125' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 9:45:36 postcodestr:75056,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 09:45:36'>=TakeEfficacyDate and '2025-05-26 09:45:36'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 09:45:36'>=TakeEfficacyDate)) and '75056'>=UPPER(StartPostcode) and '75056'<=UPPER(EndPostCode) 2025/5/26 9:45:36 postcodestr:750,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 09:45:36'>=TakeEfficacyDate and '2025-05-26 09:45:36'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 09:45:36'>=TakeEfficacyDate)) and '750'>=UPPER(StartPostcode) and '750'<=UPPER(EndPostCode) 2025/5/26 9:45:36 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 09:45:36'>=TakeEfficacyDate and '2025-05-26 09:45:36'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 09:45:36'>=TakeEfficacyDate)) 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.650,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.14,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:14.034250 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:96.83632500000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:96.83632500000000,surcharge:0,TotalPrice:96.83632500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.650,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22.65,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.97275 2025/5/26 9:45:36 GetShipVia 开始运费计算 type:0,countryId:38,TotalWeight:0.9000,shiptype:,forward:Aliexpress,orderSource:Aliexpress,postcode:03238,HfreightSide:,cuforward:FEDEX_ES_LOCAL,productCodes:970299,1,mangoFlagCode:198,ItemTypeSelect:,paramLength:0,paramWidth:0,paramHigh:0,embargoTypeCode: 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:193.0119750000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:193.0119750000000,surcharge:0,TotalPrice:193.0119750000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.650,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:32.9,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:27.965 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:192.95850000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:192.95850000000,surcharge:0,TotalPrice:192.95850000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.650,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.14,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:10.14 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:69.9660000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:69.9660000000,surcharge:0,TotalPrice:69.9660000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.650,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 9:45:36 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.650 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.650,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.72,SignatureFee:0.00 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.72 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.1680000000,CNYExchangeRate:6.90000000 2025/5/26 9:45:36 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.1680000000,surcharge:0,TotalPrice:60.1680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:52 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"082321115","DepartureNo":"USEDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 10:26:52 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',301,',','+sv.MangoFlag+',')>0 2025/5/26 10:26:52 postcodestr:08232,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 10:26:52'>=TakeEfficacyDate and '2025-05-26 10:26:52'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 10:26:52'>=TakeEfficacyDate)) and '08232'>=UPPER(StartPostcode) and '08232'<=UPPER(EndPostCode) 2025/5/26 10:26:53 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 10:26:52'>=TakeEfficacyDate and '2025-05-26 10:26:52'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 10:26:52'>=TakeEfficacyDate)) 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUND ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPSGROUND,,ActualWeight:0.087,CalculationFormula:{标准价格}*{燃油费率}*0.85+5.4,FuelRates:1.2,Discount:6.78,RegisteredFee:0.0000,PriceMethod:10.28,SignatureFee:0.00 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPSGROUND,TotalPrice:15.88560 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPSGROUND,freightCurrency:USD,TotalPrice:109.6106400000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPSGROUND,showShipViaTotalPrice:109.6106400000000,surcharge:0,TotalPrice:109.6106400000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.087,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSMIE ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSMIE,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:5.41,SignatureFee:0.00 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSMIE,TotalPrice:5.41 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSMIE,freightCurrency:USD,TotalPrice:37.3290000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:53 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUND ActualWeight:0.087 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USUPSMIE,showShipViaTotalPrice:37.3290000000,surcharge:0,TotalPrice:37.3290000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USFEDEXGROUND,TotalPrice:11.72 2025/5/26 10:26:53 GetShipVia ForwarderByID:US001+USFEDEXGROUND,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXGROUND,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXGROUND,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:26:54 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.087 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.087,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 10:26:54 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:26 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":1.580,"Length":20.3,"Width":12.3,"Height":26.3,"Postcode":"080125007","DepartureNo":"USEDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 10:59:26 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',301,',','+sv.MangoFlag+',')>0 2025/5/26 10:59:27 postcodestr:08012,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 10:59:26'>=TakeEfficacyDate and '2025-05-26 10:59:26'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 10:59:26'>=TakeEfficacyDate)) and '08012'>=UPPER(StartPostcode) and '08012'<=UPPER(EndPostCode) 2025/5/26 10:59:27 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 10:59:26'>=TakeEfficacyDate and '2025-05-26 10:59:26'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 10:59:26'>=TakeEfficacyDate)) 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:14.398250 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:1.580,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.46,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:99.34792500000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:99.34792500000000,surcharge:0,TotalPrice:99.34792500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPSGROUND,TotalPrice:16.36500 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPSGROUND,,ActualWeight:1.580,CalculationFormula:{标准价格}*{燃油费率}*0.85+5.4,FuelRates:1.2,Discount:6.78,RegisteredFee:0.0000,PriceMethod:10.75,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUND ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPSGROUND,showShipViaTotalPrice:112.9185000000000,surcharge:0,TotalPrice:112.9185000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPSGROUND,freightCurrency:USD,TotalPrice:112.9185000000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:1.580,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:27.79,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:34.32065 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:236.8124850000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:35.2155 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:1.580,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:41.43,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:236.8124850000000,surcharge:0,TotalPrice:236.8124850000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:242.986950000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:242.986950000000,surcharge:0,TotalPrice:242.986950000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUND ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXGROUND,TotalPrice:11.72 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSMIE ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXGROUND,,ActualWeight:1.580,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXGROUND,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:1.580,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.53,SignatureFee:0.00 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:9.53 2025/5/26 10:59:27 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:1.580 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:65.7570000000,CNYExchangeRate:6.90000000 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:65.7570000000,surcharge:0,TotalPrice:65.7570000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 10:59:27 GetShipVia ForwarderByID:US001+USFEDEXGROUND,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:37 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":37.000,"Length":68.0,"Width":41.0,"Height":53.0,"Postcode":"450446462","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:00:37 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:00:37 postcodestr:45044,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:00:37'>=TakeEfficacyDate and '2025-05-26 11:00:37'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:00:37'>=TakeEfficacyDate)) and '45044'>=UPPER(StartPostcode) and '45044'<=UPPER(EndPostCode) 2025/5/26 11:00:37 postcodestr:450,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:00:37'>=TakeEfficacyDate and '2025-05-26 11:00:37'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:00:37'>=TakeEfficacyDate)) and '450'>=UPPER(StartPostcode) and '450'<=UPPER(EndPostCode) 2025/5/26 11:00:37 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:00:37'>=TakeEfficacyDate and '2025-05-26 11:00:37'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:00:37'>=TakeEfficacyDate)) 2025/5/26 11:00:37 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:37.000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:84.764000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:37.000,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:72.32,SignatureFee:0.00 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:584.87160000000000,CNYExchangeRate:6.90000000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:584.87160000000000,surcharge:0,TotalPrice:584.87160000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:37 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:37.000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:37.000,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:263.8,SignatureFee:0.00 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:325.7930 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:2247.971700000000,CNYExchangeRate:6.90000000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:2247.971700000000,surcharge:0,TotalPrice:2247.971700000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:37 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:37.000 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:256.0030 2025/5/26 11:00:37 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:37.000,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:301.18,SignatureFee:0.00 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:1766.420700000000,CNYExchangeRate:6.90000000 2025/5/26 11:00:38 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:37.000 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:1766.420700000000,surcharge:0,TotalPrice:1766.420700000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:37.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:72.32,SignatureFee:0.00 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:72.32 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:499.0080000000,CNYExchangeRate:6.90000000 2025/5/26 11:00:38 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:37.000 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:499.0080000000,surcharge:0,TotalPrice:499.0080000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:37.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:56.81,SignatureFee:0.00 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:56.81 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:391.9890000000,CNYExchangeRate:6.90000000 2025/5/26 11:00:38 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:391.9890000000,surcharge:0,TotalPrice:391.9890000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:00:38 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:37.000 2025/5/26 11:03:19 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":1.140,"Length":23.7,"Width":8.7,"Height":29.2,"Postcode":"458950000","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:03:19 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:03:19 postcodestr:45895,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:03:19'>=TakeEfficacyDate and '2025-05-26 11:03:19'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:03:19'>=TakeEfficacyDate)) and '45895'>=UPPER(StartPostcode) and '45895'<=UPPER(EndPostCode) 2025/5/26 11:03:20 postcodestr:458,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:03:19'>=TakeEfficacyDate and '2025-05-26 11:03:19'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:03:19'>=TakeEfficacyDate)) and '458'>=UPPER(StartPostcode) and '458'<=UPPER(EndPostCode) 2025/5/26 11:03:20 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:03:19'>=TakeEfficacyDate and '2025-05-26 11:03:19'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:03:19'>=TakeEfficacyDate)) 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:14.284500 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:1.140,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.36,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:98.56305000000000,CNYExchangeRate:6.90000000 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:98.56305000000000,surcharge:0,TotalPrice:98.56305000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:1.140,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:24.1,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:29.7635 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:205.368150000000,CNYExchangeRate:6.90000000 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:205.368150000000,surcharge:0,TotalPrice:205.368150000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:1.140,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:41.27,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:35.0795 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:242.048550000000,CNYExchangeRate:6.90000000 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:242.048550000000,surcharge:0,TotalPrice:242.048550000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:1.140,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.36,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:10.36 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:71.4840000000,CNYExchangeRate:6.90000000 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:71.4840000000,surcharge:0,TotalPrice:71.4840000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:1.140,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:1.140 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.73 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:1.140,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.73,SignatureFee:0.00 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.2370000000,surcharge:0,TotalPrice:60.2370000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:03:20 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.2370000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:27 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"063405844","DepartureNo":"USEDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:08:27 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',301,',','+sv.MangoFlag+',')>0 2025/5/26 11:08:27 postcodestr:06340,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:08:27'>=TakeEfficacyDate and '2025-05-26 11:08:27'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:08:27'>=TakeEfficacyDate)) and '06340'>=UPPER(StartPostcode) and '06340'<=UPPER(EndPostCode) 2025/5/26 11:08:27 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:08:27'>=TakeEfficacyDate and '2025-05-26 11:08:27'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:08:27'>=TakeEfficacyDate)) 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUND ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPSGROUND,TotalPrice:15.88560 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPSGROUND,,ActualWeight:0.087,CalculationFormula:{标准价格}*{燃油费率}*0.85+5.4,FuelRates:1.2,Discount:6.78,RegisteredFee:0.0000,PriceMethod:10.28,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPSGROUND,freightCurrency:USD,TotalPrice:109.6106400000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPSGROUND,showShipViaTotalPrice:109.6106400000000,surcharge:0,TotalPrice:109.6106400000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.087,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSMIE,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:5.41,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSMIE,TotalPrice:5.41 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSMIE ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSMIE,freightCurrency:USD,TotalPrice:37.3290000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USUPSMIE,showShipViaTotalPrice:37.3290000000,surcharge:0,TotalPrice:37.3290000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUND ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXGROUND,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXGROUND,TotalPrice:11.72 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXGROUND,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXGROUND,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.087,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 11:08:28 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.087 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:28 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:56 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":15.000,"Length":63.0,"Width":35.5,"Height":37.5,"Postcode":"630111817","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:08:56 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:08:56 postcodestr:63011,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:08:56'>=TakeEfficacyDate and '2025-05-26 11:08:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:08:56'>=TakeEfficacyDate)) and '63011'>=UPPER(StartPostcode) and '63011'<=UPPER(EndPostCode) 2025/5/26 11:08:56 postcodestr:630,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:08:56'>=TakeEfficacyDate and '2025-05-26 11:08:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:08:56'>=TakeEfficacyDate)) and '630'>=UPPER(StartPostcode) and '630'<=UPPER(EndPostCode) 2025/5/26 11:08:56 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:08:56'>=TakeEfficacyDate and '2025-05-26 11:08:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:08:56'>=TakeEfficacyDate)) 2025/5/26 11:08:56 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:15.000 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:15.000,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22.38,SignatureFee:0.00 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:27.957250 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:192.90502500000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:56 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:15.000 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:15.000,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:104.25,SignatureFee:0.00 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:128.74875 2025/5/26 11:08:56 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:192.90502500000000,surcharge:0,TotalPrice:192.90502500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:888.3663750000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:57 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:15.000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:888.3663750000000,surcharge:0,TotalPrice:888.3663750000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:15.000,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:122.51,SignatureFee:0.00 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:104.1335 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:718.521150000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:57 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:15.000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:718.521150000000,surcharge:0,TotalPrice:718.521150000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:15.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22.38,SignatureFee:0.00 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:22.38 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:154.4220000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:154.4220000000,surcharge:0,TotalPrice:154.4220000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:15.000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:15.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:18.04,SignatureFee:0.00 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:18.04 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:124.4760000000,surcharge:0,TotalPrice:124.4760000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:124.4760000000,CNYExchangeRate:6.90000000 2025/5/26 11:08:57 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:15.000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:15.000,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:{重量}*5.49,SignatureFee:0.00 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:82.35000 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:568.2150000000000,surcharge:0,TotalPrice:568.2150000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:08:57 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:568.2150000000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:41 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":1.730,"Length":45.0,"Width":27.6,"Height":6.0,"Postcode":"371292166","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:11:41 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:11:41 postcodestr:37129,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:11:41'>=TakeEfficacyDate and '2025-05-26 11:11:41'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:11:41'>=TakeEfficacyDate)) and '37129'>=UPPER(StartPostcode) and '37129'<=UPPER(EndPostCode) 2025/5/26 11:11:41 postcodestr:371,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:11:41'>=TakeEfficacyDate and '2025-05-26 11:11:41'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:11:41'>=TakeEfficacyDate)) and '371'>=UPPER(StartPostcode) and '371'<=UPPER(EndPostCode) 2025/5/26 11:11:41 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:11:41'>=TakeEfficacyDate and '2025-05-26 11:11:41'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:11:41'>=TakeEfficacyDate)) 2025/5/26 11:11:41 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:1.730 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:1.730,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.46,SignatureFee:0.00 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:14.398250 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:99.34792500000000,surcharge:0,TotalPrice:99.34792500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:99.34792500000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:41 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:1.730 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:1.730,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:27.79,SignatureFee:0.00 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:34.32065 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:236.8124850000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:236.8124850000000,surcharge:0,TotalPrice:236.8124850000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:11:41 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:1.730 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:1.730,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:41.43,SignatureFee:0.00 2025/5/26 11:11:41 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:35.2155 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:242.986950000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:242.986950000000,surcharge:0,TotalPrice:242.986950000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:11:42 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:1.730 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:10.46 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:1.730,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.46,SignatureFee:0.00 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:72.1740000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:72.1740000000,surcharge:0,TotalPrice:72.1740000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:11:42 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:1.730 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:1.730,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:11:42 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:1.730 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:1.730,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.53,SignatureFee:0.00 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:9.53 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:65.7570000000,CNYExchangeRate:6.90000000 2025/5/26 11:11:42 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:65.7570000000,surcharge:0,TotalPrice:65.7570000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:17:08 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.174,"Length":12.0,"Width":9.0,"Height":4.6,"Postcode":"953558713","DepartureNo":"USWDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:17:08 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/5/26 11:17:08 postcodestr:95355,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:17:08'>=TakeEfficacyDate and '2025-05-26 11:17:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:17:08'>=TakeEfficacyDate)) and '95355'>=UPPER(StartPostcode) and '95355'<=UPPER(EndPostCode) 2025/5/26 11:17:08 postcodestr:953,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:17:08'>=TakeEfficacyDate and '2025-05-26 11:17:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:17:08'>=TakeEfficacyDate)) and '953'>=UPPER(StartPostcode) and '953'<=UPPER(EndPostCode) 2025/5/26 11:17:08 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:17:08'>=TakeEfficacyDate and '2025-05-26 11:17:08'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:17:08'>=TakeEfficacyDate)) 2025/5/26 11:17:08 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.174 2025/5/26 11:17:08 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.174,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 11:17:08 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:17:09 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.174 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.174,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:17:09 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.174 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.174,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:17:09 GetShipVia 重量计算结果 ForwarderByID:US001+FEDEXDHUS ActualWeight:0.174 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+FEDEXDHUS,TotalPrice:28.37440 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+FEDEXDHUS,,ActualWeight:0.174,CalculationFormula:{标准价格}*1.2*0.85+2.42+14,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+FEDEXDHUS,freightCurrency:USD,TotalPrice:195.7833600000000,CNYExchangeRate:6.90000000 2025/5/26 11:17:09 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.174 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice:195.7833600000000,surcharge:0,TotalPrice:195.7833600000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.174,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 11:17:09 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:20 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":15.000,"Length":63.0,"Width":35.5,"Height":37.5,"Postcode":"395673112","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:18:20 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:18:20 postcodestr:39567,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:18:20'>=TakeEfficacyDate and '2025-05-26 11:18:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:18:20'>=TakeEfficacyDate)) and '39567'>=UPPER(StartPostcode) and '39567'<=UPPER(EndPostCode) 2025/5/26 11:18:20 postcodestr:395,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:18:20'>=TakeEfficacyDate and '2025-05-26 11:18:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:18:20'>=TakeEfficacyDate)) and '395'>=UPPER(StartPostcode) and '395'<=UPPER(EndPostCode) 2025/5/26 11:18:20 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:18:20'>=TakeEfficacyDate and '2025-05-26 11:18:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:18:20'>=TakeEfficacyDate)) 2025/5/26 11:18:20 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:15.000 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:15.000,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22.38,SignatureFee:0.00 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:27.957250 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:192.90502500000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:20 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:15.000 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:15.000,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:104.25,SignatureFee:0.00 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:128.74875 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:192.90502500000000,surcharge:0,TotalPrice:192.90502500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:888.3663750000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:20 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:15.000 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:104.1335 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:888.3663750000000,surcharge:0,TotalPrice:888.3663750000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:15.000,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:122.51,SignatureFee:0.00 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:718.521150000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:718.521150000000,surcharge:0,TotalPrice:718.521150000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:20 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:15.000 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:15.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22.38,SignatureFee:0.00 2025/5/26 11:18:20 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:22.38 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:154.4220000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:154.4220000000,surcharge:0,TotalPrice:154.4220000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:21 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:15.000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:15.000,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:18.04,SignatureFee:0.00 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:18.04 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:124.4760000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:124.4760000000,surcharge:0,TotalPrice:124.4760000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:18:21 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:15.000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:15.000,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:{重量}*5.49,SignatureFee:0.00 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:82.35000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:568.2150000000000,CNYExchangeRate:6.90000000 2025/5/26 11:18:21 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:568.2150000000000,surcharge:0,TotalPrice:568.2150000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:03 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.340,"Length":13.5,"Width":9.5,"Height":6.0,"Postcode":"283765466","DepartureNo":"USEDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:26:03 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',301,',','+sv.MangoFlag+',')>0 2025/5/26 11:26:04 postcodestr:28376,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:26:03'>=TakeEfficacyDate and '2025-05-26 11:26:03'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:26:03'>=TakeEfficacyDate)) and '28376'>=UPPER(StartPostcode) and '28376'<=UPPER(EndPostCode) 2025/5/26 11:26:04 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPSGROUND','US001+UPS2D','US001+USUPSND','US001+USUPSMIE','US001+USFEDEXGROUND','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:26:03'>=TakeEfficacyDate and '2025-05-26 11:26:03'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:26:03'>=TakeEfficacyDate)) 2025/5/26 11:26:04 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.340 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.340,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPSGROUND,,ActualWeight:0.340,CalculationFormula:{标准价格}*{燃油费率}*0.85+5.4,FuelRates:1.2,Discount:6.78,RegisteredFee:0.0000,PriceMethod:10.28,SignatureFee:0.00 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPSGROUND,TotalPrice:15.88560 2025/5/26 11:26:04 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUND ActualWeight:0.340 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPSGROUND,freightCurrency:USD,TotalPrice:109.6106400000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:04 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.340 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPSGROUND,showShipViaTotalPrice:109.6106400000000,surcharge:0,TotalPrice:109.6106400000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.340,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:04 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.340 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.340,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:04 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:05 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSMIE ActualWeight:0.340 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSMIE,TotalPrice:6.98 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSMIE,,ActualWeight:0.340,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:6.98,SignatureFee:0.00 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSMIE,freightCurrency:USD,TotalPrice:48.1620000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USUPSMIE,showShipViaTotalPrice:48.1620000000,surcharge:0,TotalPrice:48.1620000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:05 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUND ActualWeight:0.340 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXGROUND,,ActualWeight:0.340,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXGROUND,TotalPrice:11.72 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXGROUND,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXGROUND,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.340,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 11:26:05 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:26:05 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.340 2025/5/26 11:31:06 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.078,"Length":9.0,"Width":9.0,"Height":4.0,"Postcode":"307476058","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 11:31:06 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 11:31:06 postcodestr:30747,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:31:06'>=TakeEfficacyDate and '2025-05-26 11:31:06'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:31:06'>=TakeEfficacyDate)) and '30747'>=UPPER(StartPostcode) and '30747'<=UPPER(EndPostCode) 2025/5/26 11:31:06 postcodestr:307,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:31:06'>=TakeEfficacyDate and '2025-05-26 11:31:06'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:31:06'>=TakeEfficacyDate)) and '307'>=UPPER(StartPostcode) and '307'<=UPPER(EndPostCode) 2025/5/26 11:31:06 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 11:31:06'>=TakeEfficacyDate and '2025-05-26 11:31:06'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 11:31:06'>=TakeEfficacyDate)) 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.078,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:9.58 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:66.1020000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:66.1020000000,surcharge:0,TotalPrice:66.1020000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.078,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 11:31:06 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.078 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 11:31:06 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:28 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.078,"Length":9.0,"Width":9.0,"Height":4.0,"Postcode":"347581706","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 13:57:28 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 13:57:29 postcodestr:34758,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:57:28'>=TakeEfficacyDate and '2025-05-26 13:57:28'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:57:28'>=TakeEfficacyDate)) and '34758'>=UPPER(StartPostcode) and '34758'<=UPPER(EndPostCode) 2025/5/26 13:57:29 postcodestr:347,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:57:28'>=TakeEfficacyDate and '2025-05-26 13:57:28'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:57:28'>=TakeEfficacyDate)) and '347'>=UPPER(StartPostcode) and '347'<=UPPER(EndPostCode) 2025/5/26 13:57:29 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:57:28'>=TakeEfficacyDate and '2025-05-26 13:57:28'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:57:28'>=TakeEfficacyDate)) 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.078,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:9.58 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:66.1020000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:66.1020000000,surcharge:0,TotalPrice:66.1020000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:57:29 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.078 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.078,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 13:57:29 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:56 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"436171193","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 13:58:56 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 13:58:57 postcodestr:43617,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:58:56'>=TakeEfficacyDate and '2025-05-26 13:58:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:58:56'>=TakeEfficacyDate)) and '43617'>=UPPER(StartPostcode) and '43617'<=UPPER(EndPostCode) 2025/5/26 13:58:57 postcodestr:436,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:58:56'>=TakeEfficacyDate and '2025-05-26 13:58:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:58:56'>=TakeEfficacyDate)) and '436'>=UPPER(StartPostcode) and '436'<=UPPER(EndPostCode) 2025/5/26 13:58:57 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:58:56'>=TakeEfficacyDate and '2025-05-26 13:58:56'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:58:56'>=TakeEfficacyDate)) 2025/5/26 13:58:57 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.087 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:57 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.087 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:57 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.087 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.087,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:57 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.087 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:9.58 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:66.1020000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:66.1020000000,surcharge:0,TotalPrice:66.1020000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:57 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.087 2025/5/26 13:58:57 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:58 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.087 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.087,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 13:58:58 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:12 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.078,"Length":9.0,"Width":9.0,"Height":4.0,"Postcode":"641512223","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 13:59:12 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 13:59:12 postcodestr:64151,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:59:12'>=TakeEfficacyDate and '2025-05-26 13:59:12'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:59:12'>=TakeEfficacyDate)) and '64151'>=UPPER(StartPostcode) and '64151'<=UPPER(EndPostCode) 2025/5/26 13:59:12 postcodestr:641,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:59:12'>=TakeEfficacyDate and '2025-05-26 13:59:12'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:59:12'>=TakeEfficacyDate)) and '641'>=UPPER(StartPostcode) and '641'<=UPPER(EndPostCode) 2025/5/26 13:59:12 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 13:59:12'>=TakeEfficacyDate and '2025-05-26 13:59:12'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 13:59:12'>=TakeEfficacyDate)) 2025/5/26 13:59:12 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.078 2025/5/26 13:59:12 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:59:12 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:13 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.078 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.078,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:13 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.078 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.078,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.078 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:9.58 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:66.1020000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:66.1020000000,surcharge:0,TotalPrice:66.1020000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:13 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.078 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.078,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 13:59:13 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.078 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.078,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 13:59:13 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:48 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"770633652","DepartureNo":"USMDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 14:01:48 SQL_ShipViaList: and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/5/26 14:01:48 postcodestr:77063,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:01:48'>=TakeEfficacyDate and '2025-05-26 14:01:48'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:01:48'>=TakeEfficacyDate)) and '77063'>=UPPER(StartPostcode) and '77063'<=UPPER(EndPostCode) 2025/5/26 14:01:48 postcodestr:770,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:01:48'>=TakeEfficacyDate and '2025-05-26 14:01:48'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:01:48'>=TakeEfficacyDate)) and '770'>=UPPER(StartPostcode) and '770'<=UPPER(EndPostCode) 2025/5/26 14:01:48 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USFEDEXGROUNDC','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:01:48'>=TakeEfficacyDate and '2025-05-26 14:01:48'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:01:48'>=TakeEfficacyDate)) 2025/5/26 14:01:48 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:0.087 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:13.397250 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:92.44102500000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:48 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:0.087 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:0.087,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:22,SignatureFee:0.00 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:27.170 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:92.44102500000000,surcharge:0,TotalPrice:92.44102500000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:187.47300000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:187.47300000000,surcharge:0,TotalPrice:187.47300000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:0.087,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:30.88,SignatureFee:0.00 2025/5/26 14:01:48 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:26.2480 2025/5/26 14:01:48 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:0.087 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:181.111200000000,surcharge:0,TotalPrice:181.111200000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:181.111200000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+UPSGROUNDC,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:9.58,SignatureFee:0.00 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+UPSGROUNDC,TotalPrice:9.58 2025/5/26 14:01:49 GetShipVia 重量计算结果 ForwarderByID:US001+UPSGROUNDC ActualWeight:0.087 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+UPSGROUNDC,freightCurrency:USD,TotalPrice:66.1020000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:49 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXGROUNDC ActualWeight:0.087 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice:66.1020000000,surcharge:0,TotalPrice:66.1020000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,,ActualWeight:0.087,CalculationFormula:,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,TotalPrice:11.72 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency:USD,TotalPrice:80.8680000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice:80.8680000000,surcharge:0,TotalPrice:80.8680000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:01:49 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:0.087 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:0.087,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.71,SignatureFee:0.00 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.71 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.0990000000,CNYExchangeRate:6.90000000 2025/5/26 14:01:49 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.0990000000,surcharge:0,TotalPrice:60.0990000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:10:54 GetShipViaInfoWithParam 开始运费计算,参数: {"PlatformId":125,"CountryShort":"US","TotalWeight":1.250,"Length":20.0,"Width":20.0,"Height":9.5,"Postcode":"80228","DepartureNo":"USWDX","ForwarderByID":[],"AutoDetectionBasicConfig":true} 2025/5/26 14:10:54 SQL_ShipViaList: and svp.PlatFormId='125' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/5/26 14:10:54 postcodestr:80228,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:10:54'>=TakeEfficacyDate and '2025-05-26 14:10:54'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:10:54'>=TakeEfficacyDate)) and '80228'>=UPPER(StartPostcode) and '80228'<=UPPER(EndPostCode) 2025/5/26 14:10:54 postcodestr:802,countryId:43,SQL_ShipPrice_Postcode: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:10:54'>=TakeEfficacyDate and '2025-05-26 14:10:54'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:10:54'>=TakeEfficacyDate)) and '802'>=UPPER(StartPostcode) and '802'<=UPPER(EndPostCode) 2025/5/26 14:10:54 countryId:43,SQL_ShipPrice_Country: and p.ForwarderByID in ('US001+USUPS','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-05-26 14:10:54'>=TakeEfficacyDate and '2025-05-26 14:10:54'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-05-26 14:10:54'>=TakeEfficacyDate)) 2025/5/26 14:10:54 GetShipVia 重量计算结果 ForwarderByID:US001+USUPS ActualWeight:1.250 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+USUPS,,ActualWeight:1.250,CalculationFormula:{标准价格}*1.25*0.91+2.5,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:10.36,SignatureFee:0.00 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+USUPS,TotalPrice:14.284500 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+USUPS,showShipViaTotalPrice:98.56305000000000,surcharge:0,TotalPrice:98.56305000000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+USUPS,freightCurrency:USD,TotalPrice:98.56305000000000,CNYExchangeRate:6.90000000 2025/5/26 14:10:54 GetShipVia 重量计算结果 ForwarderByID:US001+UPS2D ActualWeight:1.250 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+UPS2D,,ActualWeight:1.250,CalculationFormula:{标准价格}*1.3*0.95,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:24.1,SignatureFee:0.00 2025/5/26 14:10:54 GetShipVia ForwarderByID:US001+UPS2D,TotalPrice:29.7635 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+UPS2D,freightCurrency:USD,TotalPrice:205.368150000000,CNYExchangeRate:6.90000000 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+UPS2D,showShipViaTotalPrice:205.368150000000,surcharge:0,TotalPrice:205.368150000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:10:55 GetShipVia 重量计算结果 ForwarderByID:US001+USUPSND ActualWeight:1.250 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USUPSND,,ActualWeight:1.250,CalculationFormula:{标准价格}*0.85,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:41.27,SignatureFee:0.00 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USUPSND,TotalPrice:35.0795 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USUPSND,freightCurrency:USD,TotalPrice:242.048550000000,CNYExchangeRate:6.90000000 2025/5/26 14:10:55 GetShipVia 重量计算结果 ForwarderByID:US001+FEDEXDHUS ActualWeight:1.250 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+FEDEXDHUS,,ActualWeight:1.250,CalculationFormula:{标准价格}*1.2*0.85+2.42+14,FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:11.72,SignatureFee:0.00 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+FEDEXDHUS,TotalPrice:28.37440 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USUPSND,showShipViaTotalPrice:242.048550000000,surcharge:0,TotalPrice:242.048550000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+FEDEXDHUS,freightCurrency:USD,TotalPrice:195.7833600000000,CNYExchangeRate:6.90000000 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice:195.7833600000000,surcharge:0,TotalPrice:195.7833600000000,currentRate:0.14492753,RemoteFee:0 2025/5/26 14:10:55 GetShipVia 重量计算结果 ForwarderByID:US001+USFEDEXDB ActualWeight:1.250 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USFEDEXDB,,ActualWeight:1.250,CalculationFormula:{标准价格},FuelRates:,Discount:0,RegisteredFee:0.0000,PriceMethod:8.73,SignatureFee:0.00 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USFEDEXDB,TotalPrice:8.73 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USFEDEXDB,freightCurrency:USD,TotalPrice:60.2370000000,CNYExchangeRate:6.90000000 2025/5/26 14:10:55 GetShipVia ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice:60.2370000000,surcharge:0,TotalPrice:60.2370000000,currentRate:0.14492753,RemoteFee:0