2. Can this module use product variants (GA Product Variants extension which generate a supplemental filed in product properties, variant)? We plan to migrate from X-cart to OpenCart and we have hundreds of products with variants and would like to be able to import them into OpenCart, so we won't lose a lot of work done previously.
Best regards
adicoto
A pretty vague description, you not not giving any details about the exact error messages you got.
OpenCart calls it Product Options, with different option types available for single-choice, multi-choice, and various text options. Just install a fresh OpenCart and the Export/Import tool, then do an Export to see the exact worksheet formats to be used in the spreadsheet files.adicoto wrote: ↑Tue Jul 14, 2020 3:46 pm2. Can this module use product variants (GA Product Variants extension which generate a supplemental filed in product properties, variant)? We plan to migrate from X-cart to OpenCart and we have hundreds of products with variants and would like to be able to import them into OpenCart, so we won't lose a lot of work done previously.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
2. I am using for some months your tool which is magnificent for what can do. The question was related to another module (GA Product Variants Extension) which add to the product info fields the product variant. Product variant it's largely used in X-Cart (you have a product that come in 128 colours so you create 1 product and add 127 variants, each with it's color. When selecting color, image changes, SKU changes...). So, it would be nice if your module would cover this possibility too (grabbing variants information added by the Variant module extension). Can this be done ?
Instead of trying to import files for your migration from X-cart to OpenCart (data migrated only), you can rely on our migration tool to both have quick and secure data migration plus the ability to complete tasks like keeping SEO rankings, migrate customer passwords, etc. A brief instruction video: https://www.youtube.com/watch?v=C2RCeHlotmEadicoto wrote: ↑Tue Jul 14, 2020 3:46 pm2. Can this module use product variants (GA Product Variants extension which generate a supplemental filed in product properties, variant)? We plan to migrate from X-cart to OpenCart and we have hundreds of products with variants and would like to be able to import them into OpenCart, so we won't lose a lot of work done previously.
Best regards
adicoto
LitExtension - Shopping Cart Migration Expert
Visit us at: https://litextension.com
This is most likely due to empty trailing rows in your XLSX file, a known MS Excel bug had probably caused this. We always recommend using LibreOffice Calc instead of MS Excel.
We can customize the Export/Import to add support for extra DB fields introduced by 3rd party extensions, for a small charge. Please contact us with more details on this.adicoto wrote: ↑Tue Jul 14, 2020 8:27 pm2. I am using for some months your tool which is magnificent for what can do. The question was related to another module (GA Product Variants Extension) which add to the product info fields the product variant. Product variant it's largely used in X-Cart (you have a product that come in 128 colours so you create 1 product and add 127 variants, each with it's color. When selecting color, image changes, SKU changes...). So, it would be nice if your module would cover this possibility too (grabbing variants information added by the Variant module extension). Can this be done ?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I was able to successfully import all my products. However, for the clients, I am having trouble getting the current data in order to get a sample of the tables format. When I click to import, nothing happens and then I get the following messages in the error log:
[ quote]
16-07-2020 14:39:00 - PHP Unknown: Array and string offset access syntax with curly braces is deprecated in C:\MAMP\htdocs\loja\system\library\export_import\Classes\PHPExcel\Shared\String.php on line 542
16-07-2020 14:39:00 - PHP Unknown: Array and string offset access syntax with curly braces is deprecated in C:\MAMP\htdocs\loja\system\library\export_import\Classes\PHPExcel\Cell.php on line 812
16-07-2020 14:39:00 - PHP Notice: Trying to access array offset on value of type null in C:\MAMP\htdocs\loja\admin\model\extension\export_import.php on line 62.[/quote]
There is only one client registered in my database!
What can be done?
Thanks,
For a quick solution, switch back to a previous PHP V7.x release for your server.
We are working on replacing the old PHPExcel library with the newer PHPOffice / PhpSpreadsheet library for the next release of the Export/Import tool, hopefully to be released in the next few days. That one should then work for PHP 7.4, too.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Nice, I switched to PHP 7.3.7 and it did work. Thanks a lot!JNeuhoff wrote: ↑Fri Jul 17, 2020 12:08 amYou are probably using the new PHP Version 7.4 where certain features like the usage of string offset access syntax with curly braces are now deprecated in PHP. Unfortunately it's still in the PHPExcel library used by the Export/Import tool.
For a quick solution, switch back to a previous PHP V7.x release for your server.
We are working on replacing the old PHPExcel library with the newer PHPOffice / PhpSpreadsheet library for the next release of the Export/Import tool, hopefully to be released in the next few days. That one should then work for PHP 7.4, too.
To import the updated file, just add new data and upload it back in the import tab?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
thanks for the info about import errors! as for the migration procedure I would suggest you try an automated tool. it's fast and simple. the market's full of these services now and you can pick one to your personal liking. i usually go with cart2cart. they do the job quickly and i don't have to worry about data security and store's integrityadicoto wrote: ↑Tue Jul 14, 2020 3:46 pm1. For those who have import errors, I've noticed that importing file in xls format never generate error. I've had an xlsx file that was giving me errors about fields that were empty but after saving the file as xls importing from xls all was ok.
2. Can this module use product variants (GA Product Variants extension which generate a supplemental filed in product properties, variant)? We plan to migrate from X-cart to OpenCart and we have hundreds of products with variants and would like to be able to import them into OpenCart, so we won't lose a lot of work done previously.
Best regards
adicoto
No problem with the install - followed instructions completely.
php v7.2 required - which is what my site was on - should have been ok - but when I tried the first export it prompted me that php 7.3 was the minimum required.
I updated my php to 7.3 and then attempted another export - now it tells me I am using an old version of the Export/Import Tool, please upgrade to the new version 4.2
Version 4.2 IS what I installed, but nevertheless I uninstalled, refreshed, cleared cache, downloaded a fresh copy from the Marketplace, reinstalled (verifying the filename IS 4.2) - still getting the upgrade message that I am using an old version.
No export happens when I try to export product data by id range, and no error is returned.
My Opencart is 3.0.3.2
Suggestions?
New and Treading Water Feverishly
Current Cart-in-progress: https://gtgshops.com 3.0.3.2 installation, no core files modified
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I have searched the posts and have come up with bits and pieces of information, but still have a problem, so I figured I would try here for some expert help...
Let me start with what I am running:
- I have opencart 3.0.3.2 with PHP 7.2.24 and using the latest Export/Import ver. 4.4 (free version)
- Currently used category IDs are between 17 and 91. Currently used product IDs are between 127 and 226986.
Just a small note about the ID numbers, the actual number of products is 12169. Some of the ID numbers are skipped, that is why the ID number goes to 226986
So if I try running the export (entire products) on my local dev. using XXAMP, it runs perfectly (spreadsheet is created, no issues about 3mb) and noticed that the error.log (not really errors) file that it generates is 386mb (this is the error.log file, not the spreadsheet)
Now if I try running on our webhosting, it starts to run, runs for about 100-120 seconds and then get a 500 Internal error.
ERROR.LOG
2020-08-11 20:04:13 - populateProductsWorksheet: numberFormat = 'object(PhpOffice\PhpSpreadsheet\Style\NumberFormat)#239 (5) {
["formatCode":protected]=>
string(7) "General"
["builtInFormatCode":protected]=>
int(0)
["isSupervisor":protected]=>
bool(true)
["parent":protected]=>
object(PhpOffice\PhpSpreadsheet\Style\Style)#211 (12) {
["font":protected]=>
object(PhpOffice\PhpSpreadsheet\Style\Font)#212 (13) {
["name":protected]=>
.....
}
["parentPropertyName":protected]=>
NULL
}
["parentPropertyName":protected]=>
NULL
}
'
<b>Warning</b>: Error while sending QUERY packet. PID=2371649 in <b>/home/sparkp9/public_html/can/oc/system/library/db/mysqli.php</b> on line <b>18</b>
I have tried playing with different settings in php.ini, .user.ini, my.ini
My question, is there a specific setting that needs to be set for large files or is this an issue with the webhosting company that is limiting large script execution?
Thank you
Frank
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Hi J
Thank you for the quick reply. That is what I am doing, I am exporting in smaller batches. But sometimes it would be great to export the whole product file in one shot...
I did more research and did find some new info.
In MySQL variables there are 2 settings called
wait_timeout
interactive_timeout
On my Webhosting they are both set to 30 and it does not allow me to change them (need supervisor rights, etc.. ), I will try to see if they can change it for me.
Thanks again.
Frank
Any ideas or help would be appreciated.
(Apache/Linux)
A 413 Request Entity Too Large error occurs when a request made from a client is too large to be processed by the web server. ... An example request, that may cause this error would be if a client was trying to upload a large file to the server (e.g. a large media file). So in your case, try to do the Export and Import (the latter probably caused your error) in smaller batches.Getting a 'Request Entity Too Large' on install of latest version to OC 3.0.3.6
Any ideas or help would be appreciated.
(Apache/Linux)
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thanks for the reply. Its not on the import/export. Its when I am trying to install the extension. I have got this extension to work on a previous version (V3.22) on the same server, so I dont think its a server issue. Is there a manual way of installing it?JNeuhoff wrote: ↑Thu Aug 27, 2020 4:40 pmA 413 Request Entity Too Large error occurs when a request made from a client is too large to be processed by the web server. ... An example request, that may cause this error would be if a client was trying to upload a large file to the server (e.g. a large media file). So in your case, try to do the Export and Import (the latter probably caused your error) in smaller batches.Getting a 'Request Entity Too Large' on install of latest version to OC 3.0.3.6
Any ideas or help would be appreciated.
(Apache/Linux)
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thats the problem. I own my own server, and have full control over it. Ive increased limits to max, and still getting the error. Just wondering is there another extension that I should be installing along with this one to get it working?
Also, would it be possible to download the previous version? I have 3.22 working on another site on the same server (PHP5.x) and it works fine. Maybe its a PHP issue? Its not a size issue, as you mentioned the install file is only 1.1Mb. The error is misleading I think
Is there a manual way of installing it? Just FTP the uploads folder?
Users browsing this forum: No registered users and 93 guests