How to apply a tax to all items?

[idtags]

Hello,
I am trying to do the same (1.3.7 and 1.3.8)- To set tax to all products. Now I have to none.

First I did following:
"Catalog -> Product Types -> (choose a product type) -> Edit Layout -> Product Price Tax Default changed to 1

Than, I am using "SQL Query Executor" and type in window, where it says "Enter the query to be executed:" following combination (one at a time):

UPDATE products SET products_tax_class_id = 01;

or

UPDATE products SET products_tax_class_id = 1;

or

UPDATE products SET products_tax_class_id =01;

or

UPDATE products SET products_tax_class_id =1;

Than I am going to product editor and in the field "Tax Class" there is still -none-

Howevere if I manually select arror near it I can set State sale tax.

Do I do anythig wrong? What XX has to replaced with?

How would I know if remedy works?

Thanks, for respond in advance.

[Ajeh]

You need to get the id value for your tax ... edit a Product Manually and set it to taxed ... then look in the products_table to see what the value is that is set for the:
products_tax_class_id

[idtags]

Thanks for reply.

So far, I did not have a need to access products_table.

Do I look in products_table from C-panel or Zen Cart Admin?

[idtags]

Please, disregard previous questions.

I did figure out how to do it.

For others, like myself, who are from "mechanical" world here it is how to do it:

1. Go to product edit area in ZEN CART Admin and change manually first product to be taxed.

2. Go to your C-panel and click on phpMyAdmin icon.
This will take you to the next page.

3. In the upper left conner there are links to the data base. In my case it was called _ZC1 (Zen Cart 1?). Click on this link, you will get another page.

4. On the very left side is a long column with names/links of sub tables. Find the one called zen_products . Click on this link.

5. It will open on the same page this table. Scroll to the right to find column with title products_tax_class_id

6. You will see that 1-st product (which was edited in 1) has different products_tax_class_id
(in my case 2) than all others (1).

7. Next, go back to Zen Cart Admin, Tools, ... Install SQL Patches
and type in window, where it says "Enter the query to be executed:" following Code:

UPDATE products SET products_tax_class_id = 2;

Click Send

This should make it.

If this did not work, please let me know.

[Ajeh]

Thanks for the update and posting that in your case, the tax id value was 2 rather than the common value of 1 ...

Also, thanks for the detailed steps on how you were able to determine the products_tax_class_id from the products table via phpMyAdmin through your Control Panel of cPanel ...