CODEWITHSUNDEEP
woocommercemethods
s011420
s011420

Reputation: 33

How to set different woocommerce Shipping Zones for the same country and show both of them

I found that woocommerce will only show the shipping method for the shipping zone that is sorted on the top of the list(narrowest), and this default setting makes the shipping zone function become very limited.

I have 2 carriers for customers the choose,UPS and EMS. UPS and EMS have different price rules and different shipping zone settings.

to shows both shipping methods I

and I need to create 3 types of the zone:

  1. counties for UPS only
  2. counties EMS only
  3. Overlap countries with both UPS & EMS as methods.

that means I will need to create at least 30+ shipping zones. mostly like create one country as one shipping zone, and that means shipping zone is useless.

I also found that someone has the same problem as me: https://wordpress.org/support/topic/intersecting-shipping-zones-not-displayed-on-checkout/

if woocommerce can display both shipping methods on different shipping zone that will be great. is it any code I can add to make it works?

Many thanks.

Upvotes: 1

Views: 1453

Answers (1)

Mizuho Ogino
Mizuho Ogino

Reputation: 384

I had the same problem with the setting of EMS and DHL, and couldn't find any reasonable solution. Therefore, I had to spend the whole day to code it manually.

Here I post it for anyone who may need this. It save shipping IDs to the datastore and use them to calculate and merge optional rates.

// Make and merge optional rates
add_filter( 'woocommerce_package_rates', function ( $rates, $package ){

$country           = strtoupper( wc_clean( $package['destination']['country'] ) );
$state             = strtoupper( wc_clean( $package['destination']['state'] ) );
$postcode          = wc_normalize_postcode( wc_clean( $package['destination']['postcode'] ) );
$cache_key         = WC_Cache_Helper::get_cache_prefix( 'shipping_zones' ) . 'wc_shipping_zones_' . md5( sprintf( '%s+%s+%s', $country, $state, $postcode ) );
$matching_zone_ids = wp_cache_get( $cache_key, 'shipping_zones_array' ); // get ids from the datastore cache
if ( false === $matching_zone_ids ) {
    $data_store = WC_Data_Store::load( 'shipping-zone' );
    $data_store->get_zone_id_from_package( $package );
    $matching_zone_ids = wp_cache_get( $cache_key, 'shipping_zones_array' );
}
if ( $matching_zone_ids ) : foreach ( $matching_zone_ids as $matching_zone_id ):
    $new_zone = new WC_Shipping_Zone( $matching_zone_id );
    foreach ( $new_zone->get_shipping_methods( true ) as $new_method ){
        $rates = $rates + $new_method->get_rates_for_package( $package ); // make and merge the optional rate
    }
endforeach; endif;

return  $rates;

}, 10, 2 );


add_filter( 'woocommerce_get_zone_criteria', function ( $criteria, $package, $postcode_locations ) { // set ids as array to the datastore cache 

global $wpdb;
$matching_zone_ids = array();
$matching_zones = $wpdb->get_results( "SELECT zones.zone_id FROM {$wpdb->prefix}woocommerce_shipping_zones as zones LEFT OUTER JOIN {$wpdb->prefix}woocommerce_shipping_zone_locations as locations ON zones.zone_id = locations.zone_id AND location_type != 'postcode' WHERE " . implode( ' ', $criteria ) . ' ORDER BY zone_order ASC, zones.zone_id ASC LIMIT 10' );
if ( $matching_zones ){
    foreach ( $matching_zones as $zone ){
        $matching_zone_ids[] = $zone->zone_id;
    }
}
$country           = strtoupper( wc_clean( $package['destination']['country'] ) );
$state             = strtoupper( wc_clean( $package['destination']['state'] ) );
$postcode          = wc_normalize_postcode( wc_clean( $package['destination']['postcode'] ) );
$cache_key         = WC_Cache_Helper::get_cache_prefix( 'shipping_zones' ) . 'wc_shipping_zones_' . md5( sprintf( '%s+%s+%s', $country, $state, $postcode ) );
wp_cache_set( $cache_key, $matching_zone_ids, 'shipping_zones_array' );

return $criteria;

}, 10, 3 );

Upvotes: 7

Related Questions