通过 SKU 标识符使用 Woocommerce REST API 更新产品

我需要使用 REST API 将产品从实时网站更新到登台。如果我添加静态产品 ID，效果会很好。我需要的是将跨网站的产品与 SKU 进行匹配，而不是通过 ID 进行匹配，因为它不一样。

关于如何做到这一点有什么想法吗？我的代码如下。

add_action( 'woocommerce_update_product', 'on_product_savex', 10, 1 );
function on_product_savex( $product_id ) {
   $product = wc_get_product( $product_id );
   $get_main_website_product_id = get_post_meta( $product_id, '_sku', true );
   $live_ck = 'ck_xxxx';
   $live_cs = 'cs_xxxx';
   $live_url = 'https://web.com/wp-json/wc/v3/products?sku='.$get_main_website_product_id.'&consumer_key=' . $live_ck . '&consumer_secret=' . $live_cs;
   
   
   $body = array(
        'name' => $product->get_name(), // product title
        'status' => 'private', // product status, default: publish
        'regular_price' => $product->get_regular_price(),
        'sale_price' => $product->get_sale_price(),
        'description' => $product->get_description(),
        'sku' => $product->get_sku(),
        'weight' => $product->get_weight(),
        'manage_stock' => true,
        'stock_quantity' => 10,
        
     
   );
   
   print_r( $body );
   $raw_response = wp_remote_post( $live_url, 
      array(
         'headers' => array( 'Content-Type' => 'application/json' ),
         'timeout' => 30,                    
         'body' => json_encode( $body ),
      )
   );
}

首先使用 SKU 获取远程产品 ID，然后使用实时产品数据更新远程产品。

add_action( 'woocommerce_update_product', 'on_product_savex', 10, 1 );
function on_product_savex( $product_id ) {
   $product = wc_get_product( $product_id );
   $product_sku = $product->get_sku();
   $remote_keys = "consumer_key=xxxxxx&consumer_secret=xxxxxx";

   // retrieve product ID by SKU, return product properties
   $remote_get = wp_remote_get("https://web.com/wp-json/wc/v3/products?sku={$product_sku}&{$remote_keys}");
   $remote_product = json_decode($remote_get['body'])[0];
   $remote_product_id = $remote_product->id;
   
   $body = array(
      'name' => $product->get_name(), // product title
      'status' => 'private', // product status, default: publish
      'regular_price' => $product->get_regular_price(),
      'sale_price' => $product->get_sale_price(),
      'description' => $product->get_description(),
      'sku' => $product->get_sku(),
      'weight' => $product->get_weight(),
      'manage_stock' => true,
      'stock_quantity' => 10,
   );

   $raw_response = wp_remote_post( "https://web.com/wp-json/wc/v3/products/{$remote_product_id}?{$remote_keys}", 
      array(
         "headers" => array( "Content-Type" => "application/json" ),
         "timeout" => 30,                    
         "body" => json_encode( $body ),
      )
   );
}