Export Custom data in order item meta table

Hello

Please, use >Setup Fields>Product Order Items>Add Field.

The button “Add Field” shows a bit different keys for each section.

thanks, Alex

I have tried that. for example: I have added custom_field meta key. custom_field is not available in the dropdown. I tried entering it manually in the text field given below the dropdown. But under that column I can’t see any data after I export.

do you see this meta_key in table wp_woocommerce_order_itemmeta ?

Yeah, I have a field for email address. I have saved the value to item meta with meta_key attendee_email_address after the purchase is done. but I am unable to export it.

do you use “Add Field” in section “Product Order Items” ?

Oh Sorry, I was adding the field in the section “common”. I am able to see the fields in “product order items” section. Thank You.

Is there any way I can get the data attendee_email_address for the same order when I refund it? When I export it, I am not able to see the email for refunded items.

Please, open section Filter By Product and turn off “Skip fully refunded items”

It is already turnoff.

For the refunded items I can see the billing info. but I can’t see the custom fields data in the exported file.

please, submit your settings as new ticket to https://algolplus.freshdesk.com/
use tab “Tools” to get them.

I’ll reply to ticket later today.

item meta attendee_email_address was assigned to original item ,
so we had to add some code to section “Misc Settings” to get correct value

add_filter('woe_get_order_product_value_attendee_email_address', function ($value, $order, $item, $product,$item_meta) {
	$original_item_id = $item->get_meta( '_refunded_item_id', true );
	if($original_item_id) {
		$value = wc_get_order_item_meta( $original_item_id, 'attendee_email_address', true );
	}
	return $value;
}, 10, 5);

• This reply was modified 3 years, 3 months ago by algol.plus.