Some Configurable products not showing options on product page Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Configurable Product options box not showing on the front endNeed to get Simple Products with Configurable Option from Configurable ProductAfter upgrade to 1.9 configurable product options not displayingMagento 2 : New Configurable product - selecting existing simple products manually?Include configurable product price with simple product options price in Magento 2How to change price for configurable products in Product Listing using drop down options in Magento 2Associate Simple Products with Required Options to Configurable ProductM2.2 Configurable product with existing simple products - product list emptyHow to get configurable product options on associated product page?Magento2 how to remove “choose an option” in configurable products drop down

Is it possible to boil a liquid by just mixing many immiscible liquids together?

3 doors, three guards, one stone

If a contract sometimes uses the wrong name, is it still valid?

If 'B is more likely given A', then 'A is more likely given B'

Output the ŋarâþ crîþ alphabet song without using (m)any letters

What is a Meta algorithm?

How can I fade player when goes inside or outside of the area?

What LEGO pieces have "real-world" functionality?

Did Xerox really develop the first LAN?

Should I use Javascript Classes or Apex Classes in Lightning Web Components?

IndentationError when pasting code in Python 3 interpreter mode

Can Pao de Queijo, and similar foods, be kosher for Passover?

What are the motives behind Cersei's orders given to Bronn?

How discoverable are IPv6 addresses and AAAA names by potential attackers?

If Jon Snow became King of the Seven Kingdoms what would his regnal number be?

Models of set theory where not every set can be linearly ordered

How much radiation do nuclear physics experiments expose researchers to nowadays?

How can I make names more distinctive without making them longer?

How do I keep my slimes from escaping their pens?

Is there a service that would inform me whenever a new direct route is scheduled from a given airport?

ListPlot join points by nearest neighbor rather than order

How to bypass password on Windows XP account?

How to find all the available tools in macOS terminal?

What happens to sewage if there is no river near by?



Some Configurable products not showing options on product page



Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Configurable Product options box not showing on the front endNeed to get Simple Products with Configurable Option from Configurable ProductAfter upgrade to 1.9 configurable product options not displayingMagento 2 : New Configurable product - selecting existing simple products manually?Include configurable product price with simple product options price in Magento 2How to change price for configurable products in Product Listing using drop down options in Magento 2Associate Simple Products with Required Options to Configurable ProductM2.2 Configurable product with existing simple products - product list emptyHow to get configurable product options on associated product page?Magento2 how to remove “choose an option” in configurable products drop down



.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








3















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 works



This config does not work:



config that doesn't work










share|improve this question
























  • Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

    – Jonathan Ribas
    Feb 26 '17 at 18:26











  • Yes to all of that.

    – Dave G
    Feb 26 '17 at 18:27











  • Please show a print of "Configurations" section of your configurable product.

    – Jonathan Ribas
    Feb 26 '17 at 18:36











  • @JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

    – Dave G
    Feb 26 '17 at 20:53











  • In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

    – Kristof at Fooman
    Feb 26 '17 at 21:03

















3















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 works



This config does not work:



config that doesn't work










share|improve this question
























  • Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

    – Jonathan Ribas
    Feb 26 '17 at 18:26











  • Yes to all of that.

    – Dave G
    Feb 26 '17 at 18:27











  • Please show a print of "Configurations" section of your configurable product.

    – Jonathan Ribas
    Feb 26 '17 at 18:36











  • @JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

    – Dave G
    Feb 26 '17 at 20:53











  • In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

    – Kristof at Fooman
    Feb 26 '17 at 21:03













3












3








3


1






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 works



This config does not work:



config that doesn't work










share|improve this 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 works



This config does not work:



config that doesn't work







magento-2.1 configurable-product






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Feb 26 '17 at 20:49







Dave G

















asked Feb 26 '17 at 17:59









Dave GDave G

509720




509720












  • Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

    – Jonathan Ribas
    Feb 26 '17 at 18:26











  • Yes to all of that.

    – Dave G
    Feb 26 '17 at 18:27











  • Please show a print of "Configurations" section of your configurable product.

    – Jonathan Ribas
    Feb 26 '17 at 18:36











  • @JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

    – Dave G
    Feb 26 '17 at 20:53











  • In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

    – Kristof at Fooman
    Feb 26 '17 at 21:03

















  • Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

    – Jonathan Ribas
    Feb 26 '17 at 18:26











  • Yes to all of that.

    – Dave G
    Feb 26 '17 at 18:27











  • Please show a print of "Configurations" section of your configurable product.

    – Jonathan Ribas
    Feb 26 '17 at 18:36











  • @JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

    – Dave G
    Feb 26 '17 at 20:53











  • In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

    – Kristof at Fooman
    Feb 26 '17 at 21:03
















Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

– Jonathan Ribas
Feb 26 '17 at 18:26





Are all simple products enabled, in stock, product associated to a website and associated with configurable product? Have you run reindex? Please show some prints "Configurations".

– Jonathan Ribas
Feb 26 '17 at 18:26













Yes to all of that.

– Dave G
Feb 26 '17 at 18:27





Yes to all of that.

– Dave G
Feb 26 '17 at 18:27













Please show a print of "Configurations" section of your configurable product.

– Jonathan Ribas
Feb 26 '17 at 18:36





