Why do my URLs have a number at the end?

If you are seeing urls like mystore.zoeysite.com/chiffon-dress-12345 and you know the name of the product is "Chiffon Dress" or the URL Key is chiffon-dress, this is due to duplicate URL Keys. Another tell-tale sign of this issue is when your store has a large number of redirects.

Two items, be they pages, products or categories, even if they are not visible or currently enabled, should never have the same URL key. If they do, the system will create a rewrite for one to be url-key-1. If the duplicate key is not updated to be unique, this can lead to further rewrites to correct the issue such as url-key-2, url-key-100, and so on.

We recommend keeping to the following guidelines:

• Always use a unique URL Key for every single SKU, page, or category regardless of if it is visible or not
• If while creating the product / SKU you are not entering a url-key, you must use a unique name. In other words, never repeat the name even if it refers to the same kind of product. For example, if you have a product "PAIR OF SHOES" in 6 different sizes and five different colors, you should not name every sub-product "PAIR OF SHOES". Instead name it "PAIR OF SHOES Black 6", "PAIR OF SHOES Black 7", "PAIR OF SHOES Green 8", etc.
  

  Creating a Configurable product's associated products from your control panel should not cause an issue as long as Auto-generate Name has been selected

You can fix this manually from the control panel. You must uncheck Create Permanent Redirect for old URL found under the URL key. Failing to do so will result in the same issue just with a different name.

This can also be fixed with a CSV update. When you export your products, go ahead and remove all but sku, url_key and url_path. Any item that has a duplicate URL Key or has a trailing number in the url path (the -1 or -2 and so on) needs to be updated. Importing the SKU and corrected URL Keys will correct this issue going forward.