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.
Results 1 to 3 of 3
-
19 Jun 2009, 09:07 PM #1
Zen Follower
- Join Date
- Apr 2007
- Posts
- 151
- Plugin Contributions
- 0
Applying sales tax to items already inputted
-
19 Jun 2009, 09:38 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
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, 01:52 AM #3
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 codeNow all the products are taxable.PHP Code:UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0;
Is there anyway to change products in a specific subcategory so they are not taxable?
Similar Threads
-
New York State Sales Tax by Zip Full Database for Local Sales Tax Mod 2011
By SCHNiKEN in forum Currencies & Sales Taxes, VAT, GST, etc.Replies: 0Last Post: 11 Apr 2011, 04:51 AM -
[Done v1.3.9e] With Sales Tax Display Status=1, $0 Sales tax has wrong label
By swguy in forum Bug ReportsReplies: 11Last Post: 23 Jul 2010, 11:49 AM -
Sales tax on all items in cart
By plasticmart in forum General QuestionsReplies: 1Last Post: 20 Feb 2010, 02:22 AM -
1.3.7.1 Percentage Discounts & Multiple Items calculates Incorrect Sales Tax
By Kamino84 in forum Bug ReportsReplies: 0Last Post: 14 Oct 2009, 05:07 PM -
Sales Tax is being added to all items regardless of tax class
By sparrish in forum Currencies & Sales Taxes, VAT, GST, etc.Replies: 1Last Post: 17 Oct 2008, 05:48 PM
