<Solved> How to use csv import for many colors & sizes for a single product?



  • @jnsgioia Helllo! Which way are you saying is right? Did you look at my screenshot of the two exact same products uploaded with the exact same file two months apart and they have different results?



  • @wakabayashi said in How do I use a csv import for a large amount of colors & sizes for a single product?:

    @alwayspaws Sorry, I can’t help you on this one. I have never worked with csv imports. To be honest you know much more about it than me. I believe that, Markus or Michael know the technical part.

    Thank you for looking, Emanuel. :)



  • @alwayspaws I did see the difference, that is why I looked at the csv file.

    I am wondering if it somehow saved with the wrong field delimiter when you changed the number. I was expecting to see a ; for the field delimiter and a , for the multivalue separator not a , for both. Also your file had quotes around the name and value entries which I don’t use (the quotes), and are not in the sample file.

    If you are testing on your test site could you upload the original combination file as it was and see if it overwrites the product to show the incorrect information? If it does, then something was changed in the upload process since the file was made and maybe @mdekker could tell you how you need to change your csv file.

    I don’t know if I am making any sense here :|

    This is the last combination csv which I uploaded.
    0_1507761615035_Combinations_import.csv



  • I use semicolon as a field delimiter too. The comma is a source of difficulties. All “string” fields i embrace with quotes.



  • This post is deleted!


  • @jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?:

    @alwayspaws I did see the difference, that is why I looked at the csv file.

    I am wondering if it somehow saved with the wrong field delimiter when you changed the number. I was expecting to see a ; for the field delimiter and a , for the multivalue separator not a , for both. Also your file had quotes around the name and value entries which I don’t use (the quotes), and are not in the sample file.

    If you are testing on your test site could you upload the original combination file as it was and see if it overwrites the product to show the incorrect information? If it does, then something was changed in the upload process since the file was made and maybe @mdekker could tell you how you need to change your csv file.

    I don’t know if I am making any sense here :|

    This is the last combination csv which I uploaded.
    0_1507761615035_Combinations_import.csv

    You made a lot of sense and this is a great idea. I’ve been trying to find the file again.



  • @alwayspaws You’ll be angry with me… Perhaps, it would be better to try manual import via the phpmyadmin or HeidiSQL?
    And i froget to mension - i use the double quote for text

    UPD: tried 2 open your CSV in the Libreoffice calc - everything is Ok, i set the flag “Quoted field as text” - everything is perfect.



  • @DaoKakao :) How could I be angry with my good friend? :)

    I have only finally felt comfortable with csv’s one month ago. I found my original openoffice calc .ods file that I uploaded in July and made a copy to test it now, as @jnsgioia suggested. I’m trying to convert the .ods to .csv with field delimiter of semicolon and text delimiter of a comma.



  • @jnsgioia @DaoKakao Here are the results of importing the original csv for the same product today as back in July 2017. I included .csv and screenshot of product which shows that the correct and incorrect display of sizes and colors attributes TODAY, after uploading the attached .csv.

    Thank you very much for your suggestion @jnsgioia

    0_1507821034208_6-7-17-products-testing-on-10-12-17.csv

    New screenshot of same product incorrectly showing sizes and colors available selections:

    0_1507821192850_Result of uploading old csv with same product ID - Screen Shot 2017-10-12 at 11.05.45 AM.jpg



  • @daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?:

    @alwayspaws You’ll be angry with me… Perhaps, it would be better to try manual import via the phpmyadmin or HeidiSQL?
    And i froget to mension - i use the double quote for text

    UPD: tried 2 open your CSV in the Libreoffice calc - everything is Ok, i set the flag “Quoted field as text” - everything is perfect.

    I didn’t see this update because I was working on this. Let me try that! I will upload it again and post the results. Thank you again. :)



  • @alwayspaws open it with | as the separator. You will need to put it in “other”



  • @jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?:

    @alwayspaws open it with | as the separator. You will need to put it in “other”

    You came on just in time because the latest suggestion did not work. It resulted the same way with both showing.



  • @alwayspaws Your csv is using the comma as a delimiter:

    ID,Reference #,Combination Reference,Name,Combination Name,Combination Value,Combination Quantity,Categories,“Tags (x,y,z…)”,Price,Weight,Short description,Meta title,Meta description,Description,“Image URLs (x,y,z…)”,Tax rules ID,“Available for order (0 = No, 1 = Yes)”,“Show price (0 = No, 1 = Yes)”,Active (0/1),Quantity,Minimal quantity,Visibility,IMAGE LABELS (ALT TEXT)
    230,230,230-13,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,baby blue”,100,18.99,0.05,
    230,230,230-14,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,baby blue”,100,18.99,0.05,
    230,230,230-15,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XS,black”,100,18.99,0.05,
    230,230,230-16,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“SM,black”,100,18.99,0.05,
    230,230,230-17,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“MD,black”,100,18.99,0.05,
    230,230,230-18,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“LG,black”,100,18.99,0.05,
    230,230,230-19,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XL,black”,100,18.99,0.05,
    230,230,230-20,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,black”,100,18.99,0.05,
    230,230,230-21,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,black”,100,18.99,0.05,
    230,230,230-22,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XS,bright pink”,100,18.99,0.05,
    230,230,230-23,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“SM,bright pink”,100,18.99,0.05,
    230,230,230-24,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“MD,bright pink”,100,18.99,0.05,
    230,230,230-25,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“LG,bright pink”,100,18.99,0.05,
    230,230,230-26,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XL,bright pink”,100,18.99,0.05,
    230,230,230-27,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,bright pink”,100,18.99,0.05,
    230,230,230-28,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,bright pink”,100,18.99,0.05,
    230,230,230-29,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XS,light pink”,100,18.99,0.05,
    230,230,230-30,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“SM,light pink”,100,18.99,0.05,
    230,230,230-31,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“MD,light pink”,100,18.99,0.05,
    230,230,230-32,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“LG,light pink”,100,18.99,0.05,
    230,230,230-33,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XL,light pink”,100,18.99,0.05,
    230,230,230-34,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,light pink”,100,18.99,0.05,
    230,230,230-35,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,light pink”,100,18.99,0.05,
    230,230,230-36,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XS,purple”,100,18.99,0.05,
    230,230,230-37,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“SM,purple”,100,18.99,0.05,
    230,230,230-38,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“MD,purple”,100,18.99,0.05,
    230,230,230-39,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“LG,purple”,100,18.99,0.05,
    230,230,230-40,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XL,purple”,100,18.99,0.05,
    230,230,230-41,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,purple”,100,18.99,0.05,
    230,230,230-42,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,purple”,100,18.99,0.05,
    230,230,230-43,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XS,red”,100,18.99,0.05,
    230,230,230-44,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“SM,red”,100,18.99,0.05,
    230,230,230-45,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“MD,red”,100,18.99,0.05,
    230,230,230-46,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“LG,red”,100,18.99,0.05,
    230,230,230-47,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“XL,red”,100,18.99,0.05,
    230,230,230-48,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“2XL,red”,100,18.99,0.05,
    230,230,230-49,Humorous Dog Hoodie printed with Why don’t you go fetch!,“size,color”,“3XL,red”,100,Dog Clothes; Dog Hoodies,“dog hoodie, hoodies, outerwear, hooded sweatshirts”,18.99,0.05,Dog Hoodie - Why don’t you go fetch! A funny dog hoodie for dogs and dog lovers! Available in several sizes and colors.,Humorous Dog Hoodie printed with Why don’t you go fetch!,Dog Hoodie - Why don’t you go fetch! A funny dog hoodie for dogs and dog lovers! Available in several sizes and colors.,“Dog Hoodie - Why don’t you go fetch! A funny dog hoodie for dogs and dog lovers! Available in several sizes and colors. Delightful, warm and cozy for your dog and you!”,https://www.alwayspaws.com/images/dog_clothes/dog-hoodies/dog-hoodies-hooded-sweatshirt-why-dont-u-go-fetch-blue.jpg,40,1,1,1,75,1,Funny Dog Hoodie printed on the back with the words Why don’t you go Fetch so it shows up on the top of your dog. Available in many colors and sizes.



  • None of that looks the way it is on my computer. I do not have any quotes around anything but I will uncheck the “comma” which has been working for the past six months.
    Did not work.



  • @alwayspaws I opened the file in notepad, which shows how it looks to the upload mechanism.



  • This post is deleted!


  • Can i ask you to send the original ods file? I’ll try on my snadbox. ichest@gmail.com



  • You either need to try the pipe symbol or a ; actually anything except a comma



  • OK @DaoKakao thank you.

    @jnsgioia I have tried several things. Thank you. If I don’t use the comma it is not formatted properly.



  • Let me send to you @DaoKakao


Log in to reply
 

Looks like your connection to thirty bees forum was lost, please wait while we try to reconnect.