Revisions to Magento 2: How to truncate customers, products, reviews and orders table

edited body

Source Link

edited Mar 26, 2018 at 14:05

11
3

After truncating the category tables you might get duplicate entry errors for URL keys so you need to clear category URL keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`'category'

After truncating the category tables you might get duplicate entry errors for URL keys so you need to clear category URL keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`

After truncating the category tables you might get duplicate entry errors for URL keys so you need to clear category URL keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = 'category'

code indent

Source Link

edited Mar 26, 2018 at 13:31

Rama Chandran M

3.2k
13
23
38

After truncating the category tables you might get duplicate entry errors for urlURL keys so you need to clear category urlURL keys from url_rewriteurl_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`

After truncating the category tables you might get duplicate entry errors for url keys so you need to clear category url keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`

After truncating the category tables you might get duplicate entry errors for URL keys so you need to clear category URL keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`

Source Link

created Mar 26, 2018 at 13:29

Farhan Saeed

11
3

After truncating the category tables you might get duplicate entry errors for url keys so you need to clear category url keys from url_rewrite table.

DELETE FROM `url_rewrite` WHERE `entity_type` = `category`

Stack Exchange Network

Return to Answer