Possible to import products from seperate sql database?

Hi,

My site is currently run on Perl, and has an SQL database which is customized to work with the Perl scripts that generate the page. The database is not in any way set up like the ZC sql database. I'm trying to get a zc shop going on my local linux machine and then will replace our current site with the ZC one, but I want to import all the products and categories from my existing SQL database.

It is possible to somehow do a mass import of the categories and products from the SQL database I have running with my site right now? Or will I have to manually enter the products one by one? I would like to avoid that if possible as we have about 600 products with multiple images and that would be a pain.

Thanks!

I'm working on a similar issue but what I've come up with so far...which may be helpful for you is:

1- Update Data With SQLScripts Created in Excel: http://www.zen-cart.com/forum/showthread.php?t=14096

2 - Database Schema: http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema

3 - PHPXref 0.7: http://www.zen-cart.com/docs/xref-1-3-8/nav.html?index.html

4- Zen Cart V1.3.8 API: http://www.zen-cart.com/docs/phpdoc-1-3-8/

5- EasyPopulated: http://modhole.com/modhole/index.php?module=documents&JAS_DocumentManager_op=viewDocument&JAS_Document_id=2&e51995208ea2e11a175a9c6f6527be5a=3ddfe39aaa8e1b26e664a549d1da508e

6- And, someone suggested http://www.zencartbuilder.com/index.php?main_page=product_info&products_id=1

I've been trying to figure out how to use my wholesalers database (see my post: http://www.zen-cart.com/forum/showthread.php?t=110350

Hope one of those links are helpful to you!

EasyPopulate may save you a lot of time. We get data from many suppliers in many different formats, including MS Excel, CSV, XML - and in one case, as a table on a MS Word file!

We bring all of this data onto a master spreadsheet in MS Excel, that has been set up to conform to EasyPopulate's protocols.

If you are using Zencart 1.3.8a, then the version of Easypopulate you need is 1.2.5.5 (in the Free Add-Ons section of this site).

The version at Langer's Modhole is 1.2.5.4, which is buggy with 1.3.8a

There's a good item in the WIKI on Easy Populate:-

http://www.zen-cart.com/wiki/index.php/Easy_Populate