CSV import but stops after a certain number of rows

[tommylein]

Hi all,

 

I have an isse when loading data using the csv load function:

 

1. When loading products or combinations using CSV it works but the import but stops after a certain number of rows (about 80) (I can see loaded rows in mysql) and does not show any page after the load. Just a wite blank page and nothing more. No result or error message. This is not related to the data as when I spliited the inout files in junks < 80 all of them have been loaded.

But when doing this with many combinations and attributes this is a pain, I just want to laod the complete file.

1. Any idea how to configure the numnber of rows to be loaded? I read a post but it seems to be related to a paid module which I am not owning. I don't know the performance tab has a seeting like this because I cannot see the "Advanced paramters -> Performance" page (see my second post)
   
2. Any idea why the AdminImport page is not showing after the load?
   
3. in general prestashop seems to be very very slow on frontend and backend. Any performance hints other than the ones which should be on the "Advanced paramters -> Performance" page as I have read everything about these setting already.
   

version 1.5.1 fresh installation, no upgrade from prev. version

 

Thanks for help

Tommylein

[Carolina Custom Designs]

When loading products or combinations using CSV it works but the import but stops after a certain number of rows (about 80)

 

This is likely to be a timeout of PHP maximum execution time. Check Advanced Parameters > Configuration Information tab and adjust value accordingly in PHP settings.

 

Marty Shue

[Guest]

I agree, probably a time out issue - especially if you are using the CSV to upload images also

 

When I started I had to upload only 20 - 30 products at a time. Once the products were on Prestashop. I can update (without images) over 1000 at a time without problems

[mihai.namolosanu]

Can someone help me please with information about the settings that can cause Stop importing after 20-30 products? I mean what is the setting/settings to be changed.

[Guest]

Can someone help me please with information about the settings that can cause Stop importing after 20-30 products? I mean what is the setting/settings to be changed.

 

You will need to give a lot more information before anyone can help with such a problem

 

Version of prestashop?

Where is it hosted, is it shared hosting, free hosting, dedicated, VPS , etc

Do you have access to php settings

Are you trying to import images or just textual information

 

Any other info that could possible help

 

Unfortunatley, this will not be a button inside Prestashop settings to make this work: it is a hosting / php issue

[mihai.namolosanu]

Thank you haylau,

 

Please find below the informations you need:

 

- PrestaShop ver. 1.5.2.0;

- I have a shared hosting located in Romania;

- I don't have acces to php setting (at least I think so);

- I've tried to import files with and without images. The only difference is the number of imported products;

 

I know this is a hosting server settings problem and I need to know what settings need to be changed to tell those in hosting company.

 

Thank you.

[Guest]

Hi

 

Shared hosting is usually the issue with timeouts for uploads. I am not sure of the settings, there are suggestions on these forum somewhere if you search for them. But if you tell your host what you are trying to do ,they should know what the settings are

 

I doubt they will do it though

 

These are the kind of php settings that can be looked at: i am not suggesting these settings will work, I have them in a php.ini file

 

 

mysql.connect_timeout = 300;

 

; Set memory limit in megabytes

memory_limit = 128M

; Set maximum execution time in seconds

max_execution_time = 120

; Set maximum file upload size in megabytes

upload_max_filesize = 32M

; Set maximum post size in megabytes

post_max_size = 32M

 

; Set maximum input time in seconds

max_input_time = 180;

max_input_vars = 10000;

[mihai.namolosanu]

Thank you again haylau,

 

I sent those in hosting company your suggestions. I also gave them acces to the BO for themeselves loading .csv files in PrestaShop.

 

Nice day.

[xferx]

Most of the shared servers will give you that problem. I have a shared hosting pretty nice and powerfull but the execution time is 45 seconds and its far too few to load 6k products.

 

Dont worry you dont need to make several CSV's. Go to your import and load the CSV let it run untill it times out. Then go back and chek how many products you have loaded. Do the math and go again only this time type in the number of rows you wish to ignore (acording to how many products where loaded the last time).

 

Example:

 

6000 products CSV

Load CSV and let it time out.

Chek how many products you have in your system (200 products)

Load CSV and let it time out this time type in 200 in the field that says "Jump Lines"

Chek how many products you have in yoiur system (380 products)

Load CSV and let it time out this time type 380...

...

And so on.

 

Thnis was the best way i could load my products on a shared hosting.

[mihai.namolosanu]

Thank you xferx,

 

Indeed, your solution is more efficient to upload the same file instead of creating multiple files. But right now I have 13,000 products to load and probably soon I will have 6,500 more products to load, so I need to ask my hosting company to change my settings in order to upload one file at a time.

But as I said, your solution is good to be known by the others.

 

Nice day!

[mihai.namolosanu]

I will ask my hosting company what are these setting, so that everyone which has the same problem to ask hosting company personnel to modify these settings. I will post these settings.

[xferx]

Saddly almost no shared hosting will edit the php.ini setting to get a max execution time to be so long. Think that you need (with images included) arround 45 seconds per 300 products to upload on a good server. Do the math.... its over 1 hour max execution time.

 

If you want it all to be loaded in 1 execution (as i would love to do myself) yu must get a VPS or Dedicated server and edit the php.ini when you run the script and then change it back.

[ayanni]

i have managed server with super performance, i set max_excution to 300, but i still got time out, any idea