what is a csv file (database question)

[sheikyerbouti]

I'm still trying to figure out how to set the tax rate for ALL products (over 75 in the cart) at once via the database. Someone mentioned that i need to set to Number 1 a column in my csv file for the field "products_tax_class_id". Can anyone tell me what in the world my csv file is? I've never tried anything like this before with a database.....

 

Please help the NEWBIE!

 

Thanks,

pete

[♥olby]

You need the mySQL UPDATE command in phpMyAdmin.

 

The syntax is described here:

http://www.mysql.com/doc/en/UPDATE.html

 

If your taxable goods have the id 1 in your table tax_class you should run the following command on table products:

 

UPDATE products SET tax_class_id = 1

 

If the id is 2 you just change 1 to 2 or whatever it is.

 

A csv-file is a "comma seperated value"-value file like:

value1, value2, value3, .....

and is commonly used to export/import data between different platforms.