Adding fields

Hi, Ankit!

Could I just nag you a bit with help on setting up the customer billing address field?

I have this in the add_col function:

$cols['wc_settings_tab_customer_address'] = __( '<<what is the meta key here?>>', 'mytheme' );

I have this in the setttings tab function:

$settings['customer_address'] = array(
  'name' => __( 'Customer Address', 'woocommerce-simply-order-export' ),
  'type' => 'checkbox',
  'desc' => __( 'Customer Address', 'woocommerce-simply-order-export' ),
  'id' => 'wc_settings_tab_customer_address'
);

I have this in the csv_write function:

if( !empty( $fields['wc_settings_tab_customer_address'] ) && $fields['wc_settings_tab_customer_address'] === true ){
  $customer_address = get_post_meta( $od->id, '<<what is the meta key here?>>', true );
  array_push( $csv, $customer_address );
};

I’m wondering what the correct meta key is for the billing address?

Ah, nevermind I solved it in the meantime. This did the trick:

$customer_address = $od->get_formatted_billing_address();

Nice plugin, btw!

Hi Swissmiss85,

I am happy to announce that add-on for this plugin has been released, it is available at: https://sharethingz.com/woocommerce-simply-order-export-add-on/

Let me know if you have any query.

Regards
Ankit G.

Hi Ankit

I am trying to add a Product Category to the export file.

The result is Product Category appearing on the Order Export page, the title appearing on the Excel sheet, but the column being blank.

Do you have any advice? This is my attempt:

function wpg_add_columns($cols) {

$cols[‘wc_settings_tab_product_cat’] = __(‘Product Category’, ‘mytheme’);
return $cols;
}
add_filter(‘wpg_order_columns’, ‘wpg_add_columns’);

function wpg_add_fields($settings) {

$settings[‘product_cat’] = array(
‘name’ => __( ‘Product Category’, ‘woocommerce-simply-order-export’ ),
‘type’ => ‘checkbox’,
‘desc’ => __( ‘Product Category’, ‘woocommerce-simply-order-export’ ),
‘id’ => ‘wc_settings_tab_product_cat’
);

return $settings;

}
add_filter(‘wc_settings_tab_order_export’, ‘wpg_add_fields’);

function csv_write( &$csv, $od, $fields ) {

if( !empty( $fields[‘wc_settings_tab_product_cat’] ) && $fields[‘wc_settings_tab_product_cat’] === true ){
array_push( $csv, strip_tags($od->get_product_cat()) );
}

}
add_action(‘wpg_before_csv_write’, ‘csv_write’, 10, 3);

Hi Ankit

I am trying to add a Product Category to the export file.

The result is Product Category appearing on the Order Export page, the title appearing on the Excel sheet, but the column being blank.

Do you have any advice? This is my attempt:

function wpg_add_columns($cols) {

$cols['wc_settings_tab_product_cat'] = __('Product Category', 'mytheme');
return $cols;
}
add_filter('wpg_order_columns', 'wpg_add_columns');

function wpg_add_fields($settings) {

$settings['product_cat'] = array(
'name' => __( 'Product Category', 'woocommerce-simply-order-export' ),
'type' => 'checkbox',
'desc' => __( 'Product Category', 'woocommerce-simply-order-export' ),
'id' => 'wc_settings_tab_product_cat'
);

return $settings;

}
add_filter('wc_settings_tab_order_export', 'wpg_add_fields');

function csv_write( &$csv, $od, $fields ) {

if( !empty( $fields['wc_settings_tab_product_cat'] ) && $fields['wc_settings_tab_product_cat'] === true ){
array_push( $csv, strip_tags($od->get_product_cat()) );
}

}
add_action('wpg_before_csv_write', 'csv_write', 10, 3);

Please change csv_write function to.

function csv_write( &$csv, $od, $field ) {

	switch( $field ) {

		case 'wc_settings_tab_product_cat':
		 array_push( $csv, strip_tags($od->get_product_cat()) );
		break;

		default :
			break;
	}

}
add_action('wpg_add_values_to_csv', 'csv_write', 10, 3);

Hope this would help.

Regards
Ankit

i just tried that one, but still the column is blank. and to add i did purchase your add-on plugin. i was sad i didn’t get what i expect to appear on my csv file. ??

Hi amareggae,

Can you please let me know what you are trying to do with the code? Please elaborate.

Hi @ankit Gade,

I’m trying to add my custom field on the .csv file using the codes you put here. Everything works, but the .csv file that is showing the new column blank.

Here is my code:

function wpg_add_columns($cols) {

	$cols['wc_settings_tab_pessoa_contato'] = __('Pessoa de Contato', 'mytheme');
	return $cols;
}
add_filter('wpg_order_columns', 'wpg_add_columns');

function wpg_add_fields($settings) {

	$settings['pessoa_contato'] = array(
				'name' => __( 'Pessoa de Contato', 'woocommerce-simply-order-export' ),
				'type' => 'checkbox',
				'desc' => __( 'Nome e Telefone da Pessoa de Contato', 'woocommerce-simply-order-export' ),
				'id'   => 'wc_settings_tab_pessoa_contato'
				);

	return $settings;

}
add_filter('wc_settings_tab_order_export', 'wpg_add_fields');

