Free Shipping Options module, how to exclude some categories?

[Ajeh]

You could write an extensive piece of code for it ...

I thought somewhere over the last few months I wrote something for a shipping module to take the top level category and build something for that but I cannot recall what or where it might be on the forum ...

[tj1]

I went through all 30 pages of the similar thread 'Different shipping methods for different categories' (http://www.zen-cart.com/forum/showth...=91394&page=30) and 'exclude certain products from free shipping' (http://www.zen-cart.com/forum/showth...ategory&page=3), but could not find a solution for looking up all subcategories.

I found some code somewhere else on the web and this is what I've come up with:

/**
 * Get all the subcategory IDs of the parent category whose ID
 * is specified.
 *
 * @param integer $parentID
 * @return array
 */
function getSubcategories ($parentID, $self = false) {
$subs = array ();
if ($self) {
$subs[] = $parentID;
}
_getSubcategories ($parentID, &$subs);
return $subs;
}
 
/**
 * Help function for getSubcategories()
 *
 * @param integer $pid
 * @param array $cats
 * @see getSubcategories()
 */
function _getSubcategories ($pid, &$cats) {
global $db;
$sql = "SELECT c.categories_id FROM " . TABLE_CATEGORIES . " c WHERE c.parent_id=$pid";
$result = $db->Execute($sql);
while (!$result->EOF) {
$cats[] = $result->fields['categories_id'];
_getSubcategories ($result->fields['categories_id'], &$cats);
$result->MoveNext();
}
}

$top_cat_ids = array('1','25','35');
$exclude_categories = getSubcategories($top_cat_ids, true)      
            
      global $cart;
      if (!IS_ADMIN_FLAG && $_SESSION['cart']->in_cart_check('master_categories_id', $exclude_categories) > 0) {
        $this->enabled = false;
      } 

Would this work?

[tj1]

The function works, I've put it in the extra functions folder.

Now I've got all the category ids in an array called $all_cats_exclude

I'm trying to get it to work here by using

      global $cart;
      if (!IS_ADMIN_FLAG && $_SESSION['cart']->in_cart_check('master_categories_id', $all_cats_exclude) > 0) {
        $this->enabled = false;
      } 

But this is not working.

Does the function $_SESSION['cart']->in_cart_check('master_categories_id') work with an array or would I need to create a loop to run through all the values in the array?

(sorry for all the questions, as you can see my php knowledge is very basic)

[tj1]

This is what I'm using and it seems to finally work.

     if (!IS_ADMIN_FLAG) {
        global $cart;
        foreach($all_cats_exclude as $key => $cat_id_value){
        $chk_exclude_categories += $_SESSION['cart']->in_cart_check('master_categories_id',$cat_id_value);
        }
        if ($chk_exclude_categories > 0) {
          $this->enabled = false;
        }
      } 

For the file with the function to get the all the subcategories, it should go in the extra functions folder both in the catalog and admin; otherwise in the admin section it will give the 'call to undefined function" error.

[Ajeh]

How are you building your array: $all_cats_exclude

[tj1]

sorry, I forgot to include that, here's the complete code that goes in the freeoptions.php file
Just enter your top category ids in $top_cat_ids = array('1','2','3');

$top_cat_ids = array('1','2','3');
$all_cats_exclude = array();
foreach($top_cat_ids as $key => $top_id_value){
$subcat_results = getSubcategories($top_id_value, true);
    foreach($subcat_results as $key => $ind_cat_id_value){
        $all_cats_exclude[] = $ind_cat_id_value;
    } 

}

     if (!IS_ADMIN_FLAG) {
        global $cart;
        foreach($all_cats_exclude as $key => $cat_id_value){
        $chk_exclude_categories += $_SESSION['cart']->in_cart_check('master_categories_id',$cat_id_value);
        }
        if ($chk_exclude_categories > 0) {
          $this->enabled = false;
        }
      } 

Hope this helps someone, I saw many posts asking how to get all the subcategories by entering the top level category, but I could find any available solution.

[geodave]

I was so happy when I found this, but auugh, I just cannot get it to exclude a category from the free shipping option.

// disable only when entire cart is free shipping
      if (zen_get_shipping_enabled($this->code)) {
          $this->enabled = ((MODULE_SHIPPING_FREEOPTIONS_STATUS == 'True') ? true : false);
      }

      //Magical free shipping category exclusion code
      $top_cat_ids = array('108','9999','9999');
      $all_cats_exclude = array();
      foreach($top_cat_ids as $key => $top_id_value){
        $subcat_results = getSubcategories($top_id_value, true);
        foreach($subcat_results as $key => $ind_cat_id_value){
          $all_cats_exclude[] = $ind_cat_id_value;
        } 
      }

      if (!IS_ADMIN_FLAG) {
        global $cart;
        foreach($all_cats_exclude as $key => $cat_id_value){
          $chk_exclude_categories += $_SESSION['cart']->in_cart_check('master_categories_id',$cat_id_value);
        }
        if ($chk_exclude_categories > 0) {
          $this->enabled = false;
        }
      }
      //end category exclusion code 

I have that in my freeoptions.php file. When I have a shopping cart that qualifies for free shipping, then I add a product of master category 108, it still just offers free shipping.

Am I missing something crucial here?

[Ajeh]

Make sure that when you use the 108 that this is actually the master_categories_id in the products table ...

You can check this by going to the Catalog ... Categories/Products ... and find the Product and click E for edit and see what it reads for the:
Product Master Category:

What are your settings in the Free Shipping Options freeoptions shipping module that you see when you click on it and look at the right panel?

[geodave]

Yep, it's definitely the master categories ID.
In addition, my settings for the Free Shipping Options are unchanged from the default.

I cannot seem to get the addition of a product from category 108 to void the free shipping option and present regular shipping options. My category ID should be in the all_cats_exclude() array in the above code, right? I've tried it in both arrays and still I just get a free shipping option.

[Ajeh]

Check the /cache directory and ensure you have no error logs being generated on this ...