How to add product to woocommerce through php code

Paula

I have a list of products that I need to add to a client's woocommerce store. The products list is huge and will take a lot of time to add one by one to the site. I wonder if adding the woocommerce product is possible through the PHP codes?

Jacob

Once I had the same situation but in my case, the woocommerce products list was not that huge, so i managed to add products one by one through the woocommerce dashboard.

James

We can manage in case of a small product list but not in case of large number of products.

You need to use the wp_insert_post() and update_post_meta() function to add woocommerce products programmically.
See the example below:

$post = array(
    'post_author' => $user_id,
    'post_content' => "",
    'post_status' => "publish",
    'post_title' => "Product Title Here",
    'post_parent' => "",
    'post_type' => "product",
);

//Create post
$post_id = wp_insert_post( $post, $wp_error );

wp_set_object_terms( $post_id, 'Races', 'product_cat' );
wp_set_object_terms( $post_id, 'simple', 'product_type');

update_post_meta( $post_id, '_visibility', 'visible' );
update_post_meta( $post_id, '_stock_status', 'instock');
update_post_meta( $post_id, 'total_sales', '0');
update_post_meta( $post_id, '_downloadable', 'yes');
update_post_meta( $post_id, '_virtual', 'yes');
update_post_meta( $post_id, '_regular_price', "1" );
update_post_meta( $post_id, '_sale_price', "1" );
update_post_meta( $post_id, '_purchase_note', "" );
update_post_meta( $post_id, '_featured', "no" );
update_post_meta( $post_id, '_weight', "" );
update_post_meta( $post_id, '_length', "" );
update_post_meta( $post_id, '_width', "" );
update_post_meta( $post_id, '_height', "" );
update_post_meta( $post_id, '_sku', "");
update_post_meta( $post_id, '_product_attributes', array());
update_post_meta( $post_id, '_sale_price_dates_from', "" );
update_post_meta( $post_id, '_sale_price_dates_to', "" );
update_post_meta( $post_id, '_price', "1" );
update_post_meta( $post_id, '_sold_individually', "" );
update_post_meta( $post_id, '_manage_stock', "no" );
update_post_meta( $post_id, '_backorders', "no" );
update_post_meta( $post_id, '_stock', "" );

// file paths will be stored in an array keyed off md5(file path)
$downdloadArray =array('name'=>"Test", 'file' => $uploadDIR['baseurl']."/video/".$video);

$file_path =md5($uploadDIR['baseurl']."/video/".$video);


$_file_paths[  $file_path  ] = $downdloadArray;
// grant permission to any newly added files on any existing orders for this product
// do_action( 'woocommerce_process_product_file_download_paths', $post_id, 0, $downdloadArray );
update_post_meta( $post_id, '_downloadable_files', $_file_paths);
update_post_meta( $post_id, '_download_limit', '');
update_post_meta( $post_id, '_download_expiry', '');
update_post_meta( $post_id, '_download_type', '');
update_post_meta( $post_id, '_product_image_gallery', '');

Shara

Hi, If I want to add also Image, how will be code?

Thanksss

leowtp

Shara

replace the code $post_id = wp_insert_post( $post, $wp_error );

with:

$post_id = wp_insert_post( $post );
$thumb = plugin_dir_url( __FILE__ ).'images/my-image.jpg';

$url     = $thumb;
$mypost_id = $post_id;
$desc    = "Featured Image";
 
$image = media_sideload_image( $url, $mypost_id, $desc, 'id' );

set_post_thumbnail( $mypost_id, $image );

Shara

Thank you. it works.

can can u tell me how can I insert uploaded file in product? not image.
I mean file.
Thanks

leowtp

Shara

the above code from James already provided downloadable files 😆
update_post_meta( $post_id, '_downloadable', 'yes' );

then tell where the file is and set the post meta..

$file_path = plugin_dir_url( __FILE__ ).'/my-files.pdf';
update_post_meta( $post_id, '_downloadable_files', $_file_path);