• Resolved bipolab

    (@bipolab)


    When I export orders and download them as csv, the file will include also HTML codes. is it possibile to trim them?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Hi,

    Unfortunately there is no such feature yet but we have added it to our todo list.

    Thread Starter bipolab

    (@bipolab)

    Hmmm it does not sound so good…. this way is pretty useless as CSV :/
    I hope this will be added soon…
    Thanks for your reply!

    Thread Starter bipolab

    (@bipolab)

    There must be something wrong in any case: the csv has 4 columns with unkown fields (which are named “column1”, “_1”, “_2”, “_3”)

    Hi,

    Could you clarify which columns in your CSV file contain HTML? Also, could you share a screenshot or a snippet of the report with these columns because unfortunately I am unable to reproduce the issue.

    Thread Starter bipolab

    (@bipolab)

    Thank you for caring.
    As first thing, the additionals columns was generated by the commas in the values (as in the following example).
    I’ve fixed it by changing the CSV separator in settings page.
    You can take a look at the whole settings here:
    http://areatest.svilupposito.net/docs/1.settings.png

    Here you can see how the export is shown (I’ve just covered the names):
    http://areatest.svilupposito.net/docs/2.report-export.png

    And finally this is a screenshot of the CSV
    http://areatest.svilupposito.net/docs/3.csv-file.jpg

    As you can see the columns that are affected are those which contain a price. The HTML is always the same and it’s like the following:
    <span class="woocommerce-Price-amount amount"><span class="woocommerce-Price-currencySymbol">&euro;</span>&nbsp;46,34</span>

    46,34” is the only value that changes.

    Hope it may help…

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

The topic ‘HTML codes in csv files with orders report’ is closed to new replies.