3x Magento Master
From Magento 2.4, New Feature with Out of the box called a login as Customer.
This feature is useful for store administrators only. Store admin can access customer’s order history, check wishlist items, and customer-related information from the frontend by login behalf of the customer when they click on login as the customer button from the admin panel. Continue reading “How to enable Login as Customer Settings in Magento 2.4?”
In Magento 2 Sometimes we have added an extra column in the table for extended functionality in module and in future, we have removed that functionality so we need to remove extra column field from a database table.
I have added one field name gst in sales_order table and I want to remove extra field from table in future. You can remove field using dropColumn() in UpgradeSchema.php file.
Using below code snippet you can remove already existed column field from table.
Upgrade the setup_version number of module from module.xml file. An older version number is 1.0.1 so I have added new version 1.0.2 in module.xml file
Path: Magento22/app/code/Rbj/Training/etc/module.xml
<?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="Rbj_Training" setup_version="1.0.2"/> </config>
Create UpgradeSchema.php file under Setup folder in your module.
Path: Magento22/app/code/Rbj/Training/Setup/UpgradeSchema.php
<?php
namespace Rbj\Training\Setup;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\Setup\UpgradeSchemaInterface;
/**
* Upgrade the Sales_Order Table to remove extra field
*/
class UpgradeSchema implements UpgradeSchemaInterface
{
public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
$setup->startSetup();
if (version_compare($context->getVersion(), '1.0.2', '<')) {
$setup->getConnection()->dropColumn($setup->getTable('sales_order'), 'gst');
}
$setup->endSetup();
}
}
Run command from root directory of your project,
php bin/magento setup:upgrade
If you want to add the field in table Add New Field in Database Table Magento 2
If you want to rename/change column field name, Refer link Rename Column name in Table Magento 2
Magento 2 Complete guide to the list of available events that will be used in daily routine as a Magento developer to trigger event-specific tasks at a time of Development.
You can use any required events from the Core module to accomplish your requirements. Define events in the events.xml file, Create an observer.php file to do specific actions for an event.
You can also create your own custom event to accomplish your task by link, Create Custom Events. Continue reading “A Complete List of all events in Magento 2”