Change the separator in the csv export file

  • Resolved edumls

    (@edumls)


    2 years, 11 months ago

    Hi,

    First, thanks for the plugin, is very very very useful.

    When I export my products in a CSV file, the separator is a comma “,”. But I have some product titles with a comma inside and If I try to import it in a spreadsheet it is a chaos.

    It is possible to change the separator with a snipet or other way? I think, for example, in a semicolon…

    Thanks!

    • This topic was modified 2 years, 11 months ago by edumls.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author storeapps

    (@storeapps)

    2 years, 10 months ago

    Hi,

    In order to change the delimiter for the Export CSV file, you can simply search for the below snippet of code in ‘woocommerce-stock-manager/admin/views/import-export.php’ file

    var csv = convertArrayOfObjectsToCSV({
	datas: JSON.parse( response )
});

    and replace the same with the below code snippet

    var csv = convertArrayOfObjectsToCSV({
        datas: JSON.parse( response ),
        columnDelimiter: ';'
});

    P.S. you can pass any delimiter string as desired by you. Also, you would need to maintain the same changes as it would be lost if you update to any new versions of the plugin in the future.

    Plugin Author storeapps

    (@storeapps)

    2 years, 10 months ago

    Hi there,

    We are marking this thread as resolved as we haven’t heard back from you.
    If you have any other questions, feel free to open a new topic.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Change the separator in the csv export file’ is closed to new replies.