I am trying to import new products (from this CSV file) into my store.
The import is successful, yet when I go to look at the product list, some of my products are missing. You can see in this screenshot that Concentric Reducers, 180 Return, and a few others did not upload.
Can anyone help me identify why this happens?
When using a product CSV, you will get an email after the import to make you aware of whether or not the CSV was successful. I tried the file on my end here which produced the following errors:
When reviewing the CSV file, and looking at the errors, you'll notice that lines 20 & 26 are missing values in either Inventory policy and Fuflullment service or missing values in both.
You'll notice that you do in fact have a duplicate line appearing for the variant '3" / A234 / STD. You'll want to remove this line in order for the product to be imported successfully.
After fixing those errors, you'll notice you're greeted with a few more errors.
I'm not sure if line 15 is meant to be alongside line 5, but due to it being on its own, this is why the error is appearing:
For the second error, you're missing a dash in the handle:
I added a dash and moved line 15 to line 6 which successfully imported all of the data with no errors in the import email. If you make these changes to your file then you should be good to go!
Let me know if you run into any issues.
If you're referring to the window when you first import the CSV, then that can be reporting incorrectly. You'll want to refer to the email you receive when the import has completed which will tell you the number of products imported, and if any of them failed. If any of them failed, it will tell you exactly what lines, and why they failed.