SKU Error Fixer for WooCommerce

Plugin Banner

SKU Error Fixer for WooCommerce

by WordPress Monsters

Download
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.

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
  1. Settings page - search of old variations

    Settings page - search of old variations

  2. Settings page - clean SKU fields of old variations

    Settings page - clean SKU fields of old variations

  3. Settings page - removal old variations

    Settings page - removal old variations

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.

Thanks!

By evli on February 4, 2019

Fixed my problem, thank you!

Doesn't work

By Arafat Jamil (arafatjamil01) on August 9, 2018

I tried it but it is not working

Amazing!

By Robert (rpetrache) on August 6, 2018

Thanks for fixing that error!

Good start, but did not work for me

By lausianne on January 14, 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.

Works like a charm

By jrburke on January 13, 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!

One, Two, Three... DONE

By Ximbalo on June 21, 2017

Installed. Ran. Database was clean. Got back to work. Perfect.

Thank you!

By Evgeni (Karsky) on December 25, 2016

Great Plugin! Thank you!

Super mega helper

By Alio Web Developer (aliowebdeveloper) on October 18, 2016

Super mega helper for my shop! Thanks!

Smooth Operation

By richbee on September 3, 2016

Works as described. Cleaned up old SKUs on variations with ease. Way better than going into database to do a manual search and delete (or destroy).

Actually works!

By jeramiahyoung on September 3, 2016

I was worried this might wipe out all my variations but it totally removed old variations that had been deleted but for some reason were stuck in the database. So there was no record of it in wordpress... but in phpmyadmin I could see it. This plugin removed it and now I can enter the SKU I want. Highly recommend!

1.0

  • 02.05.2016
  • Initial release
Back to top