Month: January 2022

The following below Database Tables store Paypal Sales Payment Transaction.

paypal_payment_transaction

The following below Database Tables store PayPal Billing Agreement.

paypal_billing_agreement
paypal_billing_agreement_order

Magento 2 All Database Tables [500 & more Tables]

Which Magento 2 Database Tables Store Sales Order Data

Which Magento 2 Database Tables Store Sales Invoice Order Data

Which Magento 2 Database Tables Store Sales Tax and Its related Data

Which Magento 2 Database Tables Store Catalog Price Rules

Which Magento 2 Database Tables Store Cart Price Rules

Which Magento 2 Database Tables Store Shopping Cart Items

Which Magento 2 Database Table Store Sales Payment Transaction

Which Magento 2 Database Table store Sales Paypal Settlement Report

Which Magento 2 Database Table store Sales Paypal Payment Transaction

The following below Database Tables store Bundle Products

catalog_product_bundle_option
catalog_product_bundle_option_value
catalog_product_bundle_price_index
catalog_product_bundle_selection
catalog_product_bundle_selection_price
catalog_product_bundle_stock_index
catalog_product_index_price_bundle_idx
catalog_product_index_price_bundle_opt_idx
catalog_product_index_price_bundle_opt_tmp
catalog_product_index_price_bundle_sel_idx
catalog_product_index_price_bundle_sel_tmp
catalog_product_index_price_bundle_tmp

Magento 2 All Database Tables [500 & more Tables]

Which Magento 2 database table store customer’s Email Data

Which Magento 2 Database Table Store Customer Newsletter Data

Which Magento 2 database table store customer’s shipping and billing address

How To Remove Sales Order Data & Customer Data in Magento 2

Which Magento 2 Database Tables Store Customer Rating

Which Magento 2 Database Tables Store Customer Review

Which Magento 2 Database Tables Store Customer Wishlist Products

Which Magento 2 Database Table Store Patches

Which Magento 2 Database Table Store Patches

Which Magento 2 Database Table Store Static Blocks & Its Details

Which Magento 2 Database Table Store CMS Pages & Its Details

Which Magento 2 Database Tables Having All URLs Storage

Templates:: Templates define the designing look of a page, these are files with the phtml extension, containing html markup. Which a specific Template need to render is determined by the layout file.

Layout:: Layout defines the structure of the page, It is a collection of Containers & columns of page.

There are 5 types of page layout for the frontend & 3 types of page layout for the backend

5 Types of page layout for the frontend

• Empty
• 1Column
• 2Columns-left
• 2Columns-right
• 3Columns

3 Types of page layout for the backend

• Admin-empty
• Admin-1column
• Admin-2columns-left

Dynamic Block:: Dynamic module blocks are collection of multiple methods, those are used in templates files, these files are rendered by xml layout file

The XML layout file defines which block and which template file will be called.