wrong product url suffix with .html.html

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.

Hi aq4business,
Yes, let’s contact me if you need further assistance.
Regards,
Mall.

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.

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.