I have a csv-file to import to WooCommerce. When I import it via the WooCommerce-import function all runs fine. When I view the product-page with variations, they all show but are not clickable.
Any guesses what could be wrong? Something extra strange: when I visit the new product page during the import (when it’s almost finished), the product shows with clickable variations? So it looks like the error is on the latest stage of the import.
I understand you’re experiencing an issue with product variations not being clickable after an import.
This is quite unusual, but I’d be happy to help.
If I understand you correctly, the import completes successfully without any issues. Once the import is completed, are you able to confirm that the product stock is correctly updated – ensure the products are not out of stock.
Also, you can try checking your store from a private browser to see if the issue is related to a cached version of your store.
Looking at the product, it looks like the variations do not have set prices. Are you able to confirm that each variation of the product has its different price included in the backend?
Without having the prices set for each variation, this issue can cause the products not to be clickable. Please try adding the prices and check if the error persists.
Should the issue persist, I recommend temporarily deactivating all active plugins, only leaving WooCommerce and a default theme like Twenty Twenty-Four or Storefront.
You need to import variables (Type) first with all attributes. Then you need to import variations (Type), assigning to parents ID. You should have a column named “parent product”. There you write in the parent ID (e.g. id:3123) to assign it. Easiest way to understand: Add a variable product and add variations. Export it to get the right data structure.
Thanks for all the suggestions. It seems I can import some variations now, but some rows still don’t get imported: each of these rows/products has an error in the log: ‘There is no matching product to update.’
