7.7. Store Diagnostics

fmDiagnostic

This tool will help you keep your database in order and make it work faster.

To access the Diagnostics tool, navigate to the Store Manager sidebar > Tools > Store Diagnostics.

Select the checks you want to run and press [Run Diagnostics] on the toolbar.

Note: it may take a while for the checks to complete. After the process has finished, you'll see a number of detected errors for each of the selected types of diagnostic checks:

To view the details , click a diagnostics type on the left or choose one from the Diagnostics Type drop-down list on the toolbar:

Use the following tools to work with the results of the diagnostics:

Go to Product – switches you to the product record in the Category Product Grid.

View in Browser - opens selected item(s) in your browser.

Export to Excel - saves the grid to an Excel file.

It is possible to show/hide columns from the grid. Click the icon at the top left corner of the grid and select the fields to show:

Clear results - clears the grid.

Filter - creates a custom filter with the current diagnostics parameters.

The filter can be accessed from the drop-down list in the corresponding section:

Below you will find explanations for all diagnostic checks and ways to fix the detected errors.

Images

Missing product images

Shows products that have an image record in the database but the image doesn't exist on the server.

Recommended action: delete records of non-existent images.

Fix problem with recommended action - upon clicking this button, records of non-existent images for all selected products will be deleted.

Tip: you can export results into a file for the supplier.

Images that are not linked to any product

Shows a list of images that are not related to any product in the database.

Recommended action: erase unused images from the server to save space and keep the server in order.

Fix problem with recommended action - upon clicking this button, selected unused images will be deleted from FTP.

Product without any image

Displays products that don't have an image from the media gallery assigned.

Recommended action: add images to the products.

Fix problem with recommended action - clicking the button opens the selected product's form where you can add an image in the Image tab:

Duplicate pictures in the product media gallery (available in Enterprise Edition)

Identical image records appear when one image was added to more than one product. The diagnostic check shows products with identical image records.

Recommended action: delete duplicate records from the database.

Fix problem with recommended action - pressing the button launches automated removal of the duplicate image records keeping the record for the product with the biggest ID.

Note: the image itself will be kept on FTP, only duplicate image records will be removed for all products except for one with the biggest ID.

Product EAV

Products not assigned to any category

Displays products that are not linked to any of the available categories.

Recommended action: assign the products to category(s).

Fix problem with recommended action - pressing the button opens the Assign Categories window. There you can assign categories to the selected products by selecting corresponding checkboxes.

Invisible products/URL is not correct (available in Enterprise Edition)

Shows a list of product page URLs that don't respond or return a 404 error.

Recommended action: run product reindex. The reindex command allows updating product data and rewriting the URL.

Fix problem with recommended action - pressing the button launches the reindex for the selected products in the Magento admin panel.

Data integrity

Some issues with database tables may occur due to the incorrectly imported data, as a result of manual changes in the store database, or through the incorrect work of some extension. The checks offered by the Store Diagnostics tool will help you to verify table data to avoid database crashes or data loss.


Products with missing required attributes

Finds the products that do have not the required attribute specified. This may happen when product data was imported from external sources that lacked the required details.

Recommended action: specify the missing values in the fields marked with an asterisk.

Fix problem with recommended action - pressing the button opens the selected product's form where you can add missing attributes.

Duplicate values in the ‘dropdown’ attribute

Searches for the identical option labels among the attributes with the input type [Dropdown].

Recommended action: clear the duplicates among the entire attribute list with the [Dropdown] type.

Fix problem with recommended action - pressing the button opens the Edit Attribute Data form where you can rename or delete the duplicate attribute options:

Duplicates in the ‘multiple select’ attribute

Searches for identical values in the Multiple select product attributes.


Recommended action: clear the duplicates among the entire attribute list with the [Dropdown] type.

Fix problem with recommended action - pressing the button opens the Edit Attribute Data form where you can rename or delete the duplicate attribute options.

Data storage mismatch

This diagnostic check shows a list of attributes that have values stored in the incorrect table and shows the products with the mismatch of stored attribute data to its "backend_type".

Missing Admin ‘Store View' value

Shows product attributes that are missing the 'Admin Store View' value for the attribute's label.


Recommended action: fill in the missing label 'Admin Store View' value.

Fix problem with recommended action - pressing the button opens a form with details of the selected product. Select the attribute that has to be filled in and press Edit Attribute.

SEO Diagnostics (Enterprise Edition)

This group of diagnostic checks detects errors that may prevent correct indexing of your store or negatively impact ranking on search engine results pages (SERPs).

Read the complete documentation on the SEO diagnostic tools.

To get more details on diagnosing the store database, consider the following articles:

Store Diagnostics - Troubleshoot Magento Website Problems

Store Diagnostics - Keep Your Magento Images Under Control