elimination of sales tax for wholesale customers
Here is a mod for ver 3.5.x ( it will probably work with 4.x as well). This will eliminate default sales tas for wholesale customers.
Please open include/func.php of your x-cart, fund definition of function func_calculate_taxes and replace
if ($customer_info["s_state"])
$apply_taxes_to_shipping = array_pop(func_query_first("SELECT $sql_tbl[state_tax].tax_shipping FROM $sql_tbl[states], $sql_tbl[state_tax] WHERE $sql_tbl[states].code=$sql_tbl[state_tax].code $provider_condition AND $sql_tbl[state_tax].code='".$customer_info["s_state"]."' AND $sql_tbl[state_tax].country_code='".$customer_info["s_country"]."'"));
with
if ($customer_info["s_state"] && $customer_info['membership'] != 'Wholesale Level 1')
$apply_taxes_to_shipping = array_pop(func_query_first("SELECT $sql_tbl[state_tax].tax_shipping FROM $sql_tbl[states], $sql_tbl[state_tax] WHERE $sql_tbl[states].code=$sql_tbl[state_tax].code $provider_condition AND $sql_tbl[state_tax].code='".$customer_info["s_state"]."' AND $sql_tbl[state_tax].country_code='".$customer_info["s_country"]."'"));
then replace
if ($customer_info["s_state"])
$state_tax = func_query_first("select $sql_tbl[state_tax].* from $sql_tbl[states], $sql_tbl[state_tax] where $sql_tbl[states].code=$sql_tbl[state_tax].code $provider_condition and $sql_tbl[state_tax].code='".$customer_info["s_state"]."' AND $sql_tbl[state_tax].country_code='".$customer_info["s_country"]."'");
with
if ($customer_info["s_state"] && $customer_info['membership'] != 'Wholesale Level 1')
$state_tax = func_query_first("select $sql_tbl[state_tax].* from $sql_tbl[states], $sql_tbl[state_tax] where $sql_tbl[states].code=$sql_tbl[state_tax].code $provider_condition and $sql_tbl[state_tax].code='".$customer_info["s_state"]."' AND $sql_tbl[state_tax].country_code='".$customer_info["s_country"]."'");
In other words, you just need to add additional condition about membership level of a customer to
the function.
|