Importing and Exporting data in Magento using the data-flow profiles has never been particularly quick, neither does it always work perfectly every time around. This article covers how to clear up unsuccessful imports and tips to speed the process up. The technical skill level required for this task would be basic Magento development knowledge, shell access and MySQL access. If you are unable to meet these requirements, we would strongly advise getting your Magento Development company or Magento Web Host to do this for you.
First of all we will need to setup the cron job in Magento, so we can make use of it’s automated features. If this is already done on your Magento store you can skip this step. You will need SSH access and a shell client such as Putty, speak to your web host about this if you have any problems or don’t have access.
@hourly /bin/bash path_to_cron/cron.sh
If you turn on log cleaning in your Magento installation, this will reduce the overall size of the database and the amount of data that is read in logs. Effectively speeding up the whole Magento system, by cleaning out the old data logs. Here’s how you do it:
You can check the status of an export currently running, by running the following SQL command in your Magento database:
SELECT COUNT(batch_export_id) FROM dataflow_batch_export
This will show the current count of the records exported, this process shouldn’t take more than 5 minutes. The count will return zero once the export has been completed.
If you run the following SQL truncate commands on the import and export tables, this will clear the database and speed up future imports and exports using Magento’s data-flow. If you run these commands during an import/export, this will break the operation, so be advised!
Hopefully you’ve got the basics on setting up the Magento Cron, clearing your logs and speeding up your data-flow operations in Magento. If your looking for a Magento Specialist, you can contact us with your enquiry here, and we would be happy to help.