We have more than 4000 products on website with just a SKU in url like "www.mywebsite.com/RSK-XXXX
So as you know this is not good for SEO, because our SKU does not mean anything to customer so my question is is there any application I can change URL for all products in the same time? For example match url with title. Example:
Any suggestion on how to improve SEO?
So a best practice when forming your URLs is to structure them so their categorized using folders. A good method is www.website.com/category/product/
The benefits of this are that it:
Hopefully that's helpful. I wrote a full guide to Shopify SEO if you want to read more general SEO information: https://moz.com/blog/shopify-seo
Just a suggestion - the shorter URLs are better for the SEO, so instead of the URL as in example: www.mywebsite.com/products/2019-2020-nissan-altima-versa-5-button-smart-key-kr5txn4-bundle-of-3
I recommend using URL like: www.mywebsite.com/products/nissan-altima-button-smart-key
the fewer characters, numbers and words, the better. Google can read it much easier, and it will be easier for the search engines to understand this kind of URL and rank it in the most relevant search results
I have had good success with Google Sheets and using Vlookup functionality. For this to work, you need some consistency between the old URL and the new URL. Ideally, each would be unique as well. You can match up a new and old URL this way in bulk. Otherwise, if the URL has no detectable similarity, you need a human to think and match. Software like cart 2 cart can manage redirects from your old platform to new.
I am adding to @JonWright's excellent comments. When creating URLs optimize the product id by avoiding stop word like "and", "the" and such. You also want to avoid duplicate words.
Hope this was helpful.