Why does my CSV product file import fail with a TCP connection error?

[jim53]

When I import CSV product file it keeps on declining with error message saying Failed to open TCP connection.

Please assist as we are failing to import product files.

[Ablestar_Daniel]

Hello,

Are you doing the CSV import from the Shopify Admin? I tried uploading the file on a test store and it seems to be working for me now. Maybe try again and see if it works? If you're still having problems could you send a screenshot of the error?

While looking at the file I noticed that your SKUs got corrupted. For example, the first product (Marlin Blue Border School Labels) is listed as having a SKU of "6.00969E+12". This usually occurs because the file has been re-saved in Microsoft Excel and it tries to convert long numbers to scientific notation. 

If you need some help on fixing the SKUs you can follow the instructions here: https://help.godatafeed.com/hc/en-us/articles/360049916591-How-to-prevent-Excel-from-converting-your...

Best,

Daniel

[jim53]

[jim53]

Hi Daniel

I still get errors please see attcahed.

[Ablestar_Daniel]

This looks like an error between Shopify and the URLs that are hosting the images. When you import the products the CSV file is saying there's an image at a URL like https://brainware.co.za/ProdImg/Big_4712805740574.JPG When Shopify reads the CSV file it then goes out and tries to download that image file. 

The errors you're seeing are saying that Shopify had problems downloading the images for a bunch of the different products. The causes for this vary but can include:

• The remote website took too long to send the image to Shopify
• The remote website was temporarily offline
• The remote website thought the traffic was Shopify was a bot/scraping and blocked it
• There was a temporary connection issue between Shopify and the remote website
• The remote file didn't send an image back (but instead sent an HTML file)
• Shopify's requesting too many images at once and it's overwhelming the remote server

Since it doesn't seem to happen with every image (eg, the first product in the file also has an image on brainware and I don't see an error for that) it's difficult to debug for someone outside of Shopify.

I'd recommend submitting a ticket to Shopify support seeing if they could investigate further. To increase the chances of 'success' I'd try with a smaller file of 1-10 products. Once you get the errors for the import, send those over along with the file you used and mention the specific image URLs that gave an error (but work when you try to access them directly)

Best,

Daniel

[jim53]

Thank you, Daniel, I will do that.

Regards

Jim

[jim53]

Good day 

Can we please get help, we are still experiencing the same issue regarding product import. we are still receiving an error message (Failed to open TCP connection) we are unable to import products in our shop due to that. we did send an email to support @Shopify three to four weeks ago till now we are still waiting for the respond. please anyone with experience please help.