Does setting the sort order greater than zero help?
Does setting the sort order greater than zero help?
Rick
RixStix (dot) com
aka: ChainWeavers (dot) com
Could you use MySQL to pull zipcodes instead? Not sure how to do this something like this:
than in MySQL do this:PHP Code:
$zipcode_prefix = substr($order->delivery['postcode'],0,3);
global $db;
$check = $db->Execute("select zipcodezone from " . TABLE_ZIPCODEZONE . " where '" . $zipcode_prefix . "' BETWEEN zipcode_start and zipcode_end");
while (!$check->EOF) {
$dest_zone = $check->fields['zipcodezone'];
$check->MoveNext();
}
// echo $dest_zone;
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, '004', '005', 8),
(2, '010', '089', 8), etc
Not sure how to implement this though. Thanks
I am trying to do following; look up zipcode using 3 digit prefix of zip code and use zones; I am trying to figure out now how to enable this to only a certain shipping zone.
basically use MYSQL to look up 3 digit code like this
(1, '010', '089', 8) so zipcodes starting with 010 to 089 will be zone 8. Now only applied to Continental USA.
Then in zone definition add US states to this and use Shipping Zone enabled for this zone. As of now since the shipping_zone is for whole usa
Then I will add another module for AK, PR, etc Non Continental states.
So basically one says this:
Code:Alaska 99922 United States Available Shipping Methods Rates Ground delivery (The shipping rate cannot be determined at this time) $0.00 Rush Delivery (Shipping to 99922 (1 x 3.00lb(s)))
That is why I am trying to enable Shipping_zone.. to eliminate "Ground delivery (The shipping rate cannot be determined at this time)"
I got it working except for Shipping_zone it don't seem to work. Make sense?
@tmccaff, Would you please take this discussion somewhere besides the ZipShip shipping-module's support thread ... since it's not having to do with this module?
I am asking why the ZipCode shipping_zone not working In 1.5.5; is there an updated code for this to work?
Right, you're asking about Seven-Zone Zipcode-based shipping module, not ZipShip. Please continue that discussion elsewhere.
I tried both plugins and either does Shipping Zone which is what I need. This module has it but don't work. Geez
Bookmarks