cancel
Showing results for 
Search instead for 
Did you mean: 

Import product CSV sheet issue.

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

Import product CSV sheet issue.

To preface this post and I am beginner with Magento testing whether or not CE2 is worth adopting.

 

what I am trying to do is to import products and associated data via an csv sheet. I tried to make one myself which didnt work so I set up a configurable product as a template and downloaded the csv. I then deleted the product information I had on the site and re-uploaded the csv that Magento 2 CE had created only to be given the following errors. 

 

1. Value for 'color' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1
2. Value for 'manufacturer' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1
3. Value for 'material' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 1, 2, 3, 4, 5
4. Value for 'adult_boxing_glove_size' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 2, 3, 4, 5

 

This is an odd behaviour to occur where Magento won't accept a sheet that it has created based on its own parameters. 

 

Has anyone else had this issue and how would I go about fixing it so I can upload products via a spreadsheet.

 

Many thanks in advance for any help offered.

Magento ver. 2.3.0