Support

Account

Home Forums Backend Issues (wp-admin) meta keys generated by ACF

Solving

meta keys generated by ACF

  • Aloha
    I am trying to export some order data from my woocom install using the woocommerce Orders/customers CSV Export.
    I added the custom fields, they show up in the order I can populate them, I can make the field columns happen on the export but it does not populate the columns with data. The data is there in the order.
    But seems to be a problem with the keys.
    This is the meat information I get form th eorder

    here is the meta key info for the two new fields (as created by ACF):
    _pick_order field_561f52378230b
    pick_order P20-1061
    _product_cost field_561f521f8230a
    product_cost 6.69

    Does this look correct?
    I have tried both versions of the “meta” and still nothing am I doing something wrong here?

    This is the addition to the functions.php file:
    // add custom column headers
    function wc_csv_export_modify_column_headers( $column_headers ) {

    $new_headers = array(
    ‘pick_order’ => ‘pick_order’,
    ‘product_cost’ => ‘product_cost’,
    // add other column headers here in the format column_key => Column Name
    );

    return array_merge( $column_headers, $new_headers );
    }
    add_filter( ‘wc_customer_order_csv_export_order_headers’, ‘wc_csv_export_modify_column_headers’ );
    // set the data for each for custom columns
    function wc_csv_export_modify_row_data( $order_data, $order, $csv_generator ) {

    $custom_data = array(
    ‘pick_order’ => get_post_meta( $order->id, ‘_pick_order’, true ),
    ‘product_cost’ => get_post_meta( $order->id, ‘_product_cost’, true ),
    // add other row data here in the format column_key => data
    );

    $new_order_data = array();
    if ( isset( $csv_generator->order_format ) && ( ‘default_one_row_per_item’ == $csv_generator->order_format || ‘legacy_one_row_per_item’ == $csv_generator->order_format ) ) {
    foreach ( $order_data as $data ) {
    $new_order_data[] = array_merge( (array) $data, $custom_data );
    }
    } else {
    $new_order_data = array_merge( $order_data, $custom_data );
    }
    return $new_order_data;
    }
    add_filter( ‘wc_customer_order_csv_export_order_row’, ‘wc_csv_export_modify_row_data’, 10, 3 );

    Thanks

  • I guess basically what I need is the answer to this,…

    this is the meta key info I see when I create the fields via ACF

    _pick_order field_561f52378230b
    pick_order P20-1061
    _product_cost field_561f521f8230a
    product_cost 6.69

    What is the actual meta key .. any combination of what I see above does not seem to work

    Thanks

  • Also where in the DB are the ACF fields stored?

  • I did find this in wp_postmeta table

    Edit Delete 618882 36992 _pick_order field_561f52378230b
    Edit Delete 618883 36992 pick_order P00-1009
    Edit Delete 618884 36992 _product_cost field_561f521f8230a
    Edit Delete 618885 36992 product_cost 39.99

  • Each field in ACF has two entries in the database.

    your_field_name contains the value of your field

    _your_field_name holds the ACF field key that tells ACF how to find an use the value in the first one.

    and explanation of this can be found here http://www.advancedcustomfields.com/resources/get_field_object/

Viewing 5 posts - 1 through 5 (of 5 total)

The topic ‘meta keys generated by ACF’ is closed to new replies.