Invalid SKU even after deleting orphaned variations

  • Resolved Jose

    (@josefaarseth)


    3 years, 8 months ago

    One of my client’s is adding some products for a new collection, however, it seems that they created a product and didn’t bother to save it, and somehow the SKU’s got saved in the DB. Now they are trying to create them again and it appears that the SKU’s are already in use for all the variations. I’ve gone ahead and queried the SKU’s in the database, no results. I deleted the orphaned variations and 12 variations were deleted, but I still can’t create the variations with those SKU’s. I’m running out of ideas on what to do, this problem is going on in a live production website so I don’t have many choices. This is not my first time having this problem but I can’t seem to remember how I solved it the first time.

    After doing a direct query on the DB, wp_postmeta seems to host the variations. Not really sure how safe it is to delete them.

Viewing 3 replies - 1 through 3 (of 3 total)

  • You said you deleted them – but have you gone into the trash tab and emptied that? If not then they still exist!

    Mirko P.

    (@rainfallnixfig)

    Hi @josefaarseth,

    We’ve not heard back from you here. As @seank123 pointed out are those variations deleted but still in the Trash? If so, they’ve not actually been deleted. Can you send us an update on this?

    Thanks.

    Mirko P.

    (@rainfallnixfig)

    Hi @josefaarseth,

    It’s been a while since we heard from you, so I’m marking this thread as resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please open up a new topic and we’ll be happy to help out.

    Thanks.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Invalid SKU even after deleting orphaned variations’ is closed to new replies.