Total Posts: 4
I have successfully added the SKU column to my order grid, and am able to sort/filter by SKU. When the code is implemented, there is only one page of results available, even though there are 40,000k orders in the system. When I sort by a specific order status, it may show 150+ orders, but it only says there are 3-5 records.
Below is the code that is causing the problem, but I can\’t figure out why.
$collection = Mage::getResourceModel($this->_getCollectionClass())
\'sku\' => new Zend_Db_Expr(\'group_concat(`sales/order_item`.sku SEPARATOR \",\")\'),
\'names\' => new Zend_Db_Expr(\'group_concat(`sales/order_item`.name SEPARATOR \",\")\'),
Any input would be great!