I have a large catalog I’ve imported from oscommerce, 127,428 products to be exact. They’ve come through to magento as simple products with one image. I have been unsuccessful at getting the indexing to work even at the command line with ssh. It times out or just never finishes.
The second problem I am having is exporting (even just enabled products) it is giving me a memory error. There just doesn’t seem to be enough memory to get it to write the export file. I need to edit all the products to add additional pictures and change descriptions and such. I plan to use mage to edit and import the products back in.
Is there anything I can possibly do to get this thing to successfully export 127,000 products without errors?
I am using: System->Import/Export->DataFlow-Profiles -> Export all products
2
Answers
Use Magmi – http://sourceforge.net/apps/mediawiki/magmi/index.php?title=Main_Page
It’s self explanatory to use. There is a giant wiki with full instructions of how to install and operate it.
I had the exact same problem with exporting to Google Shopping. It always timed out (probably due to having too many products in my feed).
According to this exporting from Magento to Google Shopping guide:
You should change your php.ini settings to these values: