Jump to content
thirty bees forum

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


alwayspaws

Recommended Posts

  • Replies 142
  • Created
  • Last Reply

Top Posters In This Topic

@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. 01507761615035Combinations_import.csv

Link to comment
Share on other sites

@jnsgioia @DaoKakao

I use openoffice calc

I have tried so many different options now that I'm completely lost. No imports are working correctly. They all do not format properly when I get to the product import stage.

I looked at your csv @jnsgioia. What separator do I open it with? I use openoffice calc

0_1507815820704_what separators do I open this with - Screen Shot 2017-10-12 at 9.41.30 AM.jpg

Link to comment
Share on other sites

@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. 01507761615035Combinations_import.csv

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

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

@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

015078210342086-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

Link to comment
Share on other sites

@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. :)

Link to comment
Share on other sites

@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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...