Jump to content

Update Quantity in CSV Combinations


AndreaHammer
 Share

Recommended Posts

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

 

 

 

 

 

 

 

 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More