• Resolved itsgauravjain22

    (@itsgauravjain22)


    My test csv is following. The problem is I don’t know how to import comma-separated attribute values. In this case, I have problem with importing Little, Brown Book Group as Attribute 4 value(s) field. The backend consider Little as one value and Brown Book Group as another value. Could you suggest way to have comma-separated values in import file so that it imports Little, Brown Book Group as one value.

    
    sku,flipkart_url,published,name,images,description,regular_price,sale_price,weight (kg),length (cm),width (cm),height (cm),Attribute 1 name,Attribute 1 value(s),Attribute 1 visible,Attribute 1 global,Attribute 2 name,Attribute 2 value(s),Attribute 2 visible,Attribute 2 global,Attribute 3 name,Attribute 3 value(s),Attribute 3 visible,Attribute 3 global,Attribute 4 name,Attribute 4 value(s),Attribute 4 visible,Attribute 4 global,Attribute 5 name,Attribute 5 value(s),Attribute 5 visible,Attribute 5 global,Attribute 6 name,Attribute 6 value(s),Attribute 6 visible,Attribute 6 global,Attribute 7 name,Attribute 7 value(s),Attribute 7 visible,Attribute 7 global,Attribute 8 name,Attribute 8 value(s),Attribute 8 visible,Attribute 8 global
    9780349415024,https://www.flipkart.com/the-rise-of-magicks/p/itmfe8x7jtgfzrju?pid=9780349415024&lid=LSTBOK9780349415024YB6FIO&marketplace=FLIPKART&srno=s_1_1&otracker=search&fm=organic&iid=14f5ef28-3cc2-4737-8f0f-db0b653f8a72.9780349415024.SEARCH&ssid=6jut7no6rk0000001583992283516&qH=8ebc2669ba082017,0,The Rise of Magicks,https://rukminim1.flixcart.com/image/800/800/k1nw9zk0/book/0/2/4/the-rise-of-magicks-original-imafkf746jf8xpny.jpeg?q=70,"On the shield, one of seven forged in the timeless past to hold back the dark, fell a single drop of blood. So the shield weakened, and the dark, spider-patient, waited as the decades passed, and the wound spread under the grass and ground.' The brilliant conclusion to the Chronicles of the One trilogy - an epic story of love, war, family and magic. Fallon Swift has spent all her life preparing for this moment. No longer can she stand by whilst her fellow Magicks are hunted by the fanatical Purity Warriors or rounded up and experimented on by the government. Fallon must follow her destiny to restore the magical shield that once protected them all. But she can't do it alone. It is time to build her army, to take on her nemesis and take down the enemy. She has learned to fight, now she must restore the light and banish the dark forever. The final battle has begun... Series praise: 'A match for end-of-the-world classics like Stephen King's The Stand' - New York Times Review of Books 'Breathtaking' - Heat",699,,0.3,18,15,2.5,ISBN13,9780349415024,1,0,ISBN10,,0,0,Authors,Roberts Nora,1,1,Publisher,"Little, Brown Book Group",1,1,Edition,2019,1,0,Pages,464,1,0,Language,English,1,1,Binding,Paperback,1,1
    
Viewing 2 replies - 1 through 2 (of 2 total)
  • You need two extra columsL

    Type – variable or variation
    Parent – the SKU of the parent product

    Like this:

    SKU,Parent,Type,Name,Visibility in catalogue,Regular price,Attribute 1 name,Attribute 1 value(s),Attribute 1 visible,Attribute 1 global
    test001,,variable,Product,visible,,Size,”S,M,L,XL,2XL”,0,1
    ,test001,variation,Product,visible,999,Size,XL,,1
    ,test001,variation,Product,visible,999,Size,L,,1
    ,test001,variation,Product,visible,999,Size,M,,1
    ,test001,variation,Product,visible,999,Size,S,,1
    ,test001,variation,Product,visible,999,Size,2XL,,1

    As for including the comma, enclose the value with “” for example: “Little, Brown Book Group”

    Plugin Support mouli a11n

    (@mouli)

    It’s been a while since we heard from you, so I’m marking this thread resolved. Hopefully, you’ve been able to resolve this, but if you haven’t, please let open up a new topic and we’ll be happy to help out.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to import comma separated value of attribute in csv’ is closed to new replies.