Resolved Importing parameters from XML as product options

Hello Andrej,

I need advice on how to import the <option> and <param> parts

May I know on how you want to import <option> and <param> fields? From example <option> node looks as child products. Are these child products? What about <param> node? Which field you want it to import?

Hello Tharuna,

May I know how you want to import the <option> and <param> fields? From the example, the <option> node looks like child products. Are they child products? What about the <param> node? Which field do you want to import?

Sorry for the late reply - so for now we will only import the <param> part, I'm not sure how best to do it but maybe as a product property...?


Best regards
Andrej

Hello Andrej,

I'm not sure how best to do it but maybe as a product property...?

From the values in XML param node can be set as custom fields. Add two fields custom_title with Your field set to param/param_name and custom value with Your field set to param/val. See attached screenshot.

If you have multiple param nodes then add multiple combine field for param/param_name and multiple combine field for param/val. You can then use RO CSVI Combine rule to combine all param/param_name to custom_title field using ~ as combine character. Apply the rule on custom_title field. Create another combine rule for param/val and apply the rule on custom_value field. Run the import and check.

Hello, Tharuna,

custom_title and custom_value works fine, just how to combine them exactly now for XML for example:

<param>

<param_name>

<![CDATA[ Color ]]>

</param_name>

<val>

<![CDATA[ black ]]>

</val>

</param>

<param>

<param_name>

<![CDATA[ Color ]]>

</param_name>

<val>

<![CDATA[ Blue ]]>

</val>

</param>

<param>

<param_name>

<![CDATA[ Color ]]>

</param_name>

<val>

<![CDATA[ orange ]]>

</val>

</param>

<param>

<param_name>

<![CDATA[ Number of teeth ]]>

</param_name>

<val>

<![CDATA[ 25 - 32 teeth ]]>

</val>

</param>

<param>

<param_name>

<![CDATA[ Set ]]>

</param_name>

<val>

<![CDATA[ Other ]]>

</val>

</param>

And how to ensure that these values are created in virtuemart as product properties?
In the attachment we send the settings.

Best regards
Andrej

Hello Andrej,

custom_title and custom_value works fine, just how to combine them exactly now for XML for example:

You need to use RO CSVI combine rule to combine XML nodes and apply the rules on custom_title and custom_value fields. See attached screenshots.

and how to ensure that these values are created in virtuemart as product properties?

I am not sure about your question. Are you asking on how to create these fields as custom fields first before running product import?

Hello Tharuna,

that's great, but what if there are more param_nam and param_val attributes (like 20 ) in the XML, some products can have one param_name and param_val and another 20?

Best regards
Andrej

Hello Andrej,
In that case you need to add maximum possible combine fields in template fields and same should be added to the rules. Say for example if maximum possible nodes are 20 then you need to add 20 combine fields for custom_title and 20 combine fields for custom_value. In the import template on File tab set Skip empty custom fields to Yes so empty values are ignored on import.

Hello Tharuna,

please, can RO CSVI create a customfield when importing if it is not in virtuemart but in XML?
and please, how to import colors, size, located at, ..... to be displayed as a combobox with the possibility of selection at the product (possible Multi Variant)?

Best regards

Andrej

Hello Andrej,

can RO CSVI create a customfield when importing if it is not in virtuemart but in XML?

RO CSVI cannot create custom fields with VirtueMart Product import. You should use VirtueMart custom fields import, create the custom fields first and then run VirtueMart product import. You can use same import file to run VirtueMart custom fields import.

and please, how to import colors, size, located at, ..... to be displayed as a combobox with the possibility of selection at the product (possible Multi Variant)?

Please check document Importing Multi Variant custom field. Follow the example CSV format in the document to create import with your XML file.

Hello Tharuna,

according to the instructions it can be done with one import (template), is it correct? Shouldn't I import the parents first and then the children?

Best regards
Andrej

Hello Andrej,

according to the instructions it can be done with one import (template), is it correct?

Yes you can import with one template.

Shouldn't I import the parents first and then the children?

You can import parent and child together in one template but make sure that parent row is imported first and then child products rows.

Hello Tharuna,

ok, I looked at the instruction, but there are CSV fields like product_sku of child product and I don't have it in XML and I don't know how to create it to be different for each child product (child)

Best Regards
Andrej

Hello Andrej,

but there are CSV fields like product_sku of child product and I don't have it in XML and I don't know how to create it to be different for each child product (child)

If you want to create a SKU using RO CSVI you can use RO CSVI Multireplace plugin and Unique ID to generate random string as product_sku on import. Let me know if that helps.