Firstly Apologies from a new User if I am posting into the wrong group.
Not having experience of how HTML works... If we used the <Variant SKU > to populate the <Handle>, instead of an abreviated product description, would that limit our products ability to be "found " easily in a search ?
The question arose, as we are working on creating a data link to our existing accounting software Microsoft Navison ( old verson) which uses a conventional SQL Database.
Solved! Go to the solution
This is an accepted solution.
A contextualized product URL is always better than using random alphanumeric strings. It helps keep a cleaner URL structure and is considered good SEO practice by Google. That being said, the engine itself has become much better at recognising semantic patterns, so it can get information about your product through its title, its description, etc., but still a correctly created URL is always a winner (think also of URL sharing in social media, etc).
Also, one issue that could arise is the fact that products can have multiple options (eg. size, color, etc), each combination of which has its own SKU. Therefore, in this case, you wouldn't be able to match an SKU to a single URL, unless you added all your variants as individual products.