Hi All,
The error in the past was due to not selecting "Update data when duplicate keys found on import" and I gave up too soon. Now I can import CSV back but from the admin dashboard, products won't show up. But I can see they're listed in the db tables. I'll look more into this. Thank you all for your help.