[ic] Import Products with MySQL

Stefan Hornburg Racke interchange-users@icdevgroup.org
Wed Aug 14 03:53:02 2002


"Andrew Rich" <a.rich@sportingpulse.com> writes:

> Hi All
> 
> We have IC 4.8.5 (will be 4.8.6 soon!!)
> Using Foundation type site with MySQL
> Red Hat 7.3
> 
> Our product range of over 2000 items has all been hand entered over many
> late nights.
> 
> We have a few supplier product lists on CD and I can manipulate structure
> easily so what is the best way to import these.  About another 2000
> products.
> 
> I need to know the easiest or best way to import without loosing current
> catalog.  If it requires appending to products.txt and doing something with
> that is fine.

Backup products.txt, append to products.txt and reconfig/restart is
a good solution.

Another way to go is the script dbs_update from my DBIx::Easy module.

Ciao
        Racke

-- 
Prolific Interchange Consulting (Excellent German Quality !).
Take a look at Materialboerse (http://www.materialboerse.de/), WITT 
(http://www.witt-weiden.de/), Boxmover (http://shop.boxmover.ch/) or 
Passionshop (http://www.passionshop.com/racke). Need a shop ? Contact us.