Categories
View Replies (3)

Resolved Importing parameters from XML as product options

  1. andrejk
    andrejk
  2. RO CSVI
  3. Tuesday, 21 January 2025
  4.  Subscribe via email
Hello,

Joomla 4.4.10, VM 4.2.4, RO CSVI 8.11.1.

I have an XML feed for importing products into virtuemart. I need advice on how to import the <option> and <param> parts



<product>

 <id>23538</id>

 <code>D_B22403</code>

 <name>

<![CDATA[ BEFLY bike BeFly WHIP ]]>

</name>

<manufacturer>

<![CDATA[ BEFLY ]]>

</manufacturer>

<description>

<![CDATA[ <p>Frame: 1020 Hi-ten Steel TIG welded]]>

</description>

<category>

<![CDATA[ Bicycles / BMX bikes ]]>

</category>

<price_msrp>369</price_msrp>

<images>

<url>https://www.sloger.sk/images/eshop/big/23538-befly-bicykel-befly-whip-07b7dff42c90a89ac8494b69e582c478.jpg</url>

<url>https://www.sloger.sk/images/eshop/big/23538-befly-bicykel-befly-whip-2cec9ae32f9f4cdc9ac13d77cacda42d.jpg</url>

</images>

<options>

<option>

<id>25638</id>

<code>D_B22424</code>

<name>

<![CDATA[ black ]]>

</name>

<ean>8581502242409</ean>

<price_msrp>369</price_msrp>

</option>

<option>

<id>25637</id>

<code>D_B22403</code>

<name>

<![CDATA[ salmon ]]>

</name>

<ean>8581502240306</ean>

<price_msrp>369</price_msrp>

</option>

</options>

<param>

<param_name>

<![CDATA[ Color ]]>

</param_name>

<val>

<![CDATA[ black ]]>

</val>

</param>

<param>

<param_name>

<![CDATA[ Set ]]>

</param_name>

<val>

<![CDATA[ Other ]]>

</val>

</param>

</product>
<product>

Best regards
Andrej
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
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.
Attachments (1)
Screenshot 2025-02-12 at 7.29.25 PM.png Screenshot 2025-02-12 at 7.29.25 PM.png
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
andrejk
andrejk
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
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?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!