Importing products

[blanqui2001]

Hello everyone.

 

I'm having a terribel headache when importing products.

 

The problem is not in creating the csv file itself. I managed to master the file format

 

The problem comes when I have to import the csv to the server.

If I try with a 200 products file, most of the time all goes well. If the amount of products is higher than 200 I get a 500 error. But the total amount of products I need to import is about 50.000.

Splitting this huge file is not an option because the time I have to spend importing those 250 files, wich contain 200 products each is a nightmare.

 

I've tried store manager for prestashop and it is not really an option. The program starts screwing things and the job never gets done.

 

Is there any way I can do it?

3 years ago I used oscommerce and I was able to code a small program to update the database and upload the images but I can't do that with prestashop because of the weird image handling it has.

 

Any help would be really really appreciated.

 

Blanqui

[phrasespot]

I'm having a terribel headache when importing products.

We only treat PrestaShop here. You will need to consult with a qualified physician for this. Don't try to treat it yourself, may be the symptom of a more serious underlying condition.

 

If I try with a 200 products file, most of the time all goes well. If the amount of products is higher than 200 I get a 500 error.

Try increasing the memory available to PHP process.

 

Splitting this huge file is not an option because the time I have to spend importing those 250 files, wich contain 200 products each is a nightmare.

If the above does not work, load the master import file in a spreadsheet program. Write a macro to cut first 200 lines and save as a new worksheet. Then there is the tedious task of importing each one of those 250 worksheets. You can save time if you save the import configuration after the first import. Then the rest will take a few clicks each.

[i2imedia]

50.000 seems like a lot of products. There is a lot that can go wrong and will go wrong when importing that many products.

 

If I where you I would do one of the following:

 

- Split the csv in to smaller bricks (at least smaller then 50.000) and increase memory size in php.ini file.

 

and if that doesnt work i think you are reaching some limits mayby it's your hosting I dont know. So then it's better to

 

- Install Prestashop on a Xampp or Mampp server locally and increase the memory size in your php.ini then import the products.

 

Kind regards,

 

T. Barbillion