Page 53 of 58
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Wed Feb 17, 2021 6:23 am
by renegade2020
Hi all!
I am new to the forum and have what I hope to be any easy question. I am using opencart 3.0.3.6 with the Export/Import Tool by JNeuhoff. I have it all installed and have ran into a snag. Upon import of my spreadsheet it does not import, not sure why. Here's what I have done so far: test export and modified the header and columns in accordance with what it's looking for. Made sure all columns exist (used or not). Still does not seem to import anything, no errors and no results. I'm at a loss since there's no logs to point me in the right direction, any advice would be appreciated. Thanks!
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sat Mar 27, 2021 1:43 pm
by wktp76
When exporting, the description is doubled!
http://joxi.ru/D2PJQn5tJ7RoNr
1 Language
Opencart 3.0.3.2, 3.0.3.7
PHP 7.3.27
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sat Mar 27, 2021 8:31 pm
by JNeuhoff
Use LibreOffice Calc instead of MS Excel. MS Excel has a number of known bugs.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sun Mar 28, 2021 2:27 pm
by wktp76
Thank you, it worked, LibreOffice Calc is fine.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Mon Jun 07, 2021 7:03 pm
by choulio19
Hi i just installed your plugin on opnecart 3.0.2.0 and when i try to export products i get this error
Trying to access array offset on value of type int
What i have to do? Thanks
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Mon Jun 07, 2021 7:09 pm
by JNeuhoff
choulio19 wrote: ↑Mon Jun 07, 2021 7:03 pm
Hi i just installed your plugin on opnecart 3.0.2.0 and when i try to export products i get this error
Trying to access array offset on value of type int
What i have to do? Thanks
As per the
documentation:
Requirements and Limitations
PHP Version 7.2 or higher is required for the current version 4.9 of the Export/Import tool.
Older PHP Versions are only supported by our older version 3.22 of the Export/Import tool.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Thu Jun 17, 2021 12:14 am
by Russalpcs
Hi there
I am installing the latest version of Opencart. I have previously ran my store on OSCommerce and then on Zencart. On both of those I used Easy Populate to list my 12 000+ products as they create categories "on-the-fly"
I would like to know if this add-on does the same, meaning I just have to modify my existing CSV spreadsheets to your format to populate my site?
Thx
Russel
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Thu Jun 17, 2021 12:58 am
by JNeuhoff
Our Export/Import tool does not create categories on the fly. Categories have to be defined first, which can be done by our Export/Import tool, before importing the products.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Jun 18, 2021 3:44 pm
by Russalpcs
Hi there
I installed it but it does not want to export. Error "Trying to access array offset on value of type int " OC ver 3.0.3.7, PHP 7.4.20?
Russel
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Jun 18, 2021 8:14 pm
by JNeuhoff
Russalpcs wrote: ↑Fri Jun 18, 2021 3:44 pm
Hi there
I installed it but it does not want to export. Error "Trying to access array offset on value of type int " OC ver 3.0.3.7, PHP 7.4.20?
Russel
Please read the documentation:
Requirements and Limitations
Use version 4.9 of the Export/Import tool for systems with PHP Version 7.2 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Thu Jun 24, 2021 7:29 am
by jrr
Not adding/creating incremental product_ids...
I'm getting the following error message:
2021-06-23 16:03:09 - Export/Import: Missing product_ids in worksheet 'Products'!
I am importing using the incremental setting:
Use incremental Import
Yes (Update and/or add data)
I thought the extension's job was to create the product_id if said id did not exist in the xls file?
I have enabled permissions in users.
Running OC 3.0.3.6, PHP 7.2.x, and am using the opencart-3-x-export-import-multilingual-4-9-cloud.ocmod version.
Also, I have Categories and then sub-categories of products. The Export function only works if I use a category sub-directory, not the parent category name.
EG, Category "
Semiconductors" has the sub-categories "-
Transistors" and "-
Diodes". If I export the
Semiconductor-Transistors category, then it works fine, if I try to export the category
Semiconductors I get a spreadsheet with the descriptions, etc, just no products at all, where I would expect all the transistors and all the diodes instead.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Thu Jun 24, 2021 5:02 pm
by JNeuhoff
Product IDs are always required. Incremental Import only means that existing products are updated, not newly created, and that no products will be deleted before the Import.
As regards categories: I don't know what your are on about, the Export/Import of categories works just fine, both for main and sub-categories.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Jun 25, 2021 1:33 am
by jrr
I was under the impression that using the import/export would be a way to easily add new products to the store. Granted one can simply find the last number in the database and start with the next number. I guess that should work.
As for exporting categories, I want to export all the subcategories' products that are under a main product category. Not just a list of sub-categories. That was what I thought would happen if I listed the parent category under
Products (including product data, options, specials, discounts, rewards, attributes and filters)
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sun Jul 11, 2021 3:41 am
by OC2PS
When I try to export (I have tried exporting products, categories, and customers), I get the following error:
Code: Select all
Trying to access array offset on value of type int
Chosen options: By batch size (999), batch number (1).
Settings:
Use option_id instead of option name in worksheets 'ProductOptions' and 'ProductOptionValues'
Use phpTemp cache for large Exports (will be slightly slower)
P.S. Same error when I try to export by id range.
Version: opencart-3-x-export-import-multilingual-3-22
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sun Jul 11, 2021 4:05 pm
by JNeuhoff
Requirements and Limitations
Use version 4.9 of the Export/Import tool for systems with PHP Version 7.2 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Mon Jul 12, 2021 4:23 pm
by OC2PS
JNeuhoff wrote: ↑Sun Jul 11, 2021 4:05 pm
Requirements and Limitations
Use version 4.9 of the Export/Import tool for systems with PHP Version 7.2 or later.
Older PHP versions are still supported by our older version 3.22 of the Export/Import tool.
That did it.
Looks like my heuristic of looking for the download date had failed me here
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Aug 27, 2021 2:07 am
by Ljubo
OC 3.0.3.2
I have done a lot with your extension - thank you!
But, I am stuck now... When I try to export the products tables, the error log says like this:
2021-08-26 17:51:59 - PHP Fatal Error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 5242880 bytes) in /home/sbb23095/public_html/...
I am confused, server limit is 128mb, file size is 5mb, and it reports this funny error message.
Could you help please?
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Aug 27, 2021 2:12 am
by JNeuhoff
See our
FAQ on this. Try the Export in smaller batches.
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Fri Aug 27, 2021 6:18 am
by Ljubo
Thank you!
Have done it after few trials.
My advice - it would be best if you have somewhere written about the way of using the batch system (for all of us who had not done it before).
Re: Multilingual Export/Import for OpenCart 2.x / 3.x
Posted: Sat Sep 11, 2021 12:01 am
by cosmicx
Hi, thanks for the mod, but I need help with the error below.
I'm on OC 3.0.3.7, PHP7.3, using the 3.22 verson of the mod.
Following errors I see when doing a product import in Admin:
Code: Select all
Notice: Trying to access array offset on value of type int in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type int in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type float in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
Notice: Trying to access array offset on value of type null in /public_html/admin/model/extension/export_import.php on line 62
While these errors are from Apache error log:
Code: Select all
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 816
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 817
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 819
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 820
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 820
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 820
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell.php on line 824
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
PHP message: PHP Deprecated: Array and string offset access syntax with curly braces is deprecated in /public_html/system/library/export_import/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 90
Any ideas? TIA!