Please show a print of "Configurations" section of your configurable product.

– Jonathan Ribas
Feb 26 '17 at 18:36













@JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

– Dave G
Feb 26 '17 at 20:53





@JonathanRibas I've edited the original post with one working configuration and one non-working configuration.

– Dave G
Feb 26 '17 at 20:53













In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

– Kristof at Fooman
Feb 26 '17 at 21:03





In the above example the difference between working and not working seems to be the use of / in both the SKU and attribute. Could well be a bug that can't handle / (for example the character would need to be especially escaped for JSON). Can you confirm that this holds for working vs non-working for the rest of your products?

– Kristof at Fooman
Feb 26 '17 at 21:03










4 Answers
4






active

oldest

votes


















2














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?






share|improve this answer

























  • This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

    – Dave G
    Feb 28 '17 at 21:49











  • More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

    – Dave G
    Feb 28 '17 at 22:13


















6














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.






share|improve this answer


















  • 1





    Wtf. Why is this still a bug.

    – Robbie Averill
    Oct 25 '17 at 7:39


















0














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...






share|improve this answer























  • Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

    – Dave G
    Feb 26 '17 at 18:32


















0














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), ...


.






share|improve this answer























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "479"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161846%2fsome-configurable-products-not-showing-options-on-product-page%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    4 Answers
    4






    active

    oldest

    votes








    4 Answers
    4






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    2














    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?






    share|improve this answer

























    • This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

      – Dave G
      Feb 28 '17 at 21:49











    • More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

      – Dave G
      Feb 28 '17 at 22:13















    2














    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?






    share|improve this answer

























    • This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

      – Dave G
      Feb 28 '17 at 21:49











    • More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

      – Dave G
      Feb 28 '17 at 22:13













    2












    2








    2







    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?






    share|improve this answer















    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?







    share|improve this answer














    share|improve this answer



    share|improve this answer








    edited Feb 28 '17 at 9:19









    Arunendra

    6,26331842




    6,26331842










    answered Feb 28 '17 at 8:59









    Anton BoikoAnton Boiko

    361




    361












    • This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

      – Dave G
      Feb 28 '17 at 21:49











    • More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

      – Dave G
      Feb 28 '17 at 22:13

















    • This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

      – Dave G
      Feb 28 '17 at 21:49











    • More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

      – Dave G
      Feb 28 '17 at 22:13
















    This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

    – Dave G
    Feb 28 '17 at 21:49





    This is helping. Thank you. My products have only two conifugurable options. I followed your advice and added the configurable options one at a time and then verifying them on the site. So far so good. I also have many custom, non-configurable attributes. I'm adding them one at a time to see where the process breaks down.

    – Dave G
    Feb 28 '17 at 21:49













    More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

    – Dave G
    Feb 28 '17 at 22:13





    More frequent saves of the base configurable product attributes before adding configurable attributes has seemed to be the fix. I'll remain hopeful.

    – Dave G
    Feb 28 '17 at 22:13













    6














    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.






    share|improve this answer


















    • 1





      Wtf. Why is this still a bug.

      – Robbie Averill
      Oct 25 '17 at 7:39















    6














    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.






    share|improve this answer


















    • 1





      Wtf. Why is this still a bug.

      – Robbie Averill
      Oct 25 '17 at 7:39













    6












    6








    6







    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.






    share|improve this answer













    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.







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Feb 26 '17 at 23:30









    Dave GDave G

    509720




    509720







    • 1





      Wtf. Why is this still a bug.

      – Robbie Averill
      Oct 25 '17 at 7:39












    • 1





      Wtf. Why is this still a bug.

      – Robbie Averill
      Oct 25 '17 at 7:39







    1




    1





    Wtf. Why is this still a bug.

    – Robbie Averill
    Oct 25 '17 at 7:39





    Wtf. Why is this still a bug.

    – Robbie Averill
    Oct 25 '17 at 7:39











    0














    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...






    share|improve this answer























    • Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

      – Dave G
      Feb 26 '17 at 18:32















    0














    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...






    share|improve this answer























    • Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

      – Dave G
      Feb 26 '17 at 18:32













    0












    0








    0







    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...






    share|improve this answer













    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...







    share|improve this answer












    share|improve this answer



    share|improve this answer










    answered Feb 26 '17 at 18:27









    Jeff FinkelsteinJeff Finkelstein

    61537




    61537












    • Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

      – Dave G
      Feb 26 '17 at 18:32

















    • Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

      – Dave G
      Feb 26 '17 at 18:32
















    Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

    – Dave G
    Feb 26 '17 at 18:32





    Yes. Inventory available, in stock, etc., for all products. Indexer runs via cron every minute. Cache flushed routinely.

    – Dave G
    Feb 26 '17 at 18:32











    0














    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), ...


    .






    share|improve this answer



























      0














      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), ...


      .






      share|improve this answer

























        0












        0








        0







        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), ...


        .






        share|improve this answer













        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), ...


        .







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Apr 11 at 18:27









        AlexLAlexL

        266210




        266210



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161846%2fsome-configurable-products-not-showing-options-on-product-page%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Sum ergo cogito? 1 nng

            三茅街道4182Guuntc Dn precexpngmageondP