Which Magento 2.x Database Table Store Persistent Session

The following below Magento 2 Database Table store Persistent Session data.

persistent_session

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


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.x Database Table Store Products Special Discount Price

The following below Magento 2 database table store Products Special Discount Price.

catalog_product_entity_tier_price

Which Magento 2 Database Table Store Customer Group Price of products


Magento 2 Script To Add Multiple Section, Groups and Fields in Stores-Configuration


What is Declarative Schema in Magento 2


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


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


Magento 2 Allowed memory size of XXXX bytes exhausted (tried to allocate XXXX bytes)

How To Set Multi Shipping Settings In Magento 2

Magento 2.x using Multiple Shipping Address to ship products in customer’s multiple address.

The Following below admin setting required to enable Multiple Shipping Address.

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Left panel, choose SALES > Shipping Settings.

Step [3] – Right panel, Expand the Origin section

There are following below two part

[a] – Allow Shipping to Multiple Addresses

To Enable select Yes, after uncheck use system value

[b] – Maximum Qty Allowed for Shipping to Multiple Addresses

Enter required quantity as per Store need.

Step [4] – Click on Save Config button & run CLI command Flush

Finally,  Multiple Shipping setting has been done.

Benefits of Multiple Shipping Address in Magento 2.x

Shipping Address is used to ship products at customer’s address, Magento 2 allow Multiple Shipping Addresses to ship multiple address during checkout process.

The following below Benefits of Multiple Shipping Address in Magento 2

During Festivals Season :: There are trends, Customers buy products to ship to their multiple friends at same time, that time multiple shipping address required.

During Special Occasion :: Customer using multiple shipping address during to ship multiple products during special occasion like Birthday, Wedding Anniversary, Party etc.

During Corporate Gifts :: Org using multiple shipping address to ship product to their Employees.

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

Deprecated Functionality: Class Laminas\Hydrator\Reflection is deprecated, please use Laminas\Hydrator\ReflectionHydrator instead in /pathToMagento/web/vendor/laminas/laminas-hydrator/src/Reflection.php on line 17

This is a common error while upgrading Magento 2.x To Magento 2.4.3

Deprecated Functionality: Class Laminas\Hydrator\Reflection is deprecated, please use Laminas\Hydrator\ReflectionHydrator instead in /pathToMagento/web/vendor/laminas/laminas-hydrator/src/Reflection.php on line 17

The following below solution

Solution [1] – After Upgrade Magento 2.x To Magento 2.4.3

Once you successfully upgraded Magento 2.x To Magento 2.4.3 and issue occurs as above-mentioned.

The laminas class might be used in some of the extensions, need to update the specific code of these extensions.

Using below command we can find which extensions, using laminas class.

grep -r 'class to search' app/

Solution [2] – Before Upgrade Magento 2.x To Magento 2.4.3

Copy below code from Magento 2.4.3 & Paste in Magento 2.x

"require-dev": {
   "allure-framework/allure-phpunit": "~1.2.0",
   "dealerdirect/phpcodesniffer-composer-installer": "^0.5.0",
   "friendsofphp/php-cs-fixer": "~2.16.0",
   "lusitanian/oauth": "~0.8.10",
   "magento/magento-coding-standard": "*",
   "magento/magento2-functional-testing-framework": "^3.0",
   "pdepend/pdepend": "~2.7.1",
   "phpcompatibility/php-compatibility": "^9.3",
   "phpmd/phpmd": "^2.8.0",
   "phpstan/phpstan": ">=0.12.3 <=0.12.23",
   "phpunit/phpunit": "^9",
   "sebastian/phpcpd": "~5.0.0",
   "squizlabs/php_codesniffer": "~3.5.4"
    },

After paste above code in Magento 2.x, start upgrade process.

Other important Magento 2.4.x issue as below

Magento 2.3 To Magento 2.4.5 Comptibility For PHP, MYSQL, Composer, Apache etc


Magento 2.4.3-p1 Installation Steps


Magento 2.4.3 Installation Steps


Magento 2.4.3 Features


Magento 2.4.3 – p1 Features


Magento 2.4 Two Factor Authentication


Magento 2.4.1 Features


Magento 2.4 Features


Magento 2.4 Installation


Magento 2.2, Magento 2.3, Magento2.4 Installation Issue on Windows 10, XAMPP


Magento 2 Installation at 51% Error: (Wrong file in Gd2.php:64) Module ‘Magento_Theme’

How To Set Origin Shipping in Magento 2.x

Magento 2 Origin Shipping Setting need to calculate the shipping costs for the shipments made from your store as well as calculate product tax cost.

The following below admin settings need to follow.

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Left panel, choose SALES > Shipping Settings.

Step [3] – Right panel, Expand the 

Origin section

&

Shipping Policy Parameters section

