Another delimiter when products exporting

  • Resolved Aleksey

    (@hdelta045)


    5 years, 4 months ago

    Good day!
    In the plugin, when exporting products to separate the values ​​of the characteristics of the goods, such as name, price, description, etc., the default is to use a comma separated. It seems to me that this is not entirely correct, since this sign can be used in sentences describing a product when describing its properties. For example: “This T-shirt is stylish, beautiful, comfortable.” After exporting from Woocommerce and import the CSV file in Excel will split the sentence into several Excel table cells and offset the data in the tables. If there are not a lot of goods, then such a file can be quickly edited. But if there is a large amount of goods, then editing will take quite a long time. And if errors remain in the table, this may lead to incorrect import of data from the CSV file into the Woocommerce.
    Question: Is it possible to somehow change the separator when exporting data to one of those using Excel, or set your own?
    Thank.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author WebToffee

    (@webtoffee)

    5 years, 4 months ago

    Hi @hdelta045,

    We have tested the same in our test environment using the basic version of the plugin and the sentences containing comma were exported under the corresponding columns only instead of exporting into separate cells. We can assure you that there will be no issues with exporting data containing comma symbol in it.

    The option to change the delimiter while exporting products is one of our premium features. You may have a look at the premium version of the plugin in which you can specify different delimiter while exporting products.

    Thread Starter Aleksey

    (@hdelta045)

    5 years, 4 months ago

    Ok, with the premium version of the plugin everything is clear. But in the basic version, an error with the division of sentences in several columns is still present. I can provide an example of exporting test store data, in which this error manifests itself, if you are not confused that the data will be partially in Russian.

    Plugin Author WebToffee

    (@webtoffee)

    5 years, 3 months ago

    Hi @hdelta045,

    Could you please share us the CSV file with which you are having the issue via support.

    Our support team will follow you up from there.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Another delimiter when products exporting’ is closed to new replies.