How to update/add sku of all products in Woocommerce ?

In this tutorial we’ll learn how to add / update sku of all products in woocommerce .

For this, I’ve created some products without skus.

Now I want to add / update sku to all product in my woocommerce store.

To do this add the following lines of code at the end of your theme’s function.php file.

add_filter( 'init', 'update_sku', 10, 1);

 

   function update_sku( $sku ){

 

       $args = array(

               'post_type' => 'product',

              'posts_per_page' => 12

               );

       $i=0;

       $loop = new WP_Query( $args );

 

       if ( $loop->have_posts() ) {

           while ( $loop->have_posts() ) : $loop->the_post();

 

               $random_sku = mt_rand(100000, 999999);

 

               update_post_meta($loop->post->ID,'_sku',$random_sku);

 

               $i++;

           endwhile;

       } else {

           echo __( 'No products found' );

       }

       wp_reset_postdata();

   }

You can access functions.php file here:

Place the code and save file.

Now go to/refresh your store front just once and you’ll notice the product’s sku has been updated/added.

Remove the code from file after your store’s sku being updated.

NOTE : If you don’t remove after one use, products SKU will change everytime you visit any page of your site.