if ( isset($sale_price) && ! empty($sale_price) ) {

? ? $product->set_sale_price($sale_price);

? ? $product->set_price($sale_price); ?

} else {

? ? $product->set_price($regular_price); ?

}

$product->set_regular_price($regular_price);

$product->save();?

?echo $product_id."-".$regular_price."-".$sale_price."已處理！";

}

$variations = $product->get_available_variations();

?foreach ( $variations as $variation ) {

? $variation_id = $variation['variation_id'];

$url="https://yoursite.com/wp-json/wc/v3/products/".$product_id."/variations/".$variation_id;

$consumer_key = 'KEY';

$consumer_secret = 'Secret';

$headers = array(

? ? 'Authorization' => 'Basic ' . base64_encode($consumer_key.':'.$consumer_secret )

);

$data = array(

? ? 'regular_price' => $regular_price,

? ? 'sale_price' => $sale_price

);

$curl = curl_init();

curl_setopt($curl, CURLOPT_URL, $url);

curl_setopt($curl, CURLOPT_POST, true);

curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);

curl_setopt($curl, CURLOPT_TIMEOUT, 240);

curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);

curl_setopt($curl, CURLOPT_POSTFIELDS, http_build_query($data));

curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, false);

curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);

curl_setopt($curl, CURLOPT_USERPWD, "$consumer_key:$consumer_secret");

$resp = curl_exec($curl);

$status_code = curl_getinfo($curl, CURLINFO_HTTP_CODE);?

curl_close($curl);

}

echo $product_id."-".$regular_price."-".$sale_price."已處理";

$offset = isset($_GET['offset']) ? intval($_GET['offset']) : 0;

$args = [

? ? 'post_type' => 'product',

? ? 'posts_per_page' => 1,

? ? 'offset' => $offset,

? ? 'post_status' => 'publish',?

? ? 'orderby' => 'ID',?

? ? 'order' => 'DESC',?

];

$products = wc_get_products( $args );

$count = count($products);?

每次執行結束后，跳到下一頁。

?$offset = $offset + 1;

?header("Refresh: 3; URL=?offset=".$offset);?

這樣就能完美的更改數據庫里面的價格和促銷價。當然產品標題，產品分類，產品tag ，產品描述等等，都可以用這種方法去更改。 ?