Resolved unable to create multi variant

I've tryed to add empty extrafield for product_name ... but nothig changed

Hello,
First we need to solve the issue that your are having when importing your second file. Since you are saying that product_sku is different in two import files, there are new products created as CSVI checks if a product is already available in database table using product_sku field. If the given product_sku is not found then a new product is created else the product is updated. That is what is happening in your case, since product_sku is not found new products are created with your second import file. How is your two import files related? Can you send me the template XML file as requested previously? Let me run a test import to check.

Sorry.. I don't have the xml file (am I missing something?)...
The sku is different from the first file because it is added at the and a variant referred to the product size as you do on the ttutorial:

SKUPRODUCT01 (parent)
SKUPRODUCT01-32 (children: parent-size)

I compose the sku code using the first 3 column in the first file and the first 3 colum plus the column file in the second file

Hello,

Sorry.. I don't have the xml file (am I missing something?)...

You need to download your template XML file from CSVI maintenance page. To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your import templates and click continue. Download the XML file and post it.

Maybe it is not usefull to add a the parent option?.. can I use directly the parent sku without generatin a child product?

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.

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

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?

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

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?

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

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?

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

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.

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

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)

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.

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,

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.

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