i am having a hard time getting the product urls for google data feed.

i use the 'v_products_url_1' column to assign URL for upload/import.
the uri mapping evidently does not use the url i assign. e.g., 6.5" is converted to '6.5-' instead of '6.5in-' i assigned in the upload file. (not to mention for each and every product to have uri mapping, i have to go to catalog/product and preview/save?)

when i export and download, i get exactly what i uploaded, which are not the working urls.
so how do i get the product urls?