I was able to import products without issue and they would show up fine on the front end. I was in single user mode. I have one store. I have the column product_websites set to base. Nothing has changed in the import sheet I use but now anything I import will not show up on the front end unless I resaved it on the backend.
I ran a reindex manually and the product prices index did return this error
(there were more special characters repeated but I left them out):
Product Price index has been rebuilt successfully in 00:00:01 SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '1622-138-1-55' for key 'PRIMARY', query was: INSERT INTO
value) VALUES (?, ?, ?, ?), (?, ?, ?, ?),
If anyone has any ideas, I'd be very grateful. Thank you!