Post by tav105 » Tue Nov 17, 2020 12:19 pm

JNeuhoff wrote:
Wed Nov 11, 2020 7:49 pm
I think php7.4-fpm on nginx is the main culprit here, judging by the many user reports on this according to a Google search.
After installing package php7.4-mbstring, the speed of Import on php7.4-fpm & nginx 1.18.0-0 became identical to the speed of php7.4.3-4 & apache2.4.41-4.
Installing php7.4-mbstring does not affect performance with php7.4.3-4 & apache2.4.41-4.
Apparently php7.4.3-4 & apache2.4.41-4 can work with long strings by default without degrading performance.
And for php7.4-fpm & nginx 1.18.0-0 you need to install php7.4-mbstring for fast work with long strings.

Thanks again for the module

Newbie

Posts

Joined
Tue Nov 10, 2020 6:07 pm

Post by JNeuhoff » Tue Nov 17, 2020 7:08 pm

Glad to hear you managed to solve the performance issue. The PHP mbstring library should be part of a standard PHP setup anyway!

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Cue4cheap » Sat Nov 21, 2020 11:14 pm

Here is an interesting one... my webhost upgraded to php 7.4 before I expected it so I rushed to upgrade this extension. I thought I upgraded to V4.6 version 2.3.0.2 because it works well BUT... I now have a HUGE log with a lot of these:
2020-11-19 7:49:23 - PHP Warning: error_log(/REMOVED/juergen/REMOVED/opencart-3-0-3-6/system/storage/logs/error.log): failed to open stream: No such file or directory in /system/library/export_import/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Style/Style.php on line 196

Did I get a version that was beta or ?
Before I shotgun this and try to download the latest version (which I thought I had) and try again I thought I would ask here.
Thank you,
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by JNeuhoff » Sat Nov 21, 2020 11:51 pm

Did I get a version that was beta or ?
Before I shotgun this and try to download the latest version (which I thought I had) and try again I thought I would ask here.
You are right, there was some old debug code in there which I have now removed. Please download again the file 'opencart-2-x-export-import-multilingual-4-6-1.ocmod' from https://www.opencart.com/index.php?rout ... sion_id=17

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Cue4cheap » Sun Nov 22, 2020 12:34 am

JNeuhoff wrote:
Sat Nov 21, 2020 11:51 pm
You are right, there was some old debug code in there which I have now removed. Please download again the file 'opencart-2-x-export-import-multilingual-4-6-1.ocmod' from https://www.opencart.com/index.php?rout ... sion_id=17
Ok now another.
I went into modifications and disabled, removed and refreshed the old export/import extension.
I downloaded opencart-2-x-export-import-multilingual-3-22.ocmod.zip I then used extension installer to install.
I did an export of 1 - 99 and now I am getting this in the log....

Code: Select all

2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 526
2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/Cell.php on line 812
2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82
2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/Calculation.php on line 2551
2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 720
2020-11-21 9:21:09 - PHP Unknown:  Array and string offset access syntax with curly braces is deprecated in /system/PHPExcel/Classes/PHPExcel/ReferenceHelper.php on line 884

2020-11-21 9:21:10 - PHP Notice:  Trying to access array offset on value of type null in /admin/model/tool/export_import.php on line 62
This is an interesting one to me because this should be simple but I appear to be doing something wrong??

Thank you,
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by JNeuhoff » Sun Nov 22, 2020 12:50 am

You have to use Version 4.6, the older version 3.22 doesn't support newer PHP versions!

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by Cue4cheap » Sun Nov 22, 2020 12:59 am

JNeuhoff wrote:
Sun Nov 22, 2020 12:50 am
You have to use Version 4.6, the older version 3.22 doesn't support newer PHP versions!
Thank you for your patience. It is working now without issue.
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by ArnoldM » Wed Dec 09, 2020 7:45 pm

I am running 10.3.25-MariaDB, importing categories work perfect but when trying to import products I get an error:

Code: Select all

