How To Configure Name and Address Options in Magento 2.x

There are following below things need to follow to configure Name and Address Options in Magento 2

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

[2] – Go To CUSTOMERS > Customer Configuration

redirects on Right Panel form as Step 3

[3] Once redirection on [Right Panel]

[4] – Once clicked / expanded, Name and Address Options [Right Panel]

Each filed of Name and Address Options form described as below

[4.1] – Number of Lines in a Street Address : By default 3 Lines given
It can be change up to 4 Lines.

[4.2] – Show Prefix : There are three options given as follows:

No – By default selected

Optional

Required

as per store requirement select any of them

[4.3] – Prefix Dropdown Option : put prefix that Store Admin want to be include in the list, each prefix is separated by a semicolon. & put  semicolon in the beginning for empty first option.

Leave empty for open text field.

[4.4] – Show Middle Name (initial) : By default No selected, as per store requirement select Yes

It is Optional

[4.5] – Show Suffix : There are three options given as follows

No – By default selected

Optional

Required

as per store requirement select any of them

[4.6] – Prefix Dropdown Option : put prefix that Store Admin want to be include in the list, each prefix is separated by a semicolon. & put  semicolon in the beginning for empty first option.

Leave empty for open text field.

[4.7] – Show Date of Birth : There are three options given as follows

No – By default selected

Optional

Required

as per store requirement select any of them

[4.8] – Show Tax/VAT Number : There are three options given as follows

No – By default selected

Required

Optional

as per store requirement select any of them

[4.9] – Show Gender : There are three options given as follows

No – By default selected

Optional

Required

as per store requirement select any of them

[4.10 ] – Show Telephone : There are three options given as follows

No

Required -By default selected

Optional

as per store requirement select any of them

[4.11] – Show Company : There are three options given as follows

No

Optional -By default selected

Required

as per store requirement select any of them

[4.12] – Show Fax : There are three options given as follows

No – By default selected

selected

Required

as per store requirement select any of them

[5] – Finally click on Save Config Button

HTTP Security Headers Checker Tool – Security Headers Response

There are following below Security Headers Tool , display all Headers Response

https://www.site2info.com/sitesecurity.php

Once using this tool display all Headers Response as follow:

[4]- Strict-Transport-Security

[5]- Content Security Policy







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

There are following set of Database Tables Store Sales Tax and Its related Data

sales_order_tax_item
tax_calculation
tax_calculation_rate
tax_calculation_rate_title
tax_calculation_rule
tax_class
tax_order_aggregated_created
tax_order_aggregated_updated

Magento 2 All Database Tables [500 and 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

Which Magento 2.x Database Table Store Customer Newsletter Data

There are following below set of Database Table Store Customer’s Newsletter Data

newsletter_problem
newsletter_queue
newsletter_queue_link
newsletter_queue_store_link
newsletter_subscriber
newsletter_template

Magento 2 All Database Tables [500 and 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


Which Magento 2.x Database Tables Store Sales Invoice Order Data

There are following set of Database Tables Store Sales Invoice Order Data

[1] sales_Invoice :: Store [Sold Product base total, shipping total, Tax Total,Grand Total] etc.

[2] sales_Invoice_item :: Store [Sold Product Details[sku, name ect], price etc.]

[3] sales_Invoice_grid :: Store [Sold product Billing/Shipping Address Grand Item Price, Order ID(order_id), Customer Email]

[4] sales_Invoice_comment :: [Display Invoice comment & also notified , either customer notified or not]

[5] sales_Invocie_aggregated :: Store [sales Invoice aggregated data]

[6] sales_Invocie_aggregated_order :: Store [sales Invoice aggregated ordered data ]

Magento 2 All Database Tables [500 and 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 Table Store Patches


Which Magento 2 Database Tables Store Customer Review


Which Magento 2 Database Tables Store Customer Rating

Which Magento 2.x Database Table Store Patches

Magento 2 Patch is a package of core files that are modified that aims at fixing certain security bugs that cause security vulnerabilities that were encountered in earlier Magento versions, that is why called Magento 2 Security Patch.

There are following below table store Magento 2 Module Patches

patch_list

By Default, Magento 2 having 157 Security Patches in Database Table patch_list

This table having to column patch_id & patch_name

Magento 2 All Database Tables [500 and 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

Difference Between Offline Shipping Method and Online Shipping Method

There are following below difference between Offline Shipping Method and Online Shipping Method

The Online Shipping methods are those which actively consume the API of a 3rd party system owned by a shipping services provider in order to fetch the shipping cost and the information regarding the parcel’s delivery tracking

While

The Offline Shipping methods implements the shipping methods which do not involve a direct interaction with shipping carriers, so called offline shipping methods.

In case Magento 2, offline shipping methods as

Free Shipping

Flat Rate

Table Rates

Store Pickup

Which Magento 2.x Database Tables Store Sales Order Data

There are following below set of Database Tables store Sales Order Data.

sales_order

sales_order_item

sales_order_grid

sales_order_address

sales_order_payment

sales_order_status

[1] sales_order :: store [payement, discount, tax, Customer ID(customer_id), Email, Billing-Shipping payment etc.]

[2] sales_order_item :: Store [Product Details, Order ID(order_id)]

[3] sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]

[4] sales_order_address :: Store [Shipping & Billing Address, , Customer ID(customer_id)], each time store two row one for Billing address and another For shipping address while ordering any product

[5] sales_order_payment :: Store [payment details on the bases of Order ID]

[6] sales_order_status :: Store [Sales Order Status like canceled, closed, complete, fraud, holded, payment_review, Paypal Canceled Reversal, Paypal Reversed, Pending, Pending Payment, Pending Paypal, Processing]

sales_order_grid :: Store [Billing/Shipping Address Grand Item Price,Customer ID(customer_id), Order ID as increment_id]

order_id of sales_order_item Become increment_id of sales_order_grid increment_id display in

Stores -> Configuration–>Sales -> Order

Magento 2 All Database Tables [500 and 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 Table Store Patches


Which Magento 2 Database Tables Store Customer Review


Which Magento 2 Database Tables Store Customer Rating