Where can I find the appropriate tax class ids in Magento database?

Where can I find the appropriate tax class ids in Magento database?

July 8, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Where can I find the appropriate tax class ids in Magento database?

Identifying Magento Tax Class IDs for API Product Creation

As a seasoned developer working with the Magento eCommerce platform, I often find myself needing to create products via the API. One field that frequently trips up developers is tax_class_id. This value determines which tax rate will be applied to your product.

The question arises: where do you find these values inside the database? Let’s dive into this issue step-by-step.

Understanding Magento Tax Classes

In Magento, tax classes are a way of grouping products by their applicable tax rate. You can manage them through the admin interface under Sales > Tax > Tax Classes.

Each tax class is assigned to a specific tax rate in the tax rules configuration. The tax_class_id field in your API product creation request should correspond to one of these pre-configured classes.

Locating Tax Class IDs in the Database

The Magento database contains multiple tables related to taxes, but the most relevant for our purposes is tax_class.

Here’s a simple MySQL query you can run to retrieve all tax class records:

SELECT * FROM tax_class;

You’ll see a table with columns like class_id, class_type_id, and title. The class_id field contains the integer values that you need for your API requests.

For example, if you want to create a product subject to 20% VAT in Austria, you might look for a tax class title like ‘VAT 20 %’. The corresponding class_id would be what you’d supply as tax_class_id.

A More Programmatic Approach

While the database query approach works, it’s not very scalable or secure. A better solution is to use Magento’s built-in API endpoints.

The Tax API provides a list of available tax classes:

GET /V1/taxClass/list

You can fetch this data programmatically in your code to avoid hardcoding IDs. This approach ensures that your application remains compatible with future changes to the Magento database schema or tax configuration.

Building an API Extension for Tax Classes

If you’re looking to build a custom API extension that returns a list of percentages along with their corresponding tax class, here’s a high-level roadmap:

  1. Create a new module: Follow Magento’s guide on creating a new module as a starting point: https://laravelcompany.com/magento-development/creating-a-new-module/

  2. Define your API resource: Create a new TaxClass model and define its attributes in the etc/api.xml file.

  3. Implement the action: In your controller, fetch tax classes from the tax_class table using Magento’s query builder or repository methods.

  4. Return the data: Serialize your taxonomy information into an array format suitable for your API response.

  5. Register the API endpoint: Ensure your new API resource is registered and accessible via the appropriate URL pattern.

Remember, proper security measures like authentication and access control are crucial when exposing internal Magento data through APIs. Always refer to the official documentation for best practices: https://laravelcompany.com/magento-2-api-security/

Conclusion

Locating tax class IDs in the Magento database is a straightforward process that can be achieved through basic SQL queries or by leveraging the built-in Tax API.

To make your development more efficient and secure, I recommend using the API approach for fetching taxonomy data. It ensures you’re working with up-to-date information without directly interacting with the database.

Don’t forget to check out our comprehensive guide on Magento 2 API development for more advanced techniques: https://laravelcompany.com/advanced-magento-2-api-development/

Happy coding!

Catalog Database API Admin

Our network