Hello Support,
In there any issue on migration tool. after migration we are getting the product urls as .html.html
If you are aware of this issue. please let me know what changes need to make an store.
12 answers
Hi austinsullivan,
In there any issue on migration tool. after migration we are getting the product urls as .html.html
That is not issue of our tool. That is a issue of the Magento2 with your data migrated from Magento1.
You can see more about this at:
https://github.com/magento/magento2/issues/3726
http://magento.stackexchange.com/questions/135736/magento-2-1-product-urls-end-with-html-html-why
To solve that, you can do steps as bellow:
Step 1: Backup current your Magento2 database.
Step 2: Run bellow sql in your Magento2 database:
UPDATE url_rewrite SET request_path = REPLACE(request_path, ‘.html.html’, ‘.html’);
UPDATE url_rewrite SET request_path = REPLACE(request_path, ‘-html.html’, ‘.html’);
Step 3: Clear all cache of magento and your browser and access it
And tell me know how it goes.
Regards,
Mall.
works perfect
Hi aq4business,
Yes, let’s contact me if you need further assistance.
Regards,
Mall.
Hi Mall,
tody i have again the wron url structur like .html.html =(
Last week all was fine -- No changed on database or configuration….
Any solution???
Hi aq4business,
That is a strange issue. Let’s provide me the phpmyadmin credentials of your database.
I will check further and help you out.
Regards,
Mall.
@Mall: you have a pm
Hi there,
So, kindly follow steps as bellow:
Step 1: Run bellow sql in your database:
UPDATE catalog_category_entity_varchar SET value = REPLACE(value, '.html/', '/') WHERE attribute_id = 118;
UPDATE catalog_category_entity_varchar SET value = REPLACE(value, '.html', '') WHERE attribute_id = 118;
DELETE FROM url_rewrite WHERE entity_type = 'category' OR entity_type = 'product';
DELETE FROM catalog_url_rewrite_product_category;
Step 2: Once done, let’s open and re-save for each Category migrated in back-end of your site. Magento will re-generate related catgory and product urls.
And clean the Magento2 cache.
And tell me know how it goes.
Regards,
Mall.
Hi there,
I see it happens with your product’s urls: http://i.prntscr.com/a7985c87965d4c4db5de4e3c9da80500.png
So, to solve that you could do steps as bellow:
Step 1: Run bellow sql in your database:
UPDATE catalog_category_entity_varchar SET value = REPLACE(value, '.html/', '/') WHERE attribute_id = 118;
UPDATE catalog_category_entity_varchar SET value = REPLACE(value, '.html', '') WHERE attribute_id = 118;
UPDATE catalog_product_entity_varchar SET value = REPLACE(value, '.html', '') WHERE attribute_id = 120;
DELETE FROM url_rewrite WHERE entity_type = 'category' OR entity_type = 'product';
DELETE FROM catalog_url_rewrite_product_category;
Step 2: Once done, let’s open and re-save for each Category migrated in back-end of your site. Magento will re-generate related catgory and product urls.
And clean the Magento2 cache.
And tell me know how it goes.
Regards,
Mall.