Charge only one tax from resellers

[harmeet]

Hi scully2569

I was not sure if anybody else needs this. I am not expert, but I managed to hack the code to my needs. Here is how I did it -

Please note that you need to have the "dual_pricing_1_3" module installed before making this change.

Open the file includes/functions/functions_taxes.php

Close to line 32, look for -

    $tax_query = "select sum(tax_rate) as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority"; 

Replace it with -

// KLUDGE START by Harmeet - To charge only GST from resellers.
if ($_SESSION['customer_id']) {
    $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    if ($customer_check->fields['customers_whole'] != "0") {
        $whole = 1;
    }
}
if ($whole) {
    $tax_query = "select tax_rate as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority";
}
else {
// KLUDGE END
    $tax_query = "select sum(tax_rate) as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority";
// KLUDGE START by Harmeet - To charge only GST from resellers.
}
// KLUDGE END 

Close to line 78, look for -

    if ($tax->RecordCount() > 0) {
      $tax_description = '';
      while (!$tax->EOF) {
        $tax_description .= $tax->fields['tax_description'] . ' + ';
        $tax->MoveNext();
      }
      $tax_description = substr($tax_description, 0, -3);

      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    } 

Replace it with -

// KLUDGE START by Harmeet - To charge only GST from resellers.
  if ($_SESSION['customer_id']) {
    $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    if ($customer_check->fields['customers_whole'] != "0") {
        $whole = 1;
    }
  }
  if ($whole) {
    if ($tax->RecordCount() > 0) {
      $tax_description = $tax->fields['tax_description'] . ' + ';
      $tax_description = substr($tax_description, 0, -3);
      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    }
  }
  else {
// KLUDGE END
    if ($tax->RecordCount() > 0) {
      $tax_description = '';
      while (!$tax->EOF) {
        $tax_description .= $tax->fields['tax_description'] . ' + ';
        $tax->MoveNext();
      }
      $tax_description = substr($tax_description, 0, -3);

      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    }
// KLUDGE START by Harmeet - To charge only GST from resellers.
  }
// KLUDGE END 

Hope it works for you.

Thanks

[harmeet]

Here is the link to the Dual Pricing module -

http://www.zen-cart.com/forum/showthread.php?t=35450

Thanks

[scully2569]

That is awesome, I will tackle that one soon!
Thanks for replying

[MB1]

sweet this must be the answer i have been looking for?

[fraso]

Now it seems that Zen Cart has some code that apparently works for wholesalers (Thanks Harmeet!), I'm going to seriously test how well this works for my needs. However, there is another download (Tax Exemption Status) that seems to be similar to the the modifed Dual Pricing module.

Has anyone set up a store for both retail and wholesale customers so that wholesale customers are exempt from paying provincial retail sales tax (in Canada)?

[Veronika7747]

Hi scully2569

I was not sure if anybody else needs this. I am not expert, but I managed to hack the code to my needs. Here is how I did it -

Please note that you need to have the "dual_pricing_1_3" module installed before making this change.

Open the file includes/functions/functions_taxes.php

Close to line 32, look for -

    $tax_query = "select sum(tax_rate) as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority"; 

Replace it with -

// KLUDGE START by Harmeet - To charge only GST from resellers.
if ($_SESSION['customer_id']) {
    $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    if ($customer_check->fields['customers_whole'] != "0") {
        $whole = 1;
    }
}
if ($whole) {
    $tax_query = "select tax_rate as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority";
}
else {
// KLUDGE END
    $tax_query = "select sum(tax_rate) as tax_rate
                  from (" . TABLE_TAX_RATES . " tr
                  left join " . TABLE_ZONES_TO_GEO_ZONES . " za on (tr.tax_zone_id = za.geo_zone_id)
                  left join " . TABLE_GEO_ZONES . " tz on (tz.geo_zone_id = tr.tax_zone_id) )
                  where (za.zone_country_id is null
                  or za.zone_country_id = 0
                  or za.zone_country_id = '" . (int)$country_id . "')
                  and (za.zone_id is null
                  or za.zone_id = 0
                  or za.zone_id = '" . (int)$zone_id . "')
                  and tr.tax_class_id = '" . (int)$class_id . "'
                  group by tr.tax_priority";
// KLUDGE START by Harmeet - To charge only GST from resellers.
}
// KLUDGE END 

Close to line 78, look for -

    if ($tax->RecordCount() > 0) {
      $tax_description = '';
      while (!$tax->EOF) {
        $tax_description .= $tax->fields['tax_description'] . ' + ';
        $tax->MoveNext();
      }
      $tax_description = substr($tax_description, 0, -3);

      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    } 

Replace it with -

// KLUDGE START by Harmeet - To charge only GST from resellers.
  if ($_SESSION['customer_id']) {
    $customers_id = $_SESSION['customer_id'];
    $customer_check = $db->Execute("select * from " . TABLE_CUSTOMERS . " where customers_id = '$customers_id'");
    if ($customer_check->fields['customers_whole'] != "0") {
        $whole = 1;
    }
  }
  if ($whole) {
    if ($tax->RecordCount() > 0) {
      $tax_description = $tax->fields['tax_description'] . ' + ';
      $tax_description = substr($tax_description, 0, -3);
      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    }
  }
  else {
// KLUDGE END
    if ($tax->RecordCount() > 0) {
      $tax_description = '';
      while (!$tax->EOF) {
        $tax_description .= $tax->fields['tax_description'] . ' + ';
        $tax->MoveNext();
      }
      $tax_description = substr($tax_description, 0, -3);

      return $tax_description;
    } else {
      return TEXT_UNKNOWN_TAX_RATE;
    }
// KLUDGE START by Harmeet - To charge only GST from resellers.
  }
// KLUDGE END 

Hope it works for you.

Thanks

I know this is 2 years old, but I tried it with the new Dual Pricing/Wholesale module, but it works only for wholesale levels. When I have a retailer (indicated as wholesale level 0) it also does not include PST.
Anyone got it working??
Tx Veronika

[Veronika7747]

I know this is 2 years old, but I tried it with the new Dual Pricing/Wholesale module, but it works only for wholesale levels. When I have a retailer (indicated as wholesale level 0) it also does not include PST.
Anyone got it working??
Tx Veronika

I got this working, but now I have a problem with HST for wholesalers in Eastern Canada ( ns, nf, nb) as they are still being charged 13% HST. I am assuming their HST should also drop the 8% PST, right?
Any comments
Tx