Mian Saleem yes, exactly column E. I just need to have the variant name and qty on that field so we can find the items faster.

Hello,

I get the code from repo. You can try replace the line 2232 - 2239 with following

$this->db
    ->select("date, reference_no, biller, customer, GROUP_CONCAT(CONCAT({$this->db->dbprefix('sale_items')}.product_name, ' ', {$this->db->dbprefix('product_variants')}.name, ' (', ROUND({$this->db->dbprefix('sale_items')}.quantity, {$this->Settings->qty_decimals}), ')') SEPARATOR '\n') as iname, grand_total, paid, payment_status", false)
    ->from('sales')
    ->join('sale_items', 'sale_items.sale_id=sales.id', 'left')
    ->join('warehouses', 'warehouses.id=sales.warehouse_id', 'left')
    ->join('product_variants', 'product_variants.id=sale_items.option_id', 'left')
    ->group_by('sales.id')
    ->order_by('sales.date desc');

I don’t have machine with php8 so I am unable to check this but it should add the variant name after products name in column E.

Thank you

Mian Saleem I have tried but the exported report are missing data and variant still not showing you could check my attached screenshot

here attachments

The item those are not showing maybe because they are not having any variants, so it might be a bit of query condition missing.

Mian Saleem so you have any idea about that ?

Hello,

I am not so sure but it should be due to new changes. Maybe you can try case statement, something like

$this->db
    ->select("date, reference_no, biller, customer, GROUP_CONCAT(CONCAT({$this->db->dbprefix('sale_items')}.product_name, (CASE WHEN {$this->db->dbprefix('sale_items')}.option_id > 0 THEN CONCAT(' ', {$this->db->dbprefix('product_variants')}.name) ELSE '' END), ' (', ROUND({$this->db->dbprefix('sale_items')}.quantity, {$this->Settings->qty_decimals}), ')') SEPARATOR '\n') as iname, grand_total, paid, payment_status", false)
    ->from('sales')
    ->join('sale_items', 'sale_items.sale_id=sales.id', 'left')
    ->join('warehouses', 'warehouses.id=sales.warehouse_id', 'left')
    ->join('product_variants', 'product_variants.id=sale_items.option_id', 'left')
    ->group_by('sales.id')
    ->order_by('sales.date desc');

Thank you

Mian Saleem Wonderful, It works.

Thank you very much