Woocommerce CSV product import hangs – Issue with file format

  • Resolved Schalk Joubert

    (@schalkjoubert)


    4 years ago

    Hi,

    I’m experiencing issues when import products with the default (built-in) Woocommerce product importer. I don’t get an error message, but instead, the importer just hangs.
    I narrowed it down to two specific products/row data being the culprit.
    But I can’t see what is wrong in those rows. Link to CSV (I do export the good sheet as CSv when uploading)

    The import only works to the point when it reaches that row, and then hangs.
    If the culprit row is at the start of the sheet it won’t import any products at all.

    Any advice as to the issues with my csv?
    Thank you

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • ftahumour

    (@ftahumour)

    Your issue “may” be related to MIME checks that were introduced a while back for security reasons. To my knowledge there isn’t an easy workaround without the help of a plugin AND you certainly do not want to disable MIME in code for security reasons.

    The way I current get around the issue is by using the “Disable Real MIME Check” plugin in my instance. I have this installed and “disabled” most of the time, I only enable it when I want to upload a CSV with modified product data into my instance. Once enabled, the upload function works, then I just disable the plugin until the next time I need it.

    It’s a workaround, and you get site health messages telling you to remove disabled plugins, but that’s an annoyance I have to live with until a better solution is proposed/employed.

    Hope this helps you.

    Thread Starter Schalk Joubert

    (@schalkjoubert)

    Hi, Thank you so much.
    Unfortunately, it didn’t make any difference for me.

    dougaitken

    (@dougaitken)

    Automattic Happiness Engineer

    Hi @schalkjoubert

    The file is locked so I couldn’t review it.

    Related to what @ftahumour mentioned – if there is any HTML tags in the product description or product short description, the importer won’t be able to work through those either.

    If the importer stops at a certain line, can you check for any error logs at WooCommerce > Status > Logs > Select – Log under drop-down (right side) > Click – View button

    Second, can you share those two rows in a publicly accessible CSV file, please?

    Thanks,

    Plugin Support abwaita a11n

    (@abwaita)

    Hi @schalkjoubert,

    We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, you were able to find a solution to your problem!

    If you have further questions, please feel free to open a new topic.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Woocommerce CSV product import hangs – Issue with file format’ is closed to new replies.