Customer Shipping Options Import Format

A

1

Customer Code

12

Character

Yes, only if creating a customer shipping options record for a customer

If creating customer shipping options for a customer, enter a valid customer code. If you enter a customer code for this field, leave the Trade ID field (position 2) and Shipping Options Group field (position 9) blank.

B

2

Trade ID

25

Character

Yes, only if creating a customer shipping options record for an EDI trading partner

If creating customer shipping options for an EDI trading partner, enter a valid trade ID. If you enter a trade ID for this field, leave the Customer Code field (position 1) and Shipping Options Group field (position 9) blank.

C

3

Ship-To Address ID

4

Integer

No

If the customer shipping options are for a specific customer ship-to address, enter a valid ship-to address ID. If this field is blank, the customer shipping options are for all ship-to addresses.

D

4

Distribution Center ID

25

Character

No

If the customer shipping options are for a specific trading partner distribution center, enter a valid distribution center ID. If this field is blank, the customer shipping options are for all distribution centers.

E

5

Shipper ID

12

Character

No

If the customer shipping options are for a specific shipper, enter a valid shipper ID.

F

6

Shipper Interface

30

Character

No

If the shipping account ID is for a specific shipper interface, enter a valid shipper interface.

G

7

Shipping Account ID

20

Character

Yes, only if not using a ProShip shipper interface

Enter the shipping account ID.

H

8

Location Prefix

3

Character

No

Enter the location prefix for the customer shipping options.

I

9

Shipping Options Group

Character

Yes, only if creating a customer shipping options record for a customer shipping options group

If creating customer shipping options for a shipping options group, enter a valid shipping options group. If you enter a shipping options group for this field, leave the Customer Code field (position 1) and Trade ID field (position 2) blank.

J

10

Carrier

20

Character

No

Enter the carrier (shipping company) to use for the customer shipping options record. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

K

11

ProShip Shipper

30

Character

No

Enter the ProShip shipper. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

L

12

Tracking Label Print Option

18

Character

No

Enter one of the following to select whether to print tracking labels separately from pack slips:

• Print on Pack Slips

• Print Separately

This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

M

13

Return Label Print option

18

Character

No

Enter one of the following to select whether to print tracking labels separately from pack slips for returns:

• Print on Pack Slips

• Print Separately

This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (column F).

When one of the above options is entered, the Use Return Label Services check box will be selected automatically.

N

14

ProShip Return Shipper

30

Character

No

Enter the ProShip shipper for returns. This field is only used if you enter Yes for the Use Return Label Services field (position 13). This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

O

15

Freight Formula

Character

No

Enter a formula for freight if you want to adjust the freight amounts passed back from ProShip. The formula can use the following variables:

• Total - This is the total freight from ProShip including accessories.

• Base - This is the base rate from ProShip (the list or published rate).

• Discount - This is the discount amount.

You can also use any node name (the value from a ProShip response node).

You can use the following operators: +, -, and *.

You can also use parenthesis and constant values.

EXAMPLE If you want to add 5% to the total freight, you can enter Total*1.05 in this field.

This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

P

16

Per Package Add-on

6

>>9.99

No

Enter an add-on amount for each package. This is an additional fee for each package on a shipment.

This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

Q

17

Residential Delivery

3

Yes/No

No

Enter Yes to indicate the shipper is delivering to a residential address. If this field is blank, it defaults to No. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

R

18

Call Before Delivery

3

Yes/No

No

Enter Yes to indicate the shipper must call before delivery.

If this field is blank, it defaults to No. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

S

19

Liftgate Delivery

3

Yes/No

No

Enter Yes to indicate the shipper must use a liftgate for delivery.

If this field is blank, it defaults to No.

T

20

Inside Delivery

3

Yes/No

No

Enter Yes to indicate the shipper must perform inside delivery.

If this field is blank, it defaults to No. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

U

21

Signature Required

3

Yes/No

No

Enter Yes to indicate the shipper must obtain a signature for delivery.

If this field is blank, it defaults to No. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

V

22

Address Type

34

Character

No

Enter one of the following address types for the address entered for fields 23-31:

• Originator Address

• Return Address

• Third Party Freight Billing Address

This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

W

23

Company Name

30

Character

No

Enter the company name for the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

X

24

Contact

30

Character

No

Enter a contact name for the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

Y

25

Address 1

30

Character

No

Enter the first line of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

Z

26

Address 2

30

Character

No

Enter the second line of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

AA

27

City

30

Character

No

Enter the city of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

AB

28

State/Province

3

Character

No

Enter the state or province of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

AC

29

Postal Code

10

Character

No

Enter the postal code of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

NOTE If a postal code is not entered, the address is not sent to ProShip.

AD

30

Country

10

Character

No

Enter the country of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

AE

31

Phone

16

Character

No

Enter the phone number of the address. This field is only used if a ProShip shipper interface is entered for the Shipper Interface field (position 6).

AF

32

Use UPS Cloud Return Shipping Services

3

Yes/No

No

Enter Yes to use return label services for the customer. If this is Yes, return labels are printed so that a consumer can ship products back for returns. If this is blank, it defaults to No. This field is only used if a UPS Cloud shipper interface is entered for the Shipper Interface field (position 6).