Some Configurable products not showing options on product page

Question

I've manually added 20 configurable products to my store. All products use the same option for configuration, in my case "frame color." After creating the products, I went to their respective product pages and found that for about a third of the products, the ability to choose the frame color in the drop down box didn't work. Clicking on the Please choose an option drop down, shows no options available. I can find no problems with any of the simple products created. They appear identical in their setup between working configurations and those that don't.

Has anyone seen this before? Is it a known bug? If you've seen it and fixed it, I'd love to know what you did.

I've tried deleting the bad configurable products and their associated simple products and recreating them to no avail.

CE 2.1.4, no extensions installed except a theme.

This config works:

This config does not work:

Answer 1

I checked the following scenario on 2.1.4 and couldn't reproduce it, all works as expected for me, product options are available on the storefront.

Please let me provide the steps I used and let me know if it's not the same as yours.

1. I created a product attribute which has dropdown input type and named it "Size" with three values: S, M, L
2. Cleaned cache
3. Created a configurable product "Shirt" based on that "Size" attribute and used all those three values on Step 2 of Configurable Product Wizard
4. Checked all the options like Stock Status, Quantity, Website assignment in order to verify that "Color Shirt" will be available on the Storefront
5. Upon saving the "Color Shirt" I selected "Add configurable attributes to the current Attribute Set"
6. Cleaned cache
7. Then I created another configurable product "Pants" based on the same attribute "Size"
8. On the Step 2 of Configurable Product Wizard I left S, M and L unchecked and created three more values XS, XL and XXL and selected them
9. Checked all the options like Stock Status, Quantity, Website assignment in order to verify that "Pants" will be available on the Storefront
10. Upon saving the "Color Shirt" I selected "Add configurable attributes to the current Attribute Set"
11. Cleaned cache
12. Went to the Storefront and checked both Products "Shirt" and "Pants"
13. Both of them had options under "Please choose an option..."

What theme do you use? Is this issue reproducible for you without this theme installed?

Answer 2

Turns out that adding attribute values via the config options section of the create configurable product page is a bad idea. Every product that wound up with a faulty configuration was due to using attribute values I added on that page vs the values I created when I first created the product attribute itself. The solution was to go into the product attribute and remove all values that I had added through the create configuration window, and then add them to the product attribute's options list and save the product attribute. No amount of product editing saved the bad product so I wound up deleting them and recreating them. They're working fine now.

I'm glad I learned this with only 20 configurable products created and not the 1,000 I'll have ultimately.

This feels like a big old bug to me.

Answer 3

We just had this issue with a lot of products where the sizes could not be selected. The culprit was that these colors did not have a record in the eav_attribute_option_swatch table.

Once we manually added records for those colors, even if the eav_attribute_option_swatch.value was left as NULL the issue would go away.

This seems to be related to using the flat catalog.

This is the query we used to find the colors with issues:

SELECT *
    FROM eav_attribute_option o
LEFT JOIN eav_attribute_option_value v ON o.option_id = v.option_id
LEFT JOIN eav_attribute_option_swatch s ON o.option_id = s.option_id
WHERE o.attribute_id IN (YOUR ATTRIBUTE ID)
AND s.swatch_id IS NULL
AND v.store_id = 0
;

After that we simply ran:

INSERT INTO eav_attribute_option_swatch 
(option_id,store_id,type)
VALUES (ATTRIBUTE OPTION ID,0,1), ...

.

Answer 4

Do you have inventory available for the simple products that make up the configurable ones? If not, those options may not be available on the front end to end users (based on your inventory settings).

That's the first thing that I'd recommend. I'd also make sure to reindex / flush cache, etc, even if you're in developer mode.

I hope this helps...