DocumentationCommerceCommerce KB

ACSD-54342: Error message when importing CSV file without valid data

Last update: Tue Nov 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Admin
  • Developer

The ACSD-54342 patch fixes the issue where an incorrect error message occurs when importing a CSV file without valid data. This patch is available when the Quality Patches Tool (QPT) 1.1.39 is installed. The patch ID is ACSD-54342. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.7.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.6-p2

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.0 - 2.4.6-p3
NOTE
The patch might become applicable to other versions with new Quality Patches Tool releases. To check if the patch is compatible with your Adobe Commerce version, update the magento/quality-patches package to the latest version and check the compatibility on the Quality Patches Tool: Search for patches page. Use the patch ID as a search keyword to locate the patch.

Issue

An incorrect error message occurs when importing a CSV file without valid data.

Steps to reproduce:

  1. Create an import file with only invalid data (Examples: SKUs that don’t exist, invalid customer address fields, or malformed customer email addresses).
  2. Import the file, selecting to skip the validation errors.

Expected results:

The validation fails with There are no valid rows to import message.

Actual results:

The validation passes, but the import fails with Error in data structure: values are mixed message.

Apply the patch

To apply individual patches, use the following links depending on your deployment method:

To learn more about Quality Patches Tool, refer to:

For info about other patches available in QPT, refer to Quality Patches Tool: Search for patches in the Quality Patches Tool guide.

recommendation-more-help
8bd06ef0-b3d5-4137-b74e-d7b00485808a