Page 4 of 4 FirstFirst ... 234
Results 31 to 36 of 36
  1. #31
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    309
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Thanks for this SQL patch; UPDATE products SET products_tax_class_id=1;

    Works great but ...

    I currently have my prices set as "tax included" and tax class "none" so today on the product set up page each of my "net price" is the same as my "gross price"

    When I run this patch it, of course, causes the tax to be added to my net price to create a new gross price which is too high.

    This seems like an issue other people will have run into but I did not find a solution anywhere?

    I suppose I could write an SQL patch to copy each of the net prices to the gross price box and then recalculate the net prices, does not seem too elegant a solution?

  2. #32
    Join Date
    Jan 2004
    Posts
    64,747
    Blog Entries
    6
    Plugin Contributions
    214

    Default Re: Change all products to taxable goods

    Quote Originally Posted by marton_1 View Post
    Thanks for this SQL patch; UPDATE products SET products_tax_class_id=1;

    Works great but ...

    I currently have my prices set as "tax included" and tax class "none" so today on the product set up page each of my "net price" is the same as my "gross price"

    When I run this patch it, of course, causes the tax to be added to my net price to create a new gross price which is too high.

    This seems like an issue other people will have run into but I did not find a solution anywhere?

    I suppose I could write an SQL patch to copy each of the net prices to the gross price box and then recalculate the net prices, does not seem too elegant a solution?
    The patch provided doesn't take into account the very unusual action of changing the entire store from tax-added to tax-included. That requires manual editing of each price to remove the tax component, because it still adds the tax at checkout (just displays it differently).
    .

    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.

  3. #33
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    309
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    OK, thanks

  4. #34
    Join Date
    Jun 2009
    Location
    Sparta, TN
    Posts
    61
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    I recall seeing something similar years ago. You may want to look at a couple of older threads on increasing and decreasing prices.
    https://www.zen-cart.com/showthread....ecrease+prices
    https://www.zen-cart.com/showthread....versally/page3
    Last edited by VDecalS; 1 Aug 2016 at 09:44 PM. Reason: seperate links

  5. #35
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    309
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Great thanks

    I experimented with - UPDATE products SET products_price = products_price / (1 + tax rate)
    Then ran the - UPDATE products SET products_tax_class_id=1;

    Worked fine on my test site.

    Now I just have to do the same with my attribute prices

  6. #36
    Join Date
    Apr 2013
    Location
    eglisau switzerland
    Posts
    309
    Plugin Contributions
    0

    Default Re: Change all products to taxable goods

    Quote Originally Posted by DrByte View Post
    The patch provided doesn't take into account the very unusual action of changing the entire store from tax-added to tax-included. That requires manual editing of each price to remove the tax component, because it still adds the tax at checkout (just displays it differently).
    Was not really my idea, the tax authorities were pushing me to show the tax value on the invoice

    Anyway turned out OK.

    I ran Change tax category "UPDATE products SET products_tax_class_id=1;"
    The few products in a different tax class I changed manually to tax_class_id=2

    Then I ran "UPDATE products SET products_price = products_price /(1 plus tax rate) WHERE products_tax_class_id=1;"
    Did the same for tax_class_id=2

    Then I ran Fix tax in attribute prices; "UPDATE products_attributes SET options_values_price = options_values_price/(1 plus tax rate) WHERE options_values_price <> '0';"

    Then I ran Fix tax in specials prices; "UPDATE specials SET specials_new_products_price = specials_new_products_price/(1 plus tax rate) WHERE specials_new_products_price <> '0';"

    The few attributes and specials for tax rate 2 I changed manually, I could also have tried multiple WHERE statements.

 

 
Page 4 of 4 FirstFirst ... 234

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