Categories
View Replies (16)

Resolved different types of multi variant in one csv?

  1. lazy
    lazy
  2. RO CSVI
  3. Sunday, 03 May 2015
  4.  Subscribe via email
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 :-)
0
Responses (16)
rolandd
rolandd
Accepted Answer Pending Moderation
@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
  1. more than a month ago
  2. RO CSVI
  3. # 1
sandstorm871
sandstorm871
Accepted Answer Pending Moderation
@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?
  1. more than a month ago
  2. RO CSVI
  3. # 2
lazy
lazy
Accepted Answer Pending Moderation
Ohh my god, i'll try this. Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
lazy
lazy
Accepted Answer Pending Moderation
i want multiple fields cap and boy, the field cap is imported but boy not?
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 6
lazy
lazy
Accepted Answer Pending Moderation
the files are attached...
Attachments (2)
com_csvi.log.92.zip
shop-test.csv
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 8
lazy
lazy
Accepted Answer Pending Moderation
as multi field the CSVI has imported my cap and instead of boy i get cap-boy imported?
where i am wrong?
Attachments (1)
EkranResmi2015-05-0416.32.09.png EkranResmi2015-05-0416.32.09.png
  1. more than a month ago
  2. RO CSVI
  3. # 9
lazy
lazy
Accepted Answer Pending Moderation
ok, i deleted the product, now it works
  1. more than a month ago
  2. RO CSVI
  3. # 10
lazy
lazy
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 12
lazy
lazy
Accepted Answer Pending Moderation
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...
Attachments (2)
EkranResmi2015-05-0414.42.14.png EkranResmi2015-05-0414.42.14.png
EkranResmi2015-05-0414.44.47.png EkranResmi2015-05-0414.44.47.png
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 14
lazy
lazy
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 15
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 16
  • Page :
  • 1


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