2

I wanted to know the flow which is being use while saving bundle product. In database their are two main tables, catalog_product_bundle_option and catalog_product_bundle_option_value, which store data related to options of bundle item of product.

But how does Magento know when to store data in catalog_product_bundle_option and when in catalog_product_bundle_option_value?

It is not like static type of attribute which is used for saving EAV data.

2

I will try to explain brief about Bundle product. the below 3 tables important for bundle product

catalog_product_bundle_option

catalog_product_bundle_option_value

catalog_product_bundle_selection

Example :

Sprite Yoga Companion Kit consider as bundle product.

Sprite Stasis Ball : : consider as bundle associate bundle item title.

1) Sprite Stasis Ball 55 cm - This product as simple product want to display as radio button

2) Sprite Stasis Ball 65 cm - This product as simple product want to display as radio button

3) Sprite Stasis Ball 75 cm - This product as simple product want to display as radio button

enter image description here

How it will store in Table?

catalog_product_bundle_selection : associate bundle items and price are stored in this table.

catalog_product_bundle_option : How we want to display (Radio,Multiple select, dropdown,checkbox) is stored in this table. In this table "Type" is the colum as (Radio,Multiple select, dropdown,checkbox).

catalog_product_bundle_option_value : option type title stored in table. Title is the value of option. (Example : Sprite Stasis Ball)

Hope it will clear i think

  • Thanks for the answer but if catalog_product_bundle_option_value is used to store option selection then what is the use of catalog_product_bundle_selection – Ashish Madankar M2 Professiona Jun 27 '17 at 9:52
  • I have brief explain here. hope it will helpful for you – Rama Chandran M Jun 27 '17 at 11:21
  • Shall i know is it clear? or need any input on this – Rama Chandran M Jun 29 '17 at 19:30
1

Both tables are always used. The Options have titles which can be localized per store view.

catalog_product_bundle_option identifies the option and contains global values, catalog_product_bundle_option_value contains the store specific values (i.e. the title).

  • Thanks for the answer but if catalog_product_bundle_option_value is used to store option selection then what is the use of catalog_product_bundle_selection – Ashish Madankar M2 Professiona Jun 27 '17 at 9:52
  • @AnishMadankar Ah, my mistake. value is actually the localized title for the option (can be different per store view). I'll update the answer – Fabian Schmengler Jun 27 '17 at 9:59

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.