sahostking Posted July 22, 2014 Share Posted July 22, 2014 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 More sharing options...
bigbigmimi Posted July 22, 2014 Share Posted July 22, 2014 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 = 2000max_input_vars = 500000memory_limit = 512Mmax_file_uploads = 50max_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 More sharing options...
Constantino Posted July 22, 2014 Share Posted July 22, 2014 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 More sharing options...
bigbigmimi Posted July 22, 2014 Share Posted July 22, 2014 I already tried to download for the Demo Store Manager but upon install it fail to connect to demo server. I don't think it will be a solution for that even the demo couldn't work. Link to comment Share on other sites More sharing options...
Constantino Posted July 22, 2014 Share Posted July 22, 2014 It works almost perfectly. Probably, you have failed to configure a connection. Check the documantation about configuring the bridge connection to your server: http://store-manager-for-prestashop-documentation.emagicone.com/quick-start-guide/php-mysql-bridge-connection Link to comment Share on other sites More sharing options...
sahostking Posted July 23, 2014 Author Share Posted July 23, 2014 Thanks, will be giving it a try today. Link to comment Share on other sites More sharing options...
sahostking Posted July 26, 2014 Author Share Posted July 26, 2014 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 More sharing options...
usengines Posted August 6, 2014 Share Posted August 6, 2014 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 MB417LLA-PB-R (ID: MB417LLA-PB-R) cannot be saved Property Product->condition has bad value (allowed values are: new, used, refurbished) MC309LLA-PB-R (ID: MC309LLA-PB-R) cannot be saved MC812LLA-PB-R (ID: MC812LLA-PB-R) cannot be saved MD093LLA-PB-B (ID: MD093LLA-PB- cannot be saved MC705LLA-CS-PB-R (ID: MC705LLA-CS-PB-R) cannot be saved MC706LLA-PB-R (ID: MC706LLA-PB-R) cannot be saved MC706LLA-PB-B (ID: MC706LLA-PB- cannot be saved MA970LLA-PB-2R (ID: MA970LLA-PB-2R) cannot be saved MB871LLA-PB-R (ID: MB871LLA-PB-R) cannot be saved MC240LLA-B (ID: MC240LLA- cannot be saved MC226LLA-PB-R (ID: MC226LLA-PB-R) cannot be saved MD313LLA-PB-R (ID: MD313LLA-PB-R) cannot be saved MD313LLA-PB-B (ID: MD313LLA-PB- cannot be saved Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now