WooCommerce CSV for Products Attributes

Hello,

You can check the product CSV structure in this article below:
https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema

You will see there are some columns used for attributes.

As a first step, you can create a test product with variations, also with 2-3 attributes, next, you can export it as CSV using the Products > Export option.

This will give you a sample to fill out in order to import as you need. If that does not work, please provide us a copy of the CSV file you are using (with 1-2 products) so that we can test.

Hi @ihereira ,

Thank you for your reply.

I am sure that my CSV format is right because it could be used for uploading the new attributes of the products.

My question is the new attributes always overrides the current attributes of the product.

For example,
1. I have a product called “Test Product” that has 3 attributes already in the database called “Attribute A”, “Attribute B”, and “Attribute C”.
2. I am going to use below CSV to upload a new attribute called “Attribute D” for this “Test Product”.

SKU Attribute 4 name Attribute 4 value(s) Attribute 4 visible Attribute 4 global
R41009 New-Attri Attribute D 1 1

3. It could be updated successfully, but after updating Test Product only has “Attribute D”, however, the “Attribute A”, “Attribute B”, and “Attribute C” are all gone because of overriding.

Could you kindly help me with this?

Thank you!

Hello,

Can you provide a link to your CSV file, please? You can send it (for example) via Google Drive. You can add it only 1-2 products, so that I can test the same case on my site.

Looking forward to hearing from you.

Hi @ihereira ,

Thank you for the kindly help. Here is the CSV file that I used on my website.

The attributes20 will override all the other attributes of this product. I mean the attribute 1 to 19 will be gone.

https://docs.google.com/spreadsheets/d/1q9qr6mV6hcladff6_2fP-DVHFIq5qC_a-ngHxnz4oas/edit?usp=share_link

Thank you

Hi,

Thanks for sending the sample.

In this case, you will need to add the current attribute columns, and then add the next attributes as well. That means to add more columns to the CSV file, keeping the old attribute on the sheet.

Link to image: https://snipboard.io/McCjYV.jpg

I hope this helps.