Export Clients as columns

2. Do you use code https://docs.algolplus.com/algol_order_export/export-products-as-columns/ ?

please replace last function with this version

//4
function analyze_products_add_columns($phpExcel,$formatter) {
    // add products as titles
    foreach($this->product_columns as $pos=>$text){
        $formatter->objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow( $pos+$this->headers_added, 1, $text );
        //add formulas for total
        $L = PHPExcel_Cell::stringFromColumnIndex($pos + $this->headers_added);
        $row = $formatter->last_row;
        $formatter->objPHPExcel->getActiveSheet()->setCellValue( $L. ($row+1), "=SUM({$L}2:{$L}$row)");
    }
    //make first bold
    $last_column = $formatter->objPHPExcel->getActiveSheet()->getHighestDataColumn();
    $formatter->objPHPExcel->getActiveSheet()->getStyle( "A1:" . $last_column . "1" )->getFont()->setBold( true );
}

2. I updated 2nd code (for CSV) at page https://docs.algolplus.com/algol_order_export/export-products-as-columns/

You must uncomment line 82!

1. How can we implement the same but clients as columns and products as rows instead?
   Please, mark checkbox ‘Summary report by products’ and add this code to “Misc Settings”.
   version for CSV format

//Version for CSV !

//Save header to array , don't print now !
add_filter( "woe_csv_header_filter", function($data ){
    $_SESSION['woe_summary_products_header'] = $data;
    return [];
});

//Record customers for product
add_action( "woe_summary_products_add_item", function ($key, $product_item, $order, $item ) {
    //gather names
    $name = $order->get_billing_first_name() . " " . $order->get_billing_last_name();
    if( empty($_SESSION['woe_summary_products'][$key]['customer-names']) )
        $_SESSION['woe_summary_products'][$key]['customer-names'] = array();
    //and qty
    $_SESSION['woe_summary_products'][$key]['customer-names'][] = $name;
    if( empty($_SESSION['woe_summary_products'][$key][$name]) )
        $_SESSION['woe_summary_products'][$key][$name] = 0;
    $_SESSION['woe_summary_products'][$key][$name] += $product_item['qty'];
},10,4);

//Rebuild product summary rows
add_action( 'woe_summary_before_output', function(){
    //get customers
    $names = array();
    foreach($_SESSION['woe_summary_products'] as $data){
        $names = array_merge($names, $data['customer-names']);
    }
    $names = array_unique($names);
    sort($names);
    $woe_summary_products_headers_extra = $names;

    //rebuild rows
    foreach($_SESSION['woe_summary_products'] as $key=>$data){
        $new_row = $data;
        foreach($names as $name) {
            if( !isset($new_row[$name]) )//no data
                $new_row[$name.'-qty'] = "";
            else {//move to correct column
                $new_row[$name.'-qty'] = $new_row[$name];
                unset($new_row[$name]);
            }
        }
        unset($new_row['customer-names']);
        //move field summary_report_total_qty at end  $new_row
        $value = $new_row['summary_report_total_qty'];
        unset($new_row['summary_report_total_qty']);
        $new_row['summary_report_total_qty'] = $value;
        $_SESSION['woe_summary_products'][$key] = $new_row;
    }

    //make new header now
    $row =$_SESSION['woe_summary_products_header'];
    $pos = array_search("Summary Report Total Quantity", $row);
    if($pos!==false) unset($row[$pos]);
    $row = array_merge($row, $woe_summary_products_headers_extra,["Summary Report Total Quantity"]);
    array_unshift($_SESSION['woe_summary_products'],$row);
});

2. I updated 2nd code (for CSV) at page https://docs.algolplus.com/algol_order_export/export-products-as-columns/
Both issues fixed.

You must uncomment line 99!

2.Yes, scheduled jobs run in this mode

1. please, replace code with this version , I marked change with “NEW”

//4
function analyze_products_add_columns($phpExcel,$formatter) {
    // add products as titles
    foreach($this->product_columns as $pos=>$text){
        $formatter->objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow( $pos+$this->headers_added, 1, $text );
        //add formulas for total
        $L = PHPExcel_Cell::stringFromColumnIndex($pos + $this->headers_added);
        $row = $formatter->last_row;
        $formatter->objPHPExcel->getActiveSheet()->setCellValue( $L. ($row+1), "=SUM({$L}2:{$L}$row)");
    }
    $formatter->objPHPExcel->getActiveSheet()->setCellValue( "A". ($row+1), "Total");//NEW
    //make first bold
    $last_column = $formatter->objPHPExcel->getActiveSheet()->getHighestDataColumn();
    $formatter->objPHPExcel->getActiveSheet()->getStyle( "A1:" . $last_column . "1" )->getFont()->setBold( true );
}

please, submit your settings as new ticket to https://algolplus.freshdesk.com/

use tab “Tools” to get these settings.