Importing a csv avoiding that commas breaks long description

  • Resolved genart2020

    (@genart2020)


    4 years, 4 months ago

    Hello to everyone,

    so I am using the WordPress interface to import my csv file and display my products in the Woocommerce store of my website. In some Attribute fields named as example “Precautions” and “How to use” I have some long text that of course is divided by commas, the problem is that when I upload my csv these commas split my text who get reordered and displayed in alphabetical order showing an illogical reading order.

    There is any way to export a csv getting these attributes as one big block? So having commas as part of the regular text and not as a divider?
    I’ve already tried to prepare a csv with semicolon instead than commas but the result is the same as above.

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

  • Most of the time, putting quotes around the text can solve the problem:
    “1,2” ,”3,4″.

    Thread Starter genart2020

    (@genart2020)

    Thank you for your help @johannsf,

    I’ve already tried quotes but commas are still splitting my text even if it all was contained between quotes, displaying a different reading order who’s still incorrect. Also quotes are appearing in my text area like they are now part of the description.

    • This reply was modified 4 years, 4 months ago by genart2020.

    @genart2020 – I’ve had a bit of trouble duplicating this same issue.
    Are you able to share the CSV you’re using to perform this import?

    – Joey

    AJ a11n

    (@amandasjackson)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thread Starter genart2020

    (@genart2020)

    Yes I’ve been performing some tests but seems like commas still break my text..

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Importing a csv avoiding that commas breaks long description’ is closed to new replies.