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?
New Zenner
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?
Totally Zenned
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
Mike
AEIIA - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!
Oba-san
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:
Linda McGrath
If you have to think ... you haven't been zenned ...
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!
New Zenner
Tried Ajeh's SQL patch and it worked for me.
Thanks a million!!!
New Zenner
<3 <3 <3!
Totally Zenned
That didnt work for me
Sensei
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.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Totally Zenned
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;
Teach them to shop and they will shop today;
Teach them to Zen and they will OWN a shop tomorrow!
New Zenner
Ajeh, you rock!!!! muchas, MUCHAS gracias!!!!! :clap:
New Zenner
Oh I love you!!! Thank you so much! It worked like a charm!!
~ V
Bless Your Body
https://www.blessyourbody.com
Oba-san
Thanks for the update that this worked for you ... :smile:
Linda McGrath
If you have to think ... you haven't been zenned ...
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!
New Zenner
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!
My zen store: BeltBuckle.com
New Zenner
Thanks!! I Also got 100 products entered before I realised I needed them taxed. SQL update worked ...
Oba-san
You are most welcome ... thanks for the update that this was able to help you sort out your missing Taxable products setting ... :smile:
Linda McGrath
If you have to think ... you haven't been zenned ...
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!
New Zenner
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!
Sensei
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.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
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.
New Zenner
Thank you so much Ajeh! <3
Oba-san
You are most welcome ... thanks for the update that this was able to help you out ... :smile:
Linda McGrath
If you have to think ... you haven't been zenned ...
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!
Zen Follower
Worked for me. Thank you.
How we can change all products only in one category to taxable / non taxable using sql?
Tell staff why this post should be reviewed.