[artisticdogParticipant]

I was creating 34 products with Variations using WooCommerce for my shop.
I hit save or update and when the page refreshed my new product with variations was not there. I assumed I had missed a step or failed to give the product a name before creating variations or something like that?

So…
I have now re-created the products but it wont allow me to give the variations the correct SKU’s as it says ” Variation SKU must be unique”
I believe the SKU’s from 1st attempt to create the products are now preventing me from creating the products SKUs?
The products from the 1st attempt are no where to be seen, so I don’t know what to do?
How can I fix this problem?

Maybe this is a question for WooCommerce but they don’t offer support for free installs.
Also any questions I have asked them in the past don’t seem to get answered.

[LelyModerator]

Hello There,

Thanks for posting in.

Please check the following link regarding variations:
http://docs.woothemes.com/document/problems-with-large-amounts-of-data-not-saving-variations-rates-etc/
https://support.woothemes.com/hc/communities/public/questions/202015308-Variations-won-t-save-on-variable-products-

Hope this helps.

[artisticdogParticipant]

Thanks for the reply. These don’t seem to fix my problem.
I believe there are duplicate products hidden in the database? Is there a way to view the database and remove the products if this is the case?

[Rue NelModerator]

Hello There,

Please make sure that you have empty your Product’s trash (bin). If the product is still in your trash, you won’t be able to create the same product id and variation skus. Emptying your trash should allow you to add the same variation sku.

To assist you better with this issue, would you mind providing us the url of your site with login credentials, if necessary, so we can take a closer look? This is to ensure that we can provide you with a tailored answer to your situation. Once you have provided us with your URL, we will be happy to assist you with everything.

To do this, you can make a post with the following info:
– Link to your site

– WordPress Admin username / password (only if necessary)

Don’t forget to select Set as private reply. This ensures your information is only visible to our staff.

Thank you.

[artisticdogParticipant]

This reply has been marked as private.

[Paul RModerator]

Hi Scott,

You can try this third party plugin to remove any hidden products in the database.

https://wordpress.org/plugins/woocommerce-store-toolkit/

Just make sure to have a complete backup of your site before using it.

Hope that helps.

[Author]

Posts