CSV product import - Error copying image

[hedgehog]

Hello there. During product importing, TB says "Error copying image", and all imported products don't have any images, while everything worked well on PS (same product tables and server). Server logs show no relevant errors, admin panel logs shown 0x 0 error during import. Tried tweaking image setting, fresh installs, different domain names, no success

[jnsgioia]

What version are you using? I just upgraded to 1.0.8 and am having the same issue. Images were importing fine with 1.0.7.

[hedgehog]

@jnsgioia I've tried both 1.07 and 1.08. Currently i'm on 1.08 and it doesn't work at all. On 1.07, it worked with a lot of bugs (only ~50% of images were displayed correctly)

[datakick]

@hedgehog what is your memory limit?

When thirtybees copy image, it needs to resize it. It's likely that the source images are huge, so they require large amount of memory to process. TB will not try to resize such images if you run on server with limited memory, as it would lead to server crash.

[hedgehog]

@datakick 4096mb memory limit, 6gb available on VPS. I've tried both large xlsx files (8k products) as well as small tables (10 producs), and everything worked well with ~2-4k product tables with the same products/pics on prestashop, on the same hosting

[hedgehog]

@datakick here is my config

[datakick]

@hedgehog that's definitely enough memory. So the culprit must be somewhere else. Could you please try to modify this line in classes/Tools.php and change it to look like this:

'verify' => _PS_TOOL_DIR_.'cacert.pem',

[hedgehog]

@datakick Thanks, that seem like a good fix to the issue. However, there are still some problems - i have to manually regenerate thumbnails (but that's not a big problem anyway, no really need to fix), and most importantly - if there are multiple images in the table (pic1.jpg, pic2.jpg, pic3.jpg) none of them are added, same error. Only cells with one image are added correctly. I've tried both img, img, img and img,img,img But anyway, thanks alot, the tools at least works partially now

[datakick]

@hedgehog are you using correct multiple value separator ?

[hedgehog]

@datakick oh well i dont know, since im uploading xlsx not csv. During import it says "Error copying image: https://media.domain.org/sysmaster/product/hbd/h5f/8820243791902.jpg,https://media.domain.org/sysmaster/product/h92/h13/8820244447262.jpg" so that probably means that all images are recognized within the same cell as they should, and aren't separated to different cells. By the way, there is no option to choose separator if i upload xlsx, only if i upload csv

[hedgehog]

@datakick If i place space after comma, it says "Error copying image: https://media.domain.org/sysmaster/product/hbd/h5f/8820243791902.jpg,%20https://media.domain.org/sysmaster/product/h92/h13/8820244447262.jpg" maybe it something with spaces being converted to %20

[datakick]

@hedgehog try to separate the images by ; instead of ,

[hedgehog]

@datakick Wow, that's worked! Thanks alot, you sir are a prestashop wizard. Just imported 3k+ of products, regenerated thumbnails, and everything is good. I was confused since tb says that the format is "Image URLs (x,y,z...)" rather than "Image URLs (x; y; z...)", and commas were fine with PS

[jnsgioia]

@datakick This fixed the problem for me too. Thank you!!!

[Traumflug]

I was confused since tb says that the format is “Image URLs (x,y,z…)”

Whether , or ; gets used inside fields is configurable.

I just wanted to fix this message to make it match default settings, but this apparently happened already:

Where is this message which confused you?

[yaniv14]

@Traumflug I think its the example files that shows comma as a seperator

[hedgehog]

@traumflug said in CSV product import - Error copying image:

Where is this message which confused you?

Here, on the right side of the screen ("Available fields") when you choose "products" on "What do you want to import?" list. Also, @traumflug said in CSV product import - Error copying image:

Whether , or ; gets used inside fields is configurable.

It is configurable only if you upload CSV, but it's not the case for xlsx

[Traumflug]

https://github.com/thirtybees/thirtybees/issues/812

[Generaal]

Have someone a solution, The github link does'nt work.

Using 1.08 version and import the cvs file, but the images don't wont go right.

I have tried all the settings: but nothing wil work.

When I open the image link in the browser, they come up.

[kris2x]

I have the same problem. Same version tb 1.08. 
I have  tried to import the same file into ps 1.6 and everything worked.

Edited February 10, 2019 by kris2x

[kris2x]

On 12/20/2018 at 10:34 AM, datakick said:

@hedgehog that's definitely enough memory. So the culprit must be somewhere else. Could you please try to modify this line in classes/Tools.php and change it to look like this:

'verify' => _PS_TOOL_DIR_.'cacert.pem',

This solved my problem 😄

[colorful-ant]

On 12/20/2018 at 10:34 AM, datakick said:

@hedgehog that's definitely enough memory. So the culprit must be somewhere else. Could you please try to modify this line in classes/Tools.php and change it to look like this:

'verify' => _PS_TOOL_DIR_.'cacert.pem',

This solved my problem too

[kobino]

On 12/20/2018 at 10:34 AM, datakick said:

@hedgehog that's definitely enough memory. So the culprit must be somewhere else. Could you please try to modify this line in classes/Tools.php and change it to look like this:

'verify' => _PS_TOOL_DIR_.'cacert.pem',

Same problem here, solved with @datakick answer, thanks !!

[jnsgioia]

The only issue I have found is when you update tb you have to go back and change the classes/tools.php again.  Is there a way to avoid this?

[datakick]

13 minutes ago, jnsgioia said:

...you have to go back and change the classes/tools.php again...

what do you mean change the classes/tools.php ?

[jnsgioia]

On 12/20/2018 at 2:34 AM, datakick said:

@hedgehog that's definitely enough memory. So the culprit must be somewhere else. Could you please try to modify this line in classes/Tools.php and change it to look like this:

'verify' => _PS_TOOL_DIR_.'cacert.pem',

When you update tb the line above reverts to the original and the import fails.  You have to go back and modify it again.