Categories
View Replies (7)

Resolved Wrong import customfieldforall for child products

  1. easysoftware
    easysoftware
  2. RO CSVI
  3. Saturday, 17 August 2019
  4.  Subscribe via email
Hi Rolland,

we have new eshop with
Virtuemart 3.4.2
Joomla 3.9.6
CustomfieldForAll 4.0.4
CustomFilters Pro 2.7.0
CSVI Pro 7.12.0
CSVI Import Custom Fields For All


If I imported CSV for parent products, the customfields are imported ok, but for child products created duplicate customfiled.

But I need for child products the same customfield only with setup override and selected only one value from multi values.


The file for import is one (parent with child, and I importing one time.


Velikost rámu == Frame size
Modelový rok == Model year


I tried importing a single file or importing separate files and each time the result was the same.

Parameters were duplicated after child products were imported.

I send picture with right admin setup and wrong admin setup.

parent:
https://kolopark.easy.minion.cz/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14198&virtuemart_category_id=742&Itemid=435

child-wrong:
https://kolopark.easy.minion.cz/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14199&virtuemart_category_id=742&Itemid=435

child-ok:
https://kolopark.easy.minion.cz/index.php?option=com_virtuemart&view=productdetails&virtuemart_product_id=14215&virtuemart_category_id=742&Itemid=435


How can I setup or import right?

We have about 15000 products to import:
- from feeds from suppliers
- manually from ERP
- manually in administration

and the client does not want to manually overwrite child values => that then loses the use of CSVI advantage.

I've also tried to add override / disabled values to CSV, but it didn't help.


Best Regards

Rudolf
Attachments (8)
admin-parent-OK.png admin-parent-OK.png
admin-child-manually-OK.png admin-child-manually-OK.png
admin-child-import-wrong.png admin-child-import-wrong.png
web-parent-OK.png web-parent-OK.png
web-child-wrong.png web-child-wrong.png
web-child-OK.png web-child-OK.png
CSVI_Eshop - Import produktu - parametry - 2.csv
CSVI_Eshop - Import produktu - parametry - 3.csv
0
Responses (7)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Rudolf,
First thing i am noticing from your import file is that there is no relation between parent and child products. The import files should have product_parent_sku field so there is a link between child and parent products. You need to add that.

To create an override for child product you should have custom_override field in your import file with value set to Y. You can check Product import with custom fields document to know on how to use this field.

I tried importing a single file or importing separate files and each time the result was the same.

You can have one file for both parent and child products. The results were same because there was no relation between parent and child products and each products was taken as individual product.

Do these changes and run your import. If you still have issues, post the import debug log and sample import file to check. To get the debug log check How to collect debug information? document.
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
easysoftware
easysoftware
Accepted Answer Pending Moderation
First thing i am noticing from your import file is that there is no relation between parent and child products. The import files should have a product_parent_sku field so there is a link between the child and parent products. You need to add that.



Yes, there is no relationship in the import file:



Nowhere in the documentation how to set up correctly (I followed the documentation https://rolandd.com/documentation/ro-csvi/virtuemart/custom-fields-for-all-for-virtuemart)

All products have a relationship already created in the e-shop and we just add custom fields that are already created.



If it is necessary to add to csv now, please write how to proceed correctly.



To create an override for your child product, you should have a custom_override field in your import file with a value set to Y.



Yes, I tested this, but without success. I followed the instructions (https://rolandd.com/documentation/ro-csvi/virtuemart/product-import-with-custom-fields) and added override columns to csv and nothing happened, customfield created a new one.


Note that the override value is created in the DB as a new number (which is not 1 or 0), but eg 12398704 only when saved in the administration.


I didn't find this in customfieldforall.php.
  1. more than a month ago
  2. RO CSVI
  3. # 2
easysoftware
easysoftware
Accepted Answer Pending Moderation
First thing i am noticing from your import file is that there is no relation between parent and child products. The import files should have a product_parent_sku field so there is a link between the child and parent products. You need to add that.


Yes, there is no relationship in the import file:

1. Nowhere in the documentation how to set up correctly (I followed the documentation https://rolandd.com/documentation/ro-csvi/virtuemart/custom-fields-for-all-for-virtuemart)

2. All products have a relationship already created in the e-shop and we just add custom fields that are already created.

If it is necessary to add to csv now, please write how to proceed correctly.

To create an override for your child product, you should have a custom_override field in your import file with a value set to Y.


Yes, I tested this, but without success. I followed the instructions (https://rolandd.com/documentation/ro-csvi/virtuemart/product-import-with-custom-fields) and added override columns to csv and nothing happened, customfield created a new one.

Note that the override value is created in the DB as a new number (which is not 1 or 0), but eg 12398704 only when saved in the administration.

I didn't find this in customfieldforall.php.
  1. more than a month ago
  2. RO CSVI
  3. # 3
easysoftware
easysoftware
Accepted Answer Pending Moderation
Logs
Attachments (2)
com_csvi.log.32.zip
com_csvi.log.33.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
1. Nowhere in the documentation how to set up correctly (I followed the documentation https://rolandd.com/documentation/ro-csvi/virtuemart/custom-fields-for-all-for-virtuemart)

Yes, you're right there is no parent child relation examples explained in the document. All the examples are one product based. I will update the document.

2. All products have a relationship already created in the e-shop and we just add custom fields that are already created.

For CSVI to know the relation during import it is a must that parent-child relation is in the import file.

If it is necessary to add to csv now, please write how to proceed correctly.

To create an override for your child product, you should have a custom_override field in your import file with a value set to Y.


Yes, I tested this, but without success. I followed the instructions (https://rolandd.com/documentation/ro-csvi/virtuemart/product-import-with-custom-fields) and added override columns to csv and nothing happened, customfield created a new one

Below is the example content from your import files and putting them together. You can try your import with this content and check.

product_sku;custom_title;custom_value;custom_param;product_name;product_in_stock;product_price;custom_param_cs_cz;product_parent_sku;custom_override

ALP1;Velikost rámu~Modelový rok;customfieldsforall~customfieldsforall;S#M~2017;Alpina ECO M20 black-lime, 2017;;;S#M~2017;;

ALP170002;Velikost rámu;customfieldsforall;S;Alpina ECO M20 black-lime, 2017;;;S;ALP1;Y~Y

ALP170003;Velikost rámu;customfieldsforall;M;Alpina ECO M20 black-lime, 2017;;;M;ALP1;Y~Y



Note that the override value is created in the DB as a new number (which is not 1 or 0), but eg 12398704 only when saved in the administration.

I didn't find this in customfieldforall.php.

The override value saved in the db is the parent product ID value. Product import with custom fields is not based only on customfieldforall.php file but there are other files related to it.
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. # 5
easysoftware
easysoftware
Accepted Answer Pending Moderation
Hi,

ok, I tryied with new template and now import is ok :)

Thanks

Rudolf
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Rudolf,

Thank you for confirming it is working now. We will update our documentation as well.
Kind regards,

RolandD

=========================
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. # 7
  • Page :
  • 1


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