Hi @DeepakGairola25, welcome to the community forum.
So, let’s break this down. The error you have received states:
Column configurable_variations: Attribute with code “color” does not exist or is missing from product attribute set in row(s): 1, 5, 9, 18, 28, 33
Below are the values for the configurable_variations column.
1. sku=sports-lightgrey,color=Black/Light Grey|sku=sports-red,color=Black/Red|sku=sports-blue,color=Black/Blue
5. sku=standout-green,color=Green|sku=standout-purple,color=Purple|sku=standout-black,color=Black
9. sku=edge-peach,color=Peach|sku=edge-grey,color=Grey|sku=edge-blue,color=Blue|sku=edge-brown,color=Brown|sku=edge-red,color=Red|sku=edge-pink,color=Pink|sku=edge-lightblue,color=Light Blue|sku=edge-black,color=Black
18. sku=casual-skyblue,color=Sky Blue|sku=casual-blue,color=Blue|sku=casual-blackred,color=Black/Red|sku=casual-blackblue,color=Black/Blue|sku=casual-brown,color=Brown|sku=casual-darkblue,color=Dark Blue|sku=casual-lightblue,color=Light Blue|sku=casual-pink,color=Pink|sku=casual-white,color=White
28. sku=leapord-grey,color=White/Grey|sku=leapord-purple,color=White/Purple|sku=leapord-brown,color=White/Brown|sku=leapord-blue,color=White/Blue
33. sku=curve-skyblue,color=Sky Blue|sku=curve-pinkpattern,color=Pink|sku=curve-blue,color=Blue|sku=curve-blackred,color=Black|sku=curve-gold,color=Gold|sku=curve-brownpattern,color=Brown|sku=curve-whitepattern,color=White|sku=curve-white,color=White|sku=curve-blackgrey,color=Black
So from this, we can ascertain that not all of the following colours under the color attribute in the Magento backend were created before attempting to upload the csv file:
| Attribute: |
color |
|
|
| Green |
Brown |
White |
Black/Red |
| Purple |
Red |
Gold |
Black/Blue |
| Black |
Pink |
Orange |
White/Grey |
| Peach |
Light Blue |
Light Grey |
White/Purple |
| Grey |
Sky Blue |
Yellow |
White/Brown |
| Blue |
Dark Blue |
Black/Light Grey |
White/Blue |
So, you need to verify that these colours exist in the backend of Magento under:
Stores > Attributes > Product > Attribute Code = color
This all stems from the fact that you can’t upload data to Swatch or Dropdown Attribute Input Types if the data doesn’t exist to begin with - Because it can’t match it up. This is what I was doing during Episode 08 of the Let’s Build playlist.
With reference to your other question:
I also notice in magento 2.3 there is an extra attribute for import functionality that is Empty attribute value constant , this has value EMPTY__VALUE in it
You can ignore this, it appears to be a standard default value introduced into 2.3.
