2025/10/5 2:25:21 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":1.730,"Length":45.0,"Width":27.7,"Height":6.6,"Postcode":"92582","DepartureNo":"USWDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 2:25:21 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/10/5 2:25:21 postcodestr：92582，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 02:25:21'>=TakeEfficacyDate and '2025-10-05 02:25:21'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 02:25:21'>=TakeEfficacyDate)) and '92582'>=UPPER(StartPostcode) and '92582'<=UPPER(EndPostCode) 2025/10/5 2:25:21 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 02:25:21'>=TakeEfficacyDate and '2025-10-05 02:25:21'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 02:25:21'>=TakeEfficacyDate)) 2025/10/5 2:25:21 【US001+USUPS】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 【US001+USUPS】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.46，SignatureFee：0.00 2025/10/5 2:25:21 【US001+USUPS】 TotalPrice：69.0750 2025/10/5 2:25:21 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：476.617500000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 ForwarderByID:US001+USUPS,showShipViaTotalPrice：476.617500000000,surcharge：0,TotalPrice：476.617500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 2:25:21 【US001+USPS-B】 ActualWeight：1.730，CalculationFormula：{标准价格}，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.21，SignatureFee：0.00 2025/10/5 2:25:21 【US001+USPS-B】 TotalPrice：27.21 2025/10/5 2:25:21 【US001+USPS-B】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 ForwarderByID:US001+USPS-B,freightCurrency：USD,TotalPrice：187.7490000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 ForwarderByID:US001+USPS-B,showShipViaTotalPrice：187.7490000000,surcharge：0,TotalPrice：187.7490000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 2:25:21 【US001+USPSGA】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 【US001+UPS2D】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 【US001+UPS2D】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.79，SignatureFee：0.00 2025/10/5 2:25:21 【US001+UPS2D】 TotalPrice：90.32065 2025/10/5 2:25:21 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：623.2124850000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 【US001+USUPSND】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 【US001+USUPSND】 ActualWeight：1.730，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：41.43，SignatureFee：0.00 2025/10/5 2:25:21 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：623.2124850000000,surcharge：0,TotalPrice：623.2124850000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 2:25:21 【US001+USUPSND】 TotalPrice：91.2155 2025/10/5 2:25:21 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：629.386950000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：629.386950000000,surcharge：0,TotalPrice：629.386950000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 2:25:21 【US001+FEDEXDHUS】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.2*0.85+2.42+14+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 2:25:21 【US001+FEDEXDHUS】 TotalPrice：84.37440 2025/10/5 2:25:21 【US001+FEDEXDHUS】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 ForwarderByID:US001+FEDEXDHUS,freightCurrency：USD,TotalPrice：582.1833600000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice：582.1833600000000,surcharge：0,TotalPrice：582.1833600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 2:25:21 【US001+USFEDEXDB】 TotalPrice：65.53 2025/10/5 2:25:21 【US001+USFEDEXDB】重量计算结果 ActualWeight：1.730 2025/10/5 2:25:21 ForwarderByID:US001+USFEDEXDB,freightCurrency：USD,TotalPrice：452.1570000000,CNYExchangeRate：6.90000000 2025/10/5 2:25:21 【US001+USFEDEXDB】 ActualWeight：1.730，CalculationFormula：{标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.53，SignatureFee：0.00 2025/10/5 2:25:21 ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice：452.1570000000,surcharge：0,TotalPrice：452.1570000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":1.730,"Length":45.0,"Width":27.7,"Height":6.6,"Postcode":"92582","DepartureNo":"USWDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 3:13:40 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/10/5 3:13:40 postcodestr：92582，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:13:40'>=TakeEfficacyDate and '2025-10-05 03:13:40'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:13:40'>=TakeEfficacyDate)) and '92582'>=UPPER(StartPostcode) and '92582'<=UPPER(EndPostCode) 2025/10/5 3:13:40 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:13:40'>=TakeEfficacyDate and '2025-10-05 03:13:40'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:13:40'>=TakeEfficacyDate)) 2025/10/5 3:13:40 【US001+USUPS】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 【US001+USUPS】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.46，SignatureFee：0.00 2025/10/5 3:13:40 【US001+USUPS】 TotalPrice：69.0750 2025/10/5 3:13:40 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：476.617500000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 ForwarderByID:US001+USUPS,showShipViaTotalPrice：476.617500000000,surcharge：0,TotalPrice：476.617500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 【US001+USPS-B】 ActualWeight：1.730，CalculationFormula：{标准价格}，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.21，SignatureFee：0.00 2025/10/5 3:13:40 【US001+USPS-B】 TotalPrice：27.21 2025/10/5 3:13:40 【US001+USPS-B】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 ForwarderByID:US001+USPS-B,showShipViaTotalPrice：187.7490000000,surcharge：0,TotalPrice：187.7490000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 ForwarderByID:US001+USPS-B,freightCurrency：USD,TotalPrice：187.7490000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 【US001+USPSGA】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 【US001+UPS2D】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 【US001+UPS2D】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.79，SignatureFee：0.00 2025/10/5 3:13:40 【US001+UPS2D】 TotalPrice：90.32065 2025/10/5 3:13:40 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：623.2124850000000,surcharge：0,TotalPrice：623.2124850000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 【US001+USUPSND】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：623.2124850000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 【US001+USUPSND】 ActualWeight：1.730，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：41.43，SignatureFee：0.00 2025/10/5 3:13:40 【US001+USUPSND】 TotalPrice：91.2155 2025/10/5 3:13:40 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：629.386950000000,surcharge：0,TotalPrice：629.386950000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 【US001+FEDEXDHUS】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 【US001+FEDEXDHUS】 ActualWeight：1.730，CalculationFormula：{标准价格}*1.2*0.85+2.42+14+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 3:13:40 【US001+FEDEXDHUS】 TotalPrice：84.37440 2025/10/5 3:13:40 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：629.386950000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice：582.1833600000000,surcharge：0,TotalPrice：582.1833600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:13:40 【US001+USFEDEXDB】重量计算结果 ActualWeight：1.730 2025/10/5 3:13:40 ForwarderByID:US001+FEDEXDHUS,freightCurrency：USD,TotalPrice：582.1833600000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 【US001+USFEDEXDB】 ActualWeight：1.730，CalculationFormula：{标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.53，SignatureFee：0.00 2025/10/5 3:13:40 【US001+USFEDEXDB】 TotalPrice：65.53 2025/10/5 3:13:40 ForwarderByID:US001+USFEDEXDB,freightCurrency：USD,TotalPrice：452.1570000000,CNYExchangeRate：6.90000000 2025/10/5 3:13:40 ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice：452.1570000000,surcharge：0,TotalPrice：452.1570000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:41 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.078,"Length":9.0,"Width":9.0,"Height":4.0,"Postcode":"76063","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["403"],"AutoDetectionBasicConfig":true} 2025/10/5 3:25:41 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 3:25:41 postcodestr：76063，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:25:41'>=TakeEfficacyDate and '2025-10-05 03:25:41'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:25:41'>=TakeEfficacyDate)) and '76063'>=UPPER(StartPostcode) and '76063'<=UPPER(EndPostCode) 2025/10/5 3:25:41 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:25:41'>=TakeEfficacyDate and '2025-10-05 03:25:41'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:25:41'>=TakeEfficacyDate)) 2025/10/5 3:25:41 【US001+USUPS】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:41 【US001+USUPS】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 3:25:41 【US001+USUPS】 TotalPrice：67.9750 2025/10/5 3:25:41 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:41 【US001+USPSGA】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:41 【US001+USPSGA】 ActualWeight：0.078，CalculationFormula：{标准价格}*0.85，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.32，SignatureFee：0.00 2025/10/5 3:25:41 ForwarderByID:US001+USUPS,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:41 【US001+USPSGA】 TotalPrice：4.5220 2025/10/5 3:25:42 ForwarderByID:US001+USPSGA,freightCurrency：USD,TotalPrice：31.201800000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 ForwarderByID:US001+USPSGA,showShipViaTotalPrice：31.201800000000,surcharge：0,TotalPrice：31.201800000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+UPS2D】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 【US001+UPS2D】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22，SignatureFee：0.00 2025/10/5 3:25:42 【US001+UPS2D】 TotalPrice：83.170 2025/10/5 3:25:42 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：573.87300000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：573.87300000000,surcharge：0,TotalPrice：573.87300000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USUPSND】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 【US001+USUPSND】 ActualWeight：0.078，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：30.88，SignatureFee：0.00 2025/10/5 3:25:42 【US001+USUPSND】 TotalPrice：82.2480 2025/10/5 3:25:42 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：567.511200000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：567.511200000000,surcharge：0,TotalPrice：567.511200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+UPSGROUNDC】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 【US001+UPSGROUNDC】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 3:25:42 【US001+UPSGROUNDC】 TotalPrice：67.9750 2025/10/5 3:25:42 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USPSCB】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 【US001+USPSCB】 TotalPrice：11.07 2025/10/5 3:25:42 【US001+USPSCB】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.07，SignatureFee：0.00 2025/10/5 3:25:42 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：76.3830000000,surcharge：0,TotalPrice：76.3830000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USPSCB】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：76.3830000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 【US001+USPSCB】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：24.4，SignatureFee：0.00 2025/10/5 3:25:42 【US001+USPSCB】 TotalPrice：24.4 2025/10/5 3:25:42 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：168.360000000,surcharge：0,TotalPrice：168.360000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USPSCL】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：168.360000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 【US001+USPSCL】 TotalPrice：4.84 2025/10/5 3:25:42 【US001+USPSCL】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.84，SignatureFee：0.00 2025/10/5 3:25:42 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：33.3960000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：33.3960000000,surcharge：0,TotalPrice：33.3960000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USFEDEXGROUNDC】 ActualWeight：0.078，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 3:25:42 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 3:25:42 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:42 【US001+USFEDEXDH】重量计算结果 ActualWeight：0.078 2025/10/5 3:25:42 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:42 【US001+USFEDEXDH】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.05，SignatureFee：0.00 2025/10/5 3:25:42 【US001+USFEDEXDH】 TotalPrice：27.69100 2025/10/5 3:25:43 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.0679000000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:43 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.0679000000000,surcharge：0,TotalPrice：191.0679000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:50 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"31406","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 3:25:50 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 3:25:50 postcodestr：31406，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:25:50'>=TakeEfficacyDate and '2025-10-05 03:25:50'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:25:50'>=TakeEfficacyDate)) and '31406'>=UPPER(StartPostcode) and '31406'<=UPPER(EndPostCode) 2025/10/5 3:25:50 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:25:50'>=TakeEfficacyDate and '2025-10-05 03:25:50'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:25:50'>=TakeEfficacyDate)) 2025/10/5 3:25:50 【US001+USUPS】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:50 【US001+USUPS】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 3:25:50 【US001+USUPS】 TotalPrice：67.9750 2025/10/5 3:25:50 ForwarderByID:US001+USUPS,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:50 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:50 【US001+USPSGA】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:50 【US001+USPSGA】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.38，SignatureFee：0.00 2025/10/5 3:25:50 【US001+USPSGA】 TotalPrice：4.5730 2025/10/5 3:25:51 ForwarderByID:US001+USPSGA,freightCurrency：USD,TotalPrice：31.553700000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 ForwarderByID:US001+USPSGA,showShipViaTotalPrice：31.553700000000,surcharge：0,TotalPrice：31.553700000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+UPS2D】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22，SignatureFee：0.00 2025/10/5 3:25:51 【US001+UPS2D】 TotalPrice：83.170 2025/10/5 3:25:51 【US001+UPS2D】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：573.87300000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：573.87300000000,surcharge：0,TotalPrice：573.87300000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+USUPSND】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 【US001+USUPSND】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：30.88，SignatureFee：0.00 2025/10/5 3:25:51 【US001+USUPSND】 TotalPrice：82.2480 2025/10/5 3:25:51 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：567.511200000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：567.511200000000,surcharge：0,TotalPrice：567.511200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+UPSGROUNDC】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 3:25:51 【US001+UPSGROUNDC】 TotalPrice：67.9750 2025/10/5 3:25:51 【US001+UPSGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 【US001+USPSCB】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+USPSCB】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.07，SignatureFee：0.00 2025/10/5 3:25:51 【US001+USPSCB】 TotalPrice：11.07 2025/10/5 3:25:51 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：76.3830000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 【US001+USPSCL】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：76.3830000000,surcharge：0,TotalPrice：76.3830000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+USPSCL】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.97，SignatureFee：0.00 2025/10/5 3:25:51 【US001+USPSCL】 TotalPrice：4.97 2025/10/5 3:25:51 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：34.2930000000,surcharge：0,TotalPrice：34.2930000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：34.2930000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 【US001+USFEDEXGROUNDC】 ActualWeight：0.087，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 3:25:51 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 3:25:51 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:25:51 【US001+USFEDEXDH】重量计算结果 ActualWeight：0.087 2025/10/5 3:25:51 【US001+USFEDEXDH】 TotalPrice：27.69100 2025/10/5 3:25:51 【US001+USFEDEXDH】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.05，SignatureFee：0.00 2025/10/5 3:25:51 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.0679000000000,CNYExchangeRate：6.90000000 2025/10/5 3:25:51 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.0679000000000,surcharge：0,TotalPrice：191.0679000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:24 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.650,"Length":14.3,"Width":14.3,"Height":10.0,"Postcode":"93551","DepartureNo":"USWDX","ForwarderByID":[],"WLEmbargoTypeCode":["100"],"AutoDetectionBasicConfig":true} 2025/10/5 3:26:24 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/10/5 3:26:25 postcodestr：93551，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:26:24'>=TakeEfficacyDate and '2025-10-05 03:26:24'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:26:24'>=TakeEfficacyDate)) and '93551'>=UPPER(StartPostcode) and '93551'<=UPPER(EndPostCode) 2025/10/5 3:26:25 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:26:24'>=TakeEfficacyDate and '2025-10-05 03:26:24'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:26:24'>=TakeEfficacyDate)) 2025/10/5 3:26:25 【US001+USUPS】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+USUPS】 TotalPrice：68.6750 2025/10/5 3:26:25 【US001+USUPS】 ActualWeight：0.650，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.14，SignatureFee：0.00 2025/10/5 3:26:25 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：473.857500000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 ForwarderByID:US001+USUPS,showShipViaTotalPrice：473.857500000000,surcharge：0,TotalPrice：473.857500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:25 【US001+USPS-B】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+USPS-B】 ActualWeight：0.650，CalculationFormula：{标准价格}，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：16.82，SignatureFee：0.00 2025/10/5 3:26:25 【US001+USPS-B】 TotalPrice：16.82 2025/10/5 3:26:25 ForwarderByID:US001+USPS-B,freightCurrency：USD,TotalPrice：116.0580000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 ForwarderByID:US001+USPS-B,showShipViaTotalPrice：116.0580000000,surcharge：0,TotalPrice：116.0580000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:25 【US001+USPSGA】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+UPS2D】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+UPS2D】 ActualWeight：0.650，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22.65，SignatureFee：0.00 2025/10/5 3:26:25 【US001+UPS2D】 TotalPrice：83.97275 2025/10/5 3:26:25 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：579.4119750000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：579.4119750000000,surcharge：0,TotalPrice：579.4119750000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:25 【US001+USUPSND】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+USUPSND】 ActualWeight：0.650，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：32.9，SignatureFee：0.00 2025/10/5 3:26:25 【US001+USUPSND】 TotalPrice：83.965 2025/10/5 3:26:25 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：579.35850000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：579.35850000000,surcharge：0,TotalPrice：579.35850000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:25 【US001+FEDEXDHUS】 ActualWeight：0.650，CalculationFormula：{标准价格}*1.2*0.85+2.42+14+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 3:26:25 【US001+FEDEXDHUS】 TotalPrice：84.37440 2025/10/5 3:26:25 【US001+FEDEXDHUS】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice：582.1833600000000,surcharge：0,TotalPrice：582.1833600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:25 ForwarderByID:US001+FEDEXDHUS,freightCurrency：USD,TotalPrice：582.1833600000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 【US001+USFEDEXDB】重量计算结果 ActualWeight：0.650 2025/10/5 3:26:25 【US001+USFEDEXDB】 TotalPrice：64.72 2025/10/5 3:26:25 【US001+USFEDEXDB】 ActualWeight：0.650，CalculationFormula：{标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：8.72，SignatureFee：0.00 2025/10/5 3:26:25 ForwarderByID:US001+USFEDEXDB,freightCurrency：USD,TotalPrice：446.5680000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:25 ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice：446.5680000000,surcharge：0,TotalPrice：446.5680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":1.580,"Length":20.3,"Width":12.3,"Height":26.3,"Postcode":"90605","DepartureNo":"USWDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 3:26:38 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',300,',','+sv.MangoFlag+',')>0 2025/10/5 3:26:38 postcodestr：90605，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:26:38'>=TakeEfficacyDate and '2025-10-05 03:26:38'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:26:38'>=TakeEfficacyDate)) and '90605'>=UPPER(StartPostcode) and '90605'<=UPPER(EndPostCode) 2025/10/5 3:26:38 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPS-B','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+FEDEXDHUS','US001+USFEDEXDB') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 03:26:38'>=TakeEfficacyDate and '2025-10-05 03:26:38'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 03:26:38'>=TakeEfficacyDate)) 2025/10/5 3:26:38 【US001+USUPS】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 【US001+USUPS】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.46，SignatureFee：0.00 2025/10/5 3:26:38 【US001+USUPS】 TotalPrice：69.0750 2025/10/5 3:26:38 ForwarderByID:US001+USUPS,showShipViaTotalPrice：476.617500000000,surcharge：0,TotalPrice：476.617500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：476.617500000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 【US001+USPS-B】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 【US001+USPS-B】 ActualWeight：1.580，CalculationFormula：{标准价格}，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.21，SignatureFee：0.00 2025/10/5 3:26:38 【US001+USPS-B】 TotalPrice：27.21 2025/10/5 3:26:38 ForwarderByID:US001+USPS-B,freightCurrency：USD,TotalPrice：187.7490000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 【US001+USPSGA】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 ForwarderByID:US001+USPS-B,showShipViaTotalPrice：187.7490000000,surcharge：0,TotalPrice：187.7490000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 【US001+UPS2D】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 【US001+UPS2D】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.79，SignatureFee：0.00 2025/10/5 3:26:38 【US001+UPS2D】 TotalPrice：90.32065 2025/10/5 3:26:38 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：623.2124850000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：623.2124850000000,surcharge：0,TotalPrice：623.2124850000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 【US001+USUPSND】 ActualWeight：1.580，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：41.43，SignatureFee：0.00 2025/10/5 3:26:38 【US001+USUPSND】 TotalPrice：91.2155 2025/10/5 3:26:38 【US001+USUPSND】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：629.386950000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：629.386950000000,surcharge：0,TotalPrice：629.386950000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 【US001+FEDEXDHUS】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 【US001+FEDEXDHUS】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.2*0.85+2.42+14+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 3:26:38 【US001+FEDEXDHUS】 TotalPrice：84.37440 2025/10/5 3:26:38 ForwarderByID:US001+FEDEXDHUS,freightCurrency：USD,TotalPrice：582.1833600000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 ForwarderByID:US001+FEDEXDHUS,showShipViaTotalPrice：582.1833600000000,surcharge：0,TotalPrice：582.1833600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 【US001+USFEDEXDB】重量计算结果 ActualWeight：1.580 2025/10/5 3:26:38 【US001+USFEDEXDB】 TotalPrice：65.53 2025/10/5 3:26:38 ForwarderByID:US001+USFEDEXDB,freightCurrency：USD,TotalPrice：452.1570000000,CNYExchangeRate：6.90000000 2025/10/5 3:26:38 ForwarderByID:US001+USFEDEXDB,showShipViaTotalPrice：452.1570000000,surcharge：0,TotalPrice：452.1570000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 3:26:38 【US001+USFEDEXDB】 ActualWeight：1.580，CalculationFormula：{标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.53，SignatureFee：0.00 2025/10/5 8:29:09 开始运费计算，参数： {"PlatformId":118,"CountryShort":"FR","TotalWeight":46.000,"Length":132.0,"Width":30.0,"Height":59.0,"Postcode":"34740","DepartureNo":"PLTMDX","ForwarderByID":[],"WLEmbargoTypeCode":["801"],"AutoDetectionBasicConfig":true} 2025/10/5 8:29:09 SQL_ShipViaList： and svp.PlatFormId='118' and CHARINDEX(',372,',','+sv.MangoFlag+',')>0 2025/10/5 8:29:09 postcodestr：34740，countryId：40，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:29:09'>=TakeEfficacyDate and '2025-10-05 08:29:09'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:29:09'>=TakeEfficacyDate)) and '34740'>=UPPER(StartPostcode) and '34740'<=UPPER(EndPostCode) 2025/10/5 8:29:10 postcodestr：347，countryId：40，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:29:09'>=TakeEfficacyDate and '2025-10-05 08:29:09'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:29:09'>=TakeEfficacyDate)) and '347'>=UPPER(StartPostcode) and '347'<=UPPER(EndPostCode) 2025/10/5 8:29:10 countryId：40，SQL_ShipPrice_Country： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:29:09'>=TakeEfficacyDate and '2025-10-05 08:29:09'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:29:09'>=TakeEfficacyDate)) 2025/10/5 8:29:10 【HS006+FEDEX】重量计算结果 ActualWeight：46.728 2025/10/5 8:29:10 【HS006+FEDEX】 ActualWeight：46.728，CalculationFormula：{标准价格}*1.25，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：291.89，SignatureFee：0.00 2025/10/5 8:29:10 【HS006+FEDEX】 TotalPrice：364.8625 2025/10/5 8:29:10 ForwarderByID:HS006+FEDEX,freightCurrency：PLN,TotalPrice：685.941500000000,CNYExchangeRate：1.88000000 2025/10/5 8:29:10 ForwarderByID:HS006+FEDEX,showShipViaTotalPrice：685.941500000000,surcharge：0,TotalPrice：685.941500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 8:29:10 【HS006+FEDEXFREIGHT】重量计算结果 ActualWeight：46.000 2025/10/5 8:29:10 【HS006+FEDEXFREIGHT】 ActualWeight：46.000，CalculationFormula：{标准价格}*1.25+205，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：331.89，SignatureFee：0.00 2025/10/5 8:29:10 【HS006+FEDEXFREIGHT】 TotalPrice：619.8625 2025/10/5 8:29:10 ForwarderByID:HS006+FEDEXFREIGHT,freightCurrency：PLN,TotalPrice：1165.341500000000,CNYExchangeRate：1.88000000 2025/10/5 8:29:10 ForwarderByID:HS006+FEDEXFREIGHT,showShipViaTotalPrice：1165.341500000000,surcharge：0,TotalPrice：1165.341500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 8:29:10 【SZ039+HSUPSDJ】重量计算结果 ActualWeight：46.728 2025/10/5 8:29:10 【SZ039+HSUPSDJ】重量不符合条件，尺寸限制-重量：15.0000，ActualWeight：46.728 2025/10/5 8:29:10 【SZ039+HSUPS】 ActualWeight：46.728，CalculationFormula：{标准价格}*{燃油费率}*1.25+100+204，FuelRates：1.5，Discount：1.85082，RegisteredFee：0.0000，PriceMethod：175.76，SignatureFee：0.00 2025/10/5 8:29:10 【SZ039+HSUPS】 TotalPrice：633.55000 2025/10/5 8:29:10 【SZ039+HSUPS】重量计算结果 ActualWeight：46.728 2025/10/5 8:29:10 【SZ039+HSUPS】匹配可运违禁类型，国家：40，邮路编码：0531 可运违禁类型参数值：【801】 邮路配置的可运违禁类型：【普货(100)，无电池的电子产品(101)，小剪刀类(201)，螺丝刀工具类(202)，折刀类(203)，管制刀具类(204)，大剪刀类(205)，强磁性产品(301)，弱磁性产品(302)，手表类(401)，纽扣电池(402)，蓝牙、小电池产品(403)，内置电池(404)，配套电池(405)，柱状纯电池(406)，≤2600MAH的纯电池(407)，＞2600MAH的纯电池(408)，粉末类(501)，膏状类产品(502)，清洁胶产品(503)，液体类(601)，轻抛类(701)，带液体产品(702)，配套电池可转内置(40401)，植物类花草树木种子类产品(901)，电子烟(110)，蜡烛(102)，易燃易爆类(902)】 2025/10/5 8:29:10 【HS003+HSGLSEU】重量计算结果 ActualWeight：46.000 2025/10/5 8:32:02 开始运费计算，参数： {"PlatformId":118,"CountryShort":"FR","TotalWeight":46.000,"Length":132.0,"Width":30.0,"Height":59.0,"Postcode":"34740","DepartureNo":"PLTMDX","ForwarderByID":[],"WLEmbargoTypeCode":["801"],"AutoDetectionBasicConfig":true} 2025/10/5 8:32:02 SQL_ShipViaList： and svp.PlatFormId='118' and CHARINDEX(',372,',','+sv.MangoFlag+',')>0 2025/10/5 8:32:02 postcodestr：34740，countryId：40，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:32:02'>=TakeEfficacyDate and '2025-10-05 08:32:02'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:32:02'>=TakeEfficacyDate)) and '34740'>=UPPER(StartPostcode) and '34740'<=UPPER(EndPostCode) 2025/10/5 8:32:02 postcodestr：347，countryId：40，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:32:02'>=TakeEfficacyDate and '2025-10-05 08:32:02'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:32:02'>=TakeEfficacyDate)) and '347'>=UPPER(StartPostcode) and '347'<=UPPER(EndPostCode) 2025/10/5 8:32:02 countryId：40，SQL_ShipPrice_Country： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 08:32:02'>=TakeEfficacyDate and '2025-10-05 08:32:02'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 08:32:02'>=TakeEfficacyDate)) 2025/10/5 8:32:02 【HS006+FEDEX】重量计算结果 ActualWeight：46.728 2025/10/5 8:32:02 【HS006+FEDEX】 ActualWeight：46.728，CalculationFormula：{标准价格}*1.25，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：291.89，SignatureFee：0.00 2025/10/5 8:32:02 【HS006+FEDEX】 TotalPrice：364.8625 2025/10/5 8:32:02 ForwarderByID:HS006+FEDEX,showShipViaTotalPrice：685.941500000000,surcharge：0,TotalPrice：685.941500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 8:32:02 【HS006+FEDEXFREIGHT】重量计算结果 ActualWeight：46.000 2025/10/5 8:32:02 ForwarderByID:HS006+FEDEX,freightCurrency：PLN,TotalPrice：685.941500000000,CNYExchangeRate：1.88000000 2025/10/5 8:32:02 【HS006+FEDEXFREIGHT】 ActualWeight：46.000，CalculationFormula：{标准价格}*1.25+205，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：331.89，SignatureFee：0.00 2025/10/5 8:32:02 【HS006+FEDEXFREIGHT】 TotalPrice：619.8625 2025/10/5 8:32:02 ForwarderByID:HS006+FEDEXFREIGHT,showShipViaTotalPrice：1165.341500000000,surcharge：0,TotalPrice：1165.341500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 8:32:02 ForwarderByID:HS006+FEDEXFREIGHT,freightCurrency：PLN,TotalPrice：1165.341500000000,CNYExchangeRate：1.88000000 2025/10/5 8:32:02 【SZ039+HSUPSDJ】重量计算结果 ActualWeight：46.728 2025/10/5 8:32:02 【SZ039+HSUPSDJ】重量不符合条件，尺寸限制-重量：15.0000，ActualWeight：46.728 2025/10/5 8:32:02 【SZ039+HSUPS】 ActualWeight：46.728，CalculationFormula：{标准价格}*{燃油费率}*1.25+100+204，FuelRates：1.5，Discount：1.85082，RegisteredFee：0.0000，PriceMethod：175.76，SignatureFee：0.00 2025/10/5 8:32:02 【SZ039+HSUPS】重量计算结果 ActualWeight：46.728 2025/10/5 8:32:02 【SZ039+HSUPS】 TotalPrice：633.55000 2025/10/5 8:32:02 【SZ039+HSUPS】匹配可运违禁类型，国家：40，邮路编码：0531 可运违禁类型参数值：【801】 邮路配置的可运违禁类型：【普货(100)，无电池的电子产品(101)，小剪刀类(201)，螺丝刀工具类(202)，折刀类(203)，管制刀具类(204)，大剪刀类(205)，强磁性产品(301)，弱磁性产品(302)，手表类(401)，纽扣电池(402)，蓝牙、小电池产品(403)，内置电池(404)，配套电池(405)，柱状纯电池(406)，≤2600MAH的纯电池(407)，＞2600MAH的纯电池(408)，粉末类(501)，膏状类产品(502)，清洁胶产品(503)，液体类(601)，轻抛类(701)，带液体产品(702)，配套电池可转内置(40401)，植物类花草树木种子类产品(901)，电子烟(110)，蜡烛(102)，易燃易爆类(902)】 2025/10/5 8:32:02 【HS003+HSGLSEU】重量计算结果 ActualWeight：46.000 2025/10/5 10:20:51 开始运费计算，参数： {"PlatformId":125,"CountryShort":"SK","TotalWeight":1.078,"Length":25.8,"Width":13.0,"Height":9.7,"Postcode":"831 02","DepartureNo":"PLTMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 10:20:51 SQL_ShipViaList： and svp.PlatFormId='125' and CHARINDEX(',372,',','+sv.MangoFlag+',')>0 2025/10/5 10:20:51 postcodestr：831 0，countryId：565，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 10:20:51'>=TakeEfficacyDate and '2025-10-05 10:20:51'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:20:51'>=TakeEfficacyDate)) and '831 0'>=UPPER(StartPostcode) and '831 0'<=UPPER(EndPostCode) 2025/10/5 10:20:51 postcodestr：831，countryId：565，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 10:20:51'>=TakeEfficacyDate and '2025-10-05 10:20:51'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:20:51'>=TakeEfficacyDate)) and '831'>=UPPER(StartPostcode) and '831'<=UPPER(EndPostCode) 2025/10/5 10:20:51 countryId：565，SQL_ShipPrice_Country： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 10:20:51'>=TakeEfficacyDate and '2025-10-05 10:20:51'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:20:51'>=TakeEfficacyDate)) 2025/10/5 10:20:51 【HS+DPD-BIG】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:51 【HS+DPD-BIG】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.12，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.73，SignatureFee：0.00 2025/10/5 10:20:51 【HS+DPD-BIG】 TotalPrice：5.2976 2025/10/5 10:20:52 ForwarderByID:HS+DPD-BIG,freightCurrency：EUR,TotalPrice：42.380800000000,CNYExchangeRate：8.00000000 2025/10/5 10:20:52 ForwarderByID:HS+DPD-BIG,showShipViaTotalPrice：42.380800000000,surcharge：0,TotalPrice：42.380800000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:20:52 【HS006+FEDEX】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【HS006+FEDEX】 TotalPrice：28.75 2025/10/5 10:20:52 【HS006+FEDEX】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：23，SignatureFee：0.00 2025/10/5 10:20:52 ForwarderByID:HS006+FEDEX,freightCurrency：PLN,TotalPrice：54.0500000000,CNYExchangeRate：1.88000000 2025/10/5 10:20:52 ForwarderByID:HS006+FEDEX,showShipViaTotalPrice：54.0500000000,surcharge：0,TotalPrice：54.0500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:20:52 【HS006+FEDEXFREIGHT】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【HS006+FEDEXFREIGHT】 TotalPrice：458.75 2025/10/5 10:20:52 【HS006+FEDEXFREIGHT】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25+205，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：203，SignatureFee：0.00 2025/10/5 10:20:52 【HS+DPD】 TotalPrice：5.7233 2025/10/5 10:20:52 【HS+DPD】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【HS+DPD】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.21，FuelRates：1.4，Discount：0，RegisteredFee：1.2300，PriceMethod：4.73，SignatureFee：0.00 2025/10/5 10:20:52 【HS006+FEDEXFREIGHT】匹配可运违禁类型，国家：565，邮路编码：1923 可运违禁类型参数值：【101】 邮路配置的可运违禁类型：【普货(100)，平衡车类(801)，自行车类(802)】 2025/10/5 10:20:52 ForwarderByID:HS+DPD,showShipViaTotalPrice：45.786400000000,surcharge：0,TotalPrice：45.786400000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:20:52 【SZ039+HSUPSDJ】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【SZ039+HSUPSDJ】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.1*{运费折扣}*1.23*{燃油费率}+100+400，FuelRates：1.145，Discount：1.985082，RegisteredFee：0.0000，PriceMethod：30.26，SignatureFee：0.00 2025/10/5 10:20:52 【SZ039+HSUPSDJ】 TotalPrice：593.05734515222420 2025/10/5 10:20:52 ForwarderByID:HS+DPD,freightCurrency：EUR,TotalPrice：45.786400000000,CNYExchangeRate：8.00000000 2025/10/5 10:20:52 ForwarderByID:SZ039+HSUPSDJ,showShipViaTotalPrice：593.05734515222420,surcharge：0,TotalPrice：593.05734515222420,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:20:52 【SZ039+HSUPS】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【SZ039+HSUPS】 TotalPrice：437.125 2025/10/5 10:20:52 【SZ039+HSUPS】 ActualWeight：1.078，CalculationFormula：{标准价格}*{燃油费率}*1.25+100+204，FuelRates：1.5，Discount：1.85082，RegisteredFee：0.0000，PriceMethod：71，SignatureFee：0.00 2025/10/5 10:20:52 ForwarderByID:SZ039+HSUPS,freightCurrency：PLN,TotalPrice：821.79500000000,CNYExchangeRate：1.88000000 2025/10/5 10:20:52 ForwarderByID:SZ039+HSUPS,showShipViaTotalPrice：821.79500000000,surcharge：0,TotalPrice：821.79500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:20:52 【HS003+HSGLSEU】重量计算结果 ActualWeight：1.078 2025/10/5 10:20:52 【HS003+HSGLSEU】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：1.25，Discount：0，RegisteredFee：0.2400，PriceMethod：5.22，SignatureFee：0.00 2025/10/5 10:20:52 【HS003+HSGLSEU】 TotalPrice：6.5250 2025/10/5 10:20:52 ForwarderByID:HS003+HSGLSEU,freightCurrency：EUR,TotalPrice：52.200000000000,CNYExchangeRate：8.00000000 2025/10/5 10:20:52 ForwarderByID:HS003+HSGLSEU,showShipViaTotalPrice：52.200000000000,surcharge：0,TotalPrice：52.200000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:21:39 开始运费计算，参数： {"PlatformId":125,"CountryShort":"GR","TotalWeight":0.050,"Length":14.3,"Width":9.0,"Height":3.5,"Postcode":"173 43","DepartureNo":"PLFLYDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 10:21:39 SQL_ShipViaList： and svp.PlatFormId='125' and CHARINDEX(',324,',','+sv.MangoFlag+',')>0 2025/10/5 10:21:39 postcodestr：173 4，countryId：30，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-10-05 10:21:39'>=TakeEfficacyDate and '2025-10-05 10:21:39'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:21:39'>=TakeEfficacyDate)) and '173 4'>=UPPER(StartPostcode) and '173 4'<=UPPER(EndPostCode) 2025/10/5 10:21:39 postcodestr：173，countryId：30，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-10-05 10:21:39'>=TakeEfficacyDate and '2025-10-05 10:21:39'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:21:39'>=TakeEfficacyDate)) and '173'>=UPPER(StartPostcode) and '173'<=UPPER(EndPostCode) 2025/10/5 10:21:39 countryId：30，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-10-05 10:21:39'>=TakeEfficacyDate and '2025-10-05 10:21:39'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 10:21:39'>=TakeEfficacyDate)) 2025/10/5 10:21:39 【FYL1+PLGLSEU】重量计算结果 ActualWeight：0.075075 2025/10/5 10:21:39 【FYL1+PLGLSEU】 ActualWeight：0.075075，CalculationFormula：{标准价格}*1.25+13+4+1.2，FuelRates：1.3，Discount：0，RegisteredFee：0.0000，PriceMethod：85.3088，SignatureFee：0.00 2025/10/5 10:21:39 【FYL1+PLGLSEU】 TotalPrice：124.836000 2025/10/5 10:21:39 ForwarderByID:FYL1+PLGLSEU,showShipViaTotalPrice：234.69168000000000,surcharge：0,TotalPrice：234.69168000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:21:39 【FYL1+EUDPD】重量计算结果 ActualWeight：0.050 2025/10/5 10:21:39 ForwarderByID:FYL1+PLGLSEU,freightCurrency：PLN,TotalPrice：234.69168000000000,CNYExchangeRate：1.88000000 2025/10/5 10:21:39 【FYL1+EUDPD】 ActualWeight：0.050，CalculationFormula：{标准价格}*1.25+3+3.2，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：7.72，SignatureFee：0.00 2025/10/5 10:21:39 【FYL1+EUDPD】 TotalPrice：15.8500 2025/10/5 10:21:40 ForwarderByID:FYL1+EUDPD,showShipViaTotalPrice：126.800000000000,surcharge：0,TotalPrice：126.800000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 10:21:40 【FYL1+PLDPDEUBZ】 TotalPrice：59.512 2025/10/5 10:21:40 ForwarderByID:FYL1+EUDPD,freightCurrency：EUR,TotalPrice：126.800000000000,CNYExchangeRate：8.00000000 2025/10/5 10:21:40 【FYL1+PLDPDEUBZ】重量计算结果 ActualWeight：0.050 2025/10/5 10:21:40 【FYL1+PLDPDEUBZ】 ActualWeight：0.050，CalculationFormula：{标准价格}*1.3+15，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：34.24，SignatureFee：0.00 2025/10/5 10:21:40 ForwarderByID:FYL1+PLDPDEUBZ,freightCurrency：PLN,TotalPrice：111.88256000000,CNYExchangeRate：1.88000000 2025/10/5 10:21:40 ForwarderByID:FYL1+PLDPDEUBZ,showShipViaTotalPrice：111.88256000000,surcharge：0,TotalPrice：111.88256000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":1.580,"Length":20.3,"Width":12.3,"Height":26.3,"Postcode":"60601","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 12:25:35 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 12:25:35 postcodestr：60601，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:25:35'>=TakeEfficacyDate and '2025-10-05 12:25:35'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:25:35'>=TakeEfficacyDate)) and '60601'>=UPPER(StartPostcode) and '60601'<=UPPER(EndPostCode) 2025/10/5 12:25:35 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:25:35'>=TakeEfficacyDate and '2025-10-05 12:25:35'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:25:35'>=TakeEfficacyDate)) 2025/10/5 12:25:35 【US001+USUPS】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USUPS】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.46，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USUPS】 TotalPrice：69.0750 2025/10/5 12:25:35 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：476.617500000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USUPS,showShipViaTotalPrice：476.617500000000,surcharge：0,TotalPrice：476.617500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USPSGA】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+UPS2D】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+UPS2D】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：27.79，SignatureFee：0.00 2025/10/5 12:25:35 【US001+UPS2D】 TotalPrice：90.32065 2025/10/5 12:25:35 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：623.2124850000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：623.2124850000000,surcharge：0,TotalPrice：623.2124850000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USUPSND】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USUPSND】 TotalPrice：91.2155 2025/10/5 12:25:35 【US001+USUPSND】 ActualWeight：1.580，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：41.43，SignatureFee：0.00 2025/10/5 12:25:35 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：629.386950000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 【US001+UPSGROUNDC】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+UPSGROUNDC】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.46，SignatureFee：0.00 2025/10/5 12:25:35 【US001+UPSGROUNDC】 TotalPrice：69.0750 2025/10/5 12:25:35 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：629.386950000000,surcharge：0,TotalPrice：629.386950000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：476.617500000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 【US001+USPSCB】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：476.617500000000,surcharge：0,TotalPrice：476.617500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USPSCB】 ActualWeight：1.580，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.85，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USPSCB】 TotalPrice：10.85 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：74.8650000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 【US001+USPSCB】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USPSCB】 ActualWeight：1.580，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：16.09，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USPSCB】 TotalPrice：16.09 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：74.8650000000,surcharge：0,TotalPrice：74.8650000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：111.0210000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：111.0210000000,surcharge：0,TotalPrice：111.0210000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USPSCB】 ActualWeight：1.580，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：60.95，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USPSCB】 TotalPrice：60.95 2025/10/5 12:25:35 【US001+USPSCB】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：420.5550000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：420.5550000000,surcharge：0,TotalPrice：420.5550000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USPSCL】 ActualWeight：1.580，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.76，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USPSCL】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USPSCL】 TotalPrice：10.76 2025/10/5 12:25:35 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：74.2440000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：74.2440000000,surcharge：0,TotalPrice：74.2440000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USFEDEXGROUNDC】 ActualWeight：1.580，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 12:25:35 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:35 【US001+USFEDEXDH】重量计算结果 ActualWeight：1.580 2025/10/5 12:25:35 【US001+USFEDEXDH】 ActualWeight：1.580，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.09，SignatureFee：0.00 2025/10/5 12:25:35 【US001+USFEDEXDH】 TotalPrice：27.73180 2025/10/5 12:25:35 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.3494200000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:35 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.3494200000000,surcharge：0,TotalPrice：191.3494200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:38 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"30132","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 12:25:39 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 12:25:39 postcodestr：30132，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:25:38'>=TakeEfficacyDate and '2025-10-05 12:25:38'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:25:38'>=TakeEfficacyDate)) and '30132'>=UPPER(StartPostcode) and '30132'<=UPPER(EndPostCode) 2025/10/5 12:25:39 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:25:38'>=TakeEfficacyDate and '2025-10-05 12:25:38'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:25:38'>=TakeEfficacyDate)) 2025/10/5 12:25:39 【US001+USUPS】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USUPS】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:25:39 【US001+USUPS】 TotalPrice：67.9750 2025/10/5 12:25:39 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 ForwarderByID:US001+USUPS,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+USPSGA】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USPSGA】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.38，SignatureFee：0.00 2025/10/5 12:25:39 【US001+USPSGA】 TotalPrice：4.5730 2025/10/5 12:25:39 ForwarderByID:US001+USPSGA,freightCurrency：USD,TotalPrice：31.553700000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 【US001+UPS2D】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+UPS2D】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22，SignatureFee：0.00 2025/10/5 12:25:39 【US001+UPS2D】 TotalPrice：83.170 2025/10/5 12:25:39 ForwarderByID:US001+USPSGA,showShipViaTotalPrice：31.553700000000,surcharge：0,TotalPrice：31.553700000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：573.87300000000,surcharge：0,TotalPrice：573.87300000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+USUPSND】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USUPSND】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：30.88，SignatureFee：0.00 2025/10/5 12:25:39 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：573.87300000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 【US001+USUPSND】 TotalPrice：82.2480 2025/10/5 12:25:39 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：567.511200000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 【US001+UPSGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：567.511200000000,surcharge：0,TotalPrice：567.511200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+UPSGROUNDC】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:25:39 【US001+UPSGROUNDC】 TotalPrice：67.9750 2025/10/5 12:25:39 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+USPSCB】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.07，SignatureFee：0.00 2025/10/5 12:25:39 【US001+USPSCB】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USPSCB】 TotalPrice：11.07 2025/10/5 12:25:39 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：76.3830000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：76.3830000000,surcharge：0,TotalPrice：76.3830000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+USPSCL】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USPSCL】 TotalPrice：5.38 2025/10/5 12:25:39 【US001+USPSCL】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.38，SignatureFee：0.00 2025/10/5 12:25:39 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：37.1220000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：37.1220000000,surcharge：0,TotalPrice：37.1220000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 12:25:39 【US001+USFEDEXGROUNDC】 ActualWeight：0.087，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 12:25:39 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 【US001+USFEDEXDH】重量计算结果 ActualWeight：0.087 2025/10/5 12:25:39 【US001+USFEDEXDH】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.05，SignatureFee：0.00 2025/10/5 12:25:39 【US001+USFEDEXDH】 TotalPrice：27.69100 2025/10/5 12:25:39 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:25:39 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.0679000000000,CNYExchangeRate：6.90000000 2025/10/5 12:25:39 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.0679000000000,surcharge：0,TotalPrice：191.0679000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.087,"Length":12.0,"Width":9.0,"Height":2.3,"Postcode":"46074","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 12:26:19 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 12:26:19 postcodestr：46074，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:26:19'>=TakeEfficacyDate and '2025-10-05 12:26:19'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:26:19'>=TakeEfficacyDate)) and '46074'>=UPPER(StartPostcode) and '46074'<=UPPER(EndPostCode) 2025/10/5 12:26:19 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:26:19'>=TakeEfficacyDate and '2025-10-05 12:26:19'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:26:19'>=TakeEfficacyDate)) 2025/10/5 12:26:19 【US001+USUPS】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USUPS】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:26:19 【US001+USUPS】 TotalPrice：67.9750 2025/10/5 12:26:19 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+USUPS,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USPSGA】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USPSGA】 TotalPrice：4.5730 2025/10/5 12:26:19 【US001+USPSGA】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.38，SignatureFee：0.00 2025/10/5 12:26:19 ForwarderByID:US001+USPSGA,freightCurrency：USD,TotalPrice：31.553700000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+USPSGA,showShipViaTotalPrice：31.553700000000,surcharge：0,TotalPrice：31.553700000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+UPS2D】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+UPS2D】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22，SignatureFee：0.00 2025/10/5 12:26:19 【US001+UPS2D】 TotalPrice：83.170 2025/10/5 12:26:19 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：573.87300000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：573.87300000000,surcharge：0,TotalPrice：573.87300000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USUPSND】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USUPSND】 ActualWeight：0.087，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：30.88，SignatureFee：0.00 2025/10/5 12:26:19 【US001+USUPSND】 TotalPrice：82.2480 2025/10/5 12:26:19 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：567.511200000000,surcharge：0,TotalPrice：567.511200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：567.511200000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 【US001+UPSGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+UPSGROUNDC】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:26:19 【US001+UPSGROUNDC】 TotalPrice：67.9750 2025/10/5 12:26:19 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 【US001+USPSCB】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USPSCB】 TotalPrice：10.11 2025/10/5 12:26:19 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USPSCB】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：10.11，SignatureFee：0.00 2025/10/5 12:26:19 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：69.7590000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：69.7590000000,surcharge：0,TotalPrice：69.7590000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USPSCB】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USPSCB】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.67，SignatureFee：0.00 2025/10/5 12:26:19 【US001+USPSCB】 TotalPrice：11.67 2025/10/5 12:26:19 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：80.5230000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：80.5230000000,surcharge：0,TotalPrice：80.5230000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USPSCL】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USPSCL】 ActualWeight：0.087，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.71，SignatureFee：0.00 2025/10/5 12:26:19 【US001+USPSCL】 TotalPrice：4.71 2025/10/5 12:26:19 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：32.4990000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：32.4990000000,surcharge：0,TotalPrice：32.4990000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USFEDEXGROUNDC】 ActualWeight：0.087，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 12:26:19 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 12:26:19 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:19 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:19 【US001+USFEDEXDH】重量计算结果 ActualWeight：0.087 2025/10/5 12:26:19 【US001+USFEDEXDH】 TotalPrice：27.69100 2025/10/5 12:26:19 【US001+USFEDEXDH】 ActualWeight：0.087，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.05，SignatureFee：0.00 2025/10/5 12:26:20 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.0679000000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:20 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.0679000000000,surcharge：0,TotalPrice：191.0679000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 开始运费计算，参数： {"PlatformId":55,"CountryShort":"US","TotalWeight":0.078,"Length":9.0,"Width":9.0,"Height":4.0,"Postcode":"33710","DepartureNo":"USMDX","ForwarderByID":[],"WLEmbargoTypeCode":["403"],"AutoDetectionBasicConfig":true} 2025/10/5 12:26:35 SQL_ShipViaList： and svp.PlatFormId='55' and CHARINDEX(',302,',','+sv.MangoFlag+',')>0 2025/10/5 12:26:35 postcodestr：33710，countryId：43，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:26:35'>=TakeEfficacyDate and '2025-10-05 12:26:35'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:26:35'>=TakeEfficacyDate)) and '33710'>=UPPER(StartPostcode) and '33710'<=UPPER(EndPostCode) 2025/10/5 12:26:35 countryId：43，SQL_ShipPrice_Country： and p.ForwarderByID in ('US001+USUPS','US001+USPSGA','US001+UPS2D','US001+USUPSND','US001+UPSGROUNDC','US001+USPSCB','US001+USPSCL','US001+USFEDEXGROUNDC','US001+USFEDEXDH') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 12:26:35'>=TakeEfficacyDate and '2025-10-05 12:26:35'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 12:26:35'>=TakeEfficacyDate)) 2025/10/5 12:26:35 【US001+USUPS】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USUPS】 TotalPrice：67.9750 2025/10/5 12:26:35 【US001+USUPS】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:26:35 ForwarderByID:US001+USUPS,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 【US001+USPSGA】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USPSGA】 ActualWeight：0.078，CalculationFormula：{标准价格}*0.85，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：5.32，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USPSGA】 TotalPrice：4.5220 2025/10/5 12:26:35 ForwarderByID:US001+USUPS,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 ForwarderByID:US001+USPSGA,freightCurrency：USD,TotalPrice：31.201800000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 【US001+UPS2D】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.3*0.95+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：22，SignatureFee：0.00 2025/10/5 12:26:35 【US001+UPS2D】 TotalPrice：83.170 2025/10/5 12:26:35 ForwarderByID:US001+USPSGA,showShipViaTotalPrice：31.201800000000,surcharge：0,TotalPrice：31.201800000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+UPS2D】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 ForwarderByID:US001+UPS2D,freightCurrency：USD,TotalPrice：573.87300000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 【US001+USUPSND】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 ForwarderByID:US001+UPS2D,showShipViaTotalPrice：573.87300000000,surcharge：0,TotalPrice：573.87300000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+USUPSND】 ActualWeight：0.078，CalculationFormula：{标准价格}*0.85+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：30.88，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USUPSND】 TotalPrice：82.2480 2025/10/5 12:26:35 ForwarderByID:US001+USUPSND,freightCurrency：USD,TotalPrice：567.511200000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+USUPSND,showShipViaTotalPrice：567.511200000000,surcharge：0,TotalPrice：567.511200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+UPSGROUNDC】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+UPSGROUNDC】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.25+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：9.58，SignatureFee：0.00 2025/10/5 12:26:35 【US001+UPSGROUNDC】 TotalPrice：67.9750 2025/10/5 12:26:35 ForwarderByID:US001+UPSGROUNDC,freightCurrency：USD,TotalPrice：469.027500000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+UPSGROUNDC,showShipViaTotalPrice：469.027500000000,surcharge：0,TotalPrice：469.027500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+USPSCB】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.07，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USPSCB】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USPSCB】 TotalPrice：11.07 2025/10/5 12:26:35 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：76.3830000000,surcharge：0,TotalPrice：76.3830000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：76.3830000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 【US001+USPSCB】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.67，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USPSCB】 TotalPrice：11.67 2025/10/5 12:26:35 【US001+USPSCB】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 ForwarderByID:US001+USPSCB,freightCurrency：USD,TotalPrice：80.5230000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+USPSCB,showShipViaTotalPrice：80.5230000000,surcharge：0,TotalPrice：80.5230000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+USPSCL】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USPSCL】 ActualWeight：0.078，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.95，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USPSCL】 TotalPrice：4.95 2025/10/5 12:26:35 ForwarderByID:US001+USPSCL,freightCurrency：USD,TotalPrice：34.1550000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+USPSCL,showShipViaTotalPrice：34.1550000000,surcharge：0,TotalPrice：34.1550000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+USFEDEXGROUNDC】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USFEDEXGROUNDC】 TotalPrice：67.72 2025/10/5 12:26:35 【US001+USFEDEXGROUNDC】 ActualWeight：0.078，CalculationFormula： {标准价格}+56，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：11.72，SignatureFee：0.00 2025/10/5 12:26:35 ForwarderByID:US001+USFEDEXGROUNDC,freightCurrency：USD,TotalPrice：467.2680000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+USFEDEXGROUNDC,showShipViaTotalPrice：467.2680000000,surcharge：0,TotalPrice：467.2680000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 12:26:35 【US001+USFEDEXDH】重量计算结果 ActualWeight：0.078 2025/10/5 12:26:35 【US001+USFEDEXDH】 ActualWeight：0.078，CalculationFormula：{标准价格}*1.2*0.85+2.42+14，FuelRates：1.2，Discount：0，RegisteredFee：0.0000，PriceMethod：11.05，SignatureFee：0.00 2025/10/5 12:26:35 【US001+USFEDEXDH】 TotalPrice：27.69100 2025/10/5 12:26:35 ForwarderByID:US001+USFEDEXDH,freightCurrency：USD,TotalPrice：191.0679000000000,CNYExchangeRate：6.90000000 2025/10/5 12:26:35 ForwarderByID:US001+USFEDEXDH,showShipViaTotalPrice：191.0679000000000,surcharge：0,TotalPrice：191.0679000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 开始运费计算，参数： {"PlatformId":128,"CountryShort":"DE","TotalWeight":1.078,"Length":25.8,"Width":13.0,"Height":9.7,"Postcode":"08289","DepartureNo":"PLTMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 16:54:49 SQL_ShipViaList： and svp.PlatFormId='128' and CHARINDEX(',372,',','+sv.MangoFlag+',')>0 2025/10/5 16:54:49 postcodestr：08289，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 16:54:49'>=TakeEfficacyDate and '2025-10-05 16:54:49'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 16:54:49'>=TakeEfficacyDate)) and '08289'>=UPPER(StartPostcode) and '08289'<=UPPER(EndPostCode) 2025/10/5 16:54:49 postcodestr：082，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 16:54:49'>=TakeEfficacyDate and '2025-10-05 16:54:49'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 16:54:49'>=TakeEfficacyDate)) and '082'>=UPPER(StartPostcode) and '082'<=UPPER(EndPostCode) 2025/10/5 16:54:49 countryId：38，SQL_ShipPrice_Country： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 16:54:49'>=TakeEfficacyDate and '2025-10-05 16:54:49'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 16:54:49'>=TakeEfficacyDate)) 2025/10/5 16:54:49 【HS+DPD-BIG】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【HS+DPD-BIG】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.12，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：6.68，SignatureFee：0.00 2025/10/5 16:54:49 【HS+DPD-BIG】 TotalPrice：7.4816 2025/10/5 16:54:49 ForwarderByID:HS+DPD-BIG,freightCurrency：EUR,TotalPrice：59.852800000000,CNYExchangeRate：8.00000000 2025/10/5 16:54:49 ForwarderByID:HS+DPD-BIG,showShipViaTotalPrice：59.852800000000,surcharge：0,TotalPrice：59.852800000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 【HS006+FEDEX】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【HS006+FEDEX】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：23，SignatureFee：0.00 2025/10/5 16:54:49 【HS006+FEDEX】 TotalPrice：28.75 2025/10/5 16:54:49 ForwarderByID:HS006+FEDEX,freightCurrency：PLN,TotalPrice：54.0500000000,CNYExchangeRate：1.88000000 2025/10/5 16:54:49 ForwarderByID:HS006+FEDEX,showShipViaTotalPrice：54.0500000000,surcharge：0,TotalPrice：54.0500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 【HS006+FEDEXFREIGHT】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【HS006+FEDEXFREIGHT】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25+205，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：203，SignatureFee：0.00 2025/10/5 16:54:49 【HS006+FEDEXFREIGHT】 TotalPrice：458.75 2025/10/5 16:54:49 【HS+DPD】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【HS+DPD】 TotalPrice：8.0828 2025/10/5 16:54:49 【HS006+FEDEXFREIGHT】匹配可运违禁类型，国家：38，邮路编码：1923 可运违禁类型参数值：【101】 邮路配置的可运违禁类型：【普货(100)，平衡车类(801)，自行车类(802)】 2025/10/5 16:54:49 【HS+DPD】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.21，FuelRates：1.4，Discount：0，RegisteredFee：1.2300，PriceMethod：6.68，SignatureFee：0.00 2025/10/5 16:54:49 ForwarderByID:HS+DPD,freightCurrency：EUR,TotalPrice：64.662400000000,CNYExchangeRate：8.00000000 2025/10/5 16:54:49 ForwarderByID:HS+DPD,showShipViaTotalPrice：64.662400000000,surcharge：0,TotalPrice：64.662400000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 【SZ039+HSUPSDJ】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.1*{运费折扣}*1.23*{燃油费率}+100+400，FuelRates：1.145，Discount：1.985082，RegisteredFee：0.0000，PriceMethod：24.59，SignatureFee：0.00 2025/10/5 16:54:49 【SZ039+HSUPSDJ】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【SZ039+HSUPSDJ】 TotalPrice：575.62062515840030 2025/10/5 16:54:49 ForwarderByID:SZ039+HSUPSDJ,showShipViaTotalPrice：575.62062515840030,surcharge：0,TotalPrice：575.62062515840030,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 【SZ039+HSUPS】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 【SZ039+HSUPS】 ActualWeight：1.078，CalculationFormula：{标准价格}*{燃油费率}*1.25+100+204，FuelRates：1.5，Discount：1.85082，RegisteredFee：0.0000，PriceMethod：77.58，SignatureFee：0.00 2025/10/5 16:54:49 【SZ039+HSUPS】 TotalPrice：449.46250 2025/10/5 16:54:49 ForwarderByID:SZ039+HSUPS,freightCurrency：PLN,TotalPrice：844.9895000000000,CNYExchangeRate：1.88000000 2025/10/5 16:54:49 ForwarderByID:SZ039+HSUPS,showShipViaTotalPrice：844.9895000000000,surcharge：0,TotalPrice：844.9895000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 16:54:49 【HS003+HSGLSEU】 TotalPrice：6.3875 2025/10/5 16:54:49 【HS003+HSGLSEU】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：1.25，Discount：0，RegisteredFee：0.2400，PriceMethod：5.11，SignatureFee：0.00 2025/10/5 16:54:49 【HS003+HSGLSEU】重量计算结果 ActualWeight：1.078 2025/10/5 16:54:49 ForwarderByID:HS003+HSGLSEU,freightCurrency：EUR,TotalPrice：51.100000000000,CNYExchangeRate：8.00000000 2025/10/5 16:54:49 ForwarderByID:HS003+HSGLSEU,showShipViaTotalPrice：51.100000000000,surcharge：0,TotalPrice：51.100000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:00:30 开始运费计算，参数： {"PlatformId":128,"CountryShort":"DE","TotalWeight":2.950,"Length":33.0,"Width":27.0,"Height":26.0,"Postcode":"04315","DepartureNo":"DEACDX","ForwarderByID":[],"WLEmbargoTypeCode":["404"],"AutoDetectionBasicConfig":true} 2025/10/5 17:00:30 SQL_ShipViaList： and svp.PlatFormId='128' and CHARINDEX(',334,',','+sv.MangoFlag+',')>0 2025/10/5 17:00:30 postcodestr：04315，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:00:30'>=TakeEfficacyDate and '2025-10-05 17:00:30'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:00:30'>=TakeEfficacyDate)) and '04315'>=UPPER(StartPostcode) and '04315'<=UPPER(EndPostCode) 2025/10/5 17:00:30 postcodestr：043，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:00:30'>=TakeEfficacyDate and '2025-10-05 17:00:30'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:00:30'>=TakeEfficacyDate)) and '043'>=UPPER(StartPostcode) and '043'<=UPPER(EndPostCode) 2025/10/5 17:00:30 countryId：38，SQL_ShipPrice_Country： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:00:30'>=TakeEfficacyDate and '2025-10-05 17:00:30'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:00:30'>=TakeEfficacyDate)) 2025/10/5 17:00:30 【DE002+DEPAKET】 ActualWeight：2.950，CalculationFormula：{标准价格}*1.3+2，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4，SignatureFee：0.00 2025/10/5 17:00:30 【DE002+DEPAKET】重量计算结果 ActualWeight：2.950 2025/10/5 17:00:30 【DE002+DEPAKET】 TotalPrice：7.2 2025/10/5 17:00:30 ForwarderByID:DE002+DEPAKET,freightCurrency：EUR,TotalPrice：57.600000000,CNYExchangeRate：8.00000000 2025/10/5 17:00:30 ForwarderByID:DE002+DEPAKET,showShipViaTotalPrice：57.600000000,surcharge：0,TotalPrice：57.600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:00:30 【DE002+DEDHL】重量计算结果 ActualWeight：2.950 2025/10/5 17:00:30 【DE002+DEDHL】 ActualWeight：2.950，CalculationFormula：{标准价格}，FuelRates：1.25，Discount：0，RegisteredFee：0.0000，PriceMethod：3.65，SignatureFee：0.00 2025/10/5 17:00:30 【DE002+DEDHL】 TotalPrice：3.65 2025/10/5 17:00:30 ForwarderByID:DE002+DEDHL,freightCurrency：EUR,TotalPrice：29.2000000000,CNYExchangeRate：8.00000000 2025/10/5 17:00:30 【DE002+DEDPD】重量计算结果 ActualWeight：2.950 2025/10/5 17:00:30 【DE002+DEDPD】 ActualWeight：2.950，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.5，SignatureFee：0.00 2025/10/5 17:00:30 ForwarderByID:DE002+DEDHL,showShipViaTotalPrice：29.2000000000,surcharge：0,TotalPrice：29.2000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:00:30 【DE002+DEDPD】 TotalPrice：4.5 2025/10/5 17:00:30 ForwarderByID:DE002+DEDPD,freightCurrency：EUR,TotalPrice：36.000000000,CNYExchangeRate：8.00000000 2025/10/5 17:00:30 ForwarderByID:DE002+DEDPD,showShipViaTotalPrice：36.000000000,surcharge：0,TotalPrice：36.000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:25:26 开始运费计算，参数： {"PlatformId":128,"CountryShort":"DE","TotalWeight":0.140,"Length":1.3,"Width":9.0,"Height":4.0,"Postcode":"41065","DepartureNo":"DEACDX","ForwarderByID":[],"WLEmbargoTypeCode":["403"],"AutoDetectionBasicConfig":true} 2025/10/5 17:25:26 SQL_ShipViaList： and svp.PlatFormId='128' and CHARINDEX(',334,',','+sv.MangoFlag+',')>0 2025/10/5 17:25:26 postcodestr：41065，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:25:26'>=TakeEfficacyDate and '2025-10-05 17:25:26'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:25:26'>=TakeEfficacyDate)) and '41065'>=UPPER(StartPostcode) and '41065'<=UPPER(EndPostCode) 2025/10/5 17:25:26 postcodestr：410，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:25:26'>=TakeEfficacyDate and '2025-10-05 17:25:26'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:25:26'>=TakeEfficacyDate)) and '410'>=UPPER(StartPostcode) and '410'<=UPPER(EndPostCode) 2025/10/5 17:25:26 countryId：38，SQL_ShipPrice_Country： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:25:26'>=TakeEfficacyDate and '2025-10-05 17:25:26'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:25:26'>=TakeEfficacyDate)) 2025/10/5 17:25:26 【DE002+DEPAKET】重量计算结果 ActualWeight：0.140 2025/10/5 17:25:26 【DE002+DEPAKET】 ActualWeight：0.140，CalculationFormula：{标准价格}*1.3+2，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4，SignatureFee：0.00 2025/10/5 17:25:26 【DE002+DEPAKET】 TotalPrice：7.2 2025/10/5 17:25:26 ForwarderByID:DE002+DEPAKET,freightCurrency：EUR,TotalPrice：57.600000000,CNYExchangeRate：8.00000000 2025/10/5 17:25:26 ForwarderByID:DE002+DEPAKET,showShipViaTotalPrice：57.600000000,surcharge：0,TotalPrice：57.600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:25:26 【DE002+DEDHL】重量计算结果 ActualWeight：0.140 2025/10/5 17:25:26 【DE002+DEDHL】 ActualWeight：0.140，CalculationFormula：{标准价格}，FuelRates：1.25，Discount：0，RegisteredFee：0.0000，PriceMethod：3.65，SignatureFee：0.00 2025/10/5 17:25:26 【DE002+DEDHL】 TotalPrice：3.65 2025/10/5 17:25:26 ForwarderByID:DE002+DEDHL,freightCurrency：EUR,TotalPrice：29.2000000000,CNYExchangeRate：8.00000000 2025/10/5 17:25:26 【DE002+DEDPD】重量计算结果 ActualWeight：0.140 2025/10/5 17:25:26 ForwarderByID:DE002+DEDHL,showShipViaTotalPrice：29.2000000000,surcharge：0,TotalPrice：29.2000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:25:26 【DE002+DEDPD】 ActualWeight：0.140，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.5，SignatureFee：0.00 2025/10/5 17:25:26 【DE002+DEDPD】 TotalPrice：4.5 2025/10/5 17:25:26 ForwarderByID:DE002+DEDPD,showShipViaTotalPrice：36.000000000,surcharge：0,TotalPrice：36.000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:25:26 ForwarderByID:DE002+DEDPD,freightCurrency：EUR,TotalPrice：36.000000000,CNYExchangeRate：8.00000000 2025/10/5 17:26:32 开始运费计算，参数： {"PlatformId":128,"CountryShort":"DE","TotalWeight":2.950,"Length":33.0,"Width":27.0,"Height":26.0,"Postcode":"38100","DepartureNo":"DEACDX","ForwarderByID":[],"WLEmbargoTypeCode":["404"],"AutoDetectionBasicConfig":true} 2025/10/5 17:26:33 SQL_ShipViaList： and svp.PlatFormId='128' and CHARINDEX(',334,',','+sv.MangoFlag+',')>0 2025/10/5 17:26:33 postcodestr：38100，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:26:33'>=TakeEfficacyDate and '2025-10-05 17:26:33'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:26:33'>=TakeEfficacyDate)) and '38100'>=UPPER(StartPostcode) and '38100'<=UPPER(EndPostCode) 2025/10/5 17:26:33 postcodestr：381，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:26:33'>=TakeEfficacyDate and '2025-10-05 17:26:33'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:26:33'>=TakeEfficacyDate)) and '381'>=UPPER(StartPostcode) and '381'<=UPPER(EndPostCode) 2025/10/5 17:26:33 countryId：38，SQL_ShipPrice_Country： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:26:33'>=TakeEfficacyDate and '2025-10-05 17:26:33'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:26:33'>=TakeEfficacyDate)) 2025/10/5 17:26:33 【DE002+DEPAKET】重量计算结果 ActualWeight：2.950 2025/10/5 17:26:33 【DE002+DEPAKET】 ActualWeight：2.950，CalculationFormula：{标准价格}*1.3+2，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4，SignatureFee：0.00 2025/10/5 17:26:33 【DE002+DEPAKET】 TotalPrice：7.2 2025/10/5 17:26:33 ForwarderByID:DE002+DEPAKET,freightCurrency：EUR,TotalPrice：57.600000000,CNYExchangeRate：8.00000000 2025/10/5 17:26:33 ForwarderByID:DE002+DEPAKET,showShipViaTotalPrice：57.600000000,surcharge：0,TotalPrice：57.600000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:26:33 【DE002+DEDHL】重量计算结果 ActualWeight：2.950 2025/10/5 17:26:33 【DE002+DEDHL】 ActualWeight：2.950，CalculationFormula：{标准价格}，FuelRates：1.25，Discount：0，RegisteredFee：0.0000，PriceMethod：3.65，SignatureFee：0.00 2025/10/5 17:26:33 【DE002+DEDHL】 TotalPrice：3.65 2025/10/5 17:26:33 ForwarderByID:DE002+DEDHL,freightCurrency：EUR,TotalPrice：29.2000000000,CNYExchangeRate：8.00000000 2025/10/5 17:26:33 【DE002+DEDPD】 ActualWeight：2.950，CalculationFormula：，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：4.5，SignatureFee：0.00 2025/10/5 17:26:33 【DE002+DEDPD】 TotalPrice：4.5 2025/10/5 17:26:33 ForwarderByID:DE002+DEDHL,showShipViaTotalPrice：29.2000000000,surcharge：0,TotalPrice：29.2000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:26:33 【DE002+DEDPD】重量计算结果 ActualWeight：2.950 2025/10/5 17:26:33 ForwarderByID:DE002+DEDPD,showShipViaTotalPrice：36.000000000,surcharge：0,TotalPrice：36.000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:26:33 ForwarderByID:DE002+DEDPD,freightCurrency：EUR,TotalPrice：36.000000000,CNYExchangeRate：8.00000000 2025/10/5 17:29:20 开始运费计算，参数： {"PlatformId":128,"CountryShort":"DE","TotalWeight":1.078,"Length":25.8,"Width":13.0,"Height":9.7,"Postcode":"22177","DepartureNo":"PLTMDX","ForwarderByID":[],"WLEmbargoTypeCode":["101"],"AutoDetectionBasicConfig":true} 2025/10/5 17:29:20 SQL_ShipViaList： and svp.PlatFormId='128' and CHARINDEX(',372,',','+sv.MangoFlag+',')>0 2025/10/5 17:29:20 postcodestr：22177，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:29:20'>=TakeEfficacyDate and '2025-10-05 17:29:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:29:20'>=TakeEfficacyDate)) and '22177'>=UPPER(StartPostcode) and '22177'<=UPPER(EndPostCode) 2025/10/5 17:29:20 postcodestr：221，countryId：38，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:29:20'>=TakeEfficacyDate and '2025-10-05 17:29:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:29:20'>=TakeEfficacyDate)) and '221'>=UPPER(StartPostcode) and '221'<=UPPER(EndPostCode) 2025/10/5 17:29:20 countryId：38，SQL_ShipPrice_Country： and p.ForwarderByID in ('HS+DPD-BIG','HS006+FEDEX','HS006+FEDEXFREIGHT','HS+DPD','SZ039+HSUPSDJ','HS+PLDPD','SZ039+HSUPS','HS003+HSGLSEU','HS+PLDPD-BIG') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 17:29:20'>=TakeEfficacyDate and '2025-10-05 17:29:20'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 17:29:20'>=TakeEfficacyDate)) 2025/10/5 17:29:20 【HS+DPD-BIG】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 【HS+DPD-BIG】 TotalPrice：7.4816 2025/10/5 17:29:20 【HS+DPD-BIG】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.12，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：6.68，SignatureFee：0.00 2025/10/5 17:29:20 ForwarderByID:HS+DPD-BIG,freightCurrency：EUR,TotalPrice：59.852800000000,CNYExchangeRate：8.00000000 2025/10/5 17:29:20 ForwarderByID:HS+DPD-BIG,showShipViaTotalPrice：59.852800000000,surcharge：0,TotalPrice：59.852800000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:29:20 【HS006+FEDEX】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：23，SignatureFee：0.00 2025/10/5 17:29:20 【HS006+FEDEX】 TotalPrice：28.75 2025/10/5 17:29:20 【HS006+FEDEX】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 ForwarderByID:HS006+FEDEX,freightCurrency：PLN,TotalPrice：54.0500000000,CNYExchangeRate：1.88000000 2025/10/5 17:29:20 ForwarderByID:HS006+FEDEX,showShipViaTotalPrice：54.0500000000,surcharge：0,TotalPrice：54.0500000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:29:20 【HS006+FEDEXFREIGHT】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 【HS006+FEDEXFREIGHT】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25+205，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：203，SignatureFee：0.00 2025/10/5 17:29:20 【HS006+FEDEXFREIGHT】 TotalPrice：458.75 2025/10/5 17:29:20 【HS006+FEDEXFREIGHT】匹配可运违禁类型，国家：38，邮路编码：1923 可运违禁类型参数值：【101】 邮路配置的可运违禁类型：【普货(100)，平衡车类(801)，自行车类(802)】 2025/10/5 17:29:20 【HS+DPD】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 【HS+DPD】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.21，FuelRates：1.4，Discount：0，RegisteredFee：1.2300，PriceMethod：6.68，SignatureFee：0.00 2025/10/5 17:29:20 【HS+DPD】 TotalPrice：8.0828 2025/10/5 17:29:20 ForwarderByID:HS+DPD,showShipViaTotalPrice：64.662400000000,surcharge：0,TotalPrice：64.662400000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:29:20 【SZ039+HSUPSDJ】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 ForwarderByID:HS+DPD,freightCurrency：EUR,TotalPrice：64.662400000000,CNYExchangeRate：8.00000000 2025/10/5 17:29:20 【SZ039+HSUPSDJ】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.1*{运费折扣}*1.23*{燃油费率}+100+400，FuelRates：1.145，Discount：1.985082，RegisteredFee：0.0000，PriceMethod：24.59，SignatureFee：0.00 2025/10/5 17:29:20 【SZ039+HSUPSDJ】 TotalPrice：575.62062515840030 2025/10/5 17:29:20 ForwarderByID:SZ039+HSUPSDJ,showShipViaTotalPrice：575.62062515840030,surcharge：0,TotalPrice：575.62062515840030,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:29:20 【SZ039+HSUPS】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 【SZ039+HSUPS】 ActualWeight：1.078，CalculationFormula：{标准价格}*{燃油费率}*1.25+100+204，FuelRates：1.5，Discount：1.85082，RegisteredFee：0.0000，PriceMethod：77.58，SignatureFee：0.00 2025/10/5 17:29:20 【SZ039+HSUPS】 TotalPrice：449.46250 2025/10/5 17:29:20 ForwarderByID:SZ039+HSUPS,freightCurrency：PLN,TotalPrice：844.9895000000000,CNYExchangeRate：1.88000000 2025/10/5 17:29:20 【HS003+HSGLSEU】重量计算结果 ActualWeight：1.078 2025/10/5 17:29:20 【HS003+HSGLSEU】 ActualWeight：1.078，CalculationFormula：{标准价格}*1.25，FuelRates：1.25，Discount：0，RegisteredFee：0.2400，PriceMethod：5.11，SignatureFee：0.00 2025/10/5 17:29:20 【HS003+HSGLSEU】 TotalPrice：6.3875 2025/10/5 17:29:20 ForwarderByID:SZ039+HSUPS,showShipViaTotalPrice：844.9895000000000,surcharge：0,TotalPrice：844.9895000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 17:29:20 ForwarderByID:HS003+HSGLSEU,freightCurrency：EUR,TotalPrice：51.100000000000,CNYExchangeRate：8.00000000 2025/10/5 17:29:20 ForwarderByID:HS003+HSGLSEU,showShipViaTotalPrice：51.100000000000,surcharge：0,TotalPrice：51.100000000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 23:24:12 开始运费计算，参数： {"PlatformId":153,"CountryShort":"BE","TotalWeight":2.950,"Length":33.0,"Width":27.0,"Height":26.0,"Postcode":"4570","DepartureNo":"DEACDX","ForwarderByID":[],"WLEmbargoTypeCode":["404"],"AutoDetectionBasicConfig":true} 2025/10/5 23:24:12 SQL_ShipViaList： and svp.PlatFormId='153' and CHARINDEX(',334,',','+sv.MangoFlag+',')>0 2025/10/5 23:24:12 postcodestr：457，countryId：26，SQL_ShipPrice_Postcode： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 23:24:12'>=TakeEfficacyDate and '2025-10-05 23:24:12'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 23:24:12'>=TakeEfficacyDate)) and '457'>=UPPER(StartPostcode) and '457'<=UPPER(EndPostCode) 2025/10/5 23:24:12 countryId：26，SQL_ShipPrice_Country： and p.ForwarderByID in ('DE002+DEPAKET','DE002+DEDHL','DE002+DEDHLEU','DE002+DEDPD','DE002+DEDPDEU') and ((LoseEfficacyDate is not null and LoseEfficacyDate<>'' and '2025-10-05 23:24:12'>=TakeEfficacyDate and '2025-10-05 23:24:12'<=LoseEfficacyDate) or ((LoseEfficacyDate is null or LoseEfficacyDate='') and '2025-10-05 23:24:12'>=TakeEfficacyDate)) 2025/10/5 23:24:12 【DE002+DEPAKET】重量计算结果 ActualWeight：2.950 2025/10/5 23:24:12 【DE002+DEPAKET】 ActualWeight：2.950，CalculationFormula：{标准价格}*1.3+2，FuelRates：，Discount：0，RegisteredFee：0.0000，PriceMethod：8，SignatureFee：0.00 2025/10/5 23:24:12 【DE002+DEPAKET】 TotalPrice：12.4 2025/10/5 23:24:12 ForwarderByID:DE002+DEPAKET,freightCurrency：EUR,TotalPrice：99.200000000,CNYExchangeRate：8.00000000 2025/10/5 23:24:12 ForwarderByID:DE002+DEPAKET,showShipViaTotalPrice：99.200000000,surcharge：0,TotalPrice：99.200000000,currentRate：0.14492753,RemoteFee：0 2025/10/5 23:24:12 【DE002+DEDHLEU】重量计算结果 ActualWeight：2.950 2025/10/5 23:24:12 【DE002+DEDHLEU】 TotalPrice：8.08 2025/10/5 23:24:12 【DE002+DEDHLEU】 ActualWeight：2.950，CalculationFormula：{标准价格}，FuelRates：1.25，Discount：0，RegisteredFee：0.0000，PriceMethod：8.08，SignatureFee：0.00 2025/10/5 23:24:12 ForwarderByID:DE002+DEDHLEU,freightCurrency：EUR,TotalPrice：64.6400000000,CNYExchangeRate：8.00000000 2025/10/5 23:24:12 ForwarderByID:DE002+DEDHLEU,showShipViaTotalPrice：64.6400000000,surcharge：0,TotalPrice：64.6400000000,currentRate：0.14492753,RemoteFee：0