importing csv

[everythingdog]

hi all, trying to import some products/catalogues to my back office (files are from my dropshipper). i go to advanced parameters > import csv i have 'uploaded' 2 files, one is xls. the other is csv, my first problem is i dont know how to remove these 2 files from the little upload box at the top as i want to do them 1 at a time, anyone know how? my second problem is that neither of them would import, came up with lots of errors. i have looked and looked but cannot find a tutorial or guide that explains the basics of importing product catalogues, i looked at the sample files but dont really understand what they are showing. do the spreadsheets columns have to have specific columns and names etc...?? any help much appreciated thanks

Edited March 17, 2013 by everythingdog (see edit history)

[everythingdog]

no worries just going to input manually

[Christiaan_01]

You can remove that list through your ftp.

Public html -> Admin (the one you renamed after installing prestashop) -> import

 

There you see the list of all the uploaded files, and can remove them.

 

As for the csv itself: Make sure that the tabs correspond with the colums. For example: Description with description, price with price.

Also make sure that you insert the right separators. When you use commas, indicate that you use commas.

[preserver]

I removed some of these files, and it took a few minutes for it to show up on my site at the csv loader file selection drop down menu. Is that normal?

 

Also, after I removed all the old files and re-uploaded new ones, I now have a 500 error after uploading products. I uploaded a new set of categories files, no problems. I uploaded products, suddenly problems. I had them both up there without problems before removing the old files from Public html -> Admin (the one you renamed after installing prestashop) -> import.

 

My shop is still working fine, but only about 1/6 of the products uploaded, then it stopped, and instead of the csv completed message on the csv import page, there is just a 500 internal error message.

 

I also recently uploaded 1.5.4.1. I had previously been using 1.5.3.1. It had bugs in the AdminImportController file, so I had to use two fixes for it: first, a replacement for the AdminImportController file (categories had not been working properly), then a fix in the override directory for AdminImport because product images weren't working.

 

Any chance that has to do with the error message, or is it a time-out issue on with my server? Any guesses?

[eleazar]

The 500 is a very unspecific error message. Try to retrieve where the message exactly comes from. Maybe it's a prob of server configuration, maybe not.

 

You should open /config/defines.inc.php.

Change your settings in line 28 define('PS_MODE_DEV', false); to true.

Helps you to retrieve the error.

[preserver]

When I went to change that part of the code, the editor said it wasn't there.

 

I have been having big issues with being timed out that I have been attempting to fix. Besides, prestashop switched to a 404 server error almost immediately after I posted this. Apparently the 404 error aligns with the csv upload being timed out by the server.

[satkauskas]

Overrided Setting of AdminImportController.php
@ini_set('memory_limit', '1024M');
@ini_set('max_execution_time', 0);
@ini_set('max_input_time', -1);
@ini_set('max_input_vars', 20000);

 

update for more e.g. max execution time ; )

file path: controllers/admin/AdminImportController.php