Adding shipping cost as a row

Hello
1. please, visit https://docs.algolplus.com/algol_order_export/add-product-rows/
2. copy 2nd code
3. go back to export
4. add code to section “Misc settings”

thanks, Alex

Hi Alex,

Thank you very much. It worked really well. One more question. Is there a way to skip row creation if shipping cost is 0?

Thank you,

Cosmin

below line
foreach ( $order->get_items(‘shipping’) as $item_id=>$item ) {

add line
if($item["cost"] == 0 ) continue;

Thank you again @algolplus. Everything is working really nice.

One last question. Can we do the same thing for coupons?( adding them as a row, not a colum)

We tried to use Set up fields to export?->Add coupons as rows but this did nothing.

Thank you,

Cosmin

please, add this code to Misc Settings
?
//export coupons as Products
add_filter('woe_fetch_order_products', function ($products,$order,$labels, $format, $static_vals) {
$i = count ($products);
foreach ( $order->get_items('coupon') as $item_id=>$item ) {
$row = array();
$i++;
foreach ( $labels as $field => $label ) {
if ( $field == 'line_id' ) $row[ $field ] = $i;
elseif ( $field == 'sku' ) $row[ $field ] = $item->get_code();
elseif ( $field == 'name' ) $row['name'] = $item->get_name();
elseif ( $field == 'qty' ) $row['qty'] = 1;
elseif ( $field == 'line_subtotal' ) $row['line_subtotal'] = -$item->get_discount();
elseif ( $field == 'line_subtotal_tax' ) $row['line_subtotal_tax'] = -$item->get_discount_tax();
elseif ( $field == 'price' ) $row['item_price'] = -$item->get_discount();
elseif ( isset( $static_vals[ $field ] ) ) $row[ $field ] = $static_vals[ $field ];
}
$products[] = $row;
}
return $products;
}, 10, 5);

Hello,

Thank you again for your fast reply. I just got the chance to test it and everything looks good. One thing that we would like to modify if possible, would be to populate the discount amount value under the item cost column, at the moment this is empty for coupons.

Thank you,

Cosmin

just replace line

elseif ( $field == 'line_subtotal' ) $row['line_subtotal'] = -$item->get_discount();

with

elseif ( $field == 'price' ) $row['price'] = -$item->get_discount();