Resolved import customfields variations color

Hello,

how i can import this color variatio each time to be adjustable from the xml file

You need to combine variation nodes using RO CSVI combine fields. There is no way to limit combine fields based on XML nodes so you need to add maximum possible combine fields in template and use them in combine rule.

but how, the variations is different eash time, can you give an example how to do that?

Hello,

the variations is different eash time,

Since we don't know number of variations in each XML you need set a maximum possible number and add those many combine fields in template fields. Like you assume the maximum number of variation nodes are 10 then add 10 combine fields in template fields and create a combine rule based on 10 variation nodes. If the XML has 5 variations then 5 values will be used and the rest will be empty in combine rule. Also in import template on File tab you can set Skip Empty custom fields to No, that way empty values are ignored and not processed on import. Hope that is clear now.

i need help with the combine rule
the fields are the same
<variations>
<variation>
<title>ΜΠΟΡΝΤΟ</title>
<price>0.0000</price>
<stock>10</stock>
</variation>
<variation>
<title>ΔΙΑΦΑΝΟ</title>
<price>0.0000</price>
<stock>7</stock>
</variation>
<variation>
<title>ΑΣΗΜΕΝΙΟ</title>
<price>0.0000</price>
<stock>14</stock>
</variation>
<variation>
<title>ΧΡΥΣΟ</title>
<price>0.0000</price>
<stock>21</stock>
</variation>
</variations>

can yoy please modify my template with a rule how to combine

Hello,
I modified your template with combine rule for custom_title field with 2 combine fields. You need to do the same for number of XML variation nodes you would like to add. I also see a problem with your XML file and that is because of image node with : image:image. See attached screenshot. To avoid those warnings you can set Error reporting to None in import template.

i do not understand what you did
we normaly jave to do this
<custom_title><![CDATA[Χρώμα~Χρώμα~Χρώμα~Χρώμα]]></custom_title>
<custom_value><![CDATA[ΜΠΟΡΝΤΟ~ΔΙΑΦΑΝΟ~ΑΣΗΜΕΝΙΟ~ΧΡΥΣΟ]]></custom_value>
Χρώμα= Color
and
ΜΠΟΡΝΤΟ~ΔΙΑΦΑΝΟ~ΑΣΗΜΕΝΙΟ~ΧΡΥΣΟ
is the colors

Hello,
Ah, I assumed XML variation title node as custom_title value. You need to change to apply the combine rule on custom_value field and set Default value for custom_title field as Χρώμα~Χρώμα~Χρώμα. This value should be set based on maximum variations node possible. So if there is possibility of 10 variations node in XML then Χρώμα should be set 10 times separated by ~ in custom_title field. Also in custom_value add 10 combine fields and set all 10 fields in combine rule. See attached modified template. I have set it for 3 values.

is there any rule or "hack" when the stock of the variation is 0 to skip that value?

if i put
Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα
and variations has 4 colors
it does not add anything to the product
i have set the skip to no and try to yes also but with no luck

Hello,

is there any rule or "hack" when the stock of the variation is 0 to skip that value?

There is no rule to skip only that value but it should skip the entire row with RO CSVI Skip rule.

Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα~Χρώμα
and variations has 4 colors
it does not add anything to the product
i have set the skip to no and try to yes also but with no luck

The count of custom_title and custom_value should be same and so it did not work for you. In this case you add 10 combine fields in template fields for custom_value with Your field value set as variations/variation/title. Add these 10 combine fields in RO CSVI combine rule and set Combine empty values to Yes in combine rule. That should solve the problem.

There is no rule to skip only that value but it should skip the entire row with RO CSVI Skip rule

can you please tell me how to do this????

fixed the other one with Combine empty values to YES and on template Skip empty custom fields to YES

Hello,

can you please tell me how to do this????

Are you importing stock value? If so may I know how you have it setup? I see custom_value and custom_title fields in your template. RO CSVI skip rule can be applied only on fields added in import template.

no i do not import stock because of the xml of vendor is incomplete
so i thought to just not add the variations with 0 stock
as customfield
but i do not know how to accomplish

Hello,
If the value is not read in import RO CSVI will not know how to skip the value using rules. So I don't see any way to skip variations nodes with stock 0.

i found this plugin and if i add a product manually does exactly what we want

https://www.virtueplanet.com/extensions/vp-advanced-custom-field

but it doew not works with csvi to mass import
is there any progress to add this?

Hello,

but it doew not works with csvi to mass import

Yes it does not work because we don't support it in RO CSVI.

is there any progress to add this?

As of now there is no plan to support this plugin in RO CSVI. You are our first user requesting to support this plugin if we get more request we shall consider it for future release.

can this implement for me for a payment ?

Hello,

You can send us the extension at support@rolandd.com and we can have a look at how much time/money it would cost to implement this.

i send you the email