MySQL command to Update Tax to all the products on the catalog automatically

This document will guide you on how to add the Tax to all the available products with a single MySQL script.

Procedure #

1. Administration Menu > Maintenance > Execute SQL

2. On the Saleculator SQL window, type or copy-paste the below MySQL command and click on the green play button to find the available Tax Categories and their respective ID

SELECT * FROM TAXCATEGORIES;

3. This will display the list of Tax categories with respective ID numbers (Refer to the below image)

4. The above example shows 3 Tax categories. Let’s try and apply “Tax 5%” to all the available products. (Note the Tax ID is 111 for the category “Tax 5%“)

5. Therefore, to apply the Tax 5% you need to type the below script and press the green play button

UPDATE PRODUCTS SET TAXCAT='111';

(Replace '111' with '000' to apply Tax Category "Tax Exempt" etc.,)

6. This will update all the products with Tax Category “Tax 5%” (Refer to the below image)