Step [4] – Origin section having the following below fields.

Before filling any input field, need to uncheck Use System Value

Country : By default, United States, fill as per Store Origin need.
Region/State : By default California, fill as per Store Origin need.
ZIP/Postal Code : By default 90034, fill as per Store Origin need.
City : fill City as per Store Origin need.
Street Address : fill Street Address as per Store Origin need.
Street Address Line 2 : fill Street Address Line 2 as per Store Origin need.

Shipping Policy Parameters section having Apply custom Shipping Policy, By default No selected

Once Yes selected , new input field Shipping Policy displaying to fill
shipping policy content as per Store Shipping Policy need

Click on Save Config button & run CLI command Flush

Finally, Origin Shipping setting has been done.

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

Magento 2.x Online Customers Options

There are two options Online Minutes Interval & Customer Data Lifetime inside Online Customers Options.

The following below steps need to follow.

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Left panel, choose CUSTOMERS > Customer Configuration.

Step [3] – Right panel, Expand the Online Customers Options section.

Step [4] – Two options as below

Online Minutes Interval: Enter the number of minutes allowed for a Customer’s Session time on the site. 15 minutes default time, if you leave this field blank, it is considered as 15 minutes.

Customer Data Lifetime: Enter the number of minutes before unsaved customer’s data. 15 minutes default time.

Step [5] – Click on Save Config button & run CLI command Flush

Finally, Online Minutes Interval (Customer Session time period in minute) & Customer Data Lifetime (in minute) has been set.

Other important Magento 2.x issue as below

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

How To Show Tax/VAT Number in Store front in Magento 2.x

There are following below steps need to follow.

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Left panel, choose CUSTOMERS > Customer Configuration.

Step [3] – Right panel, Expand the Create New Account Options section.

Step [4] – Go To Show VAT Number on Storefront : No Section, By Default No selected.

Once clicked on drop down, There are two options as Yes & No
select Yes

Show VAT Number on Storefront : Yes  

Step [5] – Go To Right Panel Name and Address Options

Once expand Show Tax / VAT Number

There are three option No, Optional, Required

Select Required

Click on Save Config button & run CLI command Flush

Finally, VAT / TAX displaying on Store front.

How To Get Base URL Magento 2.x Programmatically

There are following below steps need to follow to create Magento 2 custom module to get Base URL, Media URL, Link URL etc,

Step [1] – Create registration.php file under your module [ Namespace / ModuleName ]

File Path=app/code/Mage2db/John/registration.php

Add below content in this file.

<?php
\Magento\Framework\Component\ComponentRegistrar::register(
    \Magento\Framework\Component\ComponentRegistrar::MODULE,
    'Mage2db_John',
    __DIR__
);

Step [2] – Create module.xml file under your module [ Namespace / ModuleName ]

File Path=app/code/Mage2db/John/etc/module.xml

Add below content in this file.

<?xml version="1.0"?>
<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Module/etc/module.xsd">
<module name="Mage2db_John" setup_version="1.0.0" />
</config>

Step [3] – Create routes.xml file under your module etc directory.

Add below content in this file.

File Path=app/code/Mage2db/John/etc/frontend/routes.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../../../../../../lib/internal/Magento/Framework/App/etc/routes.xsd">
   <router id="standard">
       <route id="john" frontName="john">
         <module name="Mage2db_John" />
       </route>
   </router>
</config>

Step [4] – Create Controller under your module.

Add below content in this file.

File Path=app/code/Mage2db/John/Controller/Index/Index.php

<?php
namespace Mage2db\John\Controller\Index;

use Magento\Backend\App\Action\Context;

class Index extends \Magento\Framework\App\Action\Action
{
	
    /**
     * @var \Magento\Framework\App\Cache\TypeListInterface
     */
    protected $_cacheTypeList;

    /**
     * @var \Magento\Framework\App\Cache\StateInterface
     */
    protected $_cacheState;

    /**
     * @var \Magento\Framework\App\Cache\Frontend\Pool
     */
    protected $_cacheFrontendPool;

    /**
     * @var \Magento\Framework\View\Result\PageFactory
     */
    protected $resultPageFactory;
	

    /**
     * @param Action\Context $context
     * @param \Magento\Framework\App\Cache\TypeListInterface $cacheTypeList
     * @param \Magento\Framework\App\Cache\StateInterface $cacheState
     * @param \Magento\Framework\App\Cache\Frontend\Pool $cacheFrontendPool
     * @param \Magento\Framework\View\Result\PageFactory $resultPageFactory
     */
    public function __construct(
       \Magento\Framework\App\Action\Context $context,
        \Magento\Framework\App\Cache\TypeListInterface $cacheTypeList,
        \Magento\Framework\App\Cache\StateInterface $cacheState,
        \Magento\Framework\App\Cache\Frontend\Pool $cacheFrontendPool,
        \Magento\Framework\Message\ManagerInterface $messageManager,
        \Magento\Framework\View\Result\PageFactory $resultPageFactory
				
    ) {
        parent::__construct($context);
        $this->_cacheTypeList = $cacheTypeList;
        $this->_cacheState = $cacheState;
        $this->_cacheFrontendPool = $cacheFrontendPool;
        $this->resultPageFactory = $resultPageFactory;
        $this->_messageManager = $messageManager;
				
     }
    
