watching to the BBC World Service and help keep your CactuShop country list 

up to date. Hey, those ISO codes might even change too  

6.18.5 

The country ID 

This is just the database ID used for that country's record. You don't need to 

do anything with this but it can sometimes be useful during development. 

6.19 Shipping 

Rates 

This section only applies if your store is set to use CactuShop's internal 

shipping system. To activate this, set the config setting 

shippingsystem

 to `c' 

(see 7.4.16.3). If you wish to use UPS real time shipping calculations, see 

6.20. 

Shipping rates are set in bands, each representing a range of order value (or 

weight) within a particular regional zone and for a particular shipping method. 

By default, CactuShop has five shipping zones and four different shipping 

methods (including `electronic shipping'). But extra ones can be created if 

required. 

6.19.1 

Adding extra shipping methods 

First open the 

tblCactuShopShippingMethods

 table. Add a new record and 

enter the name(s) and description(s) required. Make a note of the 

SM_ID

value assigned to it. 

Next, open the 

tblCactuShopShippingRates 

table. Copy all records where the 

S_ShippingMethod

 value is 1 and paste them into the foot of the table. To 

copy records you will need to click and hold down the mouse button on the 

grey margin to the left of the record ID column, and drag down, highlighting 

the required records as you go. After this, change the 

S_ ShippingMethod

value for all the new records to the 

SM_ID

 value you noted above. You can 

edit the values of these from the back end later. 

6.19.2 

Adding extra zones 

To add an extra shipping zone, copy all the records in the 

tblCactuShopShippingRates 

table where the 

S_Zone

 value is 1 and paste them 

into the foot of the table, then change the 

S_Zone

 value to 6 (or whatever the 

new zone is to be). 

You will then need to add some new code to handle the names of new zones. 

First step is to create a new language string called 

Config_Zone6

 (for 

example). You would then need to add the 

LS_ID

 value of this to the 

PageStrings statement at the top of pages where it is used (for example, the 

shipping.asp

 page). For that page, you'd also need to add an extra array line 

under the others that are there: 

aryZone(6) = GetString("Config_Zone5")

47