search

baldwin-agency / magento2-module-url-data-integrity-checker

Magento 2 module which can find potential url related problems in your catalog data
MIT License
261 stars 28 forks source link

Detect missing url_path's of categories on a certain storeview #9

Open hostep opened 4 years ago

hostep commented 4 years ago

Just ran into an issue on a shop where the url_key for the category exists on a certain storeview, but the url_path is missing:

mysql> SELECT * FROM catalog_category_entity_varchar WHERE entity_id = 6677 ORDER BY attribute_id;
+----------+--------------+----------+-----------+------------------------------+
| value_id | attribute_id | store_id | entity_id | value                        |
+----------+--------------+----------+-----------+------------------------------+
|    33040 |           45 |        0 |      6677 | Pillendoosjes                |
|    37132 |           45 |        1 |      6677 | Pillendoosjes                |
|    35086 |           45 |        2 |      6677 | Piluliers                    |
|    32017 |           52 |        0 |      6677 | PRODUCTS                     |
|    34063 |          117 |        0 |      6677 | pillendoosjes                |
|    38155 |          117 |        1 |      6677 | pillendoosjes                |
|    36109 |          117 |        2 |      6677 | piluliers                    |
|    43785 |          118 |        0 |      6677 | thuiszorg-ehbo/pillendoosjes |
|    39594 |          118 |        1 |      6677 | thuiszorg-ehbo/pillendoosjes |
+----------+--------------+----------+-----------+------------------------------+
9 rows in set (0.00 sec)

(attribute id 117 is url_key and 118 is url_path, the url_path is missing on storeview with id 2)

We should try to detect and report this.