Powered by Adobe Commerce 2.4.6-p4

eav_optimization-m.png

EAV Attributes Optimization

PRODUCT:
0
TOTAL:

Overview

Back to top

Migrating from Magento 1 to its modern counterpart Magento 2 might not be flawless and is highly dependent on the M1 setup. And you realize something is not right when a migrated Magento 2 fills the var/log/system.log file with an endless number of rows containing the same error: main.WARNING: Attempt to load value of nonexistent EAV attribute '94' for entity type 'Magento\Catalog\Api\Data\ProductInterface'. Instead of 94, you could see any other ID.

We, at SafeMage, have looked into the issue and found the cause for it. Various values in the EAV tables contain redundant data, in particular, 'null'.

The extension provides risk-free optimization of the EAV tables of all entity types (custom ones included) and clean-up for system.log. Upon successful optimization, the EAV tables will include fewer records (down to 5-10%). We have thoroughly tested and can guarantee the post-optimization integrity and working capacity of a Magento environment.

It is important to mention that regular processes that happen all the time in Magento, e.g., saving categories, products, and other entity types, are the reason why new 'null' values appear in the EAV tables. It is the case when non-required fields are empty. For that reason, we recommend optimizing the EAV tables regularly. The module makes it easy to maintain EAV tables and conduct clean-ups by providing three optimization options. You, as an admin user, can choose between a one-time manual or automatic clean-up solutions. The latter includes scheduled optimization relying on a cron job and optimization run on the fly. If you decide to enable scheduled clean-ups, monthly terms are recommended.

 

Features

  • Fixes errors in system.log: Attempt to load value of nonexistent EAV attribute 'N' for entity type 'Magento\Catalog\Api\Data\ProductInterface'
  • Safely removes useless data from EAV tables and makes them smaller in size
  • Monitors and controls unwanted data in attribute tables with the help of scheduled and on-the-fly post-optimization options
  • A nice bonus of a website's subtle performance increase
  • Maintain EAV tables and conduct clean-ups
  • Choose between a one-time manual or automatic clean-up solution

 

Demo

Store Demo / Admin Demo

Technical Specifications

Back to top

Seller profile

SafeMage

Seller contact

E-mail

Current Version

2.0.6

Adobe Commerce platform compatibility

Magento Open Source: 2.4 (current), 2.2 (obsolete), 2.3 (obsolete)

Type

Stable Build

Updated

28 July, 2023

Categories

Extensions, Site Optimization, Site Monitoring, Performance

Quality Report

Back to top

Installation & Varnish Tests

Passed

Coding Standard

Passed

Plagiarism Check

Passed

Malware Check

Passed

Marketing Review

Passed

Manual Testing

Passed

All tests were conducted on the latest versions of Adobe Commerce that existed for the compatible release lines at the moment of the extension submission. Latest versions of all other software were used, as applicable.

Release Notes

Back to top

2.0.6:

  • Compatible with Magento Open Source : 2.2 2.3 2.4
  • Stability: Stable Build
  • Description:

    • Minor code refactoring.

2.0.5:

  • Compatible with Magento Open Source : 2.2 2.3 2.4
  • Stability: Stable Build
  • Description:

    • Support for Magento 2.4.4 and PHP 8.1.

2.0.4:

  • Compatible with Magento Open Source : 2.2 2.3 2.4
  • Stability: Stable Build
  • Description:

    • Minor code refactoring.

2.0.3:

  • Compatible with Magento Open Source : 2.2 2.3 2.4
  • Stability: Stable Build
  • Description:

    • Added support for 2.4.0.

2.0.1:

  • Compatible with Magento Open Source : 2.2 2.3
  • Stability: Stable Build
  • Description:

    • Improved logging.

Support

Back to top

The best place to start if you need help with a specific extension is to contact the developer. All Adobe Commerce developers have both a contact email and a support email listed.

Contact Vendor

Q & A

Back to top

Reviews

Back to top