Item Meta Data

hi Jeff

Please, use >Setup Fields>Product order items>button “Add Field”.
You should see meta keys in the dropdown.

thanks, Alex

Hi @algolplus

This is good to know and close to what I was looking for. We have a lot of different products with different metadata sets. Instead of putting every possible metadata option in its own column(20+ columns), is there any way to have the system recognize and output the different metadata values in their own columns?

So for example, there would be three columns labeled Metadata 1, metadata 2, etc with the values of each metadata per product.

The P Order Item Metadata field already separates these metadata values by a | so I’m really wondering if there is any way to have them separated into different columns instead of just adding a | in between them.

Best,
Jeff

hi Jeff

please, follow to https://algolplus.freshdesk.com/support/solutions/articles/25000018287-add-calculated-field-for-product-

add keys metadata_1,metadata_2,metadata_3 (add more if it’s necessary!)
and use this PHP code.
thanks, Alex

add_filter( 'woe_fetch_order_product', function($row, $order, $item, $product, $item_meta) {
	$metas = WC_Order_Export_Data_Extractor::get_product_variation( $item, $order, $item->get_id(), $product );
	$metas = explode("|", $metas);
	foreach($metas as $pos=>$meta){
		$key = "metadata_" . ($pos+1);
		if(isset($row[$key]))$row[$key] = $meta;
	}
	return $row;
},10,5);