Month: December 2021

The following below solution for Relationship Between Products & Categories in Magento 2

Products may be assigned to zero or more categories

The following below solution for Magento 2.x store which will be selling in two countries. Each country has its own set of payment methods.

Create Two Websites as well as Two Store Views

Alexa.com announced, the company stopped offering new subscriptions on December 8th, 2020 & will shut down the site on May 1st, 2022

Twenty-five years ago, we founded Alexa Internet. After two decades of helping you find, reach, and convert your digital audience, we’ve made the difficult decision to retire Alexa.com on May 1, 2022. Thank you for making us your go-to resource for content research, competitive analysis, keyword research, and so much more.,” wrote Alexa Internet’s official statement.

For more info click below link

https://alexa.com retiring on May 1st, 2022

The following below layout customization need to declare in

app/code/VendorName/ModuleName/view/frontend/layout/default.xml

VendorName=Mage2db and ModuleName=John

Magento 2 module helper file used to include common method those are using in multiple places of that module.

Create Helper.php under your module.

Add below content in this file.

File Path=app/code/VendorName/ModuleName/Helper/Data.php

VendorName=Mage2db and ModuleName=John

<?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);
    }
}

in above Helper/Data.php , we have defined getStoreManagerData()

By using below code, anywhere inside module we can use getStoreManagerData()

$this->helperData->getStoreManagerData();

Finally once all command method defined inside Helper/Data.php, we can use anywhere inside module.

The following below Database Tables store Cart Price Rules

salesrule

salesrule_coupon

salesrule_coupon_aggregated

salesrule_coupon_aggregated_order

salesrule_coupon_aggregated_updated

salesrule_coupon_usage

salesrule_customer

salesrule_customer_group

salesrule_label

salesrule_product_attribute

salesrule_website

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 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 Magento 2 database tables store Catalog Price Rules

catalogrule

catalogrule_customer_group

catalogrule_group_website

catalogrule_group_website_replica

catalogrule_product

catalogrule_product_price

catalogrule_product_price_replica

catalogrule_product_replica

catalogrule_website

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