Best way to do this: flat rate, additional items, by defined zones?

[EmDash]

Hi all,

 

I'm setting up a website to sell books and DVDs within Canada. The way the client wants shipping to work is, a flat rate for each area: B.C., prairies, and the rest of Canada... for each first item. Each additional item at 50 cents each.

 

I've looked at First Item Plus modules but they specify zones by country code... that does me no good since we're dealing with regions in Canada, not countries.

 

Any advice for setting this up? I am not a programmer though I can mess around with .php if given clear enough instructions.

[EmDash]

Hi all,

 

I'm setting up a website to sell books and DVDs within Canada. The way the client wants shipping to work is, a flat rate for each area: B.C., prairies, and the rest of Canada... for each first item. Each additional item at 50 cents each.

 

I've looked at First Item Plus modules but they specify zones by country code... that does me no good since we're dealing with regions in Canada, not countries.

 

Any advice for setting this up? I am not a programmer though I can mess around with .php if given clear enough instructions.

 

:rolleyes:

 

I figured I would post how I got around this, in case others are looking for the same thing.

 

I used the table rate module. I set up each shipping zone as a tax zone: one for B.C. containing only B.C., one for the prairie provinces including those, and one for the rest of Canada with all the other provinces/territories.

 

I followed the directions here: http://www.oscommerce.com/forums/index.php?showtopic=137263 to create three separate .php files for each table rate.

 

I set all products to weigh exactly 1 kg.

 

I set each table to relate to the correct zone, and configured the rate table to look something like this:

1:8.00,2:8.50,3:9.00,4:9.50,5:10.00,6:10.50,7:11.00,8:11.50,9:12.00,999999:12.50

 

This means 1 product is $8 for shipping. 2 is $8.50. Because they all weight 1 kg. The 999999 is to allow up to 1 million products to ship at the capped rate, $12.50. You could also do it so 10 or more products is free or something.

 

Obviously the other two tables have different rates, but follow the 1:price,2:price,3:price, etc format.

 

I hope this helps someone else.