Error 404 on product page after importing CSV

[thn_]

Hello!

After importing 2k+ products some of them are showing error 404 when trying to enter product page in store. I was trying to figure out pattern on which products are causing error, but I can't, I thought maybe it's because of some characters in title like "(inches) or +, but after fixing title same thing happens. I've tried to change friendly url, it's not working, I've tried to copy product with already changed title and url, but even copy is causing 404. The only way for now to fix this is turn off friendly URL, but to be honest this is not a good fix.

Does any of you know the way to fix this?

 

PS 1.7.8.5

Edited July 18, 2022 by thn_ (see edit history)

[thn_]

i've found the way to somehow fix it temporarly - I have to add i.e. "-1" at the end of URL in every product, adding this traffic section of preferences does nothing. Ok, sure, I can add this to every product, but it's not the correct way to deal with this problem, I want to keep old URLs from old shop and not remember to add something to URL

I can see the pattern now- when URL is ended with letter it's not working, if it ends with number (when it is generated by presta or added by me) it works fine. What can be wrong?

Edited July 19, 2022 by thn_ (see edit history)