I can only update products when I manually go into the product page, change something and then save it. It won't update through magmi or bulk import or sql query.
I accidently changed the product name to the image url. I have changed it back through an upload and on the front-end it shows the product name but on the admin page it still shows the product url as the 'name' so it's hard to search for items.
The actual database shows 'name' (attribute_id = 71) as the correct name. So where is the back-end taking the data from?
If I manually go into a product and add 'test' to the end of 'name' and click save, the back-end (admin) will update, but I can't do this manually for every product.
Something seems to be happening when you click save that you cannot do via an upload?
And I have re-indexed all of it many times, through SSH aswell. Cleared cache, deleted var/cache folder.