Differentiate Between Aamazon and WalMart

WalmartAamazon.com
1FounderWalmart was founded by Sam Walton in 1962 and incorporated on October 31, 1969 as Walmart Inc.Aamazon.com was founded by Jeff Bezos in 1994 and incorporated on 1994 as Amazon.com Inc.
2HeadquartersSeattle, Washington, United StatesBentonville,  United States
3ServicesWalmart offers chain of hypermarkets, discount department stores, and grocery stores.Amazon.com  offers e-commerce, cloud computing, digital streaming, and artificial intelligence. It is considered one of the Big Four tech companies, along with Google, Apple, and Microsoft.
4Serving CountriesWalmart offers eCommerce services in 10 countries: United States, Canada, Mexico ,Central America, United Kingdom, Japan,Argentina, Chile, Canada, and South AfricaAmazon.com offers eCommerce services in 17 countries: Austria, Australia, Belgium, Canada, China, France, Germany, India, Italy, Japan, Luxembourg, Mexico, Netherlands, Singapore, Spain, UK and US  by Dec, 2019
5No of Stores
11,847 properties throughout the world [ 27 countries ], of which 11,443 were retail stores & Walmart U.S. had a total of 4,743 stores throughout the United States as of January 31, 2021
Aamazon.com has 526 physical retail stores, also including 19 Amazon Books stores, four Amazon 4-Star stores and four Presented by Amazon outlets in USA.
6Retail Stores TypeWalmart offers 6 different types physical retail stores throughout the world
 [1] Walmart Supercenter:: offers  grocery and a GM (general merchandise) Department
 [2] Walmart Express:: Mobile Express Money (Walmart App) that enables Consumers to do money service transactions at Walmart 
 [3] Walmart Neighborhood Market:: offers grocery, fresh  meat, bakery and deli departments and pharmacies
 [4] Walmart Pharmacy:: offers quality Pharmacy Products at affordable prices
 [5] Walmart Fuel Store:: offers gas, diesel fuel at affordable prices 
Aamazon.com offers 4 different types physical retail stores in USA
[1] Amazon Books:: offers Books, Devices, Merchandise
[2] Amazon 4 Star:: offers Books, Devices, Merchandise
[3] Amazon Go:: offers Breakfast, Lunch, Dinner
 [4] Aamzon PoP UP::  offers Merchandise
7Membership FeeWalmart does not charge any membership fee for online purchases.Amazon.com  Prime membership costs $12.99 per month or a once-off annual fee of $9
8No. of ProductsWalmart offers total 46.1 million products across 11766 storesAmazon.com offers  more than 606 million products available online and adds more than 50 000 products per day.
9Owned byWalmart owned by Walton family [51% Share Holding]Amazon.com, owned by MacKenzie Bezos(Ex-wife of Jeff Bezos) having 25% Share Holding and Jeff Bezos having 11% Share Holding

Magento 2 Localhost Admin not opened, Database & Files Taken From Server

If you are taking Magento2 [Files + Database] from server & setup on localhost & while trying to open Admin , It will be not opened, due to cookie domain values specified for a particular domain name.

Solution: There are following below command need to ben run

[1]-: Run select query , to check how many cookie domain values are present in Database

select * from core_config_data 
WHERE path = "web/cookie/cookie_domain"

[2]-: Run update query:

To update all path = “web/cookie/cookie_domain” into 0

update core_config_data
set value="0" 
WHERE path = "web/cookie/cookie_domain"

Once run query all path = “web/cookie/cookie_domain” values will be converted into 0, check again by using select query

select * from core_config_data 
WHERE path = "web/cookie/cookie_domain"
Note: Here only one cookie domain value, if some cases multi store, there
are multiple path = "web/cookie/cookie_domain" & each path value having domain name exists, so you need to converts all 
path = "web/cookie/cookie_domain" values into 0

Finally, localhost Magento 2 admin issue has been resolved.

Magento 2 URL Rewrites Regenerate

There are following below steps to do URL rewrites for Product, Category, CMS Pages

[1]-: The following below command to delete Product, Category & CMS Page URLs from

Table url_rewrite & catalog_url_rewrite_product_category

delete from url_rewrite;
delete from catalog_url_rewrite_product_category;

[2]-: The following below command to install by using Extension

OlegKoval_RegenerateUrlRewrites

that is responsible to regenerate Product, Category & CMS Page URLs

Install
composer require olegkoval/magento2-regenerate-url-rewrites

Once command done, It is stored location in side Vendor folder as below

[3]-: The following below command to enable olegkoval Extension , that is responsible to regenerate Product, Category & CMS Page URLs

Enable
php bin/magento module:enable OlegKoval_RegenerateUrlRewrites

