Jump to content

Importing CSV with 9000 products


Recommended Posts

Hi,

 

I'm trying to import CSV I created with over 9000 products. It keeps timing out. I imported this same list of products into Opencart and it works fine. 

 

Prestashop keeps timing out at around 1000.

 

Is there something I am missing? Memory requirements etc. for importing large csv files?

 

Any guidance or help will be appreciated.

Link to comment
Share on other sites

Hi, I am experiencing the same import issue. I am developing a clothing store and I have to import around 3000+ products daily with combinations such as size and color. I try the default CSV import in prestashop but got timeout around 5 mins later. Only about 30~40 products were imported. I asked my hosting company to change the server setting to allow more resources to be used to : 

 

max_execution_time = 2000
max_input_vars = 500000
memory_limit = 512M
max_file_uploads = 50
max_input_time = 1200

 

However this does not solve the problem and still I got timeout around 5 mins time and sometime just several products were imported.

 

Can you share your setting? Timeout at 1000 products sounds already a solution to me.... How many times you need until timeout?

I will just seperate the csv file into several smaller files, that should finish the importing. Thanks in advance.

Link to comment
Share on other sites

You may try to separate the file into smaller parts and import in few goes, or you should look for some alternative solution. I can suggest you one of them called Store Manager for Prestashop. Using this application working in bridge connection mode you can do import locally, so won't require lots of server resources.
In any case, you can try it out as there is 4-weeks free version available for download -
http://www.prestashopmanager.com/free-download/
Hope it will be helpful.

Link to comment
Share on other sites

  On 7/22/2014 at 1:40 PM, bigbigmimi said:

Hi, I am experiencing the same import issue. I am developing a clothing store and I have to import around 3000+ products daily with combinations such as size and color. I try the default CSV import in prestashop but got timeout around 5 mins later. Only about 30~40 products were imported. I asked my hosting company to change the server setting to allow more resources to be used to : 

 

max_execution_time = 2000

max_input_vars = 500000

memory_limit = 512M

max_file_uploads = 50

max_input_time = 1200

 

However this does not solve the problem and still I got timeout around 5 mins time and sometime just several products were imported.

 

Can you share your setting? Timeout at 1000 products sounds already a solution to me.... How many times you need until timeout?

I will just seperate the csv file into several smaller files, that should finish the importing. Thanks in advance.

 

Your issue may stem from the Apache Timeout which by default is set to 300s. Your web host can increase it to a higher value as this solved the issue for our web hosting clients who state it's working beautifully now. :)

Link to comment
Share on other sites

  • 2 weeks later...

When attempting to import using the part number as the name and the part number as the ID we get this message.  Have tried using simple line numbers as the id such as 1,2,3,4 that does not work either.  There is nothing in the csv help file that tells you what characters can be used or not used in a name. 

 

:  errors
 

  1. MB417LLA-PB-R (ID: MB417LLA-PB-R) cannot be saved
  2. Property Product->condition has bad value (allowed values are: new, used, refurbished)
  3. MC309LLA-PB-R (ID: MC309LLA-PB-R) cannot be saved
  4. MC812LLA-PB-R (ID: MC812LLA-PB-R) cannot be saved
  5. MD093LLA-PB-B (ID: MD093LLA-PB-B) cannot be saved
  6. MC705LLA-CS-PB-R (ID: MC705LLA-CS-PB-R) cannot be saved
  7. MC706LLA-PB-R (ID: MC706LLA-PB-R) cannot be saved
  8. MC706LLA-PB-B (ID: MC706LLA-PB-B) cannot be saved
  9. MA970LLA-PB-2R (ID: MA970LLA-PB-2R) cannot be saved
  10. MB871LLA-PB-R (ID: MB871LLA-PB-R) cannot be saved
  11. MC240LLA-B (ID: MC240LLA-B) cannot be saved
  12. MC226LLA-PB-R (ID: MC226LLA-PB-R) cannot be saved
  13. MD313LLA-PB-R (ID: MD313LLA-PB-R) cannot be saved
  14. MD313LLA-PB-B (ID: MD313LLA-PB-B) cannot be saved
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...