Get tax_calculation_rule_id from Tax class in magento

Get tax_calculation_rule_id from Tax class in magento

August 25, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Get tax_calculation_rule_id from Tax class in magento

Retrieving Tax Calculation Rule ID in Magento

Tax management is a critical aspect of e-commerce platforms like Magento. As a developer working on a custom module for tax rule extensions, you may need to retrieve the tax_calculation_rule_id based on customer and product tax class names. Let’s walk through this process step-by-step.

Understanding Tax Rules in Magento

In Magento, tax rules are defined by combining tax classes assigned to products with those assigned to customers. The connection between these two classes determines the applicable tax rate for a particular transaction.

Each tax rule is identified by a unique tax_calculation_rule_id. To access this ID programmatically, we need to query the tax_calculation_rules table in your database.

Retrieving Tax Calculation Rule ID

Firstly, ensure that you have the correct customer and product tax class names. These are typically set up during store configuration:

$customerTaxClass = 'Customer Group Tax Class Name';
$productTaxClass = 'Product Tax Class Name';

Next, we’ll create a function to fetch the tax_calculation_rule_id based on these two classes.

Creating a Helper Function

In your module’s helper class or service layer, add the following code:

public function getCalculationRuleId($customerClass, $productClass)
{
    $connection = $this->resourceConnection->getConnection();
    $select = $connection->select()
        ->from(['crt' => 'tax_calculation_rules'])
        ->where('crt.tax_customer_class_id IN (SELECT ecc.entity_type_id FROM eav_attribute AS ea
            JOIN eav_attribute_group AS ag ON ea.attribute_set_id = ag.attribute_set_id
            JOIN customer_group AS cg ON ag.group_id = cg.group_id WHERE cg.customer_group_code = ?)',
            $customerClass)
        ->where('crt.tax_product_class_id IN (SELECT tpc.entity_type_id FROM eav_attribute AS ea
            JOIN eav_attribute_group AS ag ON ea.attribute_set_id = ag.attribute_set_id
            JOIN tax_product_class AS tpc ON ag.group_id = tpc.group_id WHERE tpc.product_tax_class_code = ?)',
            $productClass);

    $result = $connection->fetchOne($select);
    return $result;
}

This function queries the tax_calculation_rules table, joining it with customer and product tax class tables to find the matching rule ID.

Implementing the Function

In your module’s controller or observer method, call this helper function:

$customerTaxClass = 'Customer Tax Class'; // Replace with actual name
$productTaxClass = 'Product Tax Class';   // Replace with actual name
$ruleId = $helper->getCalculationRuleId($customerTaxClass, $productTaxClass);

If a matching rule is found based on the provided tax class names, $ruleId will contain the required tax_calculation_rule_id.

Conclusion

Retrieving the tax_calculation_rule_id is crucial for extending Magento’s built-in tax calculation logic. By using the helper function described above, you can efficiently obtain this ID during your module’s execution.

For more advanced tax rule customizations and extensions, consider exploring the Magento Tax Extension Marketplace for pre-built solutions that can simplify your development process.

Catalog Database Extensions Configuration

Our network