Documentation

Errors in category scheduling functionality in Adobe Commerce 2.4.5

Last update: Tue Jul 01 2025 00:00:00 GMT+0000 (Coordinated Universal Time)

After upgrading to Adobe Commerce 2.4.5, you see a validation error when saving changes to product categories in the Adobe Commerce Cloud Admin panel. This happens because old data from earlier versions remains in the database and conflicts with the updated logic. To fix this, remove the outdated date attributes from your database and confirm the issue no longer occurs.

Description description

Environment

Adobe Commerce Cloud, version 2.4.5 (after upgrading from an earlier version).

Issue/Symptoms

  • You see a validation error when saving category changes in the Adobe Commerce Cloud Admin panel.
  • Error message: Make sure the To date is later than or the same as the From date.

Steps to reproduce:

  1. Go to the Adobe Commerce Cloud Admin panel.
  2. Navigate to Catalog > Categories.
  3. Select a category.
  4. Reorder products or make any changes.
  5. Click Save.

Expected result:
The system saves your changes successfully.

Actual result:
The error message prevents the system from saving your changes.

Resolution resolution

Adobe Commerce 2.4.5 resolves this issue, but leftover data from earlier versions can still trigger the error. Follow these steps to fix it:

  1. Run this SQL query to check for existing values in the custom_design_from and custom_design_to attributes:

    code language-none 
    SELECT count(*)
        FROM catalog_category_entity_datetime
        WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code IN ('custom_design_from', 'custom_design_to') AND entity_type_id = 3);

  2. If the query returns results, delete those values using a suitable SQL command. Back up your database before making any changes.

  3. After deletion, monitor the database to ensure the values don’t return.

Important:

  • Apply and test all changes in a staging or integration environment before deploying to production.
  • Always keep a recent backup of your database before making modifications.

If the issue continues after cleanup, contact Adobe Commerce support for further help.

Scheduled changes for categories in Commerce Catalog Management

recommendation-more-help
3d58f420-19b5-47a0-a122-5c9dab55ec7f