Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Tax Update MySQL

    Hi All,

    I've got 400+ products in my store (running 1.3.7) and I realized that I did not set these products to 'Taxable Goods' to handle in-state tax rates. Can anyone tell me which table I need to update in order to get all products designated as 'Taxable Goods'?

    Ideally I would like to make a mass update via phpMyAdmin - just need to know where to look - your help is appreciated!

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

    Default Re: Tax Update MySQL

    Code:
    UPDATE products SET products_tax_class=1;
    And go into Admin->Catalog->Product Types->Edit Layout ... and set the default tax class to 1.
    .

    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. #3
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Re: Tax Update MySQL

    Ah the good doctor comes to the rescue again - thank you kind sir! Just one slight tweak, the SQL is actually:

    UPDATE products SET products_tax_class_id=1;

    As the field name in 1.3.7 is 'products_tax_class_id', not 'products_tax_class'. Now that is based on the assumption that you are one of the software developers who has probably been working on this software since many versions ago - hopefully I did not update the wrong table!

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

    Default Re: Tax Update MySQL

    You are correct ... I always forget that "_id" bit until I actually run it and it doesn't work, which causes the gray matter to remember the correct field name.
    .

    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.

 

 

Similar Threads

  1. MySQL Update has crashed admin
    By PGlad in forum General Questions
    Replies: 5
    Last Post: 11 Jan 2012, 04:39 AM
  2. New Install - Admin won't update MySQL
    By David R in forum Installing on a Linux/Unix Server
    Replies: 12
    Last Post: 17 Nov 2011, 07:06 AM
  3. Replies: 1
    Last Post: 2 Feb 2008, 11:12 PM
  4. Can't edit MySQL Permissions or Update Priviledge Table
    By ssolis5788 in forum Installing on a Windows Server
    Replies: 4
    Last Post: 20 Feb 2007, 05:20 PM

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