How to Add Company Column in Abandoned Carts Report in Magento 2

Magento 2 offers an abandoned carts report that lists all registered customers who have abandoned carts which is yet to be expired. The abandoned carts report grid lists the below details:

• Customer Name
• Email Address
• Number of products in the cart
• Cart Subtotal
• Applied Coupon
• Date created
• Date of the last update
• IP address

These details can help the store owner track the reason for the cart abandonment and strive for customer retention. Cart abandonment can cost the business all the efforts, time, and money put to bring the valuable traffic to the site. In March 2020, 88.05% of online shopping orders were abandoned – Statista To reduce this number, the store owners employ various tactics using the customer data that is collected by configuring customer accounts in Magento 2 store. It may happen, depending on the nature of the business, that some useful customer data is not included in the abandoned carts report in Magento 2 default grid. For example, the customer’s company name that is collected during registration can be helpful to decide their purchase power and including it in the abandoned carts report can make the task easier. To add company column in abandoned carts report in Magento 2 can be easy with the method given in this post. However, do not forget to first enable company name in customer account in Magento 2 from the admin panel. The default Abandoned carts report in Magento 2 looks something like this:

Stepwise method to add company column in abandoned carts report in Magento 2:

1. Create registration.php file at app\code\Vendor\Module directory
   1 2 3 4

   <?php use \Magento\Framework\Component\ComponentRegistrar; ComponentRegistrar::register(ComponentRegistrar::MODULE, ‘Vendor_Module’, __DIR__);

2. Create module.xml file at app\code\Vendor\Module\etc directory
   1 2 3 4 5

   <?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=“Vendor_Module” setup_version=“1.0.0”/> </config>

3. Create di.xml file at app\code\Vendor\Module\etc\adminhtml directory
   1 2 3 4

   <?xml version=“1.0”?> <config xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=“urn:magento:framework:ObjectManager/etc/config.xsd”>     <preference for=“Magento\Reports\Block\Adminhtml\Shopcart\Abandoned\Grid” type=“Vendor\Module\Block\Adminhtml\Shopcart\Abandoned\Grid” /> </config>

