I just installed the free import/export tool so I can upload products to my store using excel/xls file.
I am using Opencart Version 1.5.3.1
The installation seems good. there is a new menu item in opencart front end:
Menu System, submenu Export/Import
I click on Export/Import and get the screen which allows to push button to export or import
the file.
I have two products in my store and many categories. I want to export the products and see what the
format is for the XLS file. After this is known, then I can create my xls file with all the products I want to import.
The problem: when i export, the only data in the file is for categories, i see no product information
in it. The products are enabled and visible from the store front.
if anyone has this working, i would greatly appreciate your help.
I wrote to the author of this tool, but no response.
I would like to know what happens with duplicate information in this file on import, with either categories or products, does it merge identical stuff or create another entry?
thank you in advance for your help
Betsy
the export has several pages in the workbook. categories is page 1, products is page 2. check the bottom left of the workbook, there should be multiple tabs. if not contact the author because it has a bug.The problem: when i export, the only data in the file is for categories, i see no product information
in it. The products are enabled and visible from the store front.
have not tested what it does but i believe it will add the same product multiple timesI would like to know what happens with duplicate information in this file on import, with either categories or products, does it merge identical stuff or create another entry?
“Anyone who stops learning is old, whether at twenty or eighty. Anyone who keeps learning stays young. The greatest thing in life is to keep your mind young.”
- Henry Ford
All products and categories are first deleted before the Import is executed.I would like to know what happens with duplicate information in this file on import, with either categories or products, does it merge identical stuff or create another entry?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Please clarify, or are you the same spammer under a new account name?johnblack5410 wrote:There is new edition for Opencart Version
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
After setting up this particular module in the administrative end of my cart (version 1.5.3.1), I am able to export my list of products along with its corresponding categories, attributes, and options. However, I receive a "500 http" error when I attempt to upload the same but updated XLS file. What could be the reason(s) for this? I am working on a test/development environment (opencarttest): do I need to be in a LIVE environment for the "import" side of this module to work?
Please help.
Thanks!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I receive this error now when I try to import an updated XLS spreadsheet onto the admin side of my Open Cart:
"Fatal Error: Call to undefined function mb_detect_encoding() in D:\Sites\OpenCartTest\admin\model\tool\export.php on line 430"
Any thoughts on what to do next?
Thanks!
Ask your webhost do it for you.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Look forward to response thanks
Do the obvious, check all the logs, e.g. server's error_log (ask your webhost for this), OpenCart's system/error.txt, also check vqmod/vqmod.log.meggabecca wrote:I am using opencart version 1.5.3.1 I use to be able to import my file, but for some reason I can not any more, so half my products are not missing, because I had to reinstall opencart, from server back ups, but for some reason it does not seem to update my products, reason for re-install syntax errors, which is now sorted, but just need to do this last leg of install, but like I said for some reason when I try to import all I get now is a blank white screen, can anyone help me with this please. Thanks in advance
I's most likely a timeout issue, or a memory_limit issue!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
How about doing a clean install, and only adding VQmod and the Export/Import tool, and then letting us know whether it works or not?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I already done clean install, and now cant log into my control panel, so now had to do another install, into my .com website, and now this is the error I have
2012-10-14 14:57:06 - PHP Notice: Error: Could not load language tool/export! in /home/meggabec/public_html/chanicebridal.com/vqmod/vqcache/vq2-system_library_language.php on line 41
2012-10-14 14:58:55 - PHP Notice: Error: Could not load language tool/export! in /home/meggabec/public_html/chanicebridal.com/vqmod/vqcache/vq2-system_library_language.php on line 41
2012-10-14 14:58:58 - PHP Notice: Error: Could not load language tool/export! in /home/meggabec/public_html/chanicebridal.com/vqmod/vqcache/vq2-system_library_language.php on line 41
2012-10-14 15:00:42 - PHP Notice: Error: Could not load language tool/export! in /home/meggabec/public_html/chanicebridal.com/vqmod/vqcache/vq2-system_library_language.php on line 41
Oh and by the way, I install both admin and system files, via filezilla, then the vqmod via vqmod managerJNeuhoff wrote:Your descriptions are so vague, I am simply not able to reproduce your error.
How about doing a clean install, and only adding VQmod and the Export/Import tool, and then letting us know whether it works or not?
You haven't installed the admin/language/english/tool/export.php at all, or not in the right place.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
For your info I installed everything how your notes told me too.... so please don't speak to me like I am stupid, I appreciate that you put time and effort into this, and also responding to everyone, I uploaded everything to my website, all the folders, just dragged and dropped, admin and system, I just dragged those folders, did not open them or anything, but it now seems to be working, apart from although I downloaded this spreadsheet from my other website, with this tool, when I try to upload it to my new site, it says the format is wrong, I am getting this message Uploaded file is not a valid spreadsheet file or its values are not in the expected formats! and thanks for your time and response. Any ideas, I have looked at spreadsheet cant see anything wrong, but prob is.JNeuhoff wrote:Well, the error message clearly says it all:
You haven't installed the admin/language/english/tool/export.php at all, or not in the right place.
Do an Export first, and then use the resulting spreadsheet worksheets to overwrite them with your own entries, keeping the format. The spreadhsheet formats are slightly different between differentOpenCart versions.meggabecca wrote:For your info I installed everything how your notes told me too.... so please don't speak to me like I am stupid, I appreciate that you put time and effort into this, and also responding to everyone, I uploaded everything to my website, all the folders, just dragged and dropped, admin and system, I just dragged those folders, did not open them or anything, but it now seems to be working, apart from although I downloaded this spreadsheet from my other website, with this tool, when I try to upload it to my new site, it says the format is wrong, I am getting this message Uploaded file is not a valid spreadsheet file or its values are not in the expected formats! and thanks for your time and response. Any ideas, I have looked at spreadsheet cant see anything wrong, but prob is.JNeuhoff wrote:Well, the error message clearly says it all:
You haven't installed the admin/language/english/tool/export.php at all, or not in the right place.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
The reason for the issue, was when i edited the export file in excel, it changed the rows to a different format, i had to manually change them all back to the correct format (i.e text, number etc) and uploaded it, worked fine after that.
Export a file first, then click on the rows to see what the format is, then when you add new rows, make sure they are the same format, if not, change them.
Users browsing this forum: No registered users and 4 guests