Resolved Still confused about exporting and importing virtuemart custom fields

Hello Karin,
Let us go with one step at a time and fix your export and then move on to import. Did you check Product export with custom fields document to know on how to export your custom fields? What is the type of custom fields you are trying to export?

Hello theruna,

they are labels as you can see. THey are used for rings with different properties. For example:

A ring can be gold/silver, can be of different heights and for a different gender. Each of these properties form a different childprodukt. That works fine as you can see in the screenshot. Now, I want to export / import those children. As for the import I have a CSV from my supplier that I want to copy data from to the CSV to be imported.

When using your tutorial, I get somethoing like this:

99_DR_Test3platin,,,,
,Eigenschaften,,selectoptions=[
{
"voption": "clabels",
"clabel": "Geschlecht",
"values": "weiblich\r\nm\u00e4nnlich"
},
{
"voption": "clabels",
"clabel": "Legierung",
"values": "Gold 333\r\nGold 585"
},
{
"voption": "clabels",
"clabel": "Ringbreite",
"values": "6\r\n8"
},
{
"voption": "clabels",
"clabel": "Ringgr\u00f6\u00dfe",
"values": "50\r\n60"
},
{
"voption": "clabels",
"clabel": "Anzahl Diamanten",
"values": "40\r\n80"
}
]|options={
"423": [
"",
"",
"",
"",
""
],
"429": [
"weiblich",
"Gold 333",
"6",
"50",
"80"
],
"430": [
"",
"",
"",
"",
""
]
}|,0.00

But It would be much easier if I got one child produkt per line with it properties.

Is that possible?

Regards

Hello Karin,
Which fields you added to your export and for which field you are getting these values? You still did not answer my question of what custom field type are these? Can you go to VirtueMart Custom fields page, click on the custom field and post a screenshot?

Of course:

Hello,
Thank you for those screenshots. You are using Multi variant custom field type. Did you add custom_title and custom_value fields in your export fields? These fields will get you the values for a specific product.

Yes, but like this:

99_DR_Test3platin,,,,
,Eigenschaften,,selectoptions=[
{
"voption": "clabels",
"clabel": "Geschlecht",
"values": "weiblich\r\nm\u00e4nnlich"
},
{
"voption": "clabels",
"clabel": "Legierung",
"values": "Gold 333\r\nGold 585"
},
{
"voption": "clabels",
"clabel": "Ringbreite",
"values": "6\r\n8"
},
{
"voption": "clabels",
"clabel": "Ringgr\u00f6\u00dfe",
"values": "50\r\n60"
},
{
"voption": "clabels",
"clabel": "Anzahl Diamanten",
"values": "40\r\n80"
}
]|options={
"423": [
"",
"",
"",
"",
""
],
"429": [
"weiblich",
"Gold 333",
"6",
"50",
"80"
],
"430": [
"",
"",
"",
"",
""
]
}|,0.00

It t possible to get the vlaues per variant in different cells (one variant per row)?

Thanks for the great support by the way!

Hello,

99_DR_Test3platin,,,,
,Eigenschaften,,selectoptions=[
{
"voption": "clabels",
"clabel": "Geschlecht",
"values": "weiblich\r\nm\u00e4nnlich"
},
{
"voption": "clabels",
"clabel": "Legierung",
"values": "Gold 333\r\nGold 585"
},
{
"voption": "clabels",
"clabel": "Ringbreite",
"values": "6\r\n8"
},
{
"voption": "clabels",
"clabel": "Ringgr\u00f6\u00dfe",
"values": "50\r\n60"
},
{
"voption": "clabels",
"clabel": "Anzahl Diamanten",
"values": "40\r\n80"
}
]|options={
"423": [
"",
"",
"",
"",
""
],
"429": [
"weiblich",
"Gold 333",
"6",
"50",
"80"
],
"430": [
"",
"",
"",
"",
""
]
}|,0.00

You will be seeing this value for custom_param field. What about custom_title and custom_value fields? Can you post your export file to check? Also post your export debug log. To get the debug log check How to collect debug information? document. Can you also confirm that your custom fields are Multi variants custom field type?

Can I send you the credentials to the file privately as it may contain personal data?

Hello,

Yes, you can send it via email to tharuna@csvimproved.com. Thank you.