Create db_schema_whitelist.json file using CLI in Magento 2.

In Magento 2, Magento Version 2.3 and higher version contains the declarative schema approach for database tables history.

You can create db_schema_whitelist.json using the command line with a single command,

The generated file location is the <Vendorname>/<Modulename>/etc/db_schema_whitelist.json in your module. Continue reading “Create db_schema_whitelist.json file using CLI in Magento 2.”

Product Custom option table relation with other entity in Magento 2

Product with the custom option available Out of the box in Magento 2. You can add, delete or update custom option of a product using an admin panel or creating a script by programmatically.

You can check the relation for each custom option table with another table in Magento 2.3

catalog_product_option is the primary table to manage Custom Option related data for a product. Continue reading “Product Custom option table relation with other entity in Magento 2”

How product images are saved in database Magento 2?

A Product is the heart of any e-Commerce system, A product contains multiple information like Title, SKU, Price, Inventory, Images and so more details.

Let’s start with the Main point, A product has multiple images, and I will just explore how each product is stored in the database. Your confusion will be clear after reading the below details of the image saved in the database.

catalog_product_entity_varchar  used for store product image value.

Continue reading “How product images are saved in database Magento 2?”