2017 © Pedro Peláez
 

library module-reindexcatalogurlrewrites

image

experius/module-reindexcatalogurlrewrites

  • Tuesday, March 20, 2018
  • by experius
  • Repository
  • 5 Watchers
  • 8 Stars
  • 423 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 2 Forks
  • 5 Open issues
  • 13 Versions
  • 79 % Grown

The README.md

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)

The Versions

20/03 2018

dev-master

9999999-dev

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

20/03 2018

1.2.3

1.2.3.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

24/01 2018

1.2.2

1.2.2.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

24/01 2018

dev-output_and_syntax

dev-output_and_syntax

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

06/11 2017

1.2.1

1.2.1.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

21/08 2017

1.2.0

1.2.0.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

21/08 2017

dev-develop

dev-develop

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

14/08 2017

1.1.4

1.1.4.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

06/07 2017

1.1.3

1.1.3.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

29/06 2017

1.1.2

1.1.2.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

07/06 2017

1.1.1

1.1.1.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

26/05 2017

1.1.0

1.1.0.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen

22/05 2017

1.0.1

1.0.1.0

  Sources   Download

proprietary

by Derrick Heesbeen
by Mage2Gen