Comment 3 for bug 946144

Hi,

I understand what you are saying. I found some domains in product.py but none that were statically assigned which you described. The issue, is that once these attributes are unlinked, even importing the attributes over again does not fix the problem. Once it is unlinked it is in this 'corrupted' state. The attribute which you are talking about is actually on product_product not product_template. In older versions of the connector it uses x_magerp_visibility but the newest I believe is a serialized value under magerp_variant, even without product_variant installed. I get confused because this is changing quite a bit.

I see in the database that there is a constraint against table magerp.product.attributes.options Just as you have said in the M2O. The major issue is that, as I stated, once these are unlinked it cant be fixed. I tried fixing this in the database but it does not make the fields searchable. What I can do, is go to the database and manually assign the attribute. In Open Magento Fields it will show the value I selected, but the export will not recognize the value.

 It is a serious issue for me for so many customers. This corruption can easily happen. The way I described is to show you how to easily reproduce the issue, but it is not the only way the corruption occurs. I am unsure of all of the ways but I assure you it happens and it makes export completely unusable. What happens in this state, it will actually export the product successfully to the website, but the field visibility is required by the magento ORM so the product will not show on the admin panel, but will exist in the database. The only way to fix it is to go into the magento database and set this field under catalog_product_entity_int. The issue with updating products, is that it runs from ERP successfully with no error but will not change anything about the product on the website. This problem effectively ruins product management.

When a resource gets unlinked or deleted, I should have the ability to re-import attributes and have it repaired. This is not the case, once the damage is done, its done. Please try the steps that I have outlined, its very easy to see the issue. Once you see the problem, you will understand my frustration.