News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

Duplicate Custom Fields in Product Children

Started by hazael, July 13, 2018, 17:18:35 PM

Previous topic - Next topic

hazael


GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

hazael

#19
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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

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.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

hazael


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
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

hazael

#24
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
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

artemiy


GJC Web Design

GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

artemiy

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