Merging Exported Field Data

Hi biotrace,

Yes, this is possible. To do it you’d need to export the Order ID and then pass it through a function that gathers all of the required data and returns it in one string.

Here’s the function you’d use for your example:

function pmxe_get_whole_address ( $id ) {
	$custom_fields = get_post_custom( $id );
	$shipping2 = $custom_fields["_shipping_address_2"][0];
	$city = $custom_fields["_shipping_city"][0];
	$postcode = $custom_fields["_shipping_postcode"][0];
	return $shipping2 . ", " . $city . ", " . $postcode;
}

Screenshot: https://imgur.com/damGA5D

Excellent – That is fantastic. Again due to how our accounting software imports data, it also requires an empty row between each order. Is it possible to add row padding after each order entry?

Also, would this code reside in ../wp-includes/functions.php

Please disregard the question about where code should be added. I saw your screenshot after ??

What function would I need to use for First and Last name? Is there a reference table of functions that I can refer to?

Ahh, no edit button.

I have created some more functions based on your sample code and they are all working great.

The only question still remaining is if I can add a blank row after each order entry.

<?php
function pmxe_get_customer_name ( $id ) {
	$custom_fields = get_post_custom( $id );
	$first = $custom_fields["_shipping_first_name"][0];
	$last = $custom_fields["_shipping_last_name"][0];
	return $first . " " . $last;
}
?>

<?php
function pmxe_get_whole_address ( $id ) {
	$custom_fields = get_post_custom( $id );
	$shipping2 = $custom_fields["_shipping_address_2"][0];
	$shipping1 = $custom_fields["_shipping_address_1"][0];
	return $shipping2 . " - " . $shipping1;
}
?>

<?php
function pmxe_get_whole_address2 ( $id ) {
	$custom_fields = get_post_custom( $id );
	$city = $custom_fields["_shipping_city"][0];
	$state = $custom_fields["_shipping_state"][0];
	$postcode = $custom_fields["_shipping_postcode"][0];
	return $city . " " . $state . " " . $postcode;
}
?>

Hey biotrace.

You can create a blank row after each order entry with the following code:

add_filter( 'wp_all_export_csv_rows', 'wpai_wp_all_export_csv_rows', 10, 3 );
function wpai_wp_all_export_csv_rows( $articles, $options, $export_id ) {
	$articles[] = "";
        return $articles;
}