Some FAQ while exporting or importing catalog in Magento
1.) My export script just shows blank page .. it looks like its working but never gets past the "Warning: Please don't close window during importing/exporting data" line in the yellow box.
A: this is a restriction of your webserver. Check the .htaccess file for a line .. set it to php_value max_execution_time 28000. Also check your php log file for errors if you dont allow the error to print out.
Possible CRON JOB Extension
http://www.magentocommerce.com/extension/2268/cron-profiles
2.) My import works fine except for the fact the QTY is blank.. what should i do?
A: this is cause by 2 things. Either you've editied the file in excel and the CSV is no longer in the proper format or you are using a CSV file with columns in the wrong order. Refer to the sample CSV provided and make sure your QTY is in the same order or if you insist on using a custom csv that isnt support atleast try moving the qty field to the front of the file csv the end of the rows.
3.) Error upon running the profile:
Declared adapter catalog/convert_adapter_productimport not found
File is in:
"/public_html/app/code/local/Mage/Catalog/Model/Convert/Adapter/Productimport.php "
A: Set permissions on that file, improper or insufficient permissions will cause that error.
4.) i am getting this error or one very similar Notice: unserialize() [function.unserialize]: Error at offset 802 of 923 bytes in /home/adultmed/public_html/app/code/core/Mage/Dataflow/Model/Batch/Abstract.php on line 66
A: save your csv in UTF8 format. This will solve the problem.
4.) What do i do when it imports correctly with no errors but they don't display on the site until i reedit and save them??
A: its because your missing the options_container column from your csv and related values. These are required and its recommended not to remove or change columns or remove them
