Fractal Posted March 15, 2003 Share Posted March 15, 2003 Hi, After searching the forums I figured out how to turn sales tax on for a product, by making sure the "taxable goods" drop down was selected. Is there a way to automate this rather than going through each product individually and making sure the taxable goods option is selected. It would be unrealistic to do this individually for a thousand products. We used easypopulate to upload the products in the first place. Thanks. Any help would be greatly appreciated. -Fractal Link to comment Share on other sites More sharing options...
Ajeh Posted March 15, 2003 Share Posted March 15, 2003 You could edit the settings via phpMyAdmin and assuming your products_tax_class_id you want is 1 and the ones to change are 0 use: UPDATE products set products_tax_class_id =1 where products_tax_class_id=0 Link to comment Share on other sites More sharing options...
wasson65 Posted March 23, 2003 Share Posted March 23, 2003 Hi, After searching the forums I figured out how to turn sales tax on for a product, by making sure the "taxable goods" drop down was selected. Is there a way to automate this rather than going through each product individually and making sure the taxable goods option is selected. It would be unrealistic to do this individually for a thousand products. We used easypopulate to upload the products in the first place. Thanks. Any help would be greatly appreciated. -Fractal Linda's suggestion is the best way to go at this point. When you upload and download with EasyPopulate, you can specify the tax class in the file. Tim Link to comment Share on other sites More sharing options...
Fractal Posted March 24, 2003 Author Share Posted March 24, 2003 Thanks for the tip. I didn't notice a field in easypopulate for the Tax Class ID though? Also, as I was adjusting my tax info, I deleted all my tax classes and decided to set the products_tax_class_id back to 0 for all products. I then re-added the taxable goods tax class and then ran Linda's code snippet in phpmyadmin again. Although the DB updated sucessfully, the tax class of all the products stayed at "none" for some reason. Do you have any idea why this might have happened. I have a taxable goods class and products_tax_class_id is set to 1 for all products. Thanks again for your help. -Fractal Link to comment Share on other sites More sharing options...
Fractal Posted March 24, 2003 Author Share Posted March 24, 2003 After downloading the latest version of Easypopulate I realized why I didn't see the tax status field. (I had an older version) By putting "Taxable Goods" into this field and uploading into mySQL, it seemed to fix the problem. Now the products_tax_class_id field contains the int "5" which works. I'm not sure what the difference between having a "1" and a "5" is in this field though? -Fractal Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.