This is a discussion on what's a csv file (database question) within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; I'm still trying to figure out how to set the tax rate for ALL products (over 75 in the cart) ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| 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 |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| CSV = Comma Separated Value text file What you do is export your table to a CSV file using phpmyadmin, then, you can open that CSV file in Excel or other spreadsheet software, and edit the data that way. Then you save the file, and re-import it using phpmyadmin. |
|
#3
| ||||
| ||||
| you know what i did instead??? i went to phpMyAdmin and did a query to UPDATE the products_tax_class_id to number 1 and that took care of the whole thing. thanks for the help. -pete |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| php/sql file merging experts, question for you | buglerroller | osCMax v1.7 Discussion | 0 | 04-24-2005 09:41 PM |
| Upgrade from 1.5 to 1.7 database question | Demented | osCMax v1.7 Installation | 1 | 02-15-2005 10:27 PM |
| Syntax error when restoring backup database file | Anonymous | osCMax v1.7 Installation | 0 | 07-09-2004 10:40 PM |
| question multiple shops on 1 database?????? | red_fraggle | osCMax v1.7 Discussion | 0 | 03-17-2004 12:27 PM |
| Where is? the config file for your sql database? | annea03 | osCommerce 2.2 Installation Help | 1 | 09-02-2003 09:16 PM |