DocumentationCommerceTools

ACSD-62793: Datetime attributes in exports missing time component. Additionally if Fields Enclosure enabled, attribute values enclosed within double-quotes

Last update: Fri Dec 13 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • Experienced
  • Admin
  • Developer

The ACSD-62793 patch fixes the issue where datetime attributes in exported data are missing the time component. Additionally if Fields Enclosure is enabled, attribute values in the additional_attributes column will be enclosed within double-quotes. This patch is available when the Quality Patches Tool (QPT) 1.1.55 is installed. The patch ID is ACSD-62793. Please note that the issue is scheduled to be fixed in Adobe Commerce 2.4.8.

Affected products and versions

The patch is created for Adobe Commerce version:

  • Adobe Commerce (all deployment methods) 2.4.7-p2

Compatible with Adobe Commerce versions:

  • Adobe Commerce (all deployment methods) 2.4.7 - 2.4.7-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

Datetime attributes in exported data don’t include the time component. Additionally if Fields Enclosure is enabled, attribute values in the additional_attributes column will be enclosed within double-quotes.

Steps to reproduce:

  1. Create a product attribute with Catalog Input Type for Store Owner = Date and Time.
  2. Assign the attribute to the Default attribute set.
  3. Create a simple product with a date and time value for the new attribute.
  4. Export the product to a CSV file from System > Data Transfer > Export.
  5. Check the attribute value in the additional_attributes column. It only has the date part, but not time.
  6. Update the attribute value to use the time, e.g. “08/10/22, 3:20 PM”.
  7. Import the CSV file.
  8. Check the catalog_product_entity_datetime table.

Expected results:

The date and time are exported and imported properly.

Actual results:

Only the date part is exported and imported.

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:

recommendation-more-help
c2d96e17-5179-455c-ad3a-e1697bb4e8c3