ZipShip - Support Thread

[tmccaff]

Could you use MySQL to pull zipcodes instead? Not sure how to do this something like this:

$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; 

than in MySQL do this:

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

[tmccaff]

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:

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?

[lat9]

@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?

[tmccaff]

I am asking why the ZipCode shipping_zone not working In 1.5.5; is there an updated code for this to work?

[lat9]

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.

[tmccaff]

I tried both plugins and either does Shipping Zone which is what I need. This module has it but don't work. Geez

[EZorb]

I am using zipship (zone 1) for Store Pickup by inserting zipcode that are allowed to use Store Pickup.

I also set zone 2 to 00000 for all 5 digits zip codes (I believe that is what I read) and that does not work. I also noticed that if I change Shipping Zone from none to the zone code choice the zipship module does not work at all. Change it back and Store Pickup works.

When I using Flat Rate module it will work if Shipping Zone is set to none. If you change it to the choice available it will not work.

This indicates to me that Locations/Taxes is not set up correctly. It is still set as it was before upgrading to 1.5.5e