[4]-: The following below command to regenerate Product, Category & CMS Page URLs

Regenerate URL
php bin/magento ok:urlrewrites:regenerate

Note: If you use some external cache mechanisms (e.g.: Redis, Varnish, etc.) - please, refresh this external cache.
Finished indicates URLs rewrite generate command successfully all URLs

Finally, Website / Store, Product, Category & CMS Page URLs has been regenerated.

Magento 2 Converts Simple Product To Virtual Product

Step-1: By Using Magento 2 Admin

  • Go To Magento 2 Admin
  • Catalog–Products: select Simple Products, which you want to converts into Virtual products.
  • Click on Edit
  • Go To Weight: “The item has weight” for Simple Product already mentioned.
  • To Converts into Virtual Product, “select Item has no weight”
  • Step-2: By Using Database SQL Query
update catalog_product_entity 
set type_id = 'virtual' 
where type_id = 'simple'

Note: Be careful, this query will be converted all Simple Products To Virtual Products
Note: If user wants to convert specific Simple Products To Virtual Products, below query need to run

update catalog_product_entity 
set type_id = 'virtual' 
where type_id = 'simple' and sku in ('BSX55MOLCG','BSX55MOLCLW','BSX55MOLCMW','BSX55MOLWWH')

Magento 2 Converts Virtual Products To Simple Products

Step-1: By Using Magento 2 Admin,

  • Go To Magento 2 Admin
  • Catalog–Products: select Virtual Products, which you want to converts into simple products.
  • Click on Edit
  • Go To Weight: “The item has no weight” for Virtual Product already mentioned.
  • To Converts into Simple Product, select Item has weight & put
    weight value.
  • Finally Click on Save button & Virtual Product will be converted into Simple
    Product.

Step-2: By Using Database SQL Query

update catalog_product_entity 
set type_id = 'simple' 
where type_id = 'virtual'

Note: Be careful, this query will be converted all Simple Products To Virtual Products
Note: If user wants to convert specific Simple Products To Virtual Products, below query need to run

update catalog_product_entity 
set type_id = 'simple' 
where type_id = 'virtual' and sku in ('BSX55MOLCG','BSX55MOLCLW','BSX55MOLCMW','BSX55MOLWWH')

Magento 2 Popular Websites

  • https://www.paulsmith.com
  • https://www.omegawatches.com
  • https://www.paperchase.com
  • https://www.paulsmith.com
  • https://www.paperchase.com
  • https://www.cyclerepublic.com
  • https://www.bulkpowders.co.uk
  • https://solgirl.com
  • https://www.coxandcox.co.uk
  • https://www.sigmabeauty.com
  • https://www.bulkpowders.co.uk
  • https://www.boodles.com
  • https://royalmen.com
  • https://rattanfurnitureuk.co.uk
  • https://girav.com
  • https://addapearl.com
  • https://onlinespyshop.co.uk

Magento 2.x Truncate Essential Tables Before Going Production or Live

There are following below Magento 2 tables need to be deleted, before going to Production or Live

--SET FOREIGN_KEY_CHECKS = 0 Compulsory otherwise Foreign Key Based Table will be not deleted --

  SET FOREIGN_KEY_CHECKS = 0;

-- Starts Truncate Quote & Sales Order & Other Tables --

TRUNCATE TABLE `gift_message`;
TRUNCATE TABLE `quote`;
TRUNCATE TABLE `quote_address`;
TRUNCATE TABLE `quote_address_item`;
TRUNCATE TABLE `quote_id_mask`;
TRUNCATE TABLE `quote_item`;
TRUNCATE TABLE `quote_item_option`;
TRUNCATE TABLE `quote_payment`;
TRUNCATE TABLE `quote_shipping_rate`;
TRUNCATE TABLE `reporting_orders`;
TRUNCATE TABLE `sales_bestsellers_aggregated_daily`;
TRUNCATE TABLE `sales_bestsellers_aggregated_monthly`;
TRUNCATE TABLE `sales_bestsellers_aggregated_yearly`;
TRUNCATE TABLE `sales_creditmemo`;
TRUNCATE TABLE `sales_creditmemo_comment`;
TRUNCATE TABLE `sales_creditmemo_grid`;
TRUNCATE TABLE `sales_creditmemo_item`;
TRUNCATE TABLE `sales_invoice`;
TRUNCATE TABLE `sales_invoiced_aggregated`;
TRUNCATE TABLE `sales_invoiced_aggregated_order`;
TRUNCATE TABLE `sales_invoice_comment`;
TRUNCATE TABLE `sales_invoice_grid`;
TRUNCATE TABLE `sales_invoice_item`;
TRUNCATE TABLE `sales_order`;
TRUNCATE TABLE `sales_order_address`;
TRUNCATE TABLE `sales_order_aggregated_created`;
TRUNCATE TABLE `sales_order_aggregated_updated`;
TRUNCATE TABLE `sales_order_grid`;
TRUNCATE TABLE `sales_order_item`;
TRUNCATE TABLE `sales_order_payment`;
TRUNCATE TABLE `sales_order_status_history`;
TRUNCATE TABLE `sales_order_tax`;
TRUNCATE TABLE `sales_order_tax_item`;
TRUNCATE TABLE `sales_payment_transaction`;
TRUNCATE TABLE `sales_refunded_aggregated`;
TRUNCATE TABLE `sales_refunded_aggregated_order`;
TRUNCATE TABLE `sales_shipment`;
TRUNCATE TABLE `sales_shipment_comment`;
TRUNCATE TABLE `sales_shipment_grid`;
TRUNCATE TABLE `sales_shipment_item`;
TRUNCATE TABLE `sales_shipment_track`;
TRUNCATE TABLE `sales_shipping_aggregated`;
TRUNCATE TABLE `sales_shipping_aggregated_order`;
TRUNCATE TABLE `tax_order_aggregated_created`;
TRUNCATE TABLE `tax_order_aggregated_updated`;

