1. millermultimedia
  2. RO CSVI
  3. Thursday, 14 May 2015
  4.  Subscribe via email
Joomla 3.4
VM 3.07
CSVI 5.21.2

Hello. I have been using CSVI for years with great success. A couple years ago I developed a website using VM 2 and Joomla 2.5. This site has around 5,000 products. Many of which are the same product but with variations in color and custom product fields. This was due to VM 2 not having the ability for Child products to have their own custom fields so I was left with defining every product as a Parent. Recently I have upgraded the site to VM 3 and Joomla 3. I am now looking for a way to simplify the product listings by converting many of the products to Child products. Using CSVI I can set the Parent ID, and remove categories for the products I wish to convert. What I have not been able to figure out is if there is a way to also enable the "disabler" field for the custom fields, of the products I am changing, into Child Products. The disabler field (either a 0 or a 1) tells Virtuemart to ignore the parent product's custom fields and only display the Child Product custom fields. I need to change these all to "1" when I process the child products. Can anyone think of a way to accomplish this using CSVI?

Thanks!
Accepted Answer Pending Moderation
Hello,

I am not sure which field you mean by the "disabler field". Which field is it in the database, do you know?
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Hi Roland. In VM 3 when you set up a Child product with it's own Custom Fields, in the custom fields area for each product, you get two check box options for each child custom field "Disabler (D) and Override (O)". The Disabler option disables the display of the parent's custom field and only displays the child's custom field in the product details. These options are stored in the _virtuemart_product_customfields database table along with the custom field setting.

I'm not sure how you would approach being able to set these during a standard Virtuemart import as the two fields are dependent on each custom field. Can CSVI do a custom import just on this database table? For example, if I know all virtuemart_product_id's can I have it then set all disabler values to "1"?

Thanks for your help.
--Miller
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Miller,

you get two check box options for each child custom field "Disabler (D) and Override (O)".
That was not an easy find !! It just says d: and o:. Very obscure :P

The disabler value is not just a 1 or 0, it actually is the virtuemart_customfield_id of the parent product that is stored in the disabler field. The same goes for the override field.

Can CSVI do a custom import just on this database table?
Yes it can because it has a primary key. So you can use the Custom table import.

You will need to find out the parent first of that child product. Then you need to find the virtuemart_product_id of the parent product, then find the virtuemart_customfield_id for that parent product. This value can be used for the disabler and/or override field.
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Hi Roland. I agree, very obscure and also not very well documented on how the two fields work. Sorry, I should have dug further into the actual field values. I have the Product ID, Parent Virtuemart Product ID, looks like I will need to dig up the Parent Custom Field IDs and then come up a way to relate these all for the import. It is this last step that is going to be a big headache.

Thanks for digging into this and for the recommendation on how to do the import.
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


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