Jump to content

Welcome, Guest!

By registering with us, you'll be able to discuss, share and private message with other members of our community.

  • 0
hedgehog

CSV product import - Error copying image

Question

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

Share this post


Link to post
Share on other sites

25 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

@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)

Share this post


Link to post
Share on other sites
  • 0

@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.

Share this post


Link to post
Share on other sites
  • 0

@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

Share this post


Link to post
Share on other sites
  • 0

@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',

  • Like 1

Share this post


Link to post
Share on other sites
  • 0

@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

Share this post


Link to post
Share on other sites
  • 0

@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

Share this post


Link to post
Share on other sites
  • 0

@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

Share this post


Link to post
Share on other sites
  • 0

@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

Share this post


Link to post
Share on other sites
  • 0

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:

0_1545398323102_fc21d323-c966-460b-b88d-4a597b7d6d28-grafik.png

Where is this message which confused you?

Share this post


Link to post
Share on other sites
  • 0

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

Where is this message which confused you?

alt text 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

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0


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 by kris2x

Share this post


Link to post
Share on other sites
  • 0
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 😄

  • Like 2

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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 !!

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites
  • 0
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 ?

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×