[RELEASED] Export/Import tool for OpenCart 1.5.5.x

Can this be used to import new products adding to the existing products in the store? I don't want to overwrite the product tables or download all existing 6000 products since I don't need to change them but add to new products only as one of my new vendors has a spreadsheet for all their products which would make it easier to add.

I would also like to add them all as "disabled" so I can go thru, edit and enable them one by one.

Is this possible with this mod?

labeshops wrote: Is this possible with this mod?

Not yet, at the moment it always first deletes all old products before importing the new ones.

We are planning a new release which will include incremental import and multi-lingual support.

@labeshops this one can't, it overwrites everything. I am now using this one http://www.opencart.com/index.php?route ... rch=export that does import and export incrementally.

Though copying from this one to the paid one's spreadsheet is a nightmare as this one adds the p> tags if you've made your description into paragraphs. When you copy & paste, those cells split into several rows and mess the whole thing up.

Sooooo looking forward to the day OC has bulk upload options built in

Thanks for the info @tac I'll check it out.

This is in the error log...
2014-05-26 11:04:02 - PHP Notice: iconv(): Detected an illegal character in input string in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386
2014-05-26 11:04:02 - Export/Import: Invalid number of worksheets, 8 worksheets expected
2014-05-26 11:28:56 - PHP Notice: Undefined variable: fileHandle in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-05-26 11:28:56 - PHP Warning: rewind() expects parameter 1 to be resource, null given in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Reader/CSV.php on line 147
2014-05-26 11:28:56 - PHP Notice: iconv(): Detected an illegal character in input string in /home/sharkbgc/public_html/system/PHPExcel/Classes/PHPExcel/Shared/String.php on line 386

String.php on line 386 is this

Code: Select all

$value = @iconv('UTF-8', 'UTF-8', $value);

CSV.php on line 147 is this

Code: Select all

rewind($fileHandle);

Language on website is Bulgarian. Not English

Hello,

Greeting for perfect extencion.

I have one questions.

When I press export button, it is begin loding, and after around minute, show front page on shop and say : Page not found.

What is the problem. I try many things, but not result.

Kind Regards!

Please, help!
Opencart version 1.5.5.1. , 800 goods in store.
Today I tried to export to the Excel and received an error:
PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in /home/....system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123

As far as I understood from previous posts, do not fix it?

Please, help.

hi
i just installed this extension

and tried to add an item into my store , but when i import the .xlsx file i got this error message



i already tried any solution , like reimport again using the first xls file and check my product database but , the error message still there
can u please give me any solution and the thing that i have done wrong ?

Palpatin wrote:Please, help!
Opencart version 1.5.5.1. , 800 goods in store.
Today I tried to export to the Excel and received an error:
PHP Fatal Error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 79 bytes) in /home/....system/PHPExcel/Classes/PHPExcel/Style/Supervisor.php on line 123

As far as I understood from previous posts, do not fix it?

Please, help.

About how to increase your memory_limit PHP setting, see http://www.opencartnews.com/tutorials/c ... olve-them/

widiz1312 wrote:hi
i just installed this extension

and tried to add an item into my store , but when i import the .xlsx file i got this error message



i already tried any solution , like reimport again using the first xls file and check my product database but , the error message still there
can u please give me any solution and the thing that i have done wrong ?

You have a conflict or a bug with a 3rd party extension (module lbpc, whatever that is). Plase get in touch with its author.

JNeuhoff wrote:

widiz1312 wrote:hi
i just installed this extension

and tried to add an item into my store , but when i import the .xlsx file i got this error message



i already tried any solution , like reimport again using the first xls file and check my product database but , the error message still there
can u please give me any solution and the thing that i have done wrong ?

You have a conflict or a bug with a 3rd party extension (module lbpc, whatever that is). Plase get in touch with its author.

how can i know which extension is it ?

btw in admin panel i have 2 language installed, english and indonesian

how can i know which extension is it ?

A quick 1-second Google search answers it.

I have the problem, identical to the one asked here a month ago. But it was never resolved.
So i simply copy-paste a part of that previous post here:
"When I press export button, it is begin loading, and after around minute it shows a front page saying : Page not found.
What is the problem. I try many things, but not result."
I want to add that that your module was working fine for a long time but then it started doing this...i cannot export my inventory now.
Thanks!

gristur1 wrote:I have the problem, identical to the one asked here a month ago. But it was never resolved.
So i simply copy-paste a part of that previous post here:
"When I press export button, it is begin loading, and after around minute it shows a front page saying : Page not found.
What is the problem. I try many things, but not result."
I want to add that that your module was working fine for a long time but then it started doing this...i cannot export my inventory now.
Thanks!

I am unable to reproduce your error, not enough details. First thing always to do is to check your server's error_log (ask webhost for it!), and OpenCart's system/logs/error.txt.

Hi
Thanks for the reply.
So error_log given to me by my web host is:
[meremart@server public_html]$ tail 20 error_log
tail: cannot open `20' for reading: No such file or directory
==> error_log <==
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 18
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 19
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 20
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 21
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_real_escape_string() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 144
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_query() expects parameter 2 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 25
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_error() expects parameter 1 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 53
[21-Jun-2014 07:38:30 America/Denver] PHP Warning: mysql_errno() expects parameter 1 to be resource, boolean given in /home/meremart/public_html/system/database/ipsmysql.php on line 53
[21-Jun-2014 07:38:30 America/Denver] PHP

And there is nothing related to the problem in opencart log.

I spent all morning trying to fix this problem, and did not succeed.
Among things i did so far, some include include:
1) Moved away from shared hosting
2) Checked all memory requirements you mentioned in installation notes and elswhere in the forums
php.ini looks like
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 2048M;
max_execution_time = 36000;
upload_max_filesize = 999M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
allow_url_fopen = on;
;display_errors = 1;
;error_reporting = E_ALL;
3)
Exporting from phpMyadmin works fine.

The problem why it was showing "page not found", was a timeout issue.
I changed it from 300 to 600, its still timing out.

Any other information that you might need?

Please. help. I built entire software package around your extensions, so if it does not work as intended the whole thing falls apart.
Thanks,
Denns

gristur1 wrote: The problem why it was showing "page not found", was a timeout issue.
I changed it from 300 to 600, its still timing out.

Comment out the line

set_time_limit( 1800 );

in the admin/model/tool/export.php file. This will force it to use your higher timeout value from your php.ini instead.

I did that, the site still time outs after much longer time.
I could give you my ftp access if that would help anything.
Thnaks

So i increase apache timeout time, and now i am getting this message after a long while.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@meremart.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

just to be clear, my hosting at the moment features 6 2,2 cpus and 8gb of ram. so i should have enough resources.
Also I am willing to pay to have this thing working properly.

gristur1 wrote: More information about this error may be available in the server error log.

So what do have in your server's error_log?