WooCommerce: Bulk Search & Replace SKUs

Yes, you could use a plugin to bulk search and replace a given string inside the WordPress database… but today I want to show you a simple snippet you can use to bulk edit SKUs in your store (please test first on staging or a development site!).

Specifically, we will replace dashes “-” with an empty string (i.e. we will remove dashes from all products’ SKU), but you can of course readapt this and for example add suffixes, remove prefixes, replace special characters and so on. Enjoy!

My goal is to remove dashes from all SKUs. The snippet below does just that, with the bonus of scheduling events as opposed to running the bulk update for all SKUs, so that the WooCommerce website doesn’t reach the memory limit and crash.

PHP Snippet: Bulk Replace SKUs @ WooCommerce Admin

Please note that in order to trigger the bulk update you must add the “bb-edit-products” URL parameter to any WordPress dashboard URL when you’re logged in as administrator or shop manager, and hit enter.

The Action Scheduler’s as_enqueue_async_action() function will schedule one event per visible product. The event will then trigger the bbloomer_edit_product_schedule() function for each product ID, and specifically this will get the SKU, edit it, and save it.

/**
 * @snippet       Bulk replace SKUs
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 7
 * @community     https://businessbloomer.com/club/
 */

add_action( 'admin_init', 'bbloomer_edit_products_admin' );
 
function bbloomer_edit_products_admin() {
	if ( isset( $_REQUEST['bb-edit-products'] ) ) {
		if ( ! current_user_can( 'manage_woocommerce' ) ) {
			wp_die( 'You do not have permission to bulk edit products' );
		}	
		$args = array(
			'status' => 'publish',
			'visibility' => 'visible',
			'limit' => -1,
			'sku' => '-',
			'return' => 'ids',
		);
		$products = wc_get_products( $args );
	   	foreach ( $products as $product_id ) {
			as_enqueue_async_action( 'bbloomer_edit_product_schedule_trigger', array( $product_id ) );
		}
	}
}

add_action( 'bbloomer_edit_product_schedule_trigger', 'bbloomer_edit_product_schedule' );

function bbloomer_edit_product_schedule( $product_id ) {
	$product = wc_get_product( $product_id );
	$sku = $product->get_sku();
	$newsku = str_replace( "-", "", $sku );
	$product->set_sku( $newsku );
	$product->save();
}

Where to add custom code?

You should place custom PHP in functions.php and custom CSS in style.css of your child theme: where to place WooCommerce customization?

This code still works, unless you report otherwise. To exclude conflicts, temporarily switch to the Storefront theme, disable all plugins except WooCommerce, and test the snippet again: WooCommerce troubleshooting 101

Related content

  • WooCommerce: Add Second Description @ Product Category Pages
    In terms of SEO, if you’re trying to rank your product category pages, you really need to make the most of the default WooCommerce product category “description” and “thumbnail”. Most themes, if compatible with WooCommerce, will show this content right below the product category name and above products. Nothing new so far. But what if […]
  • WooCommerce: Add Column to Orders Table @ WP Dashboard
    The WooCommerce Orders Table, which can be found under WP Dashboard > WooCommerce > Orders, provides us with 7 default columns: Order – Date – Status – Billing – Ship to – Total – Actions. This is used by shop managers to have an overview of all orders, before eventually clicking on a specific one. […]
  • WooCommerce: Hide/Show The WP Admin Bar
    In previous WooCommerce versions, new customers could access the WP Admin black bar after purchase. Now this seems fixed. Still, what about other user roles, and what if you want to override this default behavior? Well, here’s a quick snippet for you – feel free to use it in your own WooCommerce site. Enjoy!
  • WooCommerce: Display Custom Filters @ WP Dashboard > Products
    If you go to WordPress Dashboard > Products you will find default product admin filters such as “Select a category”, “Filter by product type”, “Filter by stock status”. What if you want to add more custom filters to let your shop managers find products easily? For example, you could add “Filter by product tag” (“product […]
  • WooCommerce: Calculate Sales by State
    You’re filing your tax returns and need to know how much you earned in each state… but then find out WooCommerce doesn’t give you this calculation by default within its reports! Don’t worry – today I’ll share a quick snippet so that you can calculate the amount you need in a second. Feel free to […]

Rodolfo Melogli

Business Bloomer Founder

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza. Follow @rmelogli

Questions? Feedback? Customization? Leave your comment now!
_____

If you are writing code, please wrap it like so: [php]code_here[/php]. Failure to complying with this, as well as going off topic or not using the English language will result in comment disapproval. You should expect a reply in about 2 weeks - this is a popular blog but I need to get paid work done first. Please consider joining the Business Bloomer Club to get quick WooCommerce support. Thank you!

Your email address will not be published. Required fields are marked *