-- Finish Truncate Quote & Sales Order Tables --

-- Truncate Customer tables

-- Starts Truncate Customer Data & Customer Address Tables --

TRUNCATE TABLE `customer_address_entity`;
TRUNCATE TABLE `customer_address_entity_datetime`;
TRUNCATE TABLE `customer_address_entity_decimal`;
TRUNCATE TABLE `customer_address_entity_int`;
TRUNCATE TABLE `customer_address_entity_text`;
TRUNCATE TABLE `customer_address_entity_varchar`;
TRUNCATE TABLE `customer_entity`;
TRUNCATE TABLE `customer_entity_datetime`;
TRUNCATE TABLE `customer_entity_decimal`;
TRUNCATE TABLE `customer_entity_int`;
TRUNCATE TABLE `customer_entity_text`;
TRUNCATE TABLE `customer_entity_varchar`;
TRUNCATE TABLE `customer_grid_flat`;
TRUNCATE TABLE `customer_log`;
TRUNCATE TABLE `customer_log`;
TRUNCATE TABLE `customer_visitor`;
TRUNCATE TABLE `persistent_session`;
TRUNCATE TABLE `wishlist`;
TRUNCATE TABLE `wishlist_item`;
TRUNCATE TABLE `wishlist_item_option`;

-- Finish Truncate Customer Data & Customer Address Tables --


-- Starts Truncate Review tables --

TRUNCATE TABLE `review`;
TRUNCATE TABLE `review_detail`;
TRUNCATE TABLE `review_entity_summary`;
TRUNCATE TABLE `review_store`;

-- Finish Truncate Review tables --

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 Database Table Store Patches

Single Sign-on (SSO)

Single Sign-on (SSO):: It is an authentication process that allow users to access multiple applications with same login credentials of Magento 2. Using this user can enter the login credentials in the third-party application and be logged in to Magento 2 store simultaneously.

“Single sign-on is an authentication method that allows a user to log in with a single ID and password to multiples applications simultaneously”

“Single Credential that enables users to log in to multiple applications and websites”

This allows faster access to applications. The customers can use their existing credentials for logging into various third-party applications such as UVdesk, The user can use one set of credentials for various platforms and won’t have to remember multiple passwords for each login.

Magento 2 using multiple stores, blog etc., by using single User ID / Password, user can enable to login multiple Magento 2 stores & blog

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


