[ic] IC 4.8.7 Importing products and emptying table

JOHN WRONG interchange-users@icdevgroup.org
Sat Feb 15 11:02:00 2003


> > I have a relatively small catalog (350 items).  We want to 
upload an
> > entirely new catalog periodically.  I create a products.txt 
that works
> > flawlessly using an import but my problem is that I want 
the existing
> > catalog to go away before the import.  Is there an easy way 
to do this
> > without deleting all the items individually.  I'm using 
MySQL on a
> > Redhat 7.2 server.  
> 
> One quick way of removing them is directly from a mysql 
command prompt.
> 
> DB

Keep a empty product products.txt file in catalog_home/products/
Delete products.sql and restart IC then import your file.


________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag