algol.plus

You’re welcome

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);
});

Hello

Please open section Setup Fields and set “Fill order details” = “1st row only”.

Hello

WooCommerce Subscriptions is complex plugin.

So we modify costs only once , when inital order placed (and new subscription created).
We don’t change anything in renewal orders, they created by “WooCommerce Subscriptions” based on existing subscription.

Hello

We fill this dropdown based on existing orders.

Please, create 2 fake orders (for these countries), wait 5 minutes and reload page with our plugin.

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”

//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(){
    global $woe_summary_products_headers_extra;
    //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']);
        $_SESSION['woe_summary_products'][$key] = $new_row;
    }
});

//Add customers to header
add_filter('woe_xls_header_filter_final', function($row){
   global $woe_summary_products_headers_extra;
   $row = array_merge($row, $woe_summary_products_headers_extra);
   return $row;
});

Hello

What theme do you use ?

if you use paid theme — submit it (zip file) as new ticket to https://algolplus.freshdesk.com/