1

i create a product with Customizable Options but sometimes at frontend, the place which custom options should have appeared is now nothing enter image description here

I'm not sure why it happen, but when i resaving the product seems to solve that. Any idea what's the cause? How to prevent that? How to fix that for all products without resaving them all?

1

I also faced the issue.

After doing some investigation I found that has_options column has 0 but product have at least one option associated in the product options table.

I didn't find a scenario to reproduce but it seems the product options were imported by any third party extension or migrated from an older version of Magento.

Re-saving product resolves the issue because there is a check at before product save that updates has_options value to 1.

So, I prepared below query to find all such products and managed to save all the resulted products.

SELECT * FROM `catalog_product_entity` WHERE entity_id in (SELECT product_id FROM `catalog_product_option`) and has_options = 0 

I hope this may help someone facing the same issue.

  • +1 for the to the point answer. – Sumit Dec 5 '19 at 9:13
1

After create or update product attribute programmatically (like tier price , etc..) by mistake product has_option set with false value.

check in "catalog_product_entity" table.

select entity_id, has_options, sku from `catalog_product_entity` where  sku = {sky of yourproduct}

So update it if has_options value is zero or null.

UPDATE `catalog_product_entity` set has_options =1 where  sku = {sky of yourproduct} 

As describe @Gulshan. find out and update product which has_options column value are false.

SELECT * FROM `catalog_product_entity` WHERE entity_id in (SELECT product_id FROM `catalog_product_option`) and has_options = 0;

And update it with update query. Before update keep backup for table "catalog_product_entity" table.

UPDATE `catalog_product_entity` set has_options =1 where entity_id in (SELECT product_id FROM `catalog_product_option`) and has_options = 0 ;

Refresh cache and check product detail page.

  • +1 for the to the point answer. Great work. – Sumit Dec 5 '19 at 7:10
  • 1
    Thanks sumit, I have got same issue after migrate my site. – Monarch Dec 11 '19 at 10:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.