4. Create Grid.php at app\code\Vendor\Module\Block\Adminhtml\Shopcart\Abandoned directory
   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218

   <?php namespace Vendor\Module\Block\Adminhtml\Shopcart\Abandoned; class Grid extends \Magento\Reports\Block\Adminhtml\Grid\Shopcart {     protected $_quotesFactory;     public function __construct(         \Magento\Backend\Block\Template\Context $context,         \Magento\Backend\Helper\Data $backendHelper,         \Magento\Reports\Model\ResourceModel\Quote\CollectionFactory $quotesFactory,         array $data = []     ) {         $this->_quotesFactory = $quotesFactory;         parent::__construct($context, $backendHelper, $data);     }     protected function _construct()     {         parent::_construct();         $this->setId(‘gridAbandoned’);     }     protected function _prepareCollection()     {         $collection = $this->_quotesFactory->create();         $filter = $this->getParam($this->getVarNameFilter(), []);         if ($filter) {             $filter = base64_decode($filter);             parse_str(urldecode($filter), $data);         }         if (!empty($data)) {             $collection->prepareForAbandonedReport($this->_storeIds, $data);         } else {             $collection->prepareForAbandonedReport($this->_storeIds);         }         $this->setCollection($collection);         parent::_prepareCollection();         if ($this->_isExport) {             $collection->setPageSize(null);         }         $this->getCollection()->resolveCustomerNames();         return $this;     }     protected function _addColumnFilterToCollection($column)     {         $field = $column->getFilterIndex() ? $column->getFilterIndex() : $column->getIndex();         $skip = [‘subtotal’, ‘customer_name’, ’email’];         if (in_array($field, $skip)) {             return $this;         }         parent::_addColumnFilterToCollection($column);         return $this;     }     protected function _prepareColumns()     {         $this->addColumn(             ‘customer_name’,             [                 ‘header’ => __(‘Customer’),                 ‘index’ => ‘customer_name’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-name’,                 ‘column_css_class’ => ‘col-name’             ]         );         $this->addColumn(             ’email’,             [                 ‘header’ => __(‘Email’),                 ‘index’ => ’email’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-email’,                 ‘column_css_class’ => ‘col-email’             ]         );         //add Company field         $this->addColumn(             ‘company’,             [                 ‘header’ => __(‘Company’),                 ‘index’ => ‘company’,                 ‘sortable’ => false,                 ‘renderer’ => \Cozmot\Register\Block\Adminhtml\Grid\Column\Renderer\Company::class,                 ‘header_css_class’ => ‘col-company’,                 ‘column_css_class’ => ‘col-company’             ]         );         $this->addColumn(             ‘items_count’,             [                 ‘header’ => __(‘Products’),                 ‘index’ => ‘items_count’,                 ‘sortable’ => false,                 ‘type’ => ‘number’,                 ‘header_css_class’ => ‘col-number’,                 ‘column_css_class’ => ‘col-number’             ]         );         $this->addColumn(             ‘items_qty’,             [                 ‘header’ => __(‘Quantity’),                 ‘index’ => ‘items_qty’,                 ‘sortable’ => false,                 ‘type’ => ‘number’,                 ‘header_css_class’ => ‘col-qty’,                 ‘column_css_class’ => ‘col-qty’             ]         );         if ($this->getRequest()->getParam(‘website’)) {             $storeIds = $this->_storeManager->getWebsite($this->getRequest()->getParam(‘website’))->getStoreIds();         } elseif ($this->getRequest()->getParam(‘group’)) {             $storeIds = $this->_storeManager->getGroup($this->getRequest()->getParam(‘group’))->getStoreIds();         } elseif ($this->getRequest()->getParam(‘store’)) {             $storeIds = [(int)$this->getRequest()->getParam(‘store’)];         } else {             $storeIds = [];         }         $this->setStoreIds($storeIds);         $currencyCode = $this->getCurrentCurrencyCode();         $this->addColumn(             ‘subtotal’,             [                 ‘header’ => __(‘Subtotal’),                 ‘type’ => ‘currency’,                 ‘currency_code’ => $currencyCode,                 ‘index’ => ‘subtotal’,                 ‘sortable’ => false,                 ‘renderer’ => \Magento\Reports\Block\Adminhtml\Grid\Column\Renderer\Currency::class,                 ‘rate’ => $this->getRate($currencyCode),                 ‘header_css_class’ => ‘col-subtotal’,                 ‘column_css_class’ => ‘col-subtotal’             ]         );         $this->addColumn(             ‘coupon_code’,             [                 ‘header’ => __(‘Applied Coupon’),                 ‘index’ => ‘coupon_code’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-coupon’,                 ‘column_css_class’ => ‘col-coupon’             ]         );         $this->addColumn(             ‘created_at’,             [                 ‘header’ => __(‘Created’),                 ‘type’ => ‘datetime’,                 ‘index’ => ‘created_at’,                 ‘filter_index’ => ‘main_table.created_at’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-created’,                 ‘column_css_class’ => ‘col-created’             ]         );         $this->addColumn(             ‘updated_at’,             [                 ‘header’ => __(‘Updated’),                 ‘type’ => ‘datetime’,                 ‘index’ => ‘updated_at’,                 ‘filter_index’ => ‘main_table.updated_at’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-updated’,                 ‘column_css_class’ => ‘col-updated’             ]         );         $this->addColumn(             ‘remote_ip’,             [                 ‘header’ => __(‘IP Address’),                 ‘index’ => ‘remote_ip’,                 ‘sortable’ => false,                 ‘header_css_class’ => ‘col-ip’,                 ‘column_css_class’ => ‘col-ip’             ]         );         $this->addExportType(‘*/*/exportAbandonedCsv’, __(‘CSV’));         $this->addExportType(‘*/*/exportAbandonedExcel’, __(‘Excel XML’));         return parent::_prepareColumns();     }     /**      * Get rows url      *      * @param \Magento\Framework\DataObject $row      *      * @return string      */     public function getRowUrl($row)     {         return $this->getUrl(‘customer/index/edit’, [‘id’ => $row->getCustomerId(), ‘active_tab’ => ‘cart’]);     } }

5. Create Company.php at app\code\Vendor\Module\Block\Adminhtml\Grid\Column\Renderer and add below code
   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

   <?php namespace Vendor\Module\Block\Adminhtml\Grid\Column\Renderer; use Magento\Backend\Block\Context; use Magento\Customer\Model\CustomerFactory; use Magento\Framework\DataObject; class Company extends \Magento\Backend\Block\Widget\Grid\Column\Renderer\AbstractRenderer {     protected $customerFactory;     public function __construct(Context $context, array $data = array(),CustomerFactory $customerFactory) {         $this->customerFactory = $customerFactory;         parent::__construct($context, $data);     }     public function render(DataObject $row)     {         $customerFactory = $this->customerFactory->create();         $customerId = $row->getcustomer_id();         $customer = $customerFactory->load($customerId);         $Addresses = $customer->getAddresses();         foreach ($Addresses as $address){             return $address->getData(‘company’);         }     } }

That’s it. Now, if you’ll check, the abandoned carts report in Magento 2 will have the company column added: Any doubts about the solution can be mentioned in the Comments section below. I’d be happy to help you out. Also, do share the solution with the Magento community via social media. Thanks.]]>