ACSD-62793: Datetime attributes in exported data don't include the time component

Categories

Import/Export

Components

magento/module-catalog-import-export, magento/module-import-export

Origin

adobe-commerce-support

Since QPT

1.1.55

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. 1. Assign the attribute to the Default attribute set. 1. Create a simple product with a date and time value for the new attribute. 1. Export the product to a CSV file from System > Data Transfer > Export. 1. Check the attribute value in the additional_attributes column. It only has the date part, but not time. 1. Update the attribute value to use the time, e.g. "08/10/22, 3:20 PM". 1. Import the CSV file. 1. Check the catalog_product_entity_datetime table.

Adobe's page lists 2.4.7 - 2.4.7-p3 as compatible; the versions below are resolved from the current QPT constraints and are the ones the tool will offer.

Adobe scheduled the permanent fix for 2.4.8.

Install

Install the Quality Patches Tool with composer require magento/quality-patches, apply the prerequisites listed for all files applicable to your distribution and version first, then run vendor/bin/magento-patches apply ACSD-62793. On Cloud, add ACSD-62793 under stage.build.QUALITY_PATCHES in .magento.env.yaml.

For cweagans/composer-patches, choose a compatible version below and download the bundle. Copy its ACSD-62793/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Bundle prerequisites the same way and list them first. Paths are relative to each package root, using the default -p1 level. Prefer local files when configuring composer-patches; a remote URL can change.

Patch files and compatible versions

Sources

• Adobe documentation for ACSD-62793
• JSON API: /api/v1/patches/ACSD-62793