Resolved Duplicate entry

Hello,
Do you have duplicate custom fields in VirtueMart with name barva? Check if you have uppercase or lowercase names. That should be causing this duplicate entry error.

Hi
I cannot have duplicate customfields named barva. I have only this customfields see attachment

Hello,
Ok custom fields looks good. When we update available fields we also consider updating multi variants. I am thinking there is a possibility of having duplicates of barva custom field in this table. Multi variant fields are stored in customfield_params field in #__virtuemart_product_customfields table. To check that, please do a RO CSVI Custom table export using #__virtuemart_product_customfields table and with fields virtuemart_product_id, virtuemart_custom_id and customfield_params run the export and post the export file. I can check if there are duplicates in the export file.

Hello
I checked multivariant fields and corrected a few records and the available fields are now updated OK.
I also created new template for export to XML file for all published products. But unfortunatelly it not working well. The XML file is empty. I am sedning you a debug file. Can you help me please what I am doing wrong?

Hello,
Glad to know duplicate entry error is solved.

I also created new template for export to XML file for all published products. But unfortunatelly it not working well. The XML file is empty. I am sedning you a debug file. Can you help me please what I am doing wrong?

In the export template in XML layout tab in Body field you have just set <SHOPITEM></SHOPITEM> but you also need to add field structure like below. That is just an example you need to create node names and fields as per your need in export. Try that and let me know.

<SHOPITEM>

<id>[product_sku]</id>

<name>[product_name]</name>

<description>[product_desc]</description>

<price>[product_price]</price>

</SHOPITEM>

Also check Custom XML section in Process XML document for more details.