If this is your first visit, check our documentation. To post, register or login.
Forums / Currencies & Sales Taxes, VAT, GST, etc. / Is there a database-adjustment to add a tax class at all productpages?

Is there a database-adjustment to add a tax class at all productpages?

Started by princess on 19 Mar 2013, 12:57 PM · Views: 889

Results 1 to 4 of 4
19 Mar 2013, 12:57 PM
#1
princess avatar

princess

New Zenner

Join Date:
Apr 2005
Posts:
59
Plugin Contributions:
0

Is there a database-adjustment to add a tax class at all productpages?

Goodmorning to you all,

I have a question, I have read a few days at this forum about a way to change all productpages that do not have a tax class now, into pages with a tax class. But,.............. I cannot find it anymore.

It was a database-adjustment.

Do you happen to know where I can find this adjustment? Or do you know what to do?

Thank you :):)

19 Mar 2013, 1:12 PM
#2
ajeh avatar

ajeh

Oba-san

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

Re: Is there a database-adjustment to add a tax class at all productpages?

Is this what you are trying to do where you want to set the Tax Class to 1 on ALL Products where Tax Class is currently set to 0?

UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

19 Mar 2013, 1:15 PM
#3
princess avatar

princess

New Zenner

Join Date:
Apr 2005
Posts:
59
Plugin Contributions:
0

Re: Is there a database-adjustment to add a tax class at all productpages?

Yes, that is what I mean. Thank you very much
Do I have to make a back-up from the whole database before adding that line?

19 Mar 2013, 1:25 PM
#4
ajeh avatar

ajeh

Oba-san

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

Re: Is there a database-adjustment to add a tax class at all productpages?

I would do a backup first then you can run that from your Zen Cart Admin in the Tools ... Install SQL Patches ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!