The DefaultReportingService does not escape data

Found in

EPiServer.Commerce 12.6.0

Fixed in

EPiServer.Commerce 13.22.0

Created

Apr 21, 2020

Updated

Jul 22, 2020

Area

Core

State

Closed, Fixed and tested


Description

Steps to Reproduce:

  • Change a product name has a comma character. ex - [Denim, Jacket11] for the SKU-21320040
  • complete an order with this sku
  • run the "Collect Report Data" job
  • Download the report file from Commerce > Report and open the csv file

Actual:
The product name is not escaped (contains the comma), it makes the csv file wrong format. The attachment is an example, the 1st data line.

Expected:
The product name should be escaped.