Categories
View Replies (3)

Resolved copy customfields values from parent to childs

  1. soura123
    soura123
  2. RO CSVI
  3. Monday, 07 June 2021
  4.  Subscribe via email
hello,
we have customfieldsforall on our site
our setup is
parent product with stockable customfields (sizes)
and on the parent product we add some extra customfields (season, color, etc)
with pitty today we realize that if user filter by size it does not display the other filters on the category so vendor suggest to use csv
to add all parent custom fields values to child also using csvi...
so my question is
i export all products and see this for example

<product>
<virtuemart_product_id><![CDATA[18324]]></virtuemart_product_id>
<product_sku><![CDATA[1970K]]></product_sku>
<custom_title><![CDATA[Εποχή~Σύνθεση~Χρώμα~Φύλο~Μανίκι]]></custom_title>
<custom_param><![CDATA[Καλοκαίρι~Φορεμα Εξωτερικό 50% Πολυεστέρας 47% Βαμβάκι 3% Ελαστομερής πολυουρεθάνη Φόδρα 100% Βαμβάκι~Κόκκινο~Κορίτσι~Κοντό μανίκι]]></custom_param>
<custom_param_el_gr><![CDATA[Καλοκαίρι~Φορεμα Εξωτερικό 50% Πολυεστέρας 47% Βαμβάκι 3% Ελαστομερής πολυουρεθάνη Φόδρα 100% Βαμβάκι~Κόκκινο~Κορίτσι~Κοντό μανίκι]]></custom_param_el_gr>
</product>

<product>
<virtuemart_product_id><![CDATA[18325]]></virtuemart_product_id>
<product_sku><![CDATA[1970K]]></product_sku>
<custom_title><![CDATA[]]></custom_title>
<custom_param><![CDATA[]]></custom_param>
<custom_param_el_gr><![CDATA[]]></custom_param_el_gr>
</product>

<product>
<virtuemart_product_id><![CDATA[18326]]></virtuemart_product_id>
<product_sku><![CDATA[1970K]]></product_sku>
<custom_title><![CDATA[]]></custom_title>
<custom_param><![CDATA[]]></custom_param>
<custom_param_el_gr><![CDATA[]]></custom_param_el_gr>
</product>

so the id 18324 is the parent and i need to import this values to its child 18325 and 18326

a little bit of help please

thanks
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
so the id 18324 is the parent and i need to import this values to its child 18325 and 18326

With RO CSVI Field copy rule, you can copy values from one field to another of the same record but not for previous or upcoming records. The only way i see it is writing a custom rule to read parent values and use it for child products fields.
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
soura123
soura123
Accepted Answer Pending Moderation
yes i will need a how to please
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Please check the linked document in my previous reply to create a custom rule in RO CSVI. In the custom rule you need to write query to select the parent product id based on the child product id or get parent product id based on parent product SKU value in fields. With the parent product id write queries to read values of custom fields you need. You need to get the custom field values in the same format as you see for parent product. You can look for these queries in RO CSVI VirtueMart addon extension and for product export at location plugins/csviaddon/virtuemart/com_virtuemart/model/export/product.php.
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!