Product changes are not applied in Sitecore XC storefront due to invalid datetime format


Description

When adding a new product to the existing category in Sitecore Experience Commerce scaled environment, a new product appears in the category listing but the product details page might not be accessed in a storefront. The root cause of the issue is that the date of the entity update and the date of the mapping update are compared between the local time and UTC time formats. As a result, the date comparison is not correct, and subsequent processing is not indexed, mapped, or cached for the entities that would otherwise be updated.

Solution

To resolve the issue, consider one of the following options: