Resolved unable to create multi variant

Hello,
One difference i see in your import file from the example in CSVI multi variant tutorial is that both parent and child rows has multi variant values but as per tutorial it should be only to parent row. Since you are saying you are testing the file, please remove the multi variant added as template fields set with default value and add it only to the parent row in your import file and then run the import. If you have any issues post the debug log with latest import file.

Ok..to test if the sistem could import the parent and the children i realized a file with the template standard similar to the file of the tutorial.. but i did'nt get the result i've expected..

It is not working neither

Hello,

It would be normal to be ableto import a variant file once you have the parent present in the DB...
Can you explain me better why the system is not able to do that? .. can it be an upgrade (amazon, ebay etc.. work in the same way: you can only import the variant data)

Variants are child products and child products are individual products by itself and you can always update the child product details using a different import file than the parent. But for updating multi variant data CSVI has a standard format to link parent and child product.

Pleeese! can you solve the issue of attatcing a child to a parent?
(if there is already a child for each parent the other would be imported in the second import?)

You are first user asking for this feature request if we get more of this request we will think of adding it to CSVI in our future versions.

It would be normal to be ableto import a variant file once you have the parent present in the DB...
Can you explain me better why the system is not able to do that? .. can it be an upgrade (amazon, ebay etc.. work in the same way: you can only import the variant data)

I'm not able to create a script as you asked;furthermore I have other client with this request (be able to import the update of the variant quantities)... and all can give me the parent file and a different variant file (different files templates for each clients) but not a non standard file with mixed parents'childrens data

Pleeese! can you solve the issue of attatcing a child to a parent?
(if there is already a child for each parent the other would be imported in the second import?)

Hello,
You cannot combine xls files using CSVI but you need to check on command line scripting to combine the files before you run the import using cron.

The problem is that i don't know how to do that... I've learned to create rules but not combination of xls files

Hello,

My question about rules was general: is there a way to use the csvi rules to retrive the parent information and create a complete child product?

There is no such CSVI rule for getting any product information or to create child product.

The alternative way:

If I have one file with all childs and all the informationforeach child (name, size, etc).. it is possible to create the product with its variants

Even by having child product with all its details we need parent product row so CSVI can update child product value to the parent product.

Alternative 2:
It is possible to create aproduct with its variant using the old style way ( http://csvimproved.com/support/import/203-virtuemart/922-multiple-customfields-filter-for-virtuemart )
in this case the problemishow to add the stock quantity

The link you posted is for importing filters that can be used for custom fields in VirtueMart extension. You issue is that you need your child product to be added as variant for parent product.

- sorry but i must solve this problem with what I have/can do -

You can try writing code to combine two files into one. That would be the best solution at this point of time.

My question about rules was general: is there a way to use the csvi rules to retrive the parent information and create a complete child product?

The alternative way:

If I have one file with all childs and all the informationforeach child (name, size, etc).. it is possible to create the product with its variants

Alternative 2:
It is possible to create aproduct with its variant using the old style way (https://csvimproved.com/support/import/203-virtuemart/922-multiple-customfields-filter-for-virtuemart)
in this case the problemishow to add the stock quantity

- sorry but i must solve this problem with what I have/can do -

Hello,

...how itis possible.. the parent sku is indicated on the import....

Let me explain what is happening right now so you understand why the product and child variants are not linked in your case. If you see the example in the tutorial, the parent product is the first row and it is a product itself. When import happens there is an entry which happens in VirtueMart product custom fields database table for this parent product and when the next rows (child product) is imported with the product_parent_sku, the value of this child product is collected and at the end the custom_params field for the parent product row is updated with collected value. This process happens hand to hand when the products are all in one import file. Since you have them in two different files for parent and child, this process of collecting and updating parent row does not happen.

Is there any wayto use a custom rule to do that?

There are no rules in CSVI to combine two files.

... "CLI script"?

I meant Command Line Interface script to append two files as you mentioned that these files are to be imported using cron jobs.

if I'm able to persuade my cliento to realize a single file with all the duplicated data but no parent sku it is possibletoimport any row adding the size field ?
(I cannot have realized a file with the parent and the childrens together as in the tutorial)

My explanation above is clear to understand that why the import file needs both parent row and child row with parent product sku so they are linked during import.

In alternative the question is:
if I'm able to persuade my cliento to realize a single file with all the duplicated data but no parent sku it is possibletoimport any row adding the size field ?
(I cannot have realized a file with the parent and the childrens together as in the tutorial)

...how itis possible.. the parent sku is indicated on the import....
Is there any wayto use a custom rule to do that?
... "CLI script"?

Hello,
Looking at the screenshots the parent products are imported good, child products are also added and are linked to their respective parent, product stock is also updated. The only and the difficult issue i see now is that the multi variant field of child products VM-G-NUMERO-2P are not linked to the parent product and so the values are missing in VirtueMart product details page and on custom fields tab. That is because when you run the import of your second file with child products CSVI does not know who the parent is to link them. So the only option is to combine the both import files you having using CLI script before running the import. I cannot think of any other solution for this issue.

Yess as you said... evenif i importedasmaller version of the second file

Hello,
Yes, your preview looks good, next is to import the file. After import what do you see in VirtueMart product details page? Lets say we take an example product with SKU 101A-COMM-ANT-39, Can you post the screenshot of this child product in VirtueMart product details page?

Also, after your second file import you should be having a total of 917 products in your VirtueMart products page where 133 are parent products from your first import file and 784 child products are imported from your second import file. Is that correct?

The child products don't have product_name details and so they will show as "Language string missing..." but they should be having product_sku, product_in_stock as in your second import file and also they are linked to the corresponding parent product. Do you see the same?

Right.. for now (until the update of the file by the client) I change the " DispWeb2.xls 1/2" with a ".5"

Hello,
So your import file has imported all the parent products. Now moving on to your second file, when you select your second file for import in CSVI, what do you see on preview page? Can you post screenshot of it?

I've removed the VM-G-NUMERO-2P field and imported from a cleared situation:
1st import done without the filed

Hello,
Thank you for posting template XML file. Looking at templates i understood that you are importing all parent products from your first import file and then child products from your second file. Lets start with your first import file, i see that you have added VM-G-NUMERO-2P as a template field and set VM-G-NUMERO-2P as default value too. I think that field is not needed, you can remove it. Other than that i don't see any other issue with your first import file, can you confirm that so we can move on with second one?

ok... thx...
here the xmlfile csvi_templates_gianfort.it_20170926-.xml

Hello Roberto,
We cant help you more here without looking at how your template is setup and how the import file works. Post the template XML file as explained in my previous post and let me run a test import here to check.