SyCoDeath Posted March 18, 2009 Share Posted March 18, 2009 Is it possible to make all items taxable, I would like an SQL querie to make all of my items taxable... i have over 500 and it would take forever to do them individually. Please Help Link to comment Share on other sites More sharing options...
SyCoDeath Posted March 18, 2009 Author Share Posted March 18, 2009 i have even tried another users idea, but no matter what all items are still showing --none-- Some please help me out, at my wits end Link to comment Share on other sites More sharing options...
federico_jacobi Posted March 19, 2009 Share Posted March 19, 2009 that can easily be done ... MAKE a tax class or rate or zone ... or all ..... now if you check the table "tax_class" there should be a class created GET THE ID number from that ... and now it's downhill 1.- BACKUP FIRST 2.- UPDATE products SET products_tax_class_id=XXXX XXXX is the class id you got before .... 3.- DONE piece of cake (or at least that worked for me) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.