Jump to content
thirty bees forum
  • 0

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


Question

Posted

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

10 answers to this question

Recommended Posts

  • 0
Posted

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?

  • Thanks 1
  • 0
Posted
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.

  • 0
Posted

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?

  • 0
Posted
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

  • 0
Posted

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:

image.png.6686aa1eb716d49dbb7aaf15bfaf135f.png

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:
image.png.a565b643d0d69949b14a2620ee27e700.png

  • 0
Posted

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.

  • Thanks 1

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