View Single Post
  #8  
Old 12-21-2003, 01:30 PM
 
jordan0 jordan0 is offline
 

Advanced Member
  
Join Date: Oct 2003
Location: San Francisco, CA
Posts: 77
 

Default yes there is a way

The built-in "update inventory" feature of x-cart only lets you change the price and quantity values for each product. In order to perform a "bulk" update of availability you will have to use a MySQL database editor such as phpMyAdmin.
I am on Mac OS X, so I use a program called CocoaMySQL. It lets me export the products table to a csv file just like xcart does, but I can update any/all data in the table this way and then re-import the products without creating duplicates. It took a few tries to get the export / import settings right so they would work with everything. I know there are tons of these programs around for Windows and Linux also. Be careful, though, and BACKUP FIRST!! ALWAYS!
__________________
Jordan Sitkin
http://www.kitkraft.biz
X-Cart 4.0.18 [unix]
Reply With Quote