I am facing problem with large number of variations in Configurable Product. I am trying to add ring and it has around 384 variables, 24 sizes, 4 metal types and 4 color/clarity.

This is the sample value for configurable_variations.


When I try to upload. The upload happens successfully but the ring size does not show up in the product page.

How do I accomplish this?

  • Hey @Samay do all other variants options other then size are visible on front end means metal type, color/clarity? & do provide some image with your question – Abhishek Tripathi Mar 31 '18 at 4:44
  • Yes. They are visible. What is the DB table which stores this ? – Samay Mar 31 '18 at 6:10
  • Product attribute related data is get stored in this tables in magento 2 catalog_product_entity_int, catalog_product_index_eav_decimal, catalog_product_entity_varchar, catalog_product_entity_text, catalog_product_entity_media_gallery_value depending on that which kind of data(type) it has – Abhishek Tripathi Mar 31 '18 at 6:25
  • 1
    I strongly suggest that you are not making any changes through queries to those tables without understanding implications. Keep in mind that flat tables have compiled these attributes for more efficient performance. We save performance by cutting out the unions among EAV relations since queries now obtain and return data found in the flat tables. Be sure to reindex if youve made changes but don't see them on the front-end. – df2k2 Mar 31 '18 at 6:34
  • Same here as @df2k2 said I just shared this to you for an information please do not do any changes to this tables through scripts – Abhishek Tripathi Mar 31 '18 at 6:43

The data you have in the gist does not contain anything relating to ring sizes. If you already knew that and were still asking for assistance with configurable products, then simply ensure that your ring size attribute is properly configured for front-end display, as well as configurable usage. When you complete the creation of the attribute, ensure that you have assigned it to the proper attribute set.

If you have gotten that far, then creating simple products as children of the configurable, will require sizes to be specified per simple child. One size = one simple product child. 10 sizes will ultimately be 10 simple products associated that parent configurable.

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.