Daniele Rutigliano - Case history: SEO, 404 e URL Key su Magento

50 %
50 %
Information about Daniele Rutigliano - Case history: SEO, 404 e URL Key su Magento

Published on March 11, 2016

Author: MeetMagentoIt

Source: slideshare.net

1. SPEAKER 2 / 25 Daniele Rutigliano  CEO of the digital agency Aproweb.  Author of the best seller “E-commerce vincente” published by Hoepli.  Speaker at Smau, Be-Wizard! 2015, WebUpdate.  Professor at LUM University.

2. ISSUE 3 / 25 Wrong URLs (with the URL rewrites)  /catalog/category/view/id/652 (it is not being rewritten!)  /brand-1/old-url-key.html (it is different from the real url key!)  /brand-1/new/product.html (the category “New” no longer exists)  Ect...

3. ISSUE 4 / 25 Catalog URL Rewrites required/blocked for 3 years

4. ISSUE 5 / 25 The error Catalog URL Rewrites index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '38494500_1423597414-0-1' for key 'UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID'' in /var/www/vhosts/domain.com/httpdocs/lib/Zend/Db/Statement/Pdo.php: 228 (The motive of this issue was a wrong import from old websites)

5. FIXED THE ISSUE OF THE URL REWRITES 6 / 25 Select and remove duplicate values SELECT DISTINCT ('sku') as 'sku', COUNT('sku') as 'skuCount', 'entity_id' FROM 'catalog_product_entity' GROUP BY 'sku' HAVING 'skuCount' > 1; Source: www.albertomariarossi.it/howto-solve-url-rewrite-indexing-errors-in-magento/

6. FIXED THE ISSUE OF THE URL REWRITES 7 / 25 Select and remove duplicate values SELECT url_key, COUNT(url_key) AS NumOccurrences FROM catalog_product_flat_1 GROUP BY url_key HAVING (COUNT(url_key) > 1); Source: www.albertomariarossi.it/howto-solve-url-rewrite-indexing-errors-in-magento/

7. FIXED THE ISSUE OF THE URL REWRITES 8 / 25 Select and remove duplicate values SELECT name, COUNT(name) AS NumOccurrences FROM catalog_product_flat_1 GROUP BY name HAVING ( COUNT(name) > 1 ); Source: www.albertomariarossi.it/howto-solve-url-rewrite-indexing-errors-in-magento/

8. FIXED THE ISSUE OF THE URL REWRITES 9 / 25 Backup and truncate the table: “core_url_rewrite” +

9. FIXED THE ISSUE OF THE URL REWRITES 10 / 25 The result

10. THE NEW ISSUE 11 / 25 ... meantime in Google Search Console 404 pages

11. THE NEW ISSUE 12 / 25 How to fix 237.627 “404 pages”??

12. THE WAYS 13 / 25 First way: manually in the Magento backend?

13. THE WAYS 14 / 25 First way: manually in the Magento backend?

14. THE WAYS 15 / 25 Second way: in the .htaccess file? redirect 301 /old-name /new-name redirect 301 /old-name2 /new-name2 redirect 301 /old-name3 /new-name3 redirect 301 /old-name4 /new-name4 redirect 301 /old-name5 /new-name5 … X 237.627 times!

15. THE WAYS 16 / 25 Second way: in the .htaccess file? redirect 301 /old-name /new-name redirect 301 /old-name2 /new-name2 redirect 301 /old-name3 /new-name3 redirect 301 /old-name4 /new-name4 redirect 301 /old-name5 /new-name5 … X 237.627 times!

16. THE WAYS 17 / 25 Third way: building redirect 301 dynamically! FROM THE BACKUP TO THE NEW DATABASE

17. THE WAYS 18 / 25 Create a database with 2 “core_url_rewrite” tables TEST DATABASE  Old “core_url_rewrite” → Rename to “old”  New “core_url_rewrite” → Rename to “new”

18. THE WAYS 19 / 25 Found the duplicate path UPDATE old, new SET old.description=2 WHERE old.request_path = new.request_path 2 is my flag

19. THE WAYS 20 / 25 Delete the duplicate path DELETE FROM old WHERE description =2

20. THE WAYS 21 / 25 Update and join the same products UPDATE old, new SET old.options='RP', old.target_path=new.request_path, old.category_id=NULL, old.product_id=NULL, old.is_system=0, old.id_path = CONCAT(old.id_path,'-APR'), old.description=1 WHERE old.product_id = new. product_id AND old.store_id=new.store_id Redirect 301 It is my check 1 is my flag

21. THE WAYS 22 / 25 A little cleaning DELETE FROM old WHERE description is NULL; DELETE FROM old WHERE target_path=request_path; UPDATE old SET description = NULL; ALTER TABLE old DROP COLUMN url_rewrite_id; RENAME TABLE old TO core_url_rewrite; (before it was 1)

22. THE WAYS 23 / 25 Import FROM THE TEST DB TO THE NEW DATABASE Import the core_url_rewrite table

23. THE WAYS 24 / 25 The end

24. THE WAYS 25 / 25 </THANKS>

Add a comment

Related pages

Meet Magento Italy Daniele Rutigliano - Meet Magento Italy

Daniele Rutigliano. ... Case history: SEO, 404 e URL Key su Magento. Meet Magento World. Meet Magento. Meet Magento DE. Meet Magento ES. Meet Magento PL ...
Read more

Meet Magento Italy Programma 2016 - Meet Magento Italy

Case history: SEO, 404 e URL Key su Magento. Daniele Rutigliano - Aproweb ...
Read more

Meet Magento Italy

Daniele Rutigliano al ‪#‎ mm16it‬ attraverso una case history illustrerà come risolvere in ‪#‎ Magento‬ i tipici problemi SEO legati agli url ...
Read more

Home - Magento Forums

Welcome to the Magento Forums! These forums are here to provide you with access to a network of dedicated Magento enthusiasts sharing tips, tricks and support.
Read more

The Art & Science of Website Optimization • Yoast

Yoast helps you with your website optimization, whether it be through software, courses, ebooks or site specific website reviews: ... Yoast SEO plugin.
Read more

Moz: SEO Software, Tools and Resources for Better Marketing

... Moz builds tools that make inbound marketing easy. ... Learn SEO Broaden your SEO with marketing resources for all skill levels: best practices, ...
Read more

Using the URL Rewrite Module : The Official Microsoft IIS Site

The Microsoft URL Rewrite Module 2.0 for IIS 7 and above enables IIS ... In those cases, ... rewrite map using the input URL as a key, ...
Read more

Google

Web History × Australia : Advanced ... Advanced search Language tools: Advertising Programmes Business Solutions +Google About Google Google.com © 2016 ...
Read more