CSV import goes wrong at end

Hi @martijntje,

Thank you for reaching out.

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 forward to hearing back from you.

Hi – yes – that’s the case. I must miss something, but I don’t know what.

You can view the product on https://www.hetmonument.nl/p/deens-ovaal-verjongde-rand/

A screenshot of a variation in the admin I uploaded to https://ibb.co/993jSg4

Hi @martijntje,

You can view the product on https://www.hetmonument.nl/p/deens-ovaal-verjongde-rand/

A screenshot of a variation in the admin I uploaded to?https://ibb.co/993jSg4

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.

Let us know how this goes.

Hi – yes each variation has its price (Reguliere prijs (€)) as seen on the screenshot on https://ibb.co/993jSg4. Or am I doing something wrong there?

Hi @martijntje,

Hi – yes each variation has its price (Reguliere prijs (€)) as seen on the screenshot on?https://ibb.co/993jSg4. Or am I doing something wrong there?

Thanks for clarifying this with us.

Were you able to try the steps I had earlier recommended only having WooCommerce as the active plugin to see if the issue persists?

?I recommend temporarily deactivating all active plugins, only leaving WooCommerce and a default theme like Twenty Twenty-Four or Storefront.

If not, please try the above steps and let us know how it goes.

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.

Hello chris2201,

Thank you for your message.
I appreciate your effort to help a fellow WooCommerce user.

Let’s wait and see if that resolves the issue for martijntje.

Have a great day!

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

Any thoughts? See screenshot of the file: https://ibb.co/T8r7JmX

Hello martijntje,

Thank you for your reply.

Could you confirm whether you are importing new products or updating existing ones?
Here is a checkmark for that feature.

Could you share a screenshot of the error?
There is no matching product to update.

Looking forward to your response. ??