Magento

Hi Blakew,

You might want to up your memory limit to atleast 512mb.
Most of our hosted clients who have over 20k products are running fine with a 512mb setup.

I will just post my import procedure in here..

“catalog_category_entity” holds a record for each category
“catalog_category_entity_varchar” holds information about the name, url-key, url-path, etc…
...the int and text tables just hold more info about categories, you can look it up in the attributes table.

I exported a csv of category id and category title from my db2 database and imported it into a new table in my mysql database. From this table, I ran php scripts to increment and output the proper paths, names, ids, etc… for the csv’s to import into the catalog_category_entity_* tables.

First I imported catalog_category_entity, then the others were in no particular order.

This worked, but needs to be automated. Also, the categories are ridiculously slow in the admin and on the home page. I am now testing the beta release on two servers, one for web server and one for database.

I hope this helps.

Is this script ready to share with us yet please?

blakew,

is the script ready to go?