Problems to Massive import products

I have a problem when I'm importing products to my store.

When I import products everything seems look ok but when I try to click in a product image in the public store this don't let me go to the details page, it doesn't do anything. I need go to editing page in the dashbord and only save the product. After that, I can click to the product image and this redirect to details page but I can't do that for 15,000 products.

I had tried update products in database with these changes (when I save the product in the dashbord this changes some values like ProductTemplateId, DownloadActivationTypeId, BasepriceUnitId and BasepriceBaseUnitId) but it doesn't work if I try to change it with a SQL query.

That's because no URL Record is added. You need to make sure each product has URL record.

Alternatively, you can use tools like NopAdmin that helps in importing products and categories (advanced fields such as attributes supported).