Page 1 of 4 123 ... LastLast
Results 1 to 10 of 36
  1. #1
    Join Date
    Apr 2007
    Posts
    14
    Plugin Contributions
    0

    Default 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?

  2. #2
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,739
    Plugin Contributions
    0

    Default 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
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

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

    PHP Code:
    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 ...
    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: v1.5.5]
    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!

  4. #4
    Join Date
    Nov 2005
    Posts
    77
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

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

    Thanks a million!!!

  5. #5
    Join Date
    Sep 2005
    Posts
    24
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    <3 <3 <3!

  6. #6
    Join Date
    Sep 2005
    Posts
    912
    Plugin Contributions
    1

    Default Re: Change all products to taxable goods

    That didnt work for me

  7. #7
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Change all products to taxable goods

    Quote Originally Posted by CnTGifts View Post
    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.

  8. #8
    Join Date
    Dec 2006
    Location
    Seligman, MO U.S.A.
    Posts
    2,101
    Plugin Contributions
    5

    Default Re: Change all products to taxable goods

    Quote Originally Posted by Ajeh View Post
    Personally, I'd cheat on this ...

    If you want ALL products to be taxable ...

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

    PHP Code:
    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 ...
    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 Code:
    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!

  9. #9
    Join Date
    Jul 2006
    Posts
    14
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

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

  10. #10

    Default Re: Change all products to taxable goods

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

 

 
Page 1 of 4 123 ... LastLast

Similar Threads

  1. Taxable goods is not add 10% to my products? how to fix?
    By anqus11 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 17 Oct 2011, 12:59 PM
  2. need to set all products to taxable goods
    By keylesslocks in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 14 Jul 2007, 02:03 PM
  3. Taxable goods Option
    By Paradigm81 in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 6
    Last Post: 5 Jul 2007, 07:29 PM
  4. Taxable Goods problem
    By joshlfisher in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 2
    Last Post: 30 Oct 2006, 03:54 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR