import attribute with line braeak in text

  • Resolved saraeee

    (@saraeee)


    2 years, 4 months ago

    Hi. I use tools > imports > WooCommerce products (CSV) to import data to woocommerce. The problem is that when in CSV file I have a new line (line break) in attribute value(s) column, the line break is omitted and in the last result it is replaced just with a space.
    I wanted to know is there any way I can use line break in my attribute values?
    The address of imported file is
    https://file.io/SSTe0Xf27zHc
    I have changed description column of experimental_fashion_sample_9_products file to attribute 10 for testing.

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

    (@saraeee)

    Hi. I couldn’t find any way for importing attributes with line break from csv file. But I replaced all line breaks with ++ character in my excel file and then import it. After that I used below query to replace ++ with new lines.
    UPDATEwpwoo_postmeta`
    SET
    meta_value = REPLACE(meta_value,
    ‘++’,
    ‘\r\n’)`;

    Hello @saraeee ,

    Thanks a lot for the update on how you’ve solved the problem.

    However, I would like to know more about the exact problem you had in the first place. I file you linked before is no longer available there. Can you please share a new link so that we can see how you’ve added the attribute values in the CSV?

    By default, the attribute values should be added using a comma as you can see on this sample file so I would like to see why it breaks on your file.

    Thread Starter saraeee

    (@saraeee)

    Dear Rashed, thanks so much for your help.
    I uploaded my file in below url.My file is in persian and I wish it doesn’t make it hard for you. I used break line in attribute 7 and it disappear in my site.
    Now I am in hurry and can’t test it again but as I remember I added line break to woocommerce sample file and it also doesn’t seen in my website.
    The file is in:
    https://www.file.io/iN7q/download/Vtr2xIcHqoJj
    This screen shot shows new line in my google sheets
    https://snipboard.io/Axmh3g.jpg
    The line break exists in csv file
    https://snipboard.io/WU6J4K.jpg
    The output in my website is
    https://snipboard.io/8omIvJ.jpg

    Hi @saraeee,

    Thanks for sharing those screenshots and elaborating on how you were able to solve the issue with the import.

    I’ll mark this thread as resolved for now. Feel free to reply and reopen it if you need any further assistance.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘import attribute with line braeak in text’ is closed to new replies.