Product has an attribute called url_path.
- What is the purpose of this attribute ?
- When does it get populated with values ?
- When are this values used ?
Product attribute url_path will be a concatenation of url_key and the Product URL Suffix defined under System > Configuration > Catalog > Search Engine Optimization.
If the same url_key already exists, it will also ensure that you don't have duplicate url_path by suffixing your url_key with an hyphen and the product's entity_id.