To echo Moz, URLs should be simple and contain relevant keywords rather than ID numbers and codes. This is not only important to ecommmerce SEO but very important to digital marketing as a whole.
Many ecommerce sites use parameters in URLs to generate dynamic content, but this can also cause duplicate content, which you should avoid if possible.
A URL using descriptive keywords is not only easier for the user to read and remember; this also improves relevance for search engines and can help to increase your rankings.
Organizing your products into clear categories that are not too deeply nested will also help your URLs to be short and contain relevant keywords.