algol.plus

hello

You added custom PHP code for ” Germanized Pro” plugin, but this plugin is not active on this website.

Please open section “Misc Settings” (at bottom) and remove PHP code.

Can you update the plugin now and check if you still see these errors ?

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, add this code to “Misc Settings” ( at bottom of the form).

add_filter('woe_skip_order_item', function($skip, $product, $item, $item_meta, $post){
return !empty($item['bundled_by']) ;
},10,5);

We don’t have control over Excel when it opens CSV, but you can use “Alt + H + O + A” shortcut.

About width for XLS format. Is option “Auto column width” on (inside section XLS)?

please, follow to https://docs.algolplus.com/algol_order_export/fields/
add key fridge
use code

add_filter('woe_get_order_value_fridge',function( $value,$order, $fieldname ) {
$lines = array();
foreach($order->get_items() as $item) {
$care_attrs = wc_get_product_terms( $item->get_product_id(), 'pa_care-transport', array( 'fields' => 'names' ) );
if(in_array('Fridge',$care_attrs) )
$lines[] = $item["name"]. " x " .$item["qty"];
}
return join(", ", $lines);
}, 10, 3 );

So it’s just product attribute ? and it’s not used in product variations ?

I’m sorry, but we don’t code such plugin, as

There’re many order importers already, like “WP All Import”.