ozstar Posted November 15, 2005 Share Posted November 15, 2005 Hi, Say I want to make all my products taxable, or have all my products status set to 'available' etc.. Can I do this by exporting the table say to a csv, changing it then import it again? Can I do this to every indiv table or maybe there is a contrib that can do this? Thanks Oz :) Link to comment Share on other sites More sharing options...
dave111 Posted November 15, 2005 Share Posted November 15, 2005 Easy populate allows you to do it with csv type files. But you could just download the sql file for the products table. Open it in excel (it will split it into columns) and just change the tax field and fill all the way down. Then paste all this back into sql and run it. Link to comment Share on other sites More sharing options...
vondada Posted November 16, 2005 Share Posted November 16, 2005 Easy populate allows you to do it with csv type files. But you could just download the sql file for the products table. Open it in excel (it will split it into columns) and just change the tax field and fill all the way down. Then paste all this back into sql and run it. Can you explain this step by step? I don't know how to do this. Link to comment Share on other sites More sharing options...
ozstar Posted November 16, 2005 Author Share Posted November 16, 2005 Yes thanks.. I have now realised that. I am not too good at Excel and had a prob or 2 changing the tax column of 0 to 1 as the 1 was in a text field not a numeric one. Trying to get that going now. Thanks again :) 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.