jnsgioia

@alwayspaws When you get back to your computer and can see the screen shots the one for saving the first file should look like this except for the read only part:

@alwayspaws I checked your files. You are using a ; for both the field separator and the multivalue separator in the first one. You need to save the file using a ^ as the field separator like you did for the second one.

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

@alwayspaws I don't know about the image questions. I upload the images with the product csv and then use @innercode's module to attach them to the combinations. Your spreadsheet looks ok to me. What did you use as your field delimiter?

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

@alwayspaws Yeah! :)

@alwayspaws they were put together because you had a comma between them and the program was expecting a semi colon.

@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

Did you save it with field delimeter - comma and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above)

The problem is in the file you first posted you have a comma between your fields as well as between size and color. In the error you just got it is because for categories you are using a semi colon as a multivalue separator but you told the upload that the multivalue separator is a comma. I think if you change the comma between the size and color to a semi colon and save the file with the field separator as a comma it should work. Do I now have you completely confused? :)

Ok, I think I now see your problem. Am I correct in that in the file you sent to @DaoKakao you had a semi colon between size and color and you changed it to a comma recently?

@alwayspaws :) hope it works this time :)

The important thing is to have a different symbol as a field delimeter and a multivalue delimiter. In your first csv you were using a comma for both.

You need both

make sure when you are importing into tb to have the field separator as a ; and the multivalue as a ,

That is how it should look, with a semi colon as the field delimiter.

@alwayspaws Your newly named file is right! You just need to open it using the semicolon checked not the comma.

@alwayspaws To open it select comma. Then go to save as copy. ( I am assuming that openoffice is similar to libreoffice here. ) On the first popup box make sure "edit filter settings" is checked Then on the second popup box make sure the ; is selected as the field separator. Then try uploading the newly saved csv and let us know what happens :)

right now it is saved with a comma and you need it saved with a semi colon. I would just use the semi colon right now, because that is the default tb format. I had to use a | and a ~ instread of the ; and , because of some the content in the book csv fields.

I thought you were saving it not opening it. You will have to open it with the comma. And then save it with the semi colon.

@alwayspaws You need to click semicolon and unclick the comma. Or put a | in the other box and and unclick the comma

btw, the libreoffice calc file I opened wasn't a tb one it was an ebay one, so don't pay attention to the content. I just wanted to illustrate the little save as box. :)

Your save as should look like this:

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

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