enter image description here

I got this really annoying issue with Magento. I attempted to load all my items onto the store but had some bugs. In result, I deleted all my items but I am still showing 57 items in the Category Products and in the URL-Rewrites. I have deleted the categories and subcategories. I have cleared the cash and have re-indexed everything, but still nothing. I need help urgently!

In addition, after uploading and deleting everything I am now getting a FATAL ERROR message if I attempt to export the .csv.

Fatal error: Unsupported operand types in includes/src/Mage_ImportExport_Model_Export_Entity_Product.php on line 875

Any help would be greatly appreciated

  • Sounds like a database issue where foreign key constraints are messed up and the delete on cascade did not happen to remove product references from all tables that would be normally affected during product deletion. I would personally consider running the database repair tool. Oct 19, 2014 at 20:51
  • Thank you for the comment. And how would you clean up the database? Do you know of a link where I could follow some steps? Oct 20, 2014 at 16:17

1 Answer 1


It's not clear to me whether you have deleted those Products and categories through Admin Panel or, Database. But, first, try to disable Compilation from Magento Admin Panel -> System -> Tools -> Compilation -> Disable Then, clear your cache and try CSV upload again

  • I added the data from the Import function on the front-end and deleted the items in the front end. I am now only able to see the items when I go into "Catalog > Manage Categories > Category Products" and in the URL Re-writes. I am not able to see the actual product in the front-end or back-end. How would I flush the product database from PHPMyAdmin? and what's causing the Fatal Error? Oct 20, 2014 at 16:02
  • Rahul, you're the man. Temporarly disabling the compilation and refreshing the cache fixed the fatal error; nonetheless, I am still having the issue with the products not showing. Oct 20, 2014 at 16:34
  • Catalog -> Manage Products, then select products and DELETE! Oct 20, 2014 at 17:06
  • Thank you so much Rahul. I was able to clear the cash and now refresh my database. The only issue I am still encountering is that when I upload items they are not visible in Magento. I need to physically go into each item and then it displays in the front-end. Any work around to fix this? Oct 20, 2014 at 17:17
  • How you are uploading products into your magento? Oct 20, 2014 at 17:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.