importing products via CSV file failed

Hi there Layla,

Just to confirm, were you using the built-in Product CSV importer? The majority of the column names you listed do not match the schema/format for the Woo CSV product importer. Also, for the built-in importer, the images would generally be listed together in a single column, rather than image_1,image_2,image_3,image_4,image_5,image_6.

Please check the schema here and make sure your CSV file matches those columns/values/etc:
https://github.com/woocommerce/woocommerce/wiki/Product-CSV-Import-Schema#csv-columns-and-formatting

I would also recommend reading over the rest of the guidelines for the importer here:
https://docs.woocommerce.com/document/product-csv-importer-exporter/

I hope that helps! If you are still having trouble, please upload your CSV file to your site’s media library or a service like Dropbox/Google drive and share the URL here so we can take a look.

Hi there Layla,

Correct, I’m using the built-in importer. I’ll try another import file matching those columns and values. Hopefully it’ll work.

Sounds like a plan — yep, hopefully matching the schema should do the job. Let us know how it goes!

Hi there Layla,

Glad to hear you are making progress!

Import completed 579 products, 278 skipped. Reason for failure: “A product with this sku already exists.”

That one is being caused for the reason it mentions — when trying to import the product, there’s already one with the same SKU. SKUs need to be unique, but I see in the CSV there are lots listed with the same SKU. For different variations, if you want to have SKUs, you can add something to the SKU to make it unique — i.e. parent SKU + something: 1099-p for the “pink” variation.

missing attributes (sizes, colors not visible)
Pictures (most of them missing or only showing 1)

For these, they will need to be set up a bit differently.

Right now, you just have a single “attributes” column. However, each different attribute will need to have its own column. As for the images, you currently have separate columns for each image, however those will need to be a single column, with a comma-separated list of images. You can see examples of how they should be formatted/entered in the example CSV here:
https://github.com/woocommerce/woocommerce/blob/master/sample-data/sample_products.csv

In your current file, these are the main things that will need to be updated:

Link to image: https://d.pr/i/q5fRZS

I hope that helps!

Hi there Layla,

I’m so glad that was helpful! Best of luck making it work! 🙂

I’m going to mark this thread as resolved for now. If you have any further questions, please start a new thread.

Have a wonderful day!