Author Topic: Duplicate Custom Fields in Product Children  (Read 758 times)

hazael

  • Beginner
  • *
  • Posts: 32
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #15 on: August 01, 2018, 09:35:44 am »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7885
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #16 on: August 01, 2018, 15:38:42 pm »
that is this

so u mean re-import them?

GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

hazael

  • Beginner
  • *
  • Posts: 32
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #17 on: August 01, 2018, 22:10:26 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7885
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #18 on: August 02, 2018, 10:56:12 am »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

hazael

  • Beginner
  • *
  • Posts: 32
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #19 on: August 03, 2018, 16:18:41 pm »
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

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 7885
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 2.6.22 & 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #20 on: August 03, 2018, 16:37:20 pm »
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 http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 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
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9608
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Duplicate Custom Fields in Product Children
« Reply #21 on: August 04, 2018, 14:37:24 pm »
Actually, there is a tool in "tools" which removes customfields from children, when they are already inherited from the parent. Make a backup first.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

hazael

  • Beginner
  • *
  • Posts: 32
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #22 on: August 09, 2018, 13:37:58 pm »
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

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 9608
  • VM3.2 Cached and Optimized
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: Duplicate Custom Fields in Product Children
« Reply #23 on: August 10, 2018, 10:17:19 am »
 vm3 provides a button in the tool view, which does it. "Remove old vm2 inherited customfields" in the tab migration. Just for the future
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

hazael

  • Beginner
  • *
  • Posts: 32
    • Biżuteria etniczna i orientalna
  • VirtueMart Version: 3.2.14
Re: Duplicate Custom Fields in Product Children
« Reply #24 on: August 12, 2018, 12:35:45 pm »
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. :-)