Recently, I have a chance to use drupal commerce with feed importer. Feed importer is very good because I can easily transfer data from MySQL to the website.

However, sometime the import process crash and I am stuck with importing page with xx% status and nothing can be done via UI.

To fix this, I have to manually edit the status of the import. Basically, all I have to do is to

update feeds_source set state = 'b:0;'; update feeds_source set fetcher_result='b:0;';

Check this .