Magento 2.x Learning & Knowledge & Troubleshooting
There are following below steps need to follow to remove Magento 2 core module, add following below code in composer.json & write name of modules you want to remove inside replace
"replace": {
"magento/module-marketplace": "*",
"magento/module-authorizenet": "*",
"magento/module-braintree": "*",
"magento/module-multishipping": "*",
}
There are following below link need to click to know Magento 2 All 500 & more Tables, where each Magento 2 Table Briefly Explanation has been explained
Magento 2 All Database Tables [500 & more Tables]
Which Magento 2.x database table store customer’s Email Data
Which Magento 2.x Database Table Store Customer Newsletter Data
Which Magento 2.x database table store customer’s shipping and billing address
How To Remove Sales Order Data & Customer Data in Magento 2
How To Remove / Delete Catalog Data or Categories / Products in Magento 2.x
Which Magento 2.x Database Tables Store Customer Rating
Which Magento 2.x Database Tables Store Customer Review
Which Magento 2.x Database Tables Store Customer Wishlist Products
Which Magento 2.x Database Table Store Patches
Which Magento 2.x Database Table Store Static Blocks & Its Details
Which Magento 2.x Database Table Store CMS Pages & Its Details
Which Magento 2.x Database Tables Having All URLs Storage
Which Magento 2.x Database Tables Store Sales Order Data
Which Magento 2.x Database Tables Store Sales Invoice Order Data
Which Magento 2.x Database Tables Store Sales Tax and Its related Data
Which Magento 2.x Database Tables Store Catalog Price Rules
During Order Review of Order Summary Page before Place An Order,
There are following below things are being displayed as Sequence below
The detailed view Order Summary helps customers understand how the store is charged. This provides transparency of the store, increasing the trust of the customers.
Need to adjustments & Position of above fields, each field having own position, to do this Store Owner(Admin) required Sort Order settings
There are following below steps need to follow.
[1]- Go To STORES > Configuration, redirects on configuration.
[2]- In left panel, expand the Sales section and choose Sales underneath.
[3]- Once redirection on [Right Panel] Checkout Totals Sort Order section.
[4]- Once clicked / expanded Checkout Totals Sort Order section [Right Panel]
[5]- Change the number assigned to each item to determine its Order Position, in Order Summary Page.
[6]- Finally click on Save Config Button
There are following below table establish connection between Categories and products.
catalog_category_product
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
Catalog Categories are EAV Entity, There are following below 6 Catalog Categories Entity Tables, where Category details are stored.
catalog_category_entity
catalog_category_entity_datetime
catalog_category_entity_decimal
catalog_category_entity_int
catalog_category_entity_text
catalog_category_entity_varchar
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
Catalog Products are EAV Entity, There are following below 6 Catalog Products Entity Tables, where product details are stored.
[1] – catalog_product_entity
[2] – catalog_product_entity_datetime
[3] – catalog_product_entity_decimal
[4] – catalog_product_entity_int
[5] – catalog_product_entity_text
[6] – catalog_product_entity_varchar
[1] – catalog_product_entity:: stores (SKU, Creation & Update Date) of products
[2] – catalog_product_entity_datetime:: stores (Special From Date) of products
[3] – catalog_product_entity_decimal:: stores product’s price
[4] – catalog_product_entity_int:: stores following below data values
manufacturer
color,
features_bags,
manufacturer,
tax_class_id,
visibility,
is_featured,
material,
pattern,
occassion,
brand,
size
[5] – catalog_product_entity_text::
[6] – catalog_product_entity_varchar:: stores following below data values
image,
meta_description,
meta_title,
name,
thumbnail,
url_key,
url_path,
country_of_origin,
country_of_shipping,
gift_message_available,
hsn_codes,
image,
in_the_box,
meta_description,
meta_title,
name,
options_container,
package_dimensions_breadth,
package_dimensions_height,
package_dimensions_length,
rollover_image,
small_image,
swatch_image,
thumbnail,
unit_sets,
url_key,
url_path,
Magento 2 All Database Tables [500 & more Tables]
Which Magento 2 database tables store Product details
Which Magento 2 database tables store Category details
How To Delete Magento 2 Categories & Products in Magento 2
Which Magento 2 Database Table Store Bundles Product
Which Magento 2 Database Table Having All Catalog (Categories & Products) URLs Rewrite Storage Data
Which Magento 2 Database Tables Store Product Attributes
How To Delete Magento 2 Products
How To Delete Magento 2 Categories
How To Delete Magento 2 Categories & Products in Magento 2
Which Magento 2 Database Table Store Customer Group Price of products
Which Magento 2 Database Table Store Products Special Discount Price
Customer Address is EAV Entity, There are following below 6 Customer Address Entity Tables, where customer’s shipping & billing address details are stored.
customer_address_entity
customer_address_entity_int
customer_address_entity_varchar
customer_address_entity_text
customer_address_entity_decimal
customer_address_entity_datetime
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 Static Blocks & Its Details
Which Magento 2 Database Table Store CMS Pages & Its Details
Which Magento 2 Database Tables Having All URLs Storage
Magento 2 collection of multiple of multiple set of Files & Folders
[1] Magento 2 Folder Structure : Set of Folder Collection as below
app, bin, setup, phpserver, var, generated, lib, pub, dev.
Magento 2 Magento using its own Technique for password hashing by following below Technique (One of the best Strongest Web Password Encryption algorithms).
[1] Password Hash –
[2] Salt –
[3] SHA256 –
[4] Argon 2ID13 –
Magento 2 Password collection of all above Password algorithms
Magento 2 Password = Password Hash + Salt + SHA256 + Argon 2ID13
6f98f4b6dd20dad5f00f97aa08541fb29c728fc1b8ce32b23bc11c66f792528c:T2izWsU9DcHN1HJ:l:2Magento 2 always stored password as above format
Fist Part=password hash
password hash=6f98f4b6dd20dad5f00f97aa08541fb29c728fc1b8ce32b23bc11c66f792528c
Second Part=Salt=T2izWsU9DcHN1HJ
The last two are the different hash algorithms:
1 is SHA256 and 2 is Argon 2ID13.
This means that the customer’s password was originally hashed with SHA256 and after that, the algorithm was updated with Argon 2ID13 and the hash was re-hashed with Argon.
Click Magento 2 Password Encryption Algorithms PDF Document
To resolve issue, need to run following below Git Command
git add *
git stash
git pull