Combinations Import via CSV - Some work, some don't, same format?!? Mystery?

[redstyles]

Good Day,

I thought all my combinations imported without issues, until I went to go start associating all the pictures to them and saw the error that at least one attribute needs to be chosen. Half are there half aren't. You'll see in the attachment what I mean.

The raw data looks like:

1;Pick Color:BLUE-BLACK, Size:25;SWP1126-BLUE-BLACK-25;1;1
1;Pick Color:BLUE-BLACK, Size:26;SWP1126-BLUE-BLACK-26;4;0
1;Pick Color:BLUE-BLACK, Size:27;SWP1126-BLUE-BLACK-27;2;0
1;Pick Color:BLUE-BLACK, Size:28;SWP1126-BLUE-BLACK-28;0;0
1;Pick Color:BLUE-BLACK, Size:29;SWP1126-BLUE-BLACK-29;2;0
1;Pick Color:BLUE-BLACK, Size:30;SWP1126-BLUE-BLACK-30;2;0
1;Pick Color:BLUE-BLACK, Size:31;SWP1126-BLUE-BLACK-31;2;0
1;Pick Color:BLUE-BLACK, Size:32;SWP1126-BLUE-BLACK-32;1;0


All these worked except the last two. All the sizes and colors are in the attribute fields and I cannot find a pattern. Even went to go look in the MySQL backend and couldn't find anything. I'm sure i'm missing something stupid, but can someone take a look please?

Thanks in advance.

[redstyles]

After more testing, in my example all of the combinations work except the last two.

When I click on the edit button of the combination and reinput manually the color/size combo (which DOES not appear in the entry area)

If I click save then it tells me:

1 error

1. This combination already exists.

WTF!

If I erase the combo an redo it FROM SCRATCH it still doesn't display the attributes and if I try to associate a picture it says:

"you must add at least one attribute"

To further the confusion, I've installed the Inventory Tab, as per calisyoda : http://www.prestashop.com/forums/viewthread/92403/integration/import_unique_product_id_for_combinations

And ALL the combinations show up.

If I take a look at another sku:

2;Color:RINSE, Size:26;AP344Y702-RINSE-26;1;1
2;Color:RINSE, Size:27;AP344Y702-RINSE-27;1;0
2;Color:RINSE, Size:28;AP344Y702-RINSE-28;1;0
2;Color:RINSE, Size:29;AP344Y702-RINSE-29;2;0
2;Color:RINSE, Size:30;AP344Y702-RINSE-30;1;0
2;Color:RINSE, Size:31;AP344Y702-RINSE-31;2;0

The 5th and 6th Combo works, the others do not display attributes (image 3)

What am I doing wrong?

(btw- the second picture is of SWP1126-BLUE-BLACK-31)

[bluepack]

My import is pretty much the same structure as your and it and it imports fine.

Are there any trailing characters in your import file?

[redstyles]

I checked for anything with the import file, but all the structure is the same.

Why do some work and some don't?

As mentioned, here's an example:

1;Color:BLUE-BLACK,Size:25;SWP1126-BLUE-BLACK-25;1;1
1;Color:BLUE-BLACK,Size:26;SWP1126-BLUE-BLACK-26;4;0
1;Color:BLUE-BLACK,Size:27;SWP1126-BLUE-BLACK-27;2;0
1;Color:BLUE-BLACK,Size:28;SWP1126-BLUE-BLACK-28;1;0
1;Color:BLUE-BLACK,Size:29;SWP1126-BLUE-BLACK-29;2;0
1;Color:BLUE-BLACK,Size:30;SWP1126-BLUE-BLACK-30;2;0
1;Color:BLUE-BLACK,Size:31;SWP1126-BLUE-BLACK-31;2;0
1;Color:BLUE-BLACK,Size:32;SWP1126-BLUE-BLACK-32;1;0

All work except:

1;Color:BLUE-BLACK,Size:31;SWP1126-BLUE-BLACK-31;2;0
1;Color:BLUE-BLACK,Size:32;SWP1126-BLUE-BLACK-32;1;0


But if I add those just on their own (changing on to default) then they work.

Can someone please point me in the right direction. I looked in the DB as well and couldn't find anything weird.

This is all I need to finish this project.....

[redstyles]

I have no clue how this worked. But it did.

It actually killed two birds with one stone.

With the following SQL command, it not only associated all my combinations to their respective pictures (yes it's an all or nothing deal) but also fixed my Combinations issue. How this makes sense? I do not know.

TRUNCATE `ps_product_attribute_image`;
INSERT INTO `ps_product_attribute_image` SELECT `id_product_attribute`, `id_image` FROM `ps_product_attribute` pa LEFT JOIN `ps_image` i ON (pa.`id_product` = i.`id_product`);

I'm done. Thanks.