Magento Import Export FAQ

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

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