2020-12-04 15:17:43 - PHP Notice:  Undefined index: Gigabyte in /home/ejraeu/domains/ejura.eu/public_html/admin/model/extension/export_import.php on line 1037
2020-12-04 15:17:43 - PHP Exception:  Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''',1,250,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','0','1','1')' at line 1<br />Error No: 1064<br />INSERT INTO `qfrl_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`) VALUES (102,5,'232683','','','','','manoserija125','SAN1',5,'GeForce GTX 1050 TI',,'',1,250,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','0','1','1'); in /home/ejraeu/domains/ejura.eu/public_html/system/library/db/mysqli.php on line 40

Newbie

Posts

Joined
Tue Nov 24, 2020 5:45 pm

Post by JNeuhoff » Wed Dec 09, 2020 11:12 pm

ArnoldasM: I am unable to reproduce your error, something is wrong with your manufacturer column. In order to help you, please send me a PM with your OpenCart admin AND cPanel/PHPMyAdmin details so that I can take a look at it.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by izowebOCforum » Fri Dec 11, 2020 1:31 pm

Hello using opencart 3.0.3.6 i can't import products or categories or anything i saved from a old opencart site in a new fresh installation of opencart 3.0.3.6

It always give theses errors;

2020-12-11 3:54:20 - Export/Import: Invalid header in the ProductOptions worksheet
2020-12-11 3:54:20 - Export/Import: Invalid header in the ProductOptionValues worksheet
2020-12-11 5:24:03 - Export/Import: Invalid header in the ProductOptions worksheet
2020-12-11 5:24:03 - Export/Import: Invalid header in the ProductOptionValues worksheet
2020-12-11 5:24:34 - Export/Import: Invalid header in the ProductOptionValues worksheet
2020-12-11 5:24:34 - Export/Import: Invalid header in the ProductAttributes worksheet
2020-12-11 5:24:34 - Export/Import: Invalid header in the ProductFilters worksheet



I replaced the top first row headers of the exported file from the old site to the same ones as the new export files are formated but it still does this error.

What i need to do?

Newbie

Posts

Joined
Wed Oct 30, 2019 5:32 am

User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by izowebOCforum » Sat Dec 12, 2020 1:13 pm

JNeuhoff wrote:
Fri Dec 11, 2020 6:17 pm
See our FAQ on how to proceed.

I tried again today, i followed theses steps on the FAQ

Can I move products from an older to a newer OpenCart server?
Yes, you can! However, the formats of the old and new spreadsheet's worksheets will be slightly different, so it won't be a simple Export off the old server plus Import to the new server. Instead, follow these steps:

Do an Export of your Categories, Products, and other data off your new server.
Do an Export of your Categories, Products, and other data off your old server.
Copy the old data, column by column, from your worksheets from step 2 and paste it to the corresponding worksheet columns of your new worksheets from step 1.
Import the updated spreadsheet files from steps 1 and 3 to your new OpenCart server.
Also bear in mind to define all your options, attributes, and filters before you use them in products or categories data. Therefore, when importing data to a new server, do the Imports in the following order:
Option definitions
Attribute definitions
Filter definitions
Categories
Products



It works fine for all but not the products import.
It always gives me this error in the logs:


2020-12-12 5:11:01 - PHP Warning: simplexml_load_string(): Entity: line 1: parser error : Start tag expected, '<' not found in /home/morbide/public_html/system/library/export_import/Classes/PHPExcel/Reader/Excel2007.php on line 88
2020-12-12 5:11:01 - PHP Warning: simplexml_load_string(): application/vnd.oasis.opendocument.spreadsheet in /home/morbide/public_html/system/library/export_import/Classes/PHPExcel/Reader/Excel2007.php on line 88
2020-12-12 5:11:01 - PHP Warning: simplexml_load_string(): ^ in /home/morbide/public_html/system/library/export_import/Classes/PHPExcel/Reader/Excel2007.php on line 88
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'x-large' for option_name 'Size' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'effrayé' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'heureux' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'malveillant' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'blanc' for option_name 'blanc ou noir' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'noir' for option_name 'blanc ou noir' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'effrayé' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'heureux' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'malveillant' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'x-large' for option_name 'Size' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'x-small' for option_name 'Size' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'effrayé' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'heureux' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'malveillant' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Blanche' for option_name 'Couleur' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Noir' for option_name 'Couleur' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'rouge vin' for option_name 'Couleur' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Certificat de décès' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'Sans certificat' for option_name 'Certificat de décès' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'effrayé' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'heureux' for option_name 'émotion' used in worksheet 'ProductOptionValues'!
2020-12-12 5:11:02 - Export/Import: Undefined option_value_name 'malveillant' for option_name 'émotion' used in worksheet 'ProductOptionValues'!

Newbie

Posts

Joined
Wed Oct 30, 2019 5:32 am

Post by JNeuhoff » Sat Dec 12, 2020 6:30 pm

You have to define the options and option values first, in your Option Definitions import, before using them in the Products import.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by izowebOCforum » Tue Dec 15, 2020 11:16 am

JNeuhoff wrote:
Sat Dec 12, 2020 6:30 pm
You have to define the options and option values first, in your Option Definitions import, before using them in the Products import.

Yes. This is done when i import the file "options-2020-12-10.xlsx" right?
I imported all the files in order as mentioned in your FAQ but when i get at the last one which is the products i get the errors i posted in this thread.
Can you tell me exactly what is going on?
If i open options-2020-12-10.xlsx i can clearly see all the options and the options values in it.
When i go in the options for products on the admin of my website, it shows all the options, they seem correctly imported in opencart... yet i still have this error in the logs while i import the products...
Thanks

Newbie

Posts

Joined
Wed Oct 30, 2019 5:32 am

Post by JNeuhoff » Tue Dec 15, 2020 4:20 pm

In your option definitions, make sure you don't have have any leading or trailing spaces for your option and/or option value names.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by ArnoldM » Wed Dec 16, 2020 12:30 am

JNeuhoff: I assumed it created the Manufacturer automatically, I added the manufacturers and it imported successfully

Newbie

Posts

Joined
Tue Nov 24, 2020 5:45 pm

Post by JNeuhoff » Wed Dec 16, 2020 12:46 am

ArnoldasM wrote:
Wed Dec 16, 2020 12:30 am
I assumed it created the Manufacturer automatically
It should, if it didn't then something else must have been wrong, or it might be a bug.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by karenayvazyan » Sat Jan 23, 2021 4:23 pm

Hello I have this type error after transfering my store from local to hosting
2021-01-23 8:01:41 - PHP Fatal Error: Uncaught Error: Class 'XMLWriter' not found in /var/**********/system/library/export_import/Classes/PHPExcel/Shared/XMLWriter.php:36
Stack trace:
#0 /var/**********/system/library/export_import/Classes/PHPExcel/Autoloader.php(79): require()
#1 [internal function]: PHPExcel_Autoloader::load('PHPExcel_Shared...')
#2 /var/**********/system/library/export_import/Classes/PHPExcel/Writer/Excel2007/ContentTypes.php(45): spl_autoload_call('PHPExcel_Shared...')
#3 /var/**********/system/library/export_import/Classes/PHPExcel/Writer/Excel2007.php(239): PHPExcel_Writer_Excel2007_ContentTypes->writeContentTypes(Object(PHPExcel), false)
#4 /var/**********/admin/model/extension/export_import.php(9190): PHPExcel_Writer_Excel2007->save('/tmp/phpxltmpwu...')
#5 /var/www/megeriancarpet.am/data/www/storage/modification/system/engine/loader.p in /var/**********/system/library/export_import/Classes/PHPExcel/Shared/XMLWriter.php on line 36

Newbie

Posts

Joined
Sun Dec 23, 2018 8:18 pm

Post by xxvirusxx » Sat Jan 23, 2021 5:52 pm

Enable xmlwriter from your php settings. If you don't have access contact hosting support to enable for you.

Upgrade Service | OC 2.3.0.2 PHP 8 | My Custom OC 3.0.3.8 | Buy me a beer


User avatar
Expert Member

Posts

Joined
Tue Jul 17, 2012 10:35 pm
Location - România

Post by gcvzensatie » Sat Jan 30, 2021 7:13 pm

Beste,

Alles lukt om te importeren.
Enkel de afbeeldingen lukken niet.
Weet u waar dit aan kan liggen?

Sabine

Newbie

Posts

Joined
Sat Feb 22, 2020 7:11 pm
Who is online

Users browsing this forum: No registered users and 16 guests