Description
openedon Aug 21, 2024
Description
Important
This issue occurs upstream in the @woocommerce/csv-export
package – I've reopened the related issue in the WC repo: woocommerce/woocommerce#25379
I've marked this issue as blocked
while we resolve the issue upstream.
We received this in one of our support requests:
When the report download is emailed to me, it is great (see screenshot attached called 'fine'). However, when the report downloads immediately, which is most of the time, there are the symbols
'-
in front of every figure in the 'fees' column (see screenshot titled 'not fine'). This is very frustrating, as Excel is not able to recognise the figures and automatically create a total for me underneath, so I have to manually remove the'-
symbols from every single row of the fees column.
Here's the "fine" screenshot from emailed reports, doesn't have '-
symbols:
Here's the "not fine" screenshot from automatically downloaded transaction reports, has '-
symbols:
Request: Since the emailed transaction CSV files do not have the symbols '-
, could we consider removing these symbols in the automatically-downloaded transaction reports?
Acceptance criteria
Removal of the symbols '-
before transaction fees in automatically downloaded transaction CSV files.
Designs
The fees column in the automatically-downloaded transaction reports should look like this:
Testing instructions
- Go to WP-Admin → Payments → Transactions on a WooPayments account that doesn't have many transactions (you can use the advanced filters in the "show" dropdown if the account has many transactions to reduce the number of transactions shown to ~20 or so)
- Click on the download button to automatically download the WooPayments transactions
- Open the downloaded CSV file, check the Fees column and check if the fees has the symbols
'-
. Ideally, these shouldn't show if this improvement is made.
Additional context
Reported on 8635657-zen