csv variation products import issue

Hi @sharonleelas,

I’ve checked your CSV file and tax:product_type doesn’t seem to be a valid CSV column name. You can review CSV columns and formatting here:

https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

Hope this helps.

Hi @sharonleelas

Please thoroughly re-check the CSV per this support documentation and make any necessary corrections as applicable.

https://woocommerce.com/document/product-csv-import-suite-importing-product-variations/

If the problem still persists then please share:
1. a screenshot of the error, and
2. a link to the latest updated CSV

We recommend https://snipboard.io for easily sharing screenshots – please follow the instructions on that page, then paste the URL in this thread.

Hi @sharonleelas

You may be having the issue described here:
https://github.com/woocommerce/woocommerce/issues/29903

That said, can you follow the steps below and see if it works?

importing a parent product without variations and having all the attributes show as not being used for variations, then importing or adding variations with those attributes and having the setting magically turn on.

@sharonleelas

Thanks for the attachments.

Can you share the action performed that triggers this error? Can you also share a screenshot of the error via https://imgbb.com or https://snipboard.io?

For better assistance, please share your WooCommerce error logs and System Status on this thread so we can take a look at your configuration and check the issue further:

System Status: You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Error Log: Share a copy of any fatal error log found under WooCommerce > System Status > Logs (if available).

Hey @sharonleelas,

Thank you for sending over the additional information.

Can you confirm if all the images you’re referencing are present in your media library and accessible with that filename?

For the import to be successful, those images need to already exist on the server. I ran a test of your CSV file after deleting all the image data in your CSV file:

That import was successful and products were imported along with their variations as expected. So it looks like all the other fields in your CSV file are working but that the images are where the issue is.

Additionally, the error message you shared could be playing a part here. The error is referencing the Elementor Pro plugin you’re using on your website. If the issue is not with the images then I suggest disabling that plugin and trying again.

Kind regards,

Hi @sharonleelas – Thanks for your patience here! I’ve run several tests on my local site and found that this can occur when you don’t have a set Attribute 1 default for the parent level product line item.

Can you go through your most recent CSV and set a value for Attribute 1 default on each parent line item and see if that works?