Hi, I'm having a strange problem were my products are not showing up in the products area. I've been using a free import/export extension to import my products and it was going pretty well, with it throwing some errors when uploading products, but it usually fixed itself when I refreshed the page or just pressed enter on the search bar path, taking me back to the extension with the success message there.
I've had a look at my database and it looks fine with all the products showing up and even the site shows the products, but the products area in the backend doesn't? When I search for a product the products area it will find it and when I filter for that product then it will show up and I'll be able to edit it.
I'm importing 2000 products at a time with a total of 93000 products, but have only imported 8000 as I want to fix this problem before continuing.
I'm using 2.0.1.1
Any help would be greatly appreciated.
Try clearing your cache. Its on system/cache/
Opencart Options Pro, Reward Points For Review, DISQUS Comment Form,
Dolrich Fortich - Freelance web developer
Yeah I tried that but not luck...
Error log looks like this when I try to upload anymore products:
2015-09-03 17:54:59 - PHP Notice: Error: Got error 28 from storage engine<br />Error No: 1030<br />SHOW COLUMNS FROM `oc_product_image` LIKE 'sort_order' in /home/system/library/db/mysqli.php on line 40
2015-09-03 17:54:59 - PHP Notice: Trying to get property of non-object in /home/admin/model/tool/export_import.php on line 2685
2015-09-03 17:54:59 - PHP Warning: fread(): Length parameter must be greater than 0 in /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php on line 118
2015-09-03 17:54:59 - PHP Fatal Error: Call to a member function attach() on a non-object in /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php on line 120
2015-09-03 17:54:59 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php:120) in /home/admin/model/tool/export_import.php on line 49
2015-09-03 17:54:59 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php:120) in /home/admin/model/tool/export_import.php on line 50
Any thoughts?
Maybe I should try and clear the database of all products and start again, is there an easy way to do that?
Error log looks like this when I try to upload anymore products:
2015-09-03 17:54:59 - PHP Notice: Error: Got error 28 from storage engine<br />Error No: 1030<br />SHOW COLUMNS FROM `oc_product_image` LIKE 'sort_order' in /home/system/library/db/mysqli.php on line 40
2015-09-03 17:54:59 - PHP Notice: Trying to get property of non-object in /home/admin/model/tool/export_import.php on line 2685
2015-09-03 17:54:59 - PHP Warning: fread(): Length parameter must be greater than 0 in /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php on line 118
2015-09-03 17:54:59 - PHP Fatal Error: Call to a member function attach() on a non-object in /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php on line 120
2015-09-03 17:54:59 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php:120) in /home/admin/model/tool/export_import.php on line 49
2015-09-03 17:54:59 - PHP Warning: Cannot modify header information - headers already sent by (output started at /home/system/PHPExcel/Classes/PHPExcel/CachedObjectStorage/PHPTemp.php:120) in /home/admin/model/tool/export_import.php on line 50
Any thoughts?
Maybe I should try and clear the database of all products and start again, is there an easy way to do that?
Disregard that last error log I found an error in the excel sheet that I think was causing it. It's uploading fine now, but still no products showing up in the product area.
Some other things you might want to know is that I was using a option in the importer called phpTemp cache for large Imports.
It was throwing an error when I had that selected so I unselected it and it's working now. So maybe it had something to do with it?
Some other things you might want to know is that I was using a option in the importer called phpTemp cache for large Imports.
It was throwing an error when I had that selected so I unselected it and it's working now. So maybe it had something to do with it?
On advice of the plugin author, I edited and saved the spreadsheet in Open Office ODS format and it imported flawlessly.
Don Bledsoe
Who is online
Users browsing this forum: No registered users and 48 guests