HELP Zones Shipping (Extra Cost For Large Items)

[simon1066]

You would need to edit the Zone Rates zones and the Free Shipping Options freeoptions for this ...

This would add that extra charge to both shipping methods ...

For the Zone Rates zones, edit the file with the code in RED:
/includes/modules/shipping/zones.php

// bof: check for oversized items and charge £15.00 extra per item
global $cart;
$chk_oversized = 0;
$oversized_title = '';
$chk_oversized += $_SESSION['cart']->in_cart_check('products_id', '1053');
$chk_oversized += $_SESSION['cart']->in_cart_check('products_id', '1046');
$chk_oversized += $_SESSION['cart']->in_cart_check('products_id', '3242');
$extra_shipping = $chk_oversized * 15.00;
if ($extra_shipping > 0) {
$oversized_title = '+ overweight shipping surcharge';
} else {
  $oversized_title = '';
}

      $this->quotes = array('id' => $this->code,
                            'module' => MODULE_SHIPPING_ZONES_TEXT_TITLE,
                            'methods' => array(array('id' => $this->code,
                                                     'title' => $shipping_method . $oversized_title,
                                                     'cost' => $shipping_cost + $extra_shipping)));

So glad I came across this bit of code. I've applied it to a Table Rate clone and I want to be able to check the cart for an oversized item as defined by its attribute. Just adding

$chk_oversized += $_SESSION['cart']->in_cart_check('products_attributes_id', '8');

doesn't work because, I think, that in_cart_check is looking in TABLE_PRODUCTS.

It may be that I need to code another function in includes\classes\shopping_cart.php to allow for a check in TABLE_PRODUCTS_ATTRIBUTES, just guessing really. Does anyone have any suggestions as to how to include an attribute check in this oversized items code?

[simon1066]

Well blow me down! It seems I was on the right track.

I added

$chk_oversized += $_SESSION['cart']->in_cart_check_attrib('products_attributes_id', '8');

into Ajeh's code and created this new function in shopping_cart.php

/* Method to calculate the number of items in a cart based on an attribute property */
  
   function in_cart_check_attrib($check_what, $check_value='1') {
    global $db;
    // if nothing is in cart return 0
    if (!is_array($this->contents)) return 0;

    // compute total quantity for field
    $in_cart_check_qty=0;

    reset($this->contents);
    while (list($products_id, ) = each($this->contents)) {
      $testing_id = zen_get_prid($products_id);
      // check if field it true
      $product_check = $db->Execute("select " . $check_what . " as check_it from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id='" . $testing_id . "' limit 1");
      if ($product_check->fields['check_it'] == $check_value) {
        $in_cart_check_qty += $this->contents[$products_id]['qty'];
      }
    }
    return $in_cart_check_qty;
  }

Seems to work fine.

[simon1066]

Ok, still need a bit of help on this.

The 'check for oversized items' is identifying the product just because it has the desired attribute, not because the product has that attribute selected in the shopping cart.

Suggestions welcome.

[Ajeh]

Is this products_attributes_id 8 the only Attribute on this Product?

[simon1066]

No, it also has a products_attributes_id of '7'

No Frame - products_attributes_id 7 (options_values_id 2)
With Frame - products_attributes_id 8 (options_values_id 1)

Only some products have a frame option

It is products 'With Frame' that need to be classed as oversized

[Ajeh]

Would something like this work for you?

/* Method to calculate the number of items in a cart based on an attribute option_id and option_values_id combo */
// example: $_SESSION['cart']->in_cart_check_attrib_quantity(1, 16)

  function in_cart_check_attrib_quantity($check_option_id, $check_option_values_id) {
//    global $db;
    // if nothing is in cart return 0
    if (!is_array($this->contents)) return 0;

    // compute total quantity for field
    $in_cart_check_qty = 0;

    $chk_products = $this->get_products();
    for ($i=0, $n=sizeof($chk_products); $i<$n; $i++) {
      foreach ($chk_products[$i]['attributes'] as $option => $value) {
        if ($option == $check_option_id && $value == $check_option_values_id) {
//          echo 'Attribute FOUND FOR $option: ' . $option . ' $value: ' . $value . ' quantity: ' . $chk_products[$i]['quantity'] . '<br><br>';
          $in_cart_check_qty += $chk_products[$i]['quantity'];
        }
      }
    }
    return $in_cart_check_qty;
  }

I have an idea to expand a similar function with more flexibility in the future but I am still giving it a think ...

[simon1066]

Would something like this work for you?

/* Method to calculate the number of items in a cart based on an attribute option_id and option_values_id combo */
// example: $_SESSION['cart']->in_cart_check_attrib_quantity(1, 16)

  function in_cart_check_attrib_quantity($check_option_id, $check_option_values_id) {
//    global $db;
    // if nothing is in cart return 0
    if (!is_array($this->contents)) return 0;

    // compute total quantity for field
    $in_cart_check_qty = 0;

    $chk_products = $this->get_products();
    for ($i=0, $n=sizeof($chk_products); $i<$n; $i++) {
      foreach ($chk_products[$i]['attributes'] as $option => $value) {
        if ($option == $check_option_id && $value == $check_option_values_id) {
//          echo 'Attribute FOUND FOR $option: ' . $option . ' $value: ' . $value . ' quantity: ' . $chk_products[$i]['quantity'] . '<br><br>';
          $in_cart_check_qty += $chk_products[$i]['quantity'];
        }
      }
    }
    return $in_cart_check_qty;
  }

I have an idea to expand a similar function with more flexibility in the future but I am still giving it a think ...

I think that is exactly what I needed, the couple of checks I've made seem to work well - I'll test more once I've fully set up my shipping and hopefully give some feedback/suggestions for your future design.

This last bit of help was all I needed to finalise my shipping costs (until I find something else!) so thank you very much.

I've sent the Team a coffee and donut.

Cheers

Simon

[Ajeh]

Thanks for the update that this was able to work for you ...

The Zen Cart Team also appreciates the support ... we really love those coffees and donuts!