Change all products to taxable goods

29 Apr 2007, 2:24 AM

#1

New Zenner

Join Date:: Apr 2007
Posts:: 14
Plugin Contributions:: 0

Change all products to taxable goods

Is there a way to "flip a switch" and all products would have a tax class of TAXABLE GOODS. They are currently set to NONE.

Any ideas?

29 Apr 2007, 3:12 AM

#2

barco57

Totally Zenned

Join Date:: Apr 2006
Location:: West Salem, IL
Posts:: 2,845
Plugin Contributions:: 0

Re: Change all products to taxable goods

you need to run the following query in phpmyadmin

UPDATE zen_products SET products_tax_class_id=1 WHERE products_tax_class_id=''

the zen_ maybe needed to be changed to match the prefix on your tables
that would be two single quotes

3 May 2007, 4:00 AM

#3

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Change all products to taxable goods

Personally, I'd cheat on this ...

If you want ALL products to be taxable ...

Go to Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1;

This will fix it with or without prefixes as it is built to manage that for you ... :smile:

14 Aug 2007, 3:49 AM

#4

kgmmusic

New Zenner

Join Date:: Nov 2005
Posts:: 76
Plugin Contributions:: 0

Re: Change all products to taxable goods

Tried Ajeh's SQL patch and it worked for me.

Thanks a million!!!

15 Dec 2007, 6:30 PM

#5

paulinenmu

New Zenner

Join Date:: Sep 2005
Posts:: 23
Plugin Contributions:: 0

Re: Change all products to taxable goods

<3 <3 <3!

26 Feb 2008, 8:29 PM

#6

cntgifts

Totally Zenned

Join Date:: Sep 2005
Posts:: 836
Plugin Contributions:: 0

Re: Change all products to taxable goods

That didnt work for me

28 Feb 2008, 5:12 PM

#7

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Change all products to taxable goods

CnTGifts:

That didnt work for me

Then your active tax class isn't number "1". Change the "1" to whatever your active/desired tax class is.

Or just change every product manually.

22 Apr 2008, 3:29 AM

#8

get_em_fast

Totally Zenned

Join Date:: Dec 2006
Location:: Seligman, MO U.S.A.
Posts:: 2,072
Plugin Contributions:: 1

Re: Change all products to taxable goods

Ajeh:

Personally, I'd cheat on this ...

If you want ALL products to be taxable ...

Go to Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1;


Thanks Ajeh, this also works GREAT to **remove** the tax class on a vast amount of products if you change the 1 to a 0 like:

```php
UPDATE products SET products_tax_class_id=0;

2 May 2008, 3:20 PM

#9

kmichel

New Zenner

Join Date:: Jul 2006
Posts:: 14
Plugin Contributions:: 0

Re: Change all products to taxable goods

Ajeh, you rock!!!! muchas, MUCHAS gracias!!!!! :clap:

26 Mar 2010, 5:31 AM

#10

terra1069

New Zenner

Join Date:: Jan 2010
Posts:: 10
Plugin Contributions:: 0

Re: Change all products to taxable goods

Oh I love you!!! Thank you so much! It worked like a charm!!

26 Mar 2010, 1:23 PM

#11

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Change all products to taxable goods

Thanks for the update that this worked for you ... :smile:

20 May 2010, 12:48 PM

#12

jayehmke

New Zenner

Join Date:: Jan 2010
Posts:: 2
Plugin Contributions:: 0

Re: Change all products to taxable goods

Ajeh:

Personally, I'd cheat on this ...

If you want ALL products to be taxable ...

Go to Tools ... Insert SQL Patches ...

UPDATE products SET products_tax_class_id=1;

> 
> This will fix it with or without prefixes as it is built to manage that for you ... :smile:

This one worked for me as well.  Thanks!

27 Feb 2011, 2:54 PM

#13

kathrynbau

New Zenner

Join Date:: Feb 2011
Location:: Gladstone QLD Australia
Posts:: 5
Plugin Contributions:: 0

Re: Change all products to taxable goods

Thanks!! I Also got 100 products entered before I realised I needed them taxed. SQL update worked ...

27 Feb 2011, 3:32 PM

#14

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Change all products to taxable goods

You are most welcome ... thanks for the update that this was able to help you sort out your missing Taxable products setting ... :smile:

23 Nov 2011, 1:12 AM

#15

lenpilot

New Zenner

Join Date:: Apr 2011
Location:: Colonial Beach Virginia
Posts:: 10
Plugin Contributions:: 0

Re: Change all products to taxable goods

Thank you! Very cool. Worked like a charm on 11,600 products I forgot to address in the customers 12 ez-poplulate uploads.

That sql patch page could be dangerous in the wrong hands!

23 Nov 2011, 2:04 AM

#16

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Change all products to taxable goods

Lenpilot:

That sql patch page could be dangerous in the wrong hands!Exactly. That's why we encourage people to "do it right the first time", and find long-term fixes instead of using tools dangerously without the knowledge required to be safe.

28 Nov 2011, 12:06 AM

#17

lenpilot

New Zenner

Join Date:: Apr 2011
Location:: Colonial Beach Virginia
Posts:: 10
Plugin Contributions:: 0

Re: Change all products to taxable goods

Taxable options are not typically in a product upload file although the field can easily be added. I do know my way around an sql query and certainly back up everything before executing strange ones.

And since you built this thing, I will most definitely heed your advice.

My comment was made to imply that I would hate for a hacker to successfully find himself on this page.

9 Jan 2012, 4:56 AM

#18

valentine88

New Zenner

Join Date:: Dec 2011
Location:: Maine
Posts:: 5
Plugin Contributions:: 0

Re: Change all products to taxable goods

Thank you so much Ajeh! <3

9 Jan 2012, 2:30 PM

#19

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Change all products to taxable goods

You are most welcome ... thanks for the update that this was able to help you out ... :smile:

24 Jul 2014, 11:30 AM

#20

jsarwar

Zen Follower

Join Date:: Jul 2012
Posts:: 347
Plugin Contributions:: 0

Re: Change all products to taxable goods

Worked for me. Thank you.
How we can change all products only in one category to taxable / non taxable using sql?