I have added some products to my store manually and the urls are working great as below
I then exported the store and added the rest of my products to the CSV file following the format of the exported products.
For some reason, despite the contents of the CSV file products being exactly the same for all products, maunailly added or imported, the URL for the imported products are like this
There is no difference that I can see when exporting all products between the correct url and the wrong one ?
any suggestions anyone? I really want ot sort this out before point google at it!!