Shipping Price based on Zip Code *Important*

[SethF]

Hi

I am desperately seeking help regarding how my shipping is priced. My shipping cost needs to be calculated depending on the ZIP CODE that the customer enters in. I can't understand why this was not included with Zen Cart since many couriers' rates change between Main Centres and Outlying Areas.

There would be about 100 Zip code entries, and each of them would need to have a custom price. So, when a customer enters their zip code, it will detect it and run it through the database, and price the shipping accordingly.

In other words, this is not based on the State, Country, weight of the product or how much it costs. It is based entirely on the Zip code of the customer.

Could something like this be implemented, or does it require special development.

Is there anyone who knows of someone who can develop this for me, or if I can develop it on my own, or maybe if something like this already exists, please let me know.

This will be GREATLY appreciated. This is quite urgent, so I will appreciate a response.

Thank you so much
S

[stevesh]

You (or someone) would need to code this - there's nothing available that I know of that will provide this function. There is this:

http://www.zen-cart.com/index.php?ma...oducts_id=1070

I haven't used it, and don't know how easy (or difficult) it would be to add zones, but it might be a place to start.

Part of the problem with your question is that I'm not familiar with any shipping provider (in the US, anyway) that only considers zip codes to determine rates. Maybe if you let us know what shipper you're planning on using, we might be able to offer better advice.

[SethF]

You (or someone) would need to code this - there's nothing available that I know of that will provide this function. There is this:

http://www.zen-cart.com/index.php?ma...oducts_id=1070

I haven't used it, and don't know how easy (or difficult) it would be to add zones, but it might be a place to start.

Part of the problem with your question is that I'm not familiar with any shipping provider (in the US, anyway) that only considers zip codes to determine rates. Maybe if you let us know what shipper you're planning on using, we might be able to offer better advice.

Thank you for your reply.

I will give the add on a shot. If it is unsuccessful, is there a Zen Cart developer which you can recommend?

My Courier works like this: "R" is the Rand - South African Currency

MAIN CENTRES: - Overnight: Up to 5kg - R70
- Economy: Up to 10kg - R70

Outlying Areas: - 3 - 4 days: Up to 5kg - R120

Special Cape Town Areas: Overnight: Up to 5kg - R80

Special Local Areas: Overnight: Up to 5kg - R40


Each Zip Code in the country will fall into 1 of those categories. Ignore the weight as it is not relevant to my products.

Is there any more info you would need?

Thanks again
S

[fairestcape]

The zipcodezones module can probably work in your situation.

Looks like you have FOUR zones, so you'd need to make a minor edit to the MODULE file. Change the number of zones from 7 to 4.

Then, configure the SQL patch which creates the new table (and its initial resident data), to match the RSA postode format.

(I've been in London for a while, so I can't remember the exact Geo-Formatting of ZA postcodes, but you have the challenge of removing POSTBOX codes from the sequence - unless of course, you will deliver to PO-Boxes.

CREATE TABLE `zipcodezone` (
`zipcode_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`zipcode_start` char(3) NOT NULL default '0',
`zipcode_end` char(3) NOT NULL default '0',
`zipcodezone` int(1) NOT NULL default '0');

INSERT INTO `zipcodezone` 
(`zipcode_id` ,`zipcode_start` ,`zipcode_end` ,`zipcodezone`)
VALUES (1, '0001', '0005', 1),
(2, '2001', '2099', 2),
(3, '3001', '3099', 2),
(4, '8001', '8099', 2),
(5, '7010', '7102', 3),
(6, '7104', '7104', 3),
(7, '350', '358', 4),
(8, '5019', '5100', 1),

See how my start code and end code are structured to embrace a GeoZone?

EG:
zipcodezone 2 (above) could be your MAJOR CENTRES (2001 - 2099 = Gauteng, 8001 - 8099 = Capetown metropolitan, etc)

zipcodezone 3 could be cape special

ETC.

Please don't ask me to build this... 1. I don't have the time. 2. I'm not really interested in doing it. It's going to be a big (time-consuming) job to get ALL the p-codes properly co0nfigured in the SQL file. I really am not interested in doing this!

[SethF]

The zipcodezones module can probably work in your situation.

Looks like you have FOUR zones, so you'd need to make a minor edit to the MODULE file. Change the number of zones from 7 to 4.

Then, configure the SQL patch which creates the new table (and its initial resident data), to match the RSA postode format.

(I've been in London for a while, so I can't remember the exact Geo-Formatting of ZA postcodes, but you have the challenge of removing POSTBOX codes from the sequence - unless of course, you will deliver to PO-Boxes.

CREATE TABLE `zipcodezone` (
`zipcode_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`zipcode_start` char(3) NOT NULL default '0',
`zipcode_end` char(3) NOT NULL default '0',
`zipcodezone` int(1) NOT NULL default '0');

INSERT INTO `zipcodezone` 
(`zipcode_id` ,`zipcode_start` ,`zipcode_end` ,`zipcodezone`)
VALUES (1, '0001', '0005', 1),
(2, '2001', '2099', 2),
(3, '3001', '3099', 2),
(4, '8001', '8099', 2),
(5, '7010', '7102', 3),
(6, '7104', '7104', 3),
(7, '350', '358', 4),
(8, '5019', '5100', 1),

See how my start code and end code are structured to embrace a GeoZone?

EG:
zipcodezone 2 (above) could be your MAJOR CENTRES (2001 - 2099 = Gauteng, 8001 - 8099 = Capetown metropolitan, etc)

zipcodezone 3 could be cape special

ETC.

Please don't ask me to build this... 1. I don't have the time. 2. I'm not really interested in doing it. It's going to be a big (time-consuming) job to get ALL the p-codes properly co0nfigured in the SQL file. I really am not interested in doing this!

Hi

Thank you for your reply.

Would it be easier to code it like this:
List all the zip codes that have a special price, and for all the zip codes not listed, a flat rate will be charged.

To be honest, I really have limited knowledge with coding, so I would in any case need someone to do this for me - which I would pay for. So if you are up for the job, I won't have a problem paying you for it. Or, please refer me to someone who can help me with this.

Thanks again.
S

[torvista]

Have a look at Ceon Advanced Shipper.