Jump to content

Prestashop 1.5 CSV import problem


Recommended Posts

Hi,

 

I installed a clean new version of prestashop 1.5. Everything was almost alright until i try to import my old 1.4 CSV files. I've updated files according to 1.5 columns. But i still had issues with importing products properly.

 

1- All products go under home. I tried both writing category IDs and category names. No way, everything's under home.

 

2- No product images. I gave img URL both as http://domain.com/folder/imaj.jpg and ../folder/imaj.jpg and my imgfolder and custom imgfolder permissions are 777.

 

So, at last, i have products without images under home category instead of under custom category when i import my product CSV file.

 

Is there anyone experienced a problem like this, or anyone has to say anything?

 

Server information

 

Server information: Linux #1 SMP Tue Nov 9 13:34:42 EST 2010 i686

Server software version: Apache/2.2.3 (CentOS)

PHP version: 5.2.16

Memory limit: 48M

Max execution time: 30

 

Database information

 

MySQL version: 5.1.54

MySQL engine: InnoDB

 

Store information

 

Prestashop version: 1.5.3.1

Current theme in use: default

Link to comment
Share on other sites

I found the solution:

1.for category : in csv type Categories (x,y,z...) instead of Categories (x,y,z,...)

2. I found a fix for images: replace content of controllers/admin/AdminImportController.php

with https://github.com/P...e3ebe473233d07.

 

This works for me.

 

 

Find the github link here:

http://www.prestashop.com/forums/topic/214816-153x-importing-with-csv-doesnt-create-imgpxxxxxjpg-and-imgtmpproduct-mini-xxxjpg/page__p__1060749__hl__category__fromsearch__1#entry1060749

Edited by eadi (see edit history)
  • Like 2
Link to comment
Share on other sites

I've found this solution:

 

The problem is that the $temp var isn't being assigned, so no file is opened.

To solve it, change this line:

 

$fd = fopen($temp, 'r');

By

$fd = fopen(_PS_UPLOAD_DIR_.$uniqid, 'r');

 

in AdminImportController.php file

 

Has worked for me on Prestashop 1.5.3.

Edited by [email protected] (see edit history)
  • Like 1
Link to comment
Share on other sites

  • 2 weeks later...

Hello eadi,

 

Thanks for sharing your solution.

 

Can you please explain "1.for category : in csv type Categories (x,y,z...) instead of Categories (x,y,z,...)". I don't understand it.

 

Thanks

 

First line in csv. Take a look to at provided example in prestashop admin

Link to comment
Share on other sites

I found the solution:

1.for category : in csv type Categories (x,y,z...) instead of Categories (x,y,z,...)

2. I found a fix for images: replace content of controllers/admin/AdminImportController.php

with https://github.com/P...e3ebe473233d07.

 

This works for me.

 

 

Find the github link here:

http://www.prestasho..._1#entry1060749

 

The link is not working, can you please tell me how i can edit the "controllers/admin/AdminImportController.php" its not working for me also. Thank you waiting to hear from some one.

Link to comment
Share on other sites

  • 3 weeks later...

how can I upload more than 1 jpg file? I have more than 1 picture to upload.

 

I have already uploaded to my server and only one picture was shown on my product. the other files are not imported to the product.

 

Also I would need to import in the "Additional shipping cost (per quantity):". it does not have this too.

 

For those who are having issue to upload their CSV, you need to go into controllers/admin/AdminImportController.php

 

$fd = fopen($temp, 'r');

By

$fd = fopen(_PS_UPLOAD_DIR_.$uniqid, 'r');

 

in AdminImportController.php file

 

Which was stated by [email protected]

 

Thanks piemant for that. :)

Link to comment
Share on other sites

  • 4 weeks later...

Import of products in the category with the same name - if you go knowing the product he is in the right category, but if you go through the menu in this category is writing that no items in this category?????

 

Prestashop 1.5.4

Link to comment
Share on other sites

  • 1 month later...

how can I upload more than 1 jpg file? I have more than 1 picture to upload.

 

I have already uploaded to my server and only one picture was shown on my product. the other files are not imported to the product.

 

Also I would need to import in the "Additional shipping cost (per quantity):". it does not have this too.

 

For those who are having issue to upload their CSV, you need to go into controllers/admin/AdminImportController.php

 

$fd = fopen($temp, 'r');

By

$fd = fopen(_PS_UPLOAD_DIR_.$uniqid, 'r');

 

in AdminImportController.php file

 

Which was stated by [email protected]

 

Thanks piemant for that. :)

 

on what line in php is it?

Link to comment
Share on other sites

×
×
  • Create New...