Resolved Question regarding XML for Virtue mart Product

Hello,

1. I would like export also value of certain custom fields is this possible?

Yes, You can add custom field as Individual template field in export template and run the export. If you do not see the template field then update available fields and check.

2. I would like export only product from one or two categories is this possible?

In export template settings on Options tab select the categories in Category filter, save the template and run the export. See attached screenshot.

3. I would like to use condition to export only product from some category if certain custom field exist is this possible?

You can export a product based on custom field value else skip the product on export. You can achieve this using RO CSVI Skip rule plugin. But you cannot check if the custom field exists using Skip rule.

Hi
I made test XML document

XML LAYOUT BODY:
<product>
<original_id>virtuemart_product_id</original_id>
</product>

I expected Id of product

My Output is:
<upload>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
<product>
<original_id>virtuemart_product_id</original_id>
</product>
</upload>

Is just layout Output should be Id numbers.

False alarm I find mistake should use [ ] [virtuemart_product_id] Now working Ok

So here I came to one problem,
current my xml - file_url
<image> images/shop/product/knux160405r11.jpg </image>

How to get
<image>https://my-site.com/images/shop/product/knux160405r11.jpg </image>

And product is
https://my-site.com/component/virtuemart/struzne-ploscice/knux-160405r11-qp1025?Itemid=161

Is not SEF

Also is it possible to show a block of code if custom field value exist.

Let say if Custom field Material : value: Steel | Steel alloys (P)

Then show all these block of code in XML:
____________________
<product_attribute>
<attribute_id>12</attribute_id>
<product_attribute_description>
<text>
<![CDATA[ Steel | Steel alloys (P) ]]>
</text>
</product_attribute_description>
</product_attribute>
________________________

In my old component which I use on J3 I did like thise in php:

if ($product->custom_field_90) {
echo "<product_attribute>\n";
echo "<attribute_id>12</attribute_id>\n";
echo "<product_attribute_description>\n";
echo "<text>";
list($value)=explode(chr(0),$product->custom_field_90);
if ($value == "VM_COS_MATERIAL) {
$matValue = Steel | Steel alloys (P)";
}

Thank you

Hello,

How to get
<image>https://my-site.com/images/shop/product/knux160405r11.jpg </image>

Use picture_url field as export field instead of file_url to get image URL with domain name

And product is
https://my-site.com/component/virtuemart/struzne-ploscice/knux-160405r11-qp1025?Itemid=161

Is not SEF

In your export template on Options tab set Export SEF URLs field to Yes, save the template and run the export. This should get SEF URL on export. See attached screenshot.

Also is it possible to show a block of code if custom field value exist.

Let say if Custom field Material : value: Steel | Steel alloys (P)

This should be possible with RO CSVI conditional rule plugin. If the value of custom field matches the value set in the conditional field then export the code set in conditional rule.

In your export template on Options tab set Export SEF URLs field to Yes, save the template and run the export. This should get SEF URL on export. See attached screenshot.

----

I did Use SEF option and in Joomla I have set Up SEF plugin. SO in another ticked I will give you site and FTP access and please check this too,

Thank you

Hello,
Just to update the ticket. This issue has been discussed in forum post with title Import prices and stock.

Hi
----

This should be possible with RO CSVI conditional rule plugin. If the value of custom field matches the value set in the conditional field then export the code set in conditional rule.
----


I try set up conditional field if value is greater than null then show block of code.

1. I create a rule: If custom exist Material obdelovanca

An I paste in Field/Value following:

<product_attribute>
<attribute_id>12</attribute_id>
<product_attribute_description>
<text>
[COM_VM_CUSTOM_LASNOSTI_MATERIJAL_OBDELOVANCA]
</text>
</product_attribute_description>
</product_attribute>

Unfortunately when I save Tags are striped and I get:

12

<text>
[COM_VM_CUSTOM_LASNOSTI_MATERIJAL_OBDELOVANCA]
</text>


Please check.

Thank you

Hello,
You need to decode the HTML tags to save it in text field. I have done that in your rule. Please run the export and check.

Oh sorry I just delete It
Didn't know you on at the moment
Omg sorry

I go inside rule see strange character and think maybe I done something wrong, so I paste again

But your support is supper fast
Thank you for that

I will try with

<product_attribute>
<attribute_id>12</attribute_id>
<product_attribute_description>
<text>
[COM_VM_CUSTOM_LASNOSTI_MATERIJAL_OBDELOVANCA]
</text>
</product_attribute_description>
</product_attribute>

Hello,

Oh sorry I just delete It
Didn't know you on at the moment
Omg sorry

No problem at all

I go inside rule see strange character and think maybe I done something wrong, so I paste again

I have fixed the rule again. Please check.

But your support is supper fast

Thank you for the feedback

Do you have enough permissions for Virtuemart to check Sef Links?

I have one more question regarding Cron Jobs
I triger Cron from my host:

/usr/local/bin/php /home/siga01/domains/strugarstvo.com/public_html/path/file.php

or browser

/usr/bin/wget -O /dev/null "https://tstrugarstvo.com/index.php?



What is correct: path for trigger template Bolha XML
Thank you

Something happen I don't know what but XML don't work anymore!

As soon I add <webshopLink>[product_url]</webshopLink> in XML Layout at template - XML Bolha SLO - I get this error:

This page contains the following errors:
error on line 15 at column 74: EntityRef: expecting ';'
Below is a rendering of the page up to the first error.
14 [basepricewithtax] 89 14 0.0150 [file_url] 1 3658 0 1 1


If I remove <webshopLink>[product_url]</webshopLink> Template works

Please check

Hello,
I added the node <webshopLink>[product_url]</webshopLink> to your XML Bolha SLO template and export works without any problem. Please check again.

Hi, I run template and then I wisit

https://strugarstvo.com/bolha.xml

And I get error

Without <webshopLink>[product_url]</webshopLink>

working good.

Hello,

Your URL contains ampersands, this character & and that is restricted in XMLs. To be able to use them you must enclose your value in CDATA tags, so set the CDATA option to Yes in your template field and try again then. That should resolve your issue.