Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 36
  1. #11
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,403
    Plugin Contributions
    6

    Default Re: Change all products to taxable goods

    Thanks for the update that this worked 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!

  2. #12
    Join Date
    Jan 2010
    Posts
    2
    Plugin Contributions
    0

    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 ...
    This one worked for me as well. Thanks!

  3. #13
    Join Date
    Feb 2011
    Location
    Gladstone QLD Australia
    Posts
    5
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Thanks!! I Also got 100 products entered before I realised I needed them taxed. SQL update worked ...

  4. #14
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,403
    Plugin Contributions
    6

    Default Re: Change all products to taxable goods

    You are most welcome ... thanks for the update that this was able to help you sort out your missing Taxable products setting ...
    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!

  5. #15
    Join Date
    Apr 2011
    Location
    Colonial Beach Virginia
    Posts
    10
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    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!

  6. #16
    Join Date
    Jan 2004
    Posts
    64,748
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: Change all products to taxable goods

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

  7. #17
    Join Date
    Apr 2011
    Location
    Colonial Beach Virginia
    Posts
    10
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    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.

  8. #18
    Join Date
    Dec 2011
    Location
    Maine
    Posts
    5
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Thank you so much Ajeh! <3

  9. #19
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,403
    Plugin Contributions
    6

    Default Re: Change all products to taxable goods

    You are most welcome ... thanks for the update that this was able to help you out ...
    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!

  10. #20
    Join Date
    Jul 2012
    Posts
    308
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Worked for me. Thank you.
    How we can change all products only in one category to taxable / non taxable using sql?

 

 
Page 2 of 4 FirstFirst 1234 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