osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 
 

what's a csv file (database question)

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) ...


Go Back   osCommerce and osCMax shopping cart software forums > osCommerce 2.2 Forums > osCommerce 2.2 Modification Help

Register FAQ Members List Calendar Mark Forums Read


Free community membership! Fast easy FREE membership
Closed Thread

 

LinkBack Thread Tools
  #1  
Old 10-22-2002, 11:32 AM
sheikyerbouti's Avatar
Member
 
Join Date: Oct 2002
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sheikyerbouti
Default what's a csv file (database question)

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
  #2  
Old 10-22-2002, 04:16 PM
michael_s's Avatar
osCMax Developer

 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 11,058
Thanks: 80
Thanked 348 Times in 327 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 10-22-2002, 05:30 PM
sheikyerbouti's Avatar
Member
 
Join Date: Oct 2002
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
sheikyerbouti
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Sponsored Links
Advertisement
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

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


All times are GMT -8. The time now is 08:11 AM.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO
http://www.oscmax.com/forums/
Copyright 2008 osCMax