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!
http://joxi.ru/D2PJQn5tJ7RoNr
1 Language
Opencart 3.0.3.2, 3.0.3.7
PHP 7.3.27
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
I'm getting the following error message:
I am importing using the incremental setting:2021-06-23 16:03:09 - Export/Import: Missing product_ids in worksheet 'Products'!
I thought the extension's job was to create the product_id if said id did not exist in the xls file?Use incremental Import
Yes (Update and/or add data)
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.
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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)
Code: Select all
Trying to access array offset on value of type int
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
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
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.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
That did it.
Looks like my heuristic of looking for the download date had failed me here
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
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?
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
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
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
Users browsing this forum: No registered users and 7 guests