Update Quantity in CSV Combinations

[AndreaHammer]

Hi eeverybody!

In a few words here's my situation:

 

I'm managing a shoes shop with 'round 1000 products, 10 combinations each product more or less, so the Combinations CSV counts around 10000 lines.

 

I'm using the column "Reference" to update the quantity, without any kind of trouble.

 

The problem is that the CSV Combinations stops to upload after more or less 1000 lines (when I'm lucky) so I have to cut off the file in 5-6 parts.

 

Is it a matter of Prestashop?

Hosting?

My internet connection?

 

What could be the solutions to upload just one unique file?

 

Thanks in advance

 

 

 

 

 

 

 

 

[PascalVG]

Maybe check first if some server settings can be modified and if that helps:

http://dh42.com/blog/speed-prestashop-php-ini/

 

 

My 2 cents,

pascal

[AndreaHammer]

Thanks for your answer. 

 

I tried to follow your suggestion, but I still have problem to upload all the file!

[PascalVG]

Did it get any better, or still the same?

 

Not sure where to look further... Is there anything useful in the server log files? Check with your host if they can guide you here a little. Where to find these log/error files, where to look for clues etc.

 

My next 2 cents

[AndreaHammer]

It's actually still the same..

I get in contact with my host and they said that from the server log the operations last too much "mod_fcgid: read data timeout in 600 seconds" even if they put

 

max_execution_time=600

max_input_vars=10000

memory_limit=256M

upload_max_filesize=100M

post_max_size=100M

max_input_time=600

 

so to the maximum allowed on my host.

 

Do you think that the operations with around 3000 lines (ID, Reference, Value, Attibutes, Quantity) can last so long?

 

i'm struggling to find a solution

[prestatent]

Hi

 

Here's a thought. You should have only one image in the combinations csv for each style of shoe.

 

So if you have 10 sizes in a combination, only the first combination should have an image, with the other 9 having no image as these sizes and hence images are all for the same style of shoe.

 

This should speed things up as the import function won't have create 1 image for each shoe size,  only 1 per shoe style.

 

Try it out and let me know how you get on.

[AndreaHammer]

Hi and thanks again for your suggestion

 

Unfortunately it's not a matter of images, as all of the photos are uploaded in the Product CSV. 

 

In the Combination CSV I have only 5 column: ID, Reference, Attribute, Value and Quantity.

[prestatent]

What version of PS are you using?

 

An example of a file that I know works for PS 1.6 is below. My columns are separated by a pipe (|).

 

1|Shoesize:1,Color:1|10:1,Graphite:1||SHOEREFER17010||||||0|1||0|7|http://www.mysite.co.uk/img_import/373848_Images.jpg|0||||
1|Shoesize:2,Color:2|10.5:2,Graphite:2||SHOEREFER1701D||||||0|1||0|7||0||||
1|Shoesize:3,Color:3|11:3,Graphite:3||SHOEREFER17011||||||0|1||0|7||0||||
1|Shoesize:4,Color:4|11.5:4,Graphite:4||SHOEREFER1701C||||||0|1||0|7||0||||
1|Shoesize:5,Color:5|12:5,Graphite:5||SHOEREFER17012||||||0|1||0|7||0||||
1|Shoesize:6,Color:6|12.5:6,Graphite:6||SHOEREFER1701J||||||0|1||0|7||0||||
1|Shoesize:7,Color:7|13:7,Graphite:7||SHOEREFER17013||||||0|1||0|7||0||||
1|Shoesize:8,Color:8|6:8,Graphite:8||SHOEREFER17006||||||0|1||0|7||0||||
1|Shoesize:9,Color:9|6.5:9,Graphite:9||SHOEREFER1701F||||||0|1||0|7||0||||
1|Shoesize:10,Color:10|7:10,Graphite:10||SHOEREFER17007||||||0|1||0|7||0||||
1|Shoesize:11,Color:11|7.5:11,Graphite:11||SHOEREFER1701G||||||0|1||0|7||0||||
1|Shoesize:12,Color:12|8:12,Graphite:12||SHOEREFER17008||||||0|1||0|7||0||||
1|Shoesize:13,Color:13|8.5:13,Graphite:13||SHOEREFER1701A||||||0|1||0|7||0||||
1|Shoesize:14,Color:14|9:14,Graphite:14||SHOEREFER17009||||||0|1||0|7||0||||
1|Shoesize:15,Color:15|9.5:15,Graphite:15||SHOEREFER1701B||||||0|1||0|7||0||||

 

It may also be a timeout issue with the script stopping after the timeperiod set in the php.ini or a similar apache setting.

 

Another option may be to run the import from the command line (outwith the browser), which will not timeout and could be scheduled by cron. I don't know if there are any modules out there that do that. We had to create this manually using a modified import script, which works well.