    /**
     * Flush cache storage
     *
     */
    public function execute()
    {
	    $this->resultPage = $this->resultPageFactory->create();  
        return $this->resultPage;
    }
}

Step [5] – Create Helper.php under your module.

Add below content in this file.

File Path=app/code/Mage2db/John/Helper/Data.php

<?php
namespace  Mage2db\John\Helper;
use Magento\Store\Model\StoreManagerInterface;

class Data extends \Magento\Framework\App\Helper\AbstractHelper
{
	protected $storeManager; 

	/**
     * @param \Magento\Framework\App\Helper\Context $context
     */
	public function __construct
	(
   \Magento\Framework\App\Helper\Context $context,   StoreManagerInterface $storeManager
	) 
	{
	    $this->storeManager = $storeManager;	
		parent::__construct($context);
	}
	  
	public function getStoreManagerData()
    {
          //return $storeUrl = $this->storeManager->getStore()->getBaseUrl();
         // get Store Url without index.php
        return $storeUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_WEB);
           // get Link Url of store
          // $storeLinkUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_DIRECT_LINK);
         // get media Base Url
        //  $storeMediaUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA);
      // get Static content Url
      // $storeStaticUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_STATIC);
    }
}

Step [6] – Create Block under your module.

Add below content in this file.

app/code/Mage2db/John/Block/Index/Index.php

<?php
namespace  Mage2db\John\Helper;
use Magento\Store\Model\StoreManagerInterface;

class Data extends \Magento\Framework\App\Helper\AbstractHelper
{
	protected $storeManager; 

	/**
     * @param \Magento\Framework\App\Helper\Context $context
     */
	public function __construct
	(
	 \Magento\Framework\App\Helper\Context $context, StoreManagerInterface $storeManager
	) 
	{
	    $this->storeManager = $storeManager;	
		parent::__construct($context);
	}
	  
	public function getStoreManagerData()
    {
          //return $storeUrl = $this->storeManager->getStore()->getBaseUrl();
         // get Store Url without index.php
        return $storeUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_WEB);
           // get Link Url of store
          // $storeLinkUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_DIRECT_LINK);
         // get media Base Url
        //  $storeMediaUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA);
      // get Static content Url
      // $storeStaticUrl = $this->storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_STATIC);
    }
	  
}

Step [7] – Create view under your module.

under view folder create layout & template file

Layout File

app/code/Mage2db/John/view/frontend/layout/john_index_index.xml

<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" layout="2columns-left" xsi:noNamespaceSchemaLocation="../../../../../../../lib/internal/Magento/Framework/View/Layout/etc/page_configuration.xsd">
 <body>		
   <referenceContainer name="main.content">			
<block class="Mage2db\John\Block\Index\Index" name="index_index" template="index/index.phtml"> </block>
  </referenceContainer>      
 </body>
</page>

Template File

app/code/Mage2db/John/view/frontend/templates/index/index.phtml

<?php

   //Template index phtml 
  echo"<BR> Base URL===".$baseurl= $block->getbaseurldata();
        
?>		

Step [8] – Finally your custom module for Base URL, Media URL, Link URL etc . has been created

Run the following below commands at your Magento 2 root directory

php bin/magento setup:upgrade
php bin/magento setup:static-content:deploy -f
php bin/magento indexer:reindex
php bin/magento cache:clean
php bin/magento cache:flush

Run below URL

https://mage2db.com/john/index/index

How To Disable One-Page Checkout in Magento 2.x

Magento 2 One-Page Checkout, all required checkout information will be put on a single page. When On-Page Checkout is enabled, the entire checkout process takes place on a single page. Each section of the checkout information is expanded as needed Accordingly, Shoppers won’t be directed to another page to complete their checkout process, It is much more time-saving than the normal checkout process.

On-Page Checkout is enabled by default, if the Store Owner wants to integrate another third party checkout extension, it is necessary to disable One-Page Checkout.

There are following below Admin setting required to disable One-Page Checkout

Step [1] – Go STORES > Configuration, redirects Configuration section.

Step [2] – Click on Left Panel Sales > Checkout

Step [3] – Once Right Panel (Checkout Options) expanded

Step [4] – Set Enable On-Page Checkout to No, after unchecked Use system value