doudao1950
doudao1950
2018-10-26 11:54

在Woocommerce中查找并​​显示产品自定义字段值

已采纳

I am trying to display a custom field value to my Woocommerce email template that was created as part of a product import.

This custom field is called 'Reference number'.

How do I do this?


Edit:

This works:

        <td class="td" style="text-align:<?php echo esc_attr( $text_align ); ?>; vertical-align:middle; font-family: 'Helvetica Neue', Helvetica, Roboto, Arial, sans-serif;">
            <?php echo wp_kses_post( $sku ); ?>
        </td>

This doesn't:

<td class="td" style="text-align:<?php echo esc_attr( $text_align ); ?>; vertical-align:middle; font-family: 'Helvetica Neue', Helvetica, Roboto, Arial, sans-serif;">
            <?php echo $product->get_meta( 'Reference number' );
 ?>
</td>

The meta_key has been taken from the DB

enter image description here

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • dongzai0020 dongzai0020 3年前

    It seems that you have imported products with custom data and you need to get a specific custom value (a custom field).

    1) First you have to find out how is registered your custom field "product code":

    In backend product list, open an imported product edit page. Search in "Custom fields" Metabox:

    enter image description here

    If you don't find it this way, in admin product list, when hovering a product line, you can get the product ID displayed as follow:

    enter image description here

    Then in your database using phpMyAdmin search on wp_postmeta table for a specific product ID (Here 53):

    enter image description here

    You will get the list of the product metadata items… Search in the meta_key column:

    enter image description here

    You should find it this time.


    2) Once you have this meta key, let say that _product_code is the meta key, you will get easily the value. There is mainly 2 ways to get and display this custom field value:

    • Using the WC_Data method get_meta() from the defined WC_Product Object $product:

      echo $product->get_meta( '_product_code' );
      
    • Using WordPress get_post_meta() function from a $product_id defined product ID variable:

      echo get_post_meta( $product_id, '_product_code', true );
      

      or from the defined WC_Product Object $product

      echo get_post_meta( $product->get_id(), '_product_code', true );
      
    点赞 评论 复制链接分享

相关推荐