How can I export a sample CSV file of a product with combinations to understand how to create similar products to import via CSV?

[30knees]

How can I export a sample CSV file of a product with combinations to understand how to create similar products to import via CSV?

I see the sample products and combinations files under Parameters>CSV Import. But I don't understand from them what I would need to enter in order to have a combination with multiple attribute values, eg:

Color: Black
Size: 44

[30knees]

@datakickAny way to do this? I've tried different values for eg

Color: Black
Size: 44

but can't get it to work.

[the.rampage.rado]

When in doubt watch an Indian how-to video: 🙂

 The process is 1:1 I just have one concern - as far as I see if we click "Delete all combinations before import" it deletes all combinations for all products in the store, not only the ones for the currently imported products? If so - if we import combinations over an existing product with combinations what is the behavior - are they automatically replaced or they are simply added to the already existing combinations?

[30knees]

11 hours ago, the.rampage.rado said:

When in doubt watch an Indian how-to video: 🙂

as far as I see if we click "Delete all combinations before import" it deletes all combinations for all products in the store, not only the ones for the currently imported products? If so - if we import combinations over an existing product with combinations what is the behavior - are they automatically replaced or they are simply added to the already existing combinations?

Thanks! I somehow thought this was a thirtybees feature and not one from PS! The video didn't explain multiple combinations such as size and colors but I experimented based on the information the video provided for a basic import and this setup works:

Attribute (Name:Type:Position)*    Value (Value:Position)*
Colour:radio:0;Shoe size:select:0    Black:0;42:0

And yes, delete all means delete all, not just of those being imported! However, the warning pop-up window says: "Are you sure that you would like to delete this entity combinations?" I think that's wrong because it indicates that it's only for the entity being imported.

[the.rampage.rado]

This part of the system is quite complex and not many users actively use it so it's normal that it gets less attention (only bugfixes, etc).

What is the result when you reimport the same product with different combinations? Are they combined or the first batch is truncated?

[30knees]

13 minutes ago, the.rampage.rado said:

What is the result when you reimport the same product with different combinations? Are they combined or the first batch is truncated?

If I re-import the same file but add an element then the combinations get doubled, unfortunately, instead of updated:

TopShoe, Black, 49

TopShoe, Black, 49, Men's

[the.rampage.rado]

I don't have luck with the combinations in my test install.

I made a python script that creates my combinations from two lists. The output is as follows:



The files imports without issues but no combinations are assigned to the previously imported products with the same reference numbers. 

I noticed that the color and size attributes don't have the Bulgarian name properly translated - fixed that - no luck with the import.
Pre-created the sizes and colors with the appropriate names - again no combinations imported.

Otherwise, deletion the existing combinations can be achieved with a SQL query, then we import the current combinations.

Question regarding the position in the csv file in columns A and B should it match the position in:

[datakick]

Please file a github issue, with sample CSV files.

Describe expected and actual results.

[30knees]

@the.rampage.radoI see a space after the ;
Does removing the space change anything?

Edited October 15 by 30knees

[the.rampage.rado]

2 hours ago, 30knees said:

@the.rampage.radoI see a space after the ;
Does removing the space change anything?

The demo csv also have a space there. Now I tested without space and again it is not importing them.

 

[the.rampage.rado]

Of course the issue was misconfiguration on my side. I saw the updated combinations file and I saw that I'm setting Reference and not Product Reference in my import template... 😞

Now they import correctly.