I have a strange issue with Magento 2.2.5 where two of my product attributes have its values showing in the Catalog Table, but when you click into the product itself to edit, the field for that attribute is empty.
I've tried a full reindex, and cleared the Magento cache as well, but none of that helps.
I've compared the two attribute configurations on a database level using:
SELECT * FROM `mydb`.`eav_attribute` WHERE `backend_type` = "varchar"
But the configurations are exactly the same as other attributes where it doesn't have such an issue.
I have also compared the actual value in database with other attributes that don't have this issue:
SELECT * FROM `catalog_product_entity_varchar`
Again, exactly the same.
Interesting note, when I duplicate the product, the two attributes are the only fields that do not get cloned over to the duplicate product. This means that the duplicate product has these two fields set to the field's default values, and even these default values don't appear in the Edit Product form! I have no idea what else I can try to fix this.