Different free shipping depending on customer discount group

[elgar]

Hi! I need to provide two different free shipping options depending on the customer's discount group. For instance, retail customer would get free shipping if his total is over $300. But for a wholesale customer I need to provide a different free shipping option, which is when their order is over $500.

I will appreciate your help very much.

Thank you.

[Ajeh]

How do you identify your Retail customer vs Wholesaler customer now?

[elgar]

How do you identify your Retail customer vs Wholesaler customer now?

I use dual pricing mod, and also I put wholesalers into a distributor pricing group.

[Ajeh]

If you have a "flag" as in something that distinguishes the customer type you can use that on the modules to enable or disable a feature ...

I am guessing that you are using the Modules ... Order Totals ... Shipping ot_shipping with the Free Shipping on Orders >= XX.XX setting ...

You would want to customize the module for the value of where the:
MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING

key is and base that value instead on the customer type and the values you want to use ...

[elgar]

If you have a "flag" as in something that distinguishes the customer type you can use that on the modules to enable or disable a feature ...

I am guessing that you are using the Modules ... Order Totals ... Shipping ot_shipping with the Free Shipping on Orders >= XX.XX setting ...

You would want to customize the module for the value of where the:
MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING

key is and base that value instead on the customer type and the values you want to use ...

Thank you very much for the answer. I am not good at code. Could you please specify which line of the code I need to change, and how?

[Ajeh]

Change the code in the ot_shipping.php from:

        if ( ($pass == true) && ( ($order->info['total'] - $order->info['shipping_cost']) >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) {
          $order->info['shipping_method'] = $this->title;
          $order->info['total'] -= $order->info['shipping_cost'];
          $order->info['shipping_cost'] = 0;
        }

To read:

// check for customer group where wholesale group = 2
$group_check = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");
if ($group_check->fields['customers_group_pricing'] == 2) {
// whole sale for over 500
  $over_total = 500;
} else {
// retail sale for over set amount
  $over_total = MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER;
}
        if ( ($pass == true) && ( ($order->info['total'] - $order->info['shipping_cost']) >= $over_total) ) {
          $order->info['shipping_method'] = $this->title;
          $order->info['total'] -= $order->info['shipping_cost'];
          $order->info['shipping_cost'] = 0;
        }

Change the = 2 to be the customers_group_pricing for the whole salers ...

Set the value of the Free Shipping over XX.XX to be the 300.00 or what ever you want for retail to be ...

This should work ... but, you are the guinea pig as I haven't had time to test it yet ...

But it should work ... in theory ...

[Ajeh]

Scratch that ... needs more customization so I am going to have to work on this a bit ... but getting there ...

[Ajeh]

Step 2 is to change the code in:
/includes/modules/pages/checkout_shipping/header_php.php

from:

    $free_shipping = false;
    if ( ($pass == true) && ($_SESSION['cart']->show_total() >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) {
      $free_shipping = true;
    }

to read:

// check for customer group where wholesale group = 2
global $db, $cart;
$group_check = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");

if ($group_check->fields['customers_group_pricing'] == 2) {
// whole sale for over 500
  $over_total = 500;
} else {
// retail sale for over set amount
  $over_total = MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER;
}

    $free_shipping = false;
    if ( ($pass == true) && ($_SESSION['cart']->show_total() >= $over_total) ) {
      $free_shipping = true;
    }

Still need to fix the display on the template to know which value to show ... that will be step 3 ...

[Ajeh]

Step 2B ... forgot the shipping estimator ...

Change the file:
/includes/modules/shipping_estimator.php

the lines:

    $free_shipping = false;
    if ( ($pass == true) && ($_SESSION['cart']->show_total() >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER)) {
      $free_shipping = true;
      include(DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/order_total/ot_shipping.php');
    }

Should read:

// check for customer group where wholesale group = 2
global $db, $cart;
$group_check = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");

if ($group_check->fields['customers_group_pricing'] == 2) {
// whole sale for over 500
  $over_total = 500;
} else {
// retail sale for over set amount
  $over_total = MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER;
}

    $free_shipping = false;
    if ( ($pass == true) && ($_SESSION['cart']->show_total() >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER)) {
      $free_shipping = true;
      include(DIR_WS_LANGUAGES . $_SESSION['language'] . '/modules/order_total/ot_shipping.php');
    }

[Ajeh]

Step 3 ...

Change the template file for:
/includes/templates/template_default/templates/tpl_checkout_shipping_default.php

where it reads:

<div id="defaultSelected"><?php echo sprintf(FREE_SHIPPING_DESCRIPTION, $currencies->format(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER)) . zen_draw_hidden_field('shipping', 'free_free'); ?></div>

to read:

<?php
// check for customer group where wholesale group = 2
global $db, $cart;
$group_check = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");

if ($group_check->fields['customers_group_pricing'] == 2) {
// whole sale for over 500
  $over_total = 500;
} else {
// retail sale for over set amount
  $over_total = MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER;
}
?>
<div id="defaultSelected"><?php echo sprintf(FREE_SHIPPING_DESCRIPTION, $currencies->format($over_total)) . zen_draw_hidden_field('shipping', 'free_free'); ?></div>

Then change the template file for the shipping estimator:
/includes/templates/template_default/templates/tpl_modules_shipping_estimator.php

where it reads:

<?php echo sprintf(FREE_SHIPPING_DESCRIPTION, $currencies->format(MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER)); ?>

to read:

<?php
// check for customer group where wholesale group = 2
global $db, $cart;
$group_check = $db->Execute("select customers_group_pricing from " . TABLE_CUSTOMERS . " where customers_id = '" . (int)$_SESSION['customer_id'] . "'");

if ($group_check->fields['customers_group_pricing'] == 2) {
// whole sale for over 500
  $over_total = 500;
} else {
// retail sale for over set amount
  $over_total = MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER;
}
echo sprintf(FREE_SHIPPING_DESCRIPTION, $currencies->format($over_total));
?>

NOTE: on all of these changes be sure to use your templates and override directories where applicable ...

Wasn't that a fun time to write? Remember us when you are rich and famous!