Get all products with php in Woocommerce WordPress
require_once(‘../wp-load.php’);
global $wpdb;
// Get 10 most recent product IDs in date descending order.
$query = new WC_Product_Query( array(
‘limit’ => -1 ,
‘status’ => ‘publish’,
‘orderby’ => ‘date’,
‘order’ => ‘DESC’
) );
$products = $query->get_products();
foreach ( $products as $product ){
//print_r($products);
//$pro_id = $product->get_id();
//$pro_title = $product->get_title();
//$attachment_ids = $product->get_gallery_image_ids();
// echo $product->get_status(); // Product status
// echo $product->get_type(); // Product type
// echo $product->get_id(); // Product ID
// echo $product->get_title(); // Product title
// echo $product->get_slug(); // Product slug
// echo $product->get_price(); // Product price
// echo $product->get_catalog_visibility(); // Product visibility
// echo $product->get_stock_status(); // Product stock status
// echo $product->get_date_created()->date(‘Y-m-d H:i:s’);
// echo $product->get_date_modified()->date(‘Y-m-d H:i:s’);
}
Source:
get all products of one category
Get all Woocommerce product IDs in an array