function csv_write( &$csv, $od, $fields ) {

	if( !empty( $fields['wc_settings_tab_pessoa_contato'] ) && $fields['wc_settings_tab_pessoa_contato'] === true ){
		$pessoa_contato = get_post_meta( $od->id, 'Pessoa de Contato', true );
		array_push( $csv, $pessoa_contato );
	}

}
add_action('wpg_before_csv_write', 'csv_write', 10, 3);

I’m not able to write my custom field into the csv file. Could you please help me?

Hi,

You can use the add-on plugin at: https://sharethingz.com/downloads/woocommerce-simply-order-export-add-on/

Once add-on is installed, you can add following code to functions.php file of your theme.

function my_wsoe_hooks() {
	add_filter( 'wsoe_filter_fields', 'my_add_fields' );
}
add_action( 'init', 'my_wsoe_hooks', 8 );

function my_add_fields( $fields ) {

	$fields['wc_settings_tab_pessoa_contato'] = __('Pessoa de Contato', 'woocommerce-simply-order-export');
}

Hope this helps

Hi Ankit.

I have used the code from post directly before mine and cannot get the custom fields added.

Using the code supplied by lumlp lumlp ads the field to the wsoe admin page but does not output anything to the CSV.

If i remove lump lump code and place your code:

function my_wsoe_hooks() {
add_filter( ‘wsoe_filter_fields’, ‘my_add_fields’ );
}
add_action( ‘init’, ‘my_wsoe_hooks’, 8 );

function my_add_fields( $fields ) {

$fields[‘wc_settings_tab_pessoa_contato’] = __(‘Pessoa de Contato’, ‘woocommerce-simply-order-export’);
}

It breaks the plugin and removes all the options from the addon plugin. It only lists the option that are available on the standard plugin.

I have the ad on plugin.

Any help would be great.

Thanks

Hi,

Can you please use this corrected code and check if issue is resolved?

function my_wsoe_hooks() {
	add_filter( 'wsoe_filter_fields', 'my_add_fields' );
}
add_action( 'init', 'my_wsoe_hooks', 8 );

function my_add_fields( $fields ) {

	$fields['wc_settings_tab_pessoa_contato'] = __('Pessoa de Contato', 'woocommerce-simply-order-export');

return $fields;

}

Hi Ankit.

Thanks for your replay. The ammended code does add the field to soe admin, but does not output to csv. The title outputs but not the content.

Here is the full code snippit.

/*WOCOMMERCE ADD FIELD */

/**

* Add the field to the checkout

*/

add_action( ‘woocommerce_after_order_notes’, ‘my_custom_checkout_field’ );

function my_custom_checkout_field( $checkout ) {

echo ‘<div id=”my_custom_checkout_field”><h2>’ . __(‘How did you hear about Amawrap?’) . ‘</h2>’;

woocommerce_form_field( ‘hear_about_us’, array(

‘type’ => ‘text’,

‘class’ => array(‘my-field-class form-row-wide’),

‘label’ => __(‘How did you hear about Amawrap?’),

‘placeholder’ => __(‘E.g Google’),

), $checkout->get_value( ‘hear_about_us’ ));

echo ‘</div>’;

}

/**

* Process the checkout

*/

add_action(‘woocommerce_checkout_process’, ‘my_custom_checkout_field_process’);

function my_custom_checkout_field_process() {

// Check if set, if its not set add an error.

if ( ! $_POST[‘hear_about_us’] )

wc_add_notice( __( ‘How did you hear about Amawrap is a required field’ ), ‘error’ );

}

/**

* Update the order meta with field value

*/

add_action( ‘woocommerce_checkout_update_order_meta’, ‘my_custom_checkout_field_update_order_meta’ );

function my_custom_checkout_field_update_order_meta( $order_id ) {

if ( ! empty( $_POST[‘hear_about_us’] ) ) {

update_post_meta( $order_id, ‘How did you hear about Amawrap’, sanitize_text_field( $_POST[‘hear_about_us’] ) );

}

}

/* add How did you hear about us to Simply order export */

function my_wsoe_hooks() {
add_filter( ‘wsoe_filter_fields’, ‘my_add_fields’ );
}
add_action( ‘init’, ‘my_wsoe_hooks’, 8 );

function my_add_fields( $fields ) {

$fields[‘wc_settings_tab_hear_about_us’] = __(‘hear about us’, ‘woocommerce-simply-order-export’);

return $fields;

}

Thanks

Hi,

The issue is with my_custom_checkout_field_update_order_meta function in above code.

You should not have spaces in meta_key while storing the order meta. You can modify the function code as following.

function my_custom_checkout_field_update_order_meta( $order_id ) {

if ( ! empty( $_POST['hear_about_us'] ) ) {

update_post_meta( $order_id, 'pessoa_contato', sanitize_text_field( $_POST['hear_about_us'] ) );

}

}

This should fetch the order meta, but you will also need to update the meta keys in your table to ‘pessoa_contato’

Hi. Thanks for that.

I have changed that cade to not having any spaces, but its still not working.

The “how did you here about us” custom field including the user inputted data does save to the database and I can also see the information within the woocommerce order screen.

Everything is working except the CSV export option in wsoe. I get the header title but not the actual info inputted into the custom field.

Any other ideas?