Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

what is a csv file (database question)


sheikyerbouti

Recommended Posts

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

Link to comment
Share on other sites

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.

Best Regards

olby

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...