README

This module has been deprecated.

Please use the following recommended alternative:

https://github.com/elgentos/regenerate-catalog-urls

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.

To see if you have invalid url rewrites run the following select query:

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.

Warnings

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

Usage

All Categories, All Products, All Storeviews php bin/magento experius_reindexcatalogurlrewrites:categoryurls

Specific Products, Specific Store Ids

php bin/magento experius_reindexcatalogurlrewrites:producturls --product_ids=36,37 --store_ids=1

All Products, All Storeviews

php bin/magento experius_reindexcatalogurlrewrites:producturls

All Products, Selected Storeviews

php bin/magento experius_reindexcatalogurlrewrites:producturls --store_ids=1

All Storeviews, Selected Products

php bin/magento experius_reindexcatalogurlrewrites:producturls --product_ids=36,37

Credits

https://github.com/Iazel/magento2-regenurl/

@PascalBrouwers categories url pull request

experius / module-reindexcatalogurlrewrites

Maintainers

Details

README