Switch from one shipping module to another dependent on product variables

[Ajeh]

What all shipping modules are installed and what custom code have you added to them?

[Craig MD]

Installed are Free shipping which applies to only a few items. Table, which I use for anything under .813 lbs and is limited to the lower 48 states. UPS, for all other shipments and USPS for alaska and Hawaii orders only per a zone only including them.
The only custom mod was adding in the center section of code below from //added by to }.

  $this->tax_basis = MODULE_SHIPPING_TABLE_TAX_BASIS;
    // disable only when entire cart is free shipping
    if (zen_get_shipping_enabled($this->code)) {
      $this->enabled = ((MODULE_SHIPPING_TABLE_STATUS == 'True') ? true : false);
    }
    // added in by cs for table ship off switch
    global $cart;
    if (IS_ADMIN_FLAG == false && $_SESSION['cart']->show_weight() > 0.813) {
      $this->enabled = false;
    }

    
    if ($this->enabled) {
      // check MODULE_SHIPPING_TABLE_HANDLING_METHOD is in
      $check_query = $db->Execute("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_TABLE_HANDLING_METHOD'");
      if ($check_query->EOF) {
        $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Handling Per Order or Per Box', 'MODULE_SHIPPING_TABLE_HANDLING_METHOD', 'Order', 'Do you want to charge Handling Fee Per Order or Per Box?', '6', '0', 'zen_cfg_select_option(array(\'Order\', \'Box\'), ', now())");
      }
    } 

[Ajeh]

Which ones are showing together that should not be seen together?

[Craig MD]

The table (orders less than .813lbs) and UPS (orders over .813lbs). The mod works until you pick a different address or adjust the weight above or below the .813lbs mark.

[Ajeh]

Do you have some custom code in the UPS module to enable/disable it based on the weight?

[Craig MD]

No mods in UPS.php.
I see what is happening now, I imported most of my customer data from another shopping cart system. For some reason the states in their address info need to be opened and re saved in order for the zones to work properly. Since I have the table shipping option limited to my lower 48 state zone it isn't showing up unless the address is edited first. Looking in customer data the states look to be fine but they don't jive with the zones. I guess I need to either export, fix, and then re import the file or some how modify my zones to match what has been imported. While I am in communication with a person of your expertise, how would you recommend fixing 6000 customers states?
Thanks
Craig

[Ajeh]

I don't know the format of your old data for the other shopping cart ...

You would need to run a translate for the data of some type to fix the old customer data to match the new customer data ...

What are you importing the data from? There might be a translation program in the Free Software Add Ons ...

[Craig MD]

It was some program called Candy Press. It was here when I got here. It took around 40 clicks to process an order. I have started searching, is there someway to open up the entire address book and edit the database?

[Ajeh]

The database tables can be browsed in phpMyAdmin ...

The table:
address_book

holds the address(es) of the customers ...

[Craig MD]

Thanks Again Ajeh!!