CSV import: commas and line break ignored on import

  • Resolved zypans01

    (@zypans01)


    3 years, 10 months ago

    Hi guys, how should I include a comma or a line-break character within the text of a special attribute cell?

    After importing products from a CSV file (created with Google Sheets), using the Woocommerce import tool, commas and line-breaks characters present in the special attributes cells have disappeared. For instance, the text
    “Hi guys, so, my name is [line break] John” will appear as “Hi guyssomy name is John”. I have looked online and tried many ways to write those characters, such as quotation marks “cell’s content” or “,” for the comma, and “\n”, “\u”, “\a”, even <br> or <br/>. I also tried to create & export the CSV file through Excel and Open Office or Numbers (Mac OsX)

    Could Mac OsX be the reason? Woocommerce version (5.2.0)?
    Any idea here, or someone who experienced the same?

    Many thanks!
    Zypans

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Ross V. a11n

    (@rossviviano)

    Automattic Happiness Engineer

    Hi there!

    Can you post the CSV file here so we can go over it with a fine-toothed comb?

    Looking forward to hearing from you!

    Ross

    Plugin Support Ross V. a11n

    (@rossviviano)

    Automattic Happiness Engineer

    Hi again,

    We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions!

    Best,

    Ross

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘CSV import: commas and line break ignored on import’ is closed to new replies.