vidhya_sun 11 years ago

@kwoksanlee: Did this get resolved for OC 2.0.x?

vidhya_sun 11 years ago

Does this import Customers too?

Zeusy123 11 years ago

opencart-2-0-x-export-import-multilingual-2-19.ocmod.zip installed in OC2.0.1.1

however i keep getting no permission, even when i have select all for adminstror. Strange error need your help please.

member186264 11 years ago

SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data

OK

<!DOCTYPE html>
<html dir="ltr" lang="en">
<head>
<meta charset="UTF-8" />

moneydoctor7@gmail.com

mightymec347 11 years ago

Hi I had just installed the tool
opencart-2-0-x-export-import-multilingual-2-19.ocmod

I had even setted the permissions. but I cannot see the export tool tab in the system/exportImport

Please help me.. need to rectify this ASAP

Thanks in advance

PsycH0Ooo 11 years ago

I have a Problem

Error Message by Export

Notice: Error: Table 'db12224349-1.product_tag' doesn't exist

Error No:1146

Can somebody help me ?

Thanks

Gjburg 11 years ago

This great add on for opencart should be there in opencart out of the box but there are some issues. First the extension doesn't work with safe_mode on.

To make it work change /system/PHPExcel/Classes/PHPExcel/Shared/File.php

Change the text around line 176: return realpath (sys_get_temp_dir ());
Into: return "your/website/path/httpsdocs/temp";

This will workaround the safemode bug.

Another thing is that it uses too much memory and many people get: Allowed memory size of ... bytes exhausted
Would be great if this can be fixed too

standardwings 11 years ago

Hi there,

This is really a good tool
I am just having one problem here that is is not allowing to upload more than 150 products
When I try to upload more than 150 product first I got memory issue so I set ini_set("memory_limit",-1);
That issue is solved but now the number of worksheet which I am actually having is differing
I am having 8 worksheet in my excel and when I debug the file and print it shows me more worksheet names. I think it is cloning the worksheet

Anyone has this issue? please help

PraSSa 11 years ago

tq man... you make my life easier. 5star

Dzonisd 11 years ago

Hi, yesterday a made export/import and everything was fine, today I want to add new product and want to export product list, but o got tis eror: "Allowed memory size of 134217728 bytes exhausted (tried to allocate 48 bytes)
See also 'System > Error Logs' for more details."

what does it mean? thank.

by the way, I'll tried to import the file wich I was uploaded yesterday, and everythig was fine, no eror. Thanks for help.

kwoksanlee 11 years ago

I have installed Export/Import Tool for OpenCart 2.0.x to opencart Version 2.0.1.1. However there is no opinion for me to set the access right of this extension in User Group. Any assistance would be appreciated. Thanks!

Mar24 11 years ago

Any news import/export tool works in OC 2.0.1.1 or not??
I need to import a lot of products to OC 2.0.1.1 i need a good solution vqmod installed too.
Please help!!

pcfixerjeff 11 years ago

Hi there, I am trying to install this extension onto a fresh setup of Open-cart 2.0.1.1. I have uploaded via the extension manager OK but when I try to refresh the modifications I get his massive error...

http://pastebin.com/4rQue6fW

Been stuck on this for hours now, any help would be much appreciated.

joost_peters85 11 years ago

Sorry problem solved

joost_peters85 11 years ago

Hi,
I got the following error:

Fatal error: require_once() [function.require]: Failed opening required 'Classes/PHPExcel.php' (include_path='.:/usr/local/lib/php') in /home/xxxxxx/domains/xxxxxx/public_html/admin/model/tool/export_import.php on line 4912

What can I do?

fersoft 11 years ago

I import then complete data with Excel then try export.

Show this error above.

Notice: 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 ''CI596',0,'CI596',1,0.00,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `oc_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 (427,1,'','','','','','','',,'CI596',0,'CI596',1,0.00,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0,'1','0','1','1'); in /home/rodrigue/public_html/shop/system/library/db/mysqli.php on line 40

Benio 11 years ago

Welcome.

I install this mod and product import ok but without product option.

I put corespond data on both xls scheets but not work.

On settings a cannot change module options .

I have lot of product options.

Best regards.

Ryan.tech 11 years ago

Hello, I am needing to export my products as well as the skus for the different options on my products. I have recently installed an extension called 'Options Boost' by qphoria that allows me to put skus for the different options, and he mentions that his extension is compatible with yours. But when I export my products, it does not export the product option skus. Could you help me with this?

Algirdas 11 years ago

hello,
when i triing install on opencart version 2.0.0.0 i geting error:
Warning : ftp_mkdir(): Can't create directory: File exists in /home/admin/controller/extension/installer.php on line 307.
I remove all files manualy from server. but sl\till geting same error.
Maybe have some ideas how to fix it?

sbsuab 11 years ago

Not happy with 2.0.1.1 so im going back to 1.5.6.4.

So now i have to export all the categories and products back to a fresh install och 1.5.6.4.

I can export them ion 2.0.1.1 but when i try to import them in 1.5.6.4 i get this:

"Uploaded file is not a valid spreadsheet file or its values are not in the expected formats!"

I have opened the files and they look alright to me, how do i solve this?