• Resolved petulak

    (@petulak)


    While importing .csv with products I can map the collums perfectly fine but if I add collum with description including HTML tags no matter where the whole row will get squeezed under ID and rest is empty. I’ve tried different separators and whole bunch of stuff, what am I doing wrong? Help appreciated, thanks.

    Image: https://i.imgur.com/LDdoRkn.png

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter petulak

    (@petulak)

    Bump 🙁

    Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    Here is a product with HTML in the description: http://cld.wthms.co/1KMW1x

    I moved that row to the top for an example, and here it is on the mapping screen: http://cld.wthms.co/ZSyZk1

    And lastly, all was mapped fine: http://cld.wthms.co/zEe4j8

    ______

    So there has to be something wrong with your CSV or something conflicting with the import, though likely the first thing.

    When there is HTML, WooCommerce quotes the whole entry like this: http://cld.wthms.co/R4aII5. So perhaps some invalid html or quotes you have is causing this.

    Thread Starter petulak

    (@petulak)

    Thanks for comment but as I found out, the quotation mark (“) breaks the whole row of import and pushes everything together. The mark can be anywhere, even in product name. Can this be somehow my fault since I force set UTF8 after converting XML to CSV? Too bad I found out after manualy copying the description for 70% of the products.

    Caleb Burks

    (@icaleb)

    Automattic Happiness Engineer

    Yea, that would make sense that it would break the import then.

    Try substituting out the quotes in the content body with the html entity: https://www.ascii.cl/htmlcodes.htm

    Or, create a product with html in the content along with quotes, and export just that. And see how it’s handled and copy that structure.

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

The topic ‘Can’t import description with HTML tags from .CSV’ is closed to new replies.