How to export ordered bundle as one line as xls?

  • Hi WordPressers,

    I have an issue when I’m exporting my orders to Excel.
    I would like to be able to export all my bundle products from my orders to excel, and only have one row for bundle products.

    example:
    Customer name ,Order number #12345 ,Item (Colorway, Size, Frame kit/complete, Customer provided note

    But when I’m exporting from Woo-commerce to excel it looks like this:

    Customer name ,Order number #12345 ,Item (Colorway, Size), Customer provided note

    Customer name ,Order number #12345 ,Item (Frame kit/complete), Customer provided note

    because it makes a row for every product in the basket.

    is there a way to export bundle order as one row in excel?

    Best Frederik.

Viewing 1 replies (of 1 total)
  • Plugin Author WPClever

    (@wpclever)

    Hi @frederiksoelver

    Please add below custom code (How to add custom code?):

    add_filter( 'woocommerce_order_get_items', 'woosb_exclude_bundled_from_order', 10, 1 );
function woosb_exclude_bundled_from_order( $items ) {
	foreach ( $items as $key => $item ) {
		if ( $item->meta_exists( '_woosb_parent_id' ) ) {
			unset( $items[ $key ] );
		}
	}

	return $items;
}
Viewing 1 replies (of 1 total)
  • The topic ‘How to export ordered bundle as one line as xls?’ is closed to new replies.