Hello,
is it possible to import mixed multi variants?
[table]
[tr]
[td]products_sku[/td]
[td]product_parent_sku[/td]
[td]size[/td]
[td]color[/td]
[td]multi_variant_title[/td]
[td]multi_variant_fileds[/td]
[/tr]
[tr]
[td]produkt1[/td]
[td] [/td]
[td][/td]
[td][/td]
[td]multi[/td]
[td]size-color[/td]
[/tr]
[tr]
[td]produkt1_1[/td]
[td]produkt1[/td]
[td]XL[/td]
[td]BLUE[/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]produkt1_2[/td]
[td]produkt1[/td]
[td]M[/td]
[td]RED[/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td]produkt2[/td]
[td][/td]
[td][/td]
[td][/td]
[td]multi[/td]
[td]size[/td]
[/tr]
[tr]
[td]produkt2_1[/td]
[td]produkt2[/td]
[td]S[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[/table]
some products should have no "color" option available. if the user choose size S no color dropdown filed will shown.
Can i leave the column "color" blank? Or do i have to create several csv files? i hope i could explain what i mean :-)
Hello,
Nice table :)
With CSVI 6 beta 6 Pro this should be possible. Give it a try I would say, if you encounter any issues, I will be here to help :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i like the table too :-)
so, i'll test it, but how can i add the fields "size" and "color" to my import template?
in the template editor i've added multi_variant_fields and title, how can i add size and color?
You can only add them after you imported the parent products. As you can see in the tutorial, an update of available fields is required after importing the parents. This is the only way to tell CSVI about the new fields.
In practice this means you need to run the import twice with the same file. Once the parent products are in, the import only needs to be done once unless you change the parent products and their ramifications.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Rolandd,
the preview don't accept the missing "color" and "size" fileds, in this case its called "cap" and "boy". i dont really understand this :-)
this two rows are on the left side of my CSV...
Hello,
You have an error in the setup of your template because the fields don't match. Either change the setting Use file for configuration to Yes or set the fields in your template in the same order as they are in your file.
the preview don't accept the missing "color" and "size" fileds, in this case its called "cap" and "boy".
That is expected if you have not run an import yet and did not update the available fields. This is how it looks on the first import, the second import should recognize all fields.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i get the following error...
Duplicate entry '374' for key 'PRIMARY' SQL=UPDATE `y5xg6_virtuemart_products` SET `virtuemart_product_id`='374',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='0.0000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-22 11:32:50',`created_by`='934',`modified_on`='2015-05-04 13:04:24',`modified_by`='934',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='11-1651'
but the preview look fine.
ok, i deleted the product, now it works
as multi field the CSVI has imported my cap and instead of boy i get cap-boy imported?
where i am wrong?
Without the debug log and the sample of the file I can't tell you anything. The only thing you give me is a screenshot, it's too little info.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
the files are attached...
In your CSV file you have named the field cap-boy, see column G (multi_variant_fields). That is why it shows up as cap-boy in CSVI.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
i want multiple fields cap and boy, the field cap is imported but boy not?
The field cap is imported because you have the field cap in your file. You do not have the field boy in your file, you have the field cap-boy. I think what is wrong is how you entered the field name. If you have more than 1 field, it should be separated by a ~-symbol, not by a minus symbol.
In that case your multi_variant_fields field should read cap~boy.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ohh my god, i'll try this. Thank you
@lazy,
How did you get on with this. I am interested in using multi variants too & if I can make it easier with CSVi, then great.
Currently I imported all my product/children in a separate CSV file & now need to link them with multi variants.
@Rolandd
Is it easier to have multiple imports as we used to do in VM2 when using the stockable variant plugin?
I used to import parent/child file first, then a custom field, set up import and last another CSVi import to link them all together.
With VM3 & CSVi6, can all this be done with one template, as @Lazy has set up already earlier in this thread?
Nil Satis Nisi Optimum !
@sandstorm871
Is it easier to have multiple imports as we used to do in VM2 when using the stockable variant plugin?
Currently a new import with multi variants requires to be done twice, this is because of the settings in the parent needs to be indexed.
You could use a single template with the imports but I think for clarity it might be easier to use multiple aptly named templates.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.