I need some advices for a shipping modules.

[yellow1912]

I currently offer 3 shipping rates to 3 zones (US, Canada, Others). Now I want to offer another shipping option to Others, I want to let them either choose First Class or Priority, is there any way to do this?

Regards.

[yellow1912]

I have multiples zones (3 zones), and I want to set multiple shipping methods for each zone, is there any way?

[yellow1912]

I want to offer shipping to multiple zones, each zones can have multiple shipping options (first class, priority, ...)
Because of the type of my product, I need only a flat rate for each type, such as:
USA:
Total < 25
First Class: 3usd
Priority: 7usd
25<Total < 50
First Class: FREE
Priority: 4usd


Canada:
Total < 25
First Class: 5usd
Priority: 9usd
25<Total < 50
First Class: FREE
Priority: 6usd
etc....

I'm thinking of creating 3 additional tables like instead of stuffing everything into the configuration table:

        $db->Execute("CREATE TABLE ". TABLE_FLEXIBLEZONE_METHODS ." (
                      id int(10) NOT NULL auto_increment,
                      name varchar(255) NOT NULL,
                      PRIMARY KEY  (ID) 
                    ) ENGINE=MyISAM;");
        $db->Execute("CREATE TABLE ". TABLE_FLEXIBLEZONE_COUNTRIES ." (
                      id int(10) NOT NULL auto_increment,
                      method_id int(10) unsigned NOT NULL,
                      country_id int(10) unsigned NOT NULL,
                      UNIQUE (method_id, country_id),
                      PRIMARY KEY  (ID) 
                    ) ENGINE=MyISAM;");
        $db->Execute("CREATE TABLE ". TABLE_FLEXIBLEZONE_RATES ." (
                      id int(10) NOT NULL auto_increment,
                      method_id int(10) unsigned NOT NULL,
                      minimum_total int(10) unsigned NOT NULL,
                      maximum_total int(10) unsigned NOT NULL,
                      cost int(10) unsigned NOT NULL,
                      PRIMARY KEY  (ID) 
                    ) ENGINE=MyISAM;"); 

The bad things:
1. it may slow down the site (but this is not necessarily true tho)
2. When I want to edit shipping methods, I can't go to admin->modules->shipping but I may have to place a new page somewhere.

So, please give me some advices, should I do this, or is there any better way?

[Ajeh]

Have you looked at Multiple Zones Multiple Tables MZMT by dreamscape for this?

There should be a link to it in his signature ...

[yellow1912]

I didn't know about that, I will check it right now. Thank you Ajeh.

[yellow1912]

I just want to thank you, Ajeh. Without your suggestion I would have wasted my time trying to re-invent the wheel. The mod is exactly what I'm looking for, fantastic.

With best regards.

[Ajeh]

Glad that suggestion could help you out ...

Might remember both dreamscape and the Zen Cart Team when you are rich and famous ...