neatpleats 9 years ago
@ioannisgr:
just a note but you have to make sure you update the permissions under user groups. Than go to your extensions and than modifications and select the Export/Import and hit the refresh button.
neatpleats 9 years ago
@ioannisgr:
just a note but you have to make sure you update the permissions under user groups. Than go to your extensions and than modifications and select the Export/Import and hit the refresh button.
shaft 9 years ago
@ioannisgr: Did you found how to fix that? I have the same problem...
agokulravikumar 9 years ago
Export/Import: Missing product_ids in worksheet 'Products'!
Solution : Kindly convert the Excel Sheet to .ods and try to upload. It worked seamlessly for me.
djeuzong3000 9 years ago
my version opencart 1.5.6.4
djeuzong3000 9 years ago
2016-09-26 14:57:36 - Export/Import: Missing product_ids in worksheet 'Products'!
i have again this error do you have solution please ?
Murat34 9 years ago
@JNeuhoff thanks for your great and free extension.
Can you add product link area for export or import? I need product link for google merchant center.
Thanks.
bengalimart 9 years ago
Hello
i am getting following error while importing
2016-03-09 6:26:53 - Export/Import: Invalid header in the Products worksheet
2016-03-09 6:26:53 - Export/Import: Invalid header in the ProductOptionValues worksheet
please guide!
yejingang 9 years ago
2.3不能用的，要修改文件和目录 <file path="admin/controller/common/menu.php">这个目录根本没有这个文件
djeuzong3000 9 years ago
please do you have solution for this error: 2016-09-15 17:43:32 - Export/Import: Missing product_ids in worksheet 'Products'!
djeuzong3000 9 years ago
@hulloanson: thank i have resolved the problem by changing muy excel file.
duoclock 9 years ago
Uploaded spreadsheet file has validation errors!
See also 'System > Tools > Error Logs' for more details.
No server data has been changed.
Opencart 2.1.0.1
indiquoise 9 years ago
great extension! Explicit readme, easy installation through OpenCart Extension installer...what more could you want? 5 stars all day.
cvdpol 10 years ago
Hi,
I installed de latest version in opencart 2.0.3.1. It is visible and I can start it. But I get the following message when I want the open the excelsheet. "excel cannot open the file 'product-2016-09-01.xlsx' because the file format or file extension is not valid.
Verify that the file has not been corrupted and that the file extension matches the format of the file."
hulloanson 10 years ago
@djeuzong3000: your excel file is corrupted.
leonymus 10 years ago
Hi,
How do you handle data that contains an ' character? (ie an apostrophe character?)
Importing data seems to give SQL error: "2016-08-28 9:06:28 - PHP Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's)')' at line 1<br />Error No: 1064<br />INSERT INTO `oc_url_alias` (`q..."
BTW good extension!
Kind regards,
Alex
pooding 10 years ago
Hi!
What is the problem Tell me please. I do import and I see the message "Success: You have successfully imported your data!", but the product did not appear on the website... Tried and a large number, and 5-10 products.
ahetaton 10 years ago
I installed the tool without error.
But when I want to export, and I get this message:
Fatal error: require_once(): Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/hardcore/public_html/admin/model/tool/export_import.php on line 7954
Please help! :(
naive 10 years ago
Powerful free extension. Good job
djeuzong3000 10 years ago
2016-08-11 16:47:35 - PHP Warning: simplexml_load_string(): Memory allocation failed : growing buffer in C:\wamp\www\test\system\PHPExcel\Classes\PHPExcel\Reader\Excel2007.php on line 645
2016-08-11 16:47:35 - PHP Warning: simplexml_load_string(): Memory allocation failed : growing buffer in C:\wamp\www\test\system\PHPExcel\Classes\PHPExcel\Reader\Excel2007.php on line 645
2016-08-11 16:47:35 - PHP Notice: Trying to get property of non-object in C:\wamp\www\test\system\PHPExcel\Classes\PHPExcel\Reader\Excel2007.php on line 1425
2016-08-11 16:47:36 - Export/Import: Invalid header in the Products worksheet
i need help
