Product SKU must be unique problem on products with variations

It’s definitely happening only on products with variations. It’s as if there is now a variations bug ??

NO ANSWERS???

Its not a bug. It means that in one of the product you are using same SKU thats why its hows you a Unique SKU.

Try to check in another product and make it different with one another

As I said, I am using a unique SKU. It’s happening now every time I try to enter a new product and new sku so I can no longer add product.

Did you try the wp_postmeta table in phpMyAdmin, and search for meta_key LIKE _sku to see if there are any unwanted SKUs left over?

I did thanks again! There were no duplicates but I did do a database optimization which seemed to clear up the problem. I have no idea why but glad it has ??

I’m having the same problem. I’ve checked post_meta and the sku does not exist there at all. (748252302748) I’ve done a database optimization, but wasn’t as lucky – it didn’t fix it.

We have 183 variants total in 19 products, every variant has a unique 12 digit sku (our UPC barcode number). But there are about twenty of them that give this error, and I can’t figure out why.

Has anybody else seen this, where it wasn’t fixed with a db optimization?

I should mention that we have a second WordPress installation on the same server, in a different directory with a different database table prefix, also running WC. All the skus are fine in that one, and the 160 or so skus that are working fine on THIS install also exist in that install. So I don’t think it’s relevant that it’s there, but thought I should mention it.

Have you deleted products that are perhaps still in the trash? If yes they need to be permanently deleted otherwise they will cause this problem. After doing that you may also need to do the database optimization again.

Also, if you are duplicating products to create new products, and removing variations on the duplicate, make sure you actually take the steps to delete the variations, then delete attributes. For example, let’s say you are going from a product with variations to one that is a simple product. You need to delete the variations that carried over into the duplicate, then delete the attributes, then change it to a simple product.

Another thing to consider, could you possibly be super caching? If you have the WP Super Cache plugin activated, clear cache and deactivate and optimize database and try again.

Otherwise, without access to the admin it’s hard to tell.

Thank you for the suggestions. Sadly, none of them apply. My trash is empty, the items were entered without duplicating old ones, and we aren’t caching.

I’ve found a workaround, though. This particular site is being used as a backend translator – I’m importing orders from another source and then exporting them to yet another source. Because both sources can talk to WooCommerce, but they can’t talk to each other. As a result, I don’t care what the store looks like. So I created every variant as a simply product with no attributes and no variants. And now everything works.

It doesn’t solve the problem for the next person to find this thread via Google, but I’m happy to put it behind me for now.

Thanks again for taking the time to make some suggestions.

The plugin resolves this problem – https://www.ads-software.com/plugins/sku-error-fixer-for-woocommerce/

That looks promising. Thanks for posting it. If I run into this problem again I’ll try it. (We moved forward without variations on that cart and so aren’t experiencing the problem due to that workaround.)

I tried this plugin https://www.ads-software.com/plugins/sku-error-fixer-for-woocommerce/ buut didn’t work as well as the Phpmyadmin method.
Any help will be highly appreciate
Thanks

Jeremiewp, please explain in more detail what you mean by “work as well as the Phpmyadmin method”?

I meant that I didn’t find the SKU folder in phpmyadmin

what’s the SKU folder in phpmyadmin? she really needs to be there? Can you show a screenshot?