Jump to content

Importing large volume products - the bad-bad 500 internal error


Recommended Posts

Hello for everyone!

 

I read many forum topcs about one of the most recent problem

 

Cannot importing large amount of products without an 500 error code of server.

 

Peoples, including me, cannot import too much products via csv file, because of server problems  (input_vars, execution_time, memory_limit etc.)

 

I would like to know, is there any solution to run a php file somehow in a terminal of the server to not stop the script???

 

It is a controller (tokened file) without any chance I think

 

(http://mysite.com/admin/index.php?controller=AdminImport&token=cd345ejrg3485o2n58otnv2ermn845#)

 

Is there any good solution?

 

Of course I increased the above mentioned timeout and memory limits

 

I would do it on the most fresh PS 1.6.0.14

 

-----

 

If it is not a right way! 

 

Please someone explain me wich database table contains the images links because we want to write a code for it, and

share when ready

 

thank you

 

 

Link to comment
Share on other sites

Here we are:

 

Serverinformations Linux #57~precise1-Ubuntu SMP Tue Jul 15 03:51:20 UTC 2014 x86_64

Server softvare version Apache/2.2.22 (Ubuntu)

PHP version 5.3.10-1ubuntu3.17

Memory limit 1024M

Max execution time 44000

Database informations

MySQL version 5.5.31-0ubuntu0.12.04.1

MySQL server: localhost

MySQL name: xxxxxxxx

MySQL user: yyyyyyyy

Table prefix ps_

MySQL engine InnoDB

Link to comment
Share on other sites

Oh. I understand your pain. I imported similar number of products earlier and had to disable indexing in code, increase memory up to 2G and do other small polishings. But it was v1.4. Things are different in v1.6.

 

How long it takes to import 100 products?

Link to comment
Share on other sites

There is an idea if some of the PS programmers read this post:

 

It would be helpful, when an administrator prepare everything on  CSV import page, then could be two way:

 

- instantly start the import like now

 

- or make a button what could generate a specified php file about the instantaneous setting, next to the imported csv file

 

And of course admin can run it in terminal console

 

This should be a solution....

 

any comment please?

Link to comment
Share on other sites

Thanks my friend, but the problem is we have 37.000 products in the shop and wanted to bypass the endless importing method :blink:

 

For such extreme cases of import volume, I have seen other forum members advising to transfer your website to localhost environment (on a PC with as powerful hardware as possible, obviously), complete the import process there and then transfer the website back to the web host.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...