Jump to content
  • 0
constantina

Prestashop 1.5 CSV import problem

Question

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

Share this post


Link to post
Share on other sites

24 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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 piemant@yahoo.it

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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 piemant@yahoo.it

 

Thanks piemant for that. :)

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

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 piemant@yahoo.it

 

Thanks piemant for that. :)

 

on what line in php is it?

Share this post


Link to post
Share on other sites

×