This plugin hasn’t been tested with the latest three major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

SKU Error Fixer for WooCommerce

Description

When you are creating new products in your webshop using a WooCommerce plugin, you can get the unique SKU error for your product and SKU can’t be saved properly. This happens because in the database there are old variations of previously created products that have the same SKU number. WooCommerce SKU Error Fixer plugin solves this problem by cleaning and/or removing old products variables and also you can setup automatic checking and fixing of non-unique SKU problem when you edit a product.

Screenshots

  • Settings page - search of old variations
  • Settings page - clean SKU fields of old variations
  • Settings page - removal old variations

Installation

Install of “SKU Error Fixer for WooCommerce” can be done either by searching for “SKU Error Fixer for WooCommerce” via the “Plugins > Add New” screen in your WordPress dashboard, or by using the following steps:

  1. Download the plugin via WordPress.org
  2. Upload the ZIP file through the ‘Plugins > Add New > Upload’ screen in your WordPress dashboard
  3. Activate the plugin through the ‘Plugins’ menu in WordPress

FAQ

What is the old variations?

These are former variations of variable products when it type have been changed to Simple or another type of product not variable. WooCommerce does not remove these variations to the case you decide to change the product type on variable again. For this case variables remain intact with all fields filled in, including the SKU field.

What’s the problem of old variations?
Clogging the database of unnecessary data

Old variation of products is invisible. You can change the product type with variable to another, and after some time to remove this product and forget about it, but these variations will not be removed. They are stored in the database and it can take a lot of space.

Unique SKU problem

A known problem of the uniqueness of the SKU number of the product. WooCommers allows you to assign only unique SKU for product. If you used any SKU for the product variation, and then changed the product type to another, you will not be able to use the same SKU for a different product. You will receive an error “Product SKU must be unique”. WooCommerce SKU Error Fixer plugin eliminates this problem.

How do I use this plugin?

After installing the plugin you will need to go to the plugin settings page Woocommerce > SKU Error Fixer, where you can to scan your site for presence of any old variations, clean them SKU fields or remove them completely. You can also setup automatic checking and fixing not unique SKU problem when you edit a product.

Reviews

4 February 2019
Fixed my problem, thank you!
14 January 2018
Did not fix this issue: https://wordpress.org/support/topic/invalid-or-duplicated-sku-2/#post-9862728 I assume it is just not the purpose of this plugin to fix issues that occur on import.
13 January 2018
After spending hours trying to figure out why sometimes CSV files with SKUs would import and other times they wouldn't, I stumbled across this little plug-in and VOILA - problem SOLVED! Highly recommend this product!
Read all 12 reviews

Contributors & Developers

“SKU Error Fixer for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Change log

1.0

  • 02.05.2016
  • Initial release