Resolved Multi Variant Import

Hello Beata,

There is an issue with multi variant imports in CSVI 6.1.2 and there is a patch available that should be installed on the site. You can unpack the patch to the server and the import should work.

Your file looks good to me, so that doesn't need any change. Install the patch and give it a try and you should be good to go.

Hello Roland,
Thank you very much for your kind help. Unfortunately it didn't work.
I attache the log file. (It shows there were no patch file imported....?)
I have imported the file as it was described in the tutorials.
I am looking forward to your kind reply.
Best regards,
Beata

Hello Beata,

The patch file needs to be applied manually because since Joomla 3.4.4 it is no longer allowed to upload patch files. Did you apply the patch file manually?

Hello Roland,
Thank you! It works!!!!!
Beata

Hello Roland,
After the test import was OK with 5-6 child products I have tried to upload the whole CSV file. There are 623 variants for 1 product. These are in one CSV file.

The result: The child products were created well, but only a few values were added to them. (About 50 child products were created with values, the others were without values at all.) I attache a screen shot as well.

I tried to do the import with 50 products - the result was OK.
I tried to add another 50 products - The first 50 became empty, the 2nd 50 were OK.....

Could you please help me. Is there a limit?
I am looking forward to your kind reply.
Best regards, Beata

Hello Beata,

There is no limit from CSVI but I am thinking you may be hitting the limit of the database. The field customfield_params where all the variants are stored has a limit of 17,000 characters.

There are 623 variants for 1 product.

You mean that 1 product has 623 child products? Each product has 5 ramifications looking at the screenshot. So that makes a total of 3,115 variations. So this makes the limit of 17,000 suddenly not so large. I would suggest to increase the 17,000 character limit and see if that helps.

I tried to do the import with 50 products - the result was OK.
I tried to add another 50 products - The first 50 became empty, the 2nd 50 were OK.....

That is expected because you need to import all at the same time.

Hello Roland,
I succeed to increase the limit to 19000 only. Bigger number was no accepted.
Everything has remained the same. (I have tried again the import with 200 variants.) I have 5 remifications/product, with
4*3*2*2*13 different values=624 variants/product.
I don't know what to do
Regards, Beata

Hello Beata,

What value do you have in the customfield_params field for 1 product?

You could change the type of the field from VARCHAR to TEXT. The TEXT type allows up to 4GB of data if I am not mistaken, at least a lot more than you will ever need.

Hello Roland,
It didn't help....It seems it is too much for VM.
Any more idea?
Best regards, Beata

Hello Beata,

Not really any more ideas. I think it will require a significant amount of effort to figure out exactly where what goes wrong. My first question still stands (as I didn't get any answer)

What value do you have in the customfield_params field for 1 product?

Hello Roland,
When text is the type it doesn't accept a value.
What should be the value?
I am looking forward to your kind reply.
Regards, Beata

Hello Beata,

When text is the type it doesn't accept a value.

It doesn't need a value, the size of this field is fixed.

Hello Roland,
But did you asked this value in your previous mail? Shall I make any other changes to be able to upload the multi variants?
Beata

Hello Beata,

But did you asked this value in your previous mail?

I did ask for the value but not the value of the field declaration but the value that is stored in that field for the product you are importing with all the child products. Find the product ID of your product in this table and see what is stored int he customfield_param field for this ID. That is what we want to know. Alternatively, collect debug information and post the debug log of your import and I can check that.

Shall I make any other changes to be able to upload the multi variants?

After you made the change to TEXT, you can run the import and see what it does. At least the field will be big enough to hold the data. If you still have issues, you know it is not related to the database field size.

Hello Roland,
Hereby I send a screens-shot of the product customfield_params datas.
I have tried the import wit the text type, nothing has changed.
After importing the multi variants, I can't open the product page in the admin area.(the VM has freezed.) It seems that there are too many data in the file for the VM....
?????
Regards, Beata

Hello Beata,

You found the correct field but instead of a screenshot can you post the actual content of the customfield_params field?

I can't open the product page in the admin area.(the VM has freezed.) It seems that there are too many data in the file for the VM....

Yeah it looks like it, not sure which browser you use, try Chrome, it seems to be more forgiving. Have you asked VM about any limitations?