While Installing Magento 2 getting this issue
Windows 10, XAMPP, WAMP
This issue with All Magento version as 2.2.X,  Magento2.3.X,  Magento 2.4.X
error message Module 'Magento_Theme': [ERROR] InvalidArgumentException: Wrong file in D:\xampp\htdocs\magento2\vendor\magento\framework\Image\Adapter\Gd2.php:64 Stack trace: #0 D:\xampp\htdocs\magento2\vendor\magento\framework\Image.php(55): Magento\Framework\Image\Adapter\Gd2->open('C:/wamp64/www/m...') #1 D:\xampp\htdocs\magento2\vendor\magento\framework\Image.php(36): Magento\Framework\Image->open() #2 D:\xampp\htdocs\magento2\vendor\magento\framework\ObjectManager\Factory\AbstractFactory.php(121): Magento\Framework\Image->__construct(Object(Magento\Framework\Image\Adapter\Gd2), 'C:/wamp64/www/m...') #3 D:\xampp\htdocs\magento2\vendor\magento\framework\ObjectManager\Factory\Dynamic\Developer.php(66): Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\Framewo...', Array) #4 D:\xampp\htdocs\magento2\vendor\magento\framework\ObjectManager\ObjectManager.php(56): Magento\Framework\ObjectManager\Factory\Dynamic\Developer->create('Magento\Framewo...', Array) #5 D:\xampp\htdocs\magento2\vendor\magento\framework\Image\Factory.php(47): Magento\Framework\ObjectManager\ObjectManager->create('Magento\Framewo...', Array) #6 D:\xampp\htdocs\magento2\vendor\magento\framework\View\Design\Theme\Image.php(127): Magento\Framework\Image\Factory->create('C:/wamp64/www/m...') #7 D:\xampp\htdocs\magento2\vendor\magento\module-theme\Model\Theme\Registration.php(135): Magento\Framework\View\Design\Theme\Image->createPreviewImage('C:/wamp64/www/m...') #8 D:\xampp\htdocs\magento2\vendor\magento\module-theme\Model\Theme\Registration.php(114): Magento\Theme\Model\Theme\Registration->_savePreviewImage(Object(Magento\Theme\Model\Theme\Data)) #9 D:\xampp\htdocs\magento2\vendor\magento\module-theme\Model\Theme\Registration.php(73): Magento\Theme\Model\Theme\Registration->_registerThemeRecursively(Object(Magento\Theme\Model\Theme\Data)) #10 D:\xampp\htdocs\magento2\vendor\magento\module-theme\Setup\Patch\Data\RegisterThemes.php(47): Magento\Theme\Model\Theme\Registration->register() #11 D:\xampp\htdocs\magento2\vendor\magento\framework\Setup\Patch\PatchApplier.php(162): Magento\Theme\Setup\Patch\Data\RegisterThemes->apply() #12 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(1023): Magento\Framework\Setup\Patch\PatchApplier->applyDataPatch('Magento_Theme') #13 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(890): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data', Array) #14 [internal function]: Magento\Setup\Model\Installer->installDataFixtures(Array) #15 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(371): call_user_func_array(Array, Array) #16 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Controller\Install.php(109): Magento\Setup\Model\Installer->install(Array) #17 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Controller\AbstractActionController.php(83): Magento\Setup\Controller\Install->startAction() #18 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #19 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #20 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Controller\AbstractController.php(117): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #21 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #22 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #23 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #24 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Application.php(339): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #25 D:\xampp\htdocs\magento2\setup\index.php(39): Laminas\Mvc\Application->run() #26 {main} Next Magento\Framework\Setup\Exception: Unable to apply data patch Magento\Theme\Setup\Patch\Data\RegisterThemes for module Magento_Theme. Original exception message: Wrong file in D:\xampp\htdocs\magento2\vendor\magento\framework\Setup\Patch\PatchApplier.php:170 Stack trace: #0 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(1023): Magento\Framework\Setup\Patch\PatchApplier->applyDataPatch('Magento_Theme') #1 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(890): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data', Array) #2 [internal function]: Magento\Setup\Model\Installer->installDataFixtures(Array) #3 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Model\Installer.php(371): call_user_func_array(Array, Array) #4 D:\xampp\htdocs\magento2\setup\src\Magento\Setup\Controller\Install.php(109): Magento\Setup\Model\Installer->install(Array) #5 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Controller\AbstractActionController.php(83): Magento\Setup\Controller\Install->startAction() #6 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(321): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #7 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #8 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Controller\AbstractController.php(117): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #9 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #10 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(321): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #11 D:\xampp\htdocs\magento2\vendor\laminas\laminas-eventmanager\src\EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #12 D:\xampp\htdocs\magento2\vendor\laminas\laminas-mvc\src\Application.php(339): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #13 D:\xampp\htdocs\magento2\setup\index.php(39): Laminas\Mvc\Application->run() #14 {main}

Solution: Please replace below method

Find validateURLScheme function in vendor\magento\framework\Image\Adapter\Gd2.php file. at line 96. Replace function with this: !file_exists($filename)

Replace existing validateURLScheme function with modified validateURLScheme function as per below code

private function validateURLScheme(string $filename) : bool
  {
      $allowed_schemes = ['ftp', 'ftps', 'http', 'https'];
      $url = parse_url($filename);
      if ($url && isset($url['scheme']) && !in_array($url['scheme'], $allowed_schemes) && !file_exists($filename)) {
          return false;
      }

      return true;
  }

Finally, Magento 2 Installation will be completed 100% after above changes

Other Important Magento 2.X Link

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


Magento 2.4.4 Features


Magento 2.4.4 Installation Steps


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’