alwayspaws

My latest attempt again failed. Products CSV - just one product with two colors and eight sizes. 01508208740243products_import-worksheet.csv Combinations CSV: 01508208789132combinations_import-template-worksheet.csv I think I should make a copy of my tee shirts CSV that worked and try it again unless someone sees something wrong with these CSV's. Settings for import: Field separator: ^ (caret) Multiple value separator: semicolon Size options do not show up, item shows "this product is no longer in stock" and the tags are cut off again. @lesley @mdekker Can you please look at the CSV imports? How can all these things suddenly go wrong?

@traumflug Don't worry, I understand you. We need your help. Please don't go away! I always thank whomever helps me. I'm officially thanking you now for everything you've done so far!

There have been problems with the forum post loading. You go to the page from the email alert you get and you have to reload or wait and scroll and repeat in order to see the latest posts.

@zimmer-media said in <Reopened> How to use csv import for many colors & sizes for a single product?: @alwayspaws It is best to ignore the product ID when selecting the fields. Use product reference as key in the previous screen. Hi. Do you mean delete that column because if I'm going to ignore it, what do I need it for? :) Can I just use the Product Reference (Reference number) and Reference as the Combination Reference? Thank you.

@jnsgioia said in <Reopened> How to use csv import for many colors & sizes for a single product?: @alwayspaws I did update it. I downloaded the zip file he provided and uploaded it like a new module to TB. It updated the old module. Great! I've never had to update a module before. Thanks.

I know you're trying to help me but I know that: and I need to get off the computer now even though you're trying to help. Thank you.

Thank you to everyone for trying to help me. I will try again later.

@daokakao said in <Reopened> How to use csv import for many colors & sizes for a single product?: @alwayspaws There's a mistake: you've inserted the combinations ref numbers into the PRODUCT_ID field! And your last sample files seems to be ok How can that be wrong?

I'm very confused. The test product ID is 1000 and the test combination reference numbers are 1000-1 1000-2 1000-3 1000-4 1000-5 1000-6 1000-7 1000-8 I don't know what's wrong. I need a break. It took this long to test because my host had to reinstall my development site and then there was trouble and they had to do it manually. Sorry.

@daokakao said in <Reopened> How to use csv import for many colors & sizes for a single product?: Look: PRODUCTID is the 'artifical' index and primary key of 'products' table, it assigned automatically and should not be changed. The PRODUCTID field in the 'COMBINATIONS' table and in the combinations csv is binding with the 'products' table. So, when you have lets say 10 combinationsof one product, then you should have 10 lines in the combinations CSV, each of them starting with the same number. And this number MUST be equal with corresponding product_id in the 'products' table Here are my combination and then product .ods. I didn't add all the colors because I wanted to test them first: 01508174344041combinations_import-template-worksheet.ods 01508174418362products_import-worksheet.ods

@DaoKakao please see this, which is why I changed it: @jnsgioia said in <Reopened> How to use csv import for many colors & sizes for a single product?: @alwayspaws The Reference column is the sku for the combination. I use the product reference number-#. For instance, if my product sku (product reference number) is SG201 and I have 4 combinations for that product then the reference column would contain SG201-1 SG201-2 SG201-3 SG201-4. Looking at your spreadsheet it looks like you have that in the product id field. You should have your TB product ID (the number in the first column of your product list in the back office) in that column.

Let's forget about the image alt text question. I wasn't talking about images. Did you update @innercode's module - nothing is working for me right now. I can't even get @innercode to be hotlinked. I'm done for a while. I have all the instructions for importing, etc. Thanks very much for the help.

@innercode How do I apply the update? Is it a new version and I upload the zip file that is the update?

I went back to my old method just for the product combination ID's. Are my combination attributes and values correctly formatted now? 01508170264231combinations_import-template-worksheet.ods Do I use ALT text for the images on both the product and combinations .csv's? Do you use the image position column? If you do, do you add a specific url by color for each line? Update: the import did not work. It doesn't show my size selections:

Reopened due to questions about formatting sample combinations import csv. FYI: I switched to LibreOffice. I deleted all columns I never use. Are my combination attributes and values correctly formatted now?

@innercode said in Can I change default to "switch to image editing" in Mass Combinations Update?: Just to let you all know. New version is now available on Addons. Currently this feature is supported only in PS1.6 and TB, but as I understand there are no merchants who use PS1.7 :) Exactly where is the download for the update please? I went here but do not see it. I also PM'd you but I don't think PS Addons let it go through because my 3 months tech support is over. https://addons.prestashop.com/en/fast-mass-updates/17917-mass-combinations-update.html Thanks!

@vincentdenkspel He really was being sarcastic but it does have a negative touch. He may be as frustrated as we are when we come across these stumbling blocks. Kudos to you about mentioning the crowdfunding. I was following that closely! :)

@jnsgioia said in [Solved by DaoKaKao] How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws Yeah! :) @jnsgioia @DaoKakao Right on! @jnsgioia I propose that we clean up this post because we don't want anyone new coming along and trying all the wrong things from misconceptions. I'm going to delete what's unnecessary in my opinion. Please delete and update into one or two posts what is critical for potential users. You don't have to delete upvoted posts. Just combine them, if possible. Thanks!

LOL! @marci123 (grumpy cat). @vincentdenkspel He's being sarcastic. These English idiomatic phrases stump a lot of people. Just like @Occam saying "dream on". That made me laugh every time I noticed it. It's funny. It means that it's highly unlikely it will ever happen so it will only happen in your imagination. :) Of course, we all have great hopes and expectations and it's the imagination of the people here who help us update, change, configure, install and more whatever we need. :)

@DaoKakao FIXED! Thank you so much for all the help. Will need to get this sorted out tomorrow, please. Have a great day / evening! :) I know it is updated because I edited the alt text for the image a little bit. :)

Great! It took a long time to import but now I can import the combinations. So let me see what happens.

@DaoKakao Field delimiter is ^ (called caret) Should the Multiple value separator be semicolon if I use: size;color for combinations?

@jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws reverse them :) If you save the csv with a comma delimiter have the tb field separator comma, if you save it with a semi colon have the tb field delimiter semi colon @jnsgioia This is what I started out with and had no problems until I saw the combinations were put together.

@daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws Why don't you make a sandbox environments for new features testing? It will ease your life. I can send my version of CSV for you. just try to import it? @daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws Why don't you make a sandbox environments for new features testing? It will ease your life. I can send my version of CSV for you. just try to import it? I tried to import it but didn't see these two when I went to open and save: Text values are in doublequotes: yes Save fields as on screen: yes

@daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws No, this is free - you should organize a sandbox by yourself. Here's an alternative for XAMPP: https://www.mamp.info/en/ - for MAC. If you encounter the problems with APACHE/NGINX configuration - i can help you @alwayspaws said in How do I use a csv import for a large amount of colors & sizes for a single product?: I’m currently using a test copy of my site in TB. This is exactly what the sandbox is I will try that. I'm having problems with the import.