Prestashop 1.5 CSV import problem

[constantina]

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

[eadi]

I have exactly the same problem. Didn't find any solution, working for hours.

[eadi]

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 January 16, 2013 by eadi (see edit history)

[constantina]

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

[constantina]

Yeah, editing AdminImportController.php also worked for me. Thank you very much!

[[email protected]]

Hello eadi,

 

please explain "in csv type Categories (x,y,z...) instead of Categories (x,y,z,...)"

Is it just a matter of a comma in the field?

 

Thanks

Edited January 18, 2013 by [email protected] (see edit history)

[[email protected]]

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 January 25, 2013 by [email protected] (see edit history)

[ricky11]

Still not understand how this was solved... is this a import bug?

[ricky11]

Can't seem to import products to certain categories, its always going to HOME category!

 

Any way out?

[[email protected]]

Can't seem to import products to certain categories, its always going to HOME category!

 

Any way out?

I think it's a bug. Try the solution I've suggested: you have to change the code in AdminImportController.php file.

[ricky11]

Thanks solution worked. hope they resolve it in future releases.

[netwide]

this works. You need to apply both fixes in this thread for it to work properly.

[e.negrobov]

Piemant, thank you for the solution. I spent 3 days trying to upload images and one day on cateories without any results. You are the hero

[Maury Markowitz]

People in this thread: are you saying that *no* images were uploading?

 

I do get *most* images, but *some* do not appear. I cannot see a pattern.

[eadi]

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

[design4VIP]

thx, it's working on 1.5 but how to fix categories in 1.4.9.0?

[rasegan]

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.

[cutecat]

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.

[cutecat]

any updates for Additional shipping cost (per quantity): to be added into CSV import?

[Dmit]

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

[47diamonddistrict.com]

Upgrade to 1.5.4.1 fix that issue for me.

[rexie123]

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?

[benjamin utterback]

Hi rexie123, what version of PrestaShop are you using?

[rexie123]

Hi rexie123, what version of PrestaShop are you using?

 

hi have

Prestashop v1.5.3.1

[rexie123]

als ik de import doe in prestashop komt het wel in de database maar niet in de shop??