Can’t import more than 1 product attribute (CSV file import)

Hey there!

Do the attributes already exist on your site, that you are trying to import using?

The attributes did not exist in my site at the time of the first import attempt. It was a clean WP and Woocommerce install. After the first attempt, all products with 1 attribute (size, color, etc) were succesfully imported but all products with more than 1 attribute failed to import the additional attributes even if it’s a repeated attribute.

Here’s a small video showing the issue I’m experiencing: https://www.screencast.com/t/H3iT202bcPE6

Hi there,

You can find more information about how to format your CSV file in this article below:

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

It also has a CSV example and a column header reference.

Hope this helps!

Thanks @ihereira. I tried both downloading and using their sample and following this instruction mentioned in the page

If you want to make sure you’re including all of the fields that are required for your online store, you can add one product via WordPress and then export that CSV to create your basic template.

None worked… Second and Third attributes are still not being imported.

Hi @traduality

I understand the suggestion did not work. This is what I usually do if there’s something not working with the CSV:

Create a test variable product with 2-3 attributes or variations (or whatever number you prefer) and export it as CSV using the Products> Export option.

This will give you an exact sample of what you need and all the required columns and required data for you to fill out.

Let me know if that helps!

@nathvi for some reason that fixed my problem but not for what you’re thinking of…

I created a product with 3 attributes manually, exported it, then compared my current template with the downloaded export and realized they were both identical.

Then I compared the exported product (the one created manually) with the version I have in my current template and all data was also identical.

So, I erased all products again, clean woocommerce, then uploaded a bunch of my existing products using the new template I got from the export and everything uploaded correctly. All products with 2 or 3 attributes are now being imported correctly.

Then, just for the fun of it, I uploaded another set of products using my old template, and everything imported correctly again.

My only conclusion is that maybe the database tables for attributes 2 and 3 don’t exist in the database when you try to import products on a clean woocommerce installation, so products with 2 or 3 attributes in a CSV file are not importing correctly but if you first create a 3-attribute product, then import your CSV file, everything will be imported correctly because the manual work creates the tables.

I recorded everything I did in a video, in case you want to check it out for future support purposes: https://www.screencast.com/t/Rm6Wavnskr7