Duplicate Custom Fields in Product Children

[hazael]

I found this solution in CSVI - support for "custom_disabler"
Maybe it will solve my problem.

https://csvimproved.com/support/import/1120-product-import-with-custom-fields

[GJC Web Design]

that is this

so u mean re-import them?

[hazael]

Yes. I will export to CSV and in LibreOffice i will change all productchild  for column "custom_disabler" from "Y" to "N".
After importing this changes, everything should be turned off. This component is not cheap, but I think I have no choice but to buy it. It will be useful for the future ;-)

[GJC Web Design]

if it is only the product custom fields table u want to change u can export in csv and re-import directly with phpmyadmin in your hosting area

you don't need 3rd party software like csvi to do this

[hazael]

I have 112 positions of custom fields and 1730 products with this fields. In db table "virtuemart_product_customfields" in column "disabler" i have 39000 positions for different numbers of options from fields or if this no checked this is number 0... 

list in child product in tab with parameters from custom fields should have "select all" checkbox. It would be faster...

[GJC Web Design]

ouch ...  u have my sympathy

just meant u don't need csvi to do this as its just a single table

csvi comes into its own when importing complete products etc a there are so many crosslinked tables etc

[Milbo]

Actually, there is a tool in "tools" which removes customfields from children, when they are already inherited from the parent. Make a backup first.

[hazael]

My problem has been solved (with the CSVI component) in this forum :
https://csvimproved.com/forum?view=topic&defaultmenu=1054&catid=44&id=34445&limitstart=0

[Milbo]

 vm3 provides a button in the tool view, which does it. "Remove old vm2 inherited customfields" in the tab migration. Just for the future

[hazael]

I understand, but I did not want to delete all custom fields in child products - just duplicates. Children's products have their own custom fields that differ from the parent's products. They display double. The child product displays its custom field and same the parent product field - this is an bug. By default, the child should replace the parent.
I removed duplicates using CSVI. I replaced  custom field values from the parent product with a child product. :-)

[artemiy]

Hello everyone,

I've been advised to report about VM issue here.
In short: I use RO CSVI Pro to import products.
Some customfields are inherited from parent product. Each child has "disable" option for those customfields. With CSVI pro I'm trying to activate "disabled" option, but I get duplicate and disabled at the same time instead just disabled.

Expectations


And reality


Here's what RolandD replied me

Good morning,

Your file is correct and RO CSVI is correct, in my findinds VirtueMart is doing some weird things. The import runs as expected and does the same as what VirtueMart does when you manually set the disabler option.

So I imported your file and on the child product I enabled the disabler in VirtueMart. This was saved. So I compared this to what is imported and that is the same. Now in the child product I removed the disabler and saved it in VirtueMart, suddenly this product has the custom field 4x. This is 2x the same one, so they are double. If I repeat this process, the product gets the fields duplicated again. You can try it as well.

After import in the database they are not duplicate, but only on screen.

Something weird is going on in VirtueMart, from the view of RO CSVI, the database is as needed. This is something you may need to report to the VirtueMart team.

Your import file is fine from what I can see.

Any thoughts?

[GJC Web Design]

this problem has been reported to the devs and I think fixed in the forth coming VM3.8.x

[artemiy]

Anyone knows approximate release date?

[GJC Web Design]

Its in final testing afaik

[artemiy]

Upgraded to VirtueMart 3.8.0 10319.
No changes, unfortunately ((