experius/module-reindexcatalogurlrewrites

DEPRECATED

This module has been deprecated., _(*1)

Please use the following recommended alternative:, _(*2)

https://github.com/elgentos/regenerate-catalog-urls, _(*3)

It is possible that the module has created invalid category url rewrites because the rewrites are created for all the stores and not for the stores which are related to the category. The recommended alternative uses the stores related to the categories., _(*4)

To see if you have invalid url rewrites run the following select query:, _(*5)

SELECT DISTINCT u.url_rewrite_id from store as s 
INNER JOIN store_group as sg
  ON s.group_id = sg.group_id 
INNER JOIN catalog_category_entity as c
  ON sg.root_category_id = SUBSTRING_INDEX(SUBSTRING_INDEX(c.path, '/', 2), '/', -1)
LEFT JOIN url_rewrite as u
  ON c.entity_id = u.entity_id AND s.store_id != u.store_id
WHERE entity_type = 'category';

This query will return url rewrite ids which you can then remove from the url_rewrite table., _(*6)

Warnings, _(*7)

• BETA
• Don't ever use without testing on dev or staging enviroment first.

Usage, _(*8)

All Categories, All Products, All Storeviews php bin/magento experius_reindexcatalogurlrewrites:categoryurls, _(*9)

Specific Products, Specific Store Ids, _(*10)

php bin/magento experius_reindexcatalogurlrewrites:producturls --product_ids=36,37 --store_ids=1, _(*11)

All Products, All Storeviews, _(*12)

php bin/magento experius_reindexcatalogurlrewrites:producturls, _(*13)

All Products, Selected Storeviews, _(*14)

php bin/magento experius_reindexcatalogurlrewrites:producturls --store_ids=1, _(*15)

All Storeviews, Selected Products, _(*16)

php bin/magento experius_reindexcatalogurlrewrites:producturls --product_ids=36,37, _(*17)

Credits, _(*18)

https://github.com/Iazel/magento2-regenurl/, _(*19)

@PascalBrouwers categories url pull request, _(*20)