BluJay Solutions Parcel 21.1.0 - User Guide
UPS Europe and Asia Pacific - Custom Rate Import |
Scroll |
Use the Custom Rate Import screen to import custom rate files for a UPS Europe and Asia Pacific carrier and to specify the date on which these rates go into effect. You can import multiple files in one operation, including different files for different services.
Note:
•Custom rate files for importing into Parcel must be CSV files that follow a specific format as detailed in the section below on custom rate file format.
•BluJay Solutions support in conjunction with UPS produces these files from data provided by the Parcel customer, and then provides the Custom Rate files to the customer for importing into their Parcel system.
To import custom rate files...
1.From the System menu. select Settings > UPS Europe and Asia Pacific > [UPSEU_APAC _Carrier] > Custom Rate Import to open the Custom Rate Import screen.
2.On the Custom Rate Import screen, fill in the fields as follows:
In this box... |
Do this... |
Rate Effective Date |
Type the date on which the UPS custom rates go into effect. Use the following date format: YYYYMMDD; for example, for a Rate Effective Date of May 1, 2010: 20100501. |
Custom Rate Directory |
Type the complete path name of the folder (directory) where the UPS custom rate files are located; for example: C:\Program Files\Kewill\Flagship\UPS EU\Custom Rate Files. Notes: •This folder must be local to the Parcel server itself; that is, it must be located on either on a local hard drive or on a mapped network drive. •You can import any number of custom rate files provided that they are all placed in the same folder. Parcel imports all the correctly formatted CSV files in this folder. |
3.Click [SAVE] to import the files in the specified folder or click [CANCEL] to exit the Custom Rate Import screen.
Custom Rate File format
Note: Each Custom Rate File contains data for a combination of one origin and one customer account. All services available for this origin and account are listed in this file (see following table and example).
Each custom rate file is a CSV file containing the following information:
Field |
Description |
Customer |
The name of the customer. |
Origin |
The two-letter code for the country of origin; for example, for the Czech Republic: CZ |
Account |
The UPS Europe and Asia Pacific customer account number; for example: 12356 |
Service |
The UPS service name. |
Packaging Type |
Valid values for packaging type are as follows: •Documents •Packages |
Rate Currency |
The three-letter currency code for the rates; for example, for the Czech Crown (Ceska Koruna): CZK |
Weight Units |
The three-character abbreviation for the weight units used; for example, for pounds: KGS |
Multi Piece |
Valid values for Multi Piece are as follows: •Yes •No |
Outbound |
Valid values for Outbound are as follows: •Yes •No |
Bill Types |
The billing type used for this shipment. Valid values are: •Prepaid •Collect •Third Party •Consignee |
Weight (kg) |
The minimum weight for a particular row of rates in kilograms to one decimal place (see example below); for example: 1.5 |
Zone |
The name of the UPS Europe and Asia Pacific zone for which the rate is applicable; for example: Zone 5 |
Note: For the format of this file see the following topic: Custom Rate Import File Format.
Example of Custom Rate file (portion with header and one table)
Customer |
Carrier Name |
|
|
|
|
||
Origin |
CZ |
|
|
|
|
|
|
Account |
123456 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Service |
Express Saver |
|
|
|
|
|
|
Packaging Type |
Documents |
|
|
|
|
|
|
Rate Currency |
CZK |
|
|
|
|
|
|
Weight Units |
KGS |
|
|
|
|
|
|
Multi Piece |
No |
|
|
|
|
|
|
Outbound |
Yes |
|
|
|
|
|
|
Bill Types |
Prepaid |
Collect |
Third Party |
Consignee |
|
|
|
|
|
|
|
|
|
|
|
Weight |
Zone 6 |
Zone 7 |
Zone 8 |
Zone 9 |
Zone 10 |
Zone 11 |
Zone 12 |
Envelope |
841.68 |
841.68 |
913.40 |
1022.85 |
1087.02 |
1132.31 |
1275.74 |
0.5 |
1211.57 |
1181.38 |
1352.73 |
1419.16 |
1502.20 |
1539.94 |
1672.05 |
1.0 |
1517.30 |
1521.07 |
1803.39 |
1815.47 |
1955.12 |
2189.13 |
2381.63 |
1.5 |
1755.08 |
1823.02 |
2116.67 |
2211.78 |
2408.05 |
2687.35 |
2951.56 |
2.0 |
1992.87 |
2124.97 |
2433.71 |
2608.09 |
2860.97 |
3185.57 |
3521.49 |
2.5 |
2230.65 |
2426.92 |
2762.08 |
3004.40 |
3313.90 |
3683.78 |
4091.41 |
Notes: For clarity, the above example shows how a portion of the sample Custom Rates file (header and one table) appears in spreadsheet form. The equivalent of the same portion of the comma-delimited CSV file is as follows:
Customer,Carrier Name,,,,,,
Origin,CZ,,,,,,
Account,123456,,,,,,
,,,,,,,
Service,Express Saver,,,,,,
Packaging Type,Documents,,,,,,
Rate Currency,CZK,,,,,,
Weight Units,KGS,,,,,,
Multi Piece,No,,,,,,
Outbound,Yes,,,,,,
Bill Types,Prepaid,Collect,Third Party,Consignee,,,
,,,,,,,
Weight,Zone 6,Zone 7,Zone 8,Zone 9,Zone 10,Zone 11,Zone 12
Envelope,841.68,841.68,913.40,1022.85,1087.02,1132.31,1275.74
0.5,1211.57,1181.38,1352.73,1419.16,1502.20,1539.94,1672.05
1.0,1517.30,1521.07,1803.39,1815.47,1955.12,2189.13,2381.63
1.5,1755.08,1823.02,2116.67,2211.78,2408.05,2687.35,2951.56
2.0,1992.87,2124.97,2433.71,2608.09,2860.97,3185.57,3521.49
2.5,2230.65,2426.92,2762.08,3004.40,3313.90,3683.78,4091.41
