Author: John

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:2

Magento 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

How To Configure Password Options in Magento 2.x

To resolve issue, need to run following below Git Command

git add * 
git stash
git pull

Magento 2 Customer Account Sharing Options allows which level customer account information need to share, either Website Level or Global Level.

How To Configure Customer Account Sharing Options in Magento 2.x

Magento 2 Customer Account Sharing Options allows which level customer account information need to share either Website Level or Global Level.

There are following below steps need to follow.

[1]- Go To STORES > Configuration, redirects on configuration.

[2] – Left Panel Clicked Customers > Customer Configuration

[3] – Once redirection on [Right Panel]

[4] – Once clicked / expanded, URL Options [Right Panel]

There are following below two options are given in Drop Down Values

By Default Per Website & Another one Global

Per Website : Customer Information like First Name, Last Name Email, Contact Details etc will be shared by within website, Finally customer information accessed by specified website.

Global : Customer Information like First Name, Last Name Email, Contact Details etc will be shared by Globally by website or store, Finally customer information accessed by multiple website or store.

Each of these Customer Account Sharing Options must be select as per Multi Website & Store need

Magento 2 All Database Tables [500 & more Tables]

How To Set Multi Shipping Settings In Magento 2

How To Set Origin Shipping in Magento 2

Difference Between Offline Shipping Method and Online Shipping Method

Magento 2 Online Customers Options

How To Apply Customer Group Price of Products in Magento 2

How To Add Customer Groups Dropdown in Magento 2 Admin Form and Grid By UI Component

How To Get all Customers Data in Magento 2

How To Create Customer Order in Magento 2 Admin Panel

Magento 2 Login As Customer Not Enabled

How To Configure Customer Account Sharing Options in Magento 2

Magento 2 Redirect To Customer Dashboard After Login

Which Magento 2 database table store customer shipping and billing address

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

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 Wishlist Products

Magento 2 Increase Customer Session Time

Which Magento 2 Database Table Store Patches

The Magento 2 customer password options provides customer’s account security, once customer creating account, required strong password,
Customer’s change password, Customer’s forget password, Customer’s reset password etc.

There are following options , how to storeowner(admin) can make strong password for their customers.

[1] – Go To STORES > Configuration, redirects on configuration.

[2] – Left Panel Clicked Customers > Customer Configuration

[3] – Once redirection on [Right Panel]

[4] – Once clicked / expanded, Password Options [Right Panel]

[4.1] Password Reset Protection Type : There are four options given By IP / Email, By IP, By Email, None, as per store requirement select any of them.

[4.2] Max Number of Password Reset Requests : By Default 5 Hour given, as per store requirement enter Hour value, value must be greater than 0, in case disable this feature, enter 0

[4.3] Min Time Between Password Reset Requests :

[5] – Finally click on Save Config Button

There are following below difference

	MongoDB	MariaDB
1	MongoDB released on 11 February 2009 & developed by Developed by MongoDB Inc.	MariaDB released on 29 October 2009 & developed by MariaDB Corporation Ab
2	MongoDB  is an open-source relational DBMS solution created to provide SQL features for accessing the data.	MariaDB  is open-source, and is a NoSQL Database.
3	MongoDB is written in Perl, bash, C, and C++	MongoDB is written in C++, JavaScript, Python
4	MongoDB supports non relational (NoSQL) database program & open-source document database, that stores the data in the form of key-value pairs	MariaDB supports relational database management system (RDBMS) that is a compatible with widely used MySQL database technology & open-source database
5	MongoDB does not support XML for storage.	MariaDB supports XML for storage, access, and retrieval in XML data format.
6	MongoDB supports Referential Integrity & Foreign Keys concept	MariaDB does not support Referential Integrity & Foreign Keys concept
7	MongoDB supports Multi document based ACID transactions with snapshot isolation.	MariaDB supports only ACID transactions without snapshot isolation.
8
9
10