Applying sales tax to items already inputted

19 Jun 2009, 8:07 PM

Zen Follower

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

Applying sales tax to items already inputted

Is there a way to apply Sales Tax to items that have already been inputted into the database such as applying the Sales tax to the whole Subcategory or Category?

I'm trying to avoid having to edit each individual item and clicking on the drop down box to select Taxable Goods.

http://www.SullivanVitamins.com

America's Favorite Vitamin Source & Irish Shop

19 Jun 2009, 8:38 PM

drbyte

Sensei

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

Re: Applying sales tax to items already inputted

.
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.

20 Jun 2009, 12:52 AM

gws76

Zen Follower

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

Re: Applying sales tax to items already inputted

Thanks I used the solution in this thread.
http://www.zen-cart.com/forum/showthread.php?t=61896

I backed up my database first then in Admin > Tools > Install SQL Patches. Pasted in the box "Enter the query to be executed" the code ```php
UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;


Now all the products are taxable.  

Is there anyway to change products in a specific subcategory so they are not taxable?

http://www.SullivanVitamins.com

America's Favorite Vitamin Source & Irish Shop