Appendix F

CSV Rates Upload

CSV Rates Upload enables you to set up an infinitely flexible table of shipping charges. There are two types of CSV format, Range and Each.

If your shipping charge rate is by Range you are effectively setting prices for ranges of quantities. For example, 1-5 units will add £10 to the total of the shipping charge and 6-10 units will add £18 to the total and so on.

If your shipping charge is by Each , you are effectively setting prices per unit for ranges of quantities. For example, 1-5 units will add £10 each to the total of the shipping charge and 6-10 units will add £18 each to the total and so on.

The format of the CSV file is simply two columns as shown in the examples below. It is also possible to type the rate variations directly into the Rate box as: 5=10; 10=18; 20=30; *=35.

UNIT

CSV Data Format

Resulting Shipping Charge for Unit Rate Type - Range

5

10

1-5 units will add £10 (total) to the shipping charge

10

18

6-10 units will add £18 (total) to the shipping charge

20

30

11-20 units will add £30 (total) to the shipping charge

*

35

21 and more units will add £35 (total) to the shipping charge

Direct Input format: 5=10;10=18; 20=30;*=35

CSV Data Format

Resulting Shipping Charge for Unit Rate Type - Each

each

 

Each modifier changes the calculation

10

18

1-10 units will add £18 (per unit) to the shipping charge

20

30

11-20 units will add £30 (per unit) to the shipping charge

*

35

21 and more units will add £35 (per unit) to the shipping charge

Direct Input format: each= ;10=18; 20=30;*=35

WEIGHT

CSV Data Format

Resulting Shipping Charge for Weight Rate Type - Range

5

10

1-5 measures of weight will add £10 (total) to the shipping charge

10

18

>5-10 measures of weight will add £18 (total) to the shipping charge

20

30

>10-20 measures of weight will add £30 (total) to the shipping charge

*

35

>20 and more measures of weight will add £35 (total) to the shipping charge

Direct Input format: 5=10;10=18; 20=30;*=35

CSV Data Format

Resulting Shipping Charge for Weight Rate Type - Each

each

 

Each modifier changes the calculation

10

18

0-10 measures of weight will add £18 (per measurement) to the shipping charge

20

30

>10-20 measures of weight will add £30 (per measurement) to the shipping charge

*

35

>20 measures of weight will add £35 (per measurement) to the shipping charge

Direct Input format: each= ;10=18; 20=30;*=35

Value %age

CSV Data Format

Resulting Shipping Charge for Value %age Rate Type - Range

5

10

%10 (total) will be added for goods up to £5 

10

18

%18 (total) will be added for goods between £5 and £10

20

30

%30 (total) will be added for goods between £10 and £20

*

35

%35 (total) will be added for goods over £30

Direct Input format: 5=10;10=18; 20=30;*=35

CSV Data Format

Resulting Shipping Charge for Value %age Rate Type - Each

each

 

Each modifier changes the calculation

10

18

%18 (each) will be added for goods up to £10

20

30

%30 (each) will be added for goods between £10 and £20

*

35

%35 (each) will be added for goods over £30

Direct Input format: each= ;10=18; 20=30;*=35

To view the table of content when viewing this help file in an early browser version click here

©2003-4 Teckna Ltd. All rights reserved.
For further information and support refer to our Contact Details.