How to reindex the URL rewrites?

shuai_zend · March 19, 2016, 1:25pm

in M2 reindexer have’t URL rewrite.
but i TRUNCATE tables catalog_url_rewrite_product_category and URL_rewrite
so all page 404 error.
how to rebuilding? like M1 shell/indexer.php --reindex.

dmitrii_fediuk · March 19, 2016, 1:27pm

How to reindex Magento 2 data from the command line?

shuai_zend · March 19, 2016, 1:29pm

M2 can’t rebuilding URL index.
i used this cil…but tables is null

dmitrii_fediuk · March 19, 2016, 1:40pm

Magento 2 updates the catalog_url_rewrite_product_category table automatically on a product and category saving:

github.com

magento/magento2/blob/255ceb/app/code/Magento/CatalogUrlRewrite/etc/events.xml#L8-L35


<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">
<event name="catalog_category_prepare_save">
    <observer name="category_save_rewrites_history_setter" instance="Magento\CatalogUrlRewrite\Observer\CategorySaveRewritesHistorySetterObserver"/>
</event>
<event name="catalog_category_save_after">
    <observer name="process_url_rewrite_saving" instance="Magento\CatalogUrlRewrite\Observer\CategoryProcessUrlRewriteSavingObserver"/>
</event>
<event name="catalog_product_import_bunch_save_after">
    <observer name="catalog_product_import_rewrites_generation" instance="Magento\CatalogUrlRewrite\Observer\AfterImportDataObserver"/>
</event>
<event name="catalog_product_import_bunch_delete_after">
    <observer name="catalog_product_import_rewrites_delete" instance="Magento\CatalogUrlRewrite\Observer\ClearProductUrlsObserver"/>
</event>
<event name="catalog_product_delete_before">
    <observer name="process_url_rewrite_removing" instance="Magento\CatalogUrlRewrite\Observer\ProductProcessUrlRewriteRemovingObserver"/>
</event>
<event name="catalog_product_save_before">
    <observer name="product_url_key_autogeneration" instance="Magento\CatalogUrlRewrite\Observer\ProductUrlKeyAutogeneratorObserver"/>
</event>
<event name="catalog_product_save_after">
    <observer name="process_url_rewrite_saving" instance="Magento\CatalogUrlRewrite\Observer\ProductProcessUrlRewriteSavingObserver"/>
</event>
<event name="catalog_category_save_before">
    <observer name="category_url_path_autogeneration" instance="Magento\CatalogUrlRewrite\Observer\CategoryUrlPathAutogeneratorObserver"/>
</event>
<event name="catalog_category_move_after">
    <observer name="process_url_rewrite_moving" instance="Magento\CatalogUrlRewrite\Observer\CategoryProcessUrlRewriteMovingObserver"/>
</event>

You should restore the catalog_url_rewrite_product_category table from a backup, and never truncate it again.

shuai_zend · March 19, 2016, 1:56pm

thank you guy.
but i’m have’t backup.
any idea can reindex url_rewrite and tables catalog_url_rewrite_product_category ?

dmitrii_fediuk · March 19, 2016, 1:57pm

Resave each product.
For example, try to do a group product updating using the backend product list tools for it.

shuai_zend · March 19, 2016, 2:00pm

OMG.
i have 6K SKU…
too much…
have easy idea?

dmitrii_fediuk · March 19, 2016, 2:20pm

Besides the batch product updating by on backend product list screen, you can also try to execute a simple standard export and then re-import: for example, re-import only sku and url_key attributes, and Magento should reindex the rewrites.

shuai_zend · April 1, 2016, 4:32pm

so,i have easy idea.
is resave category…