Categories
View Replies (6)

Resolved Multivariant variants are all visible

  1. 4creations
    4creations
  2. RO CSVI
  3. Monday, 03 June 2019
  4.  Subscribe via email
I am importing multivariant products, based on color (sample for a product with two varinat and a product with six variants below). What I am expecting as a customer is to see two products, click into the one I want and then see a select list in order to select color.
The products are inserted and seem ok. The problem is that I see all eight products eg all the variants (see http://www.promotionalgifts.gr/yyy-dptest/troubleshoot.html)! If I click into any of them, the functionality is as expected (select list, change product upon list selection).
Am I missing a piece here?

I do the import in two steps: First create the variants, then additional info.

The mulltivariant importer. Τύπος is the name of the multivariant custom field, ΧΡΩΜΑ (meaning color) and is not a custom filed


"product_sku","product_name","product_parent_sku","category_path","published","multi_variant_title","multi_variant_fields","ΧΡΩΜΑ"

"tsh_PRODUCT2-03","TSH UMBRELLA OTHER","","YYY_DPTEST/TROUBLESHOOT","1","Τύπος","ΧΡΩΜΑ","black"

"tsh_PRODUCT2-07","TSH UMBRELLA OTHER","tsh_PRODUCT2-03","YYY_DPTEST/TROUBLESHOOT","1","","","grey"

"tsh_PRODUCT1-03","TSH_UMBRELLA","","YYY_DPTEST/TROUBLESHOOT","1","Τύπος","ΧΡΩΜΑ","black"

"tsh_PRODUCT1-04","TSH_UMBRELLA","tsh_PRODUCT1-03","YYY_DPTEST/TROUBLESHOOT","1","","","blue"

"tsh_PRODUCT1-05","TSH_UMBRELLA","tsh_PRODUCT1-03","YYY_DPTEST/TROUBLESHOOT","1","","","red"

"tsh_PRODUCT1-09","TSH_UMBRELLA","tsh_PRODUCT1-03","YYY_DPTEST/TROUBLESHOOT","1","","","green"

"tsh_PRODUCT1-10","TSH_UMBRELLA","tsh_PRODUCT1-03","YYY_DPTEST/TROUBLESHOOT","1","","","orange"

"tsh_PRODUCT1-37","TSH_UMBRELLA","tsh_PRODUCT1-03","YYY_DPTEST/TROUBLESHOOT","1","","","royal blue"


import additional product fields


"product_sku","product_s_desc","product_desc","product_width","product_height","product_length","product_lwh_uom","product_weight","product_weight_uom","product_packaging","file_url","media_published"

"tsh_PRODUCT2-03","Sample description product 02","Long long long product 02","11,11","11,11","11,11","M","0,390","KG","0","images/stories/virtuemart/product/MO7719_03.jpg","1"

"tsh_PRODUCT2-07","Sample description product 0","Long long long product 02","11,11","11,11","11,11","M","0,390","KG","0","images/stories/virtuemart/product/MO7719_07.jpg","1"

"tsh_PRODUCT1-03","Sample description product 01","Sample long long long description product 01","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_03.jpg","1"

"tsh_PRODUCT1-04","Sample description product 01","Sample long long long description product 01n","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_04.jpg","1"

"tsh_PRODUCT1-05","Sample description product 01","Sample long long long description product 01n","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_05.jpg","1"

"tsh_PRODUCT1-09","Sample description product 01","Sample long long long description product 01n","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_09.jpg","1"

"tsh_PRODUCT1-10","Sample description product 01","Sample long long long description product 01","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_10.jpg","1"

"tsh_PRODUCT1-37","Sample description product 01","Sample long long long description product 01","11,11","11,11","11,11","M","0,280","KG","12","images/stories/virtuemart/product/MO7210_37.jpg","1"
0
Responses (6)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I am importing multivariant products, based on color (sample for a product with two varinat and a product with six variants below). What I am expecting as a customer is to see two products, click into the one I want and then see a select list in order to select color.
The products are inserted and seem ok. The problem is that I see all eight products eg all the variants (see http://www.promotionalgifts.gr/yyy-dptest/troubleshoot.html )! If I click into any of them, the functionality is as expected (select list, change product upon list selection).
Am I missing a piece here?

I do the import in two steps: First create the variants, then additional info.
The mulltivariant importer. Τύπος is the name of the multivariant custom field, ΧΡΩΜΑ (meaning color) and is not a custom filed

I understand your issue. Since you also have the parent and child product in the same category you should have them grouped as one product with a dropdown selection of custom field values. The issue i see here is that you mentioned that ΧΡΩΜΑ is not a custom field. But you should have ΧΡΩΜΑ as a string custom field in VirtueMart. So create the string custom field, update available fields and then run the import and check. If you still have issues post the latest debug log to check. To get debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
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
4creations
4creations
Accepted Answer Pending Moderation
Hi tharuna
In order to facilitate the reading, the multivariant field is named MVType and the selector field is named TSH_COLOR. I left only two SKUs (see below).
What I did:

  1. Added a TSH_COLOR string custom field, default values (no cart attribute, no cart input, no layout position)

  2. Updated available fields. TSH_COLOR is available in tables: google, order, product

  3. Ran the import, debug attached

  4. FWIW I tried to set the custom field as cart attribute and cart input and set the layout to addtocart but I still see two products



Imported data


"product_sku","product_name","product_parent_sku","category_path","published","multi_variant_title","multi_variant_fields","TSH_COLOR"

"tsh_PRODUCT2-03","TSH UMBRELLA OTHER","","YYY_DPTEST/TROUBLESHOOT","1","MVType","TSH_COLOR","black"

"tsh_PRODUCT2-07","TSH UMBRELLA OTHER","tsh_PRODUCT2-03","YYY_DPTEST/TROUBLESHOOT","1","","","grey"


com_csvi.log.357.zip
Attachments (1)
com_csvi.log.357.zip
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you also add a product price only to parent product? You can do that by using product_price field in your import. See if that solves the issue.
Kind regards,

Tharuna

=========================
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. # 3
4creations
4creations
Accepted Answer Pending Moderation
No luck :( The price appear correct but I see all products.

Imported


"product_sku","product_name","product_parent_sku","category_path","published","multi_variant_title","multi_variant_fields","TSH_COLOR","product_price"

"tsh_PRODUCT2-03","TSH UMBRELLA OTHER","","YYY_DPTEST/TROUBLESHOOT","1","MVType","TSH_COLOR","black","99.9"

"tsh_PRODUCT2-07","TSH UMBRELLA OTHER","tsh_PRODUCT2-03","YYY_DPTEST/TROUBLESHOOT","1","","","grey",""

and the log is parent_only_price.log
In case it helps, I imported using price for both parent and child


"product_sku","product_name","product_parent_sku","category_path","published","multi_variant_title","multi_variant_fields","TSH_COLOR","product_price"

"tsh_PRODUCT2-03","TSH UMBRELLA OTHER","","YYY_DPTEST/TROUBLESHOOT","1","MVType","TSH_COLOR","black","99.9"

"tsh_PRODUCT2-07","TSH UMBRELLA OTHER","tsh_PRODUCT2-03","YYY_DPTEST/TROUBLESHOOT","1","","","grey","88.8"

the log is all_price.log
parent_only_price.zip all+price.zip
Attachments (2)
parent_only_price.zip
all+price.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Since child product should get grouped under parent product, you need to add price and category_path only for parent product and not for the child. I have done that modification to your import content. Can you try the import of below content and check how it goes? 

"product_sku","product_name","product_parent_sku","category_path","published","multi_variant_title","multi_variant_fields","TSH_COLOR","product_price"

"tsh_PRODUCT2-03","TSH UMBRELLA OTHER","","YYY_DPTEST/TROUBLESHOOT","1","MVType","TSH_COLOR","black","99.9"

"tsh_PRODUCT2-07","TSH UMBRELLA OTHER","tsh_PRODUCT2-03","","1","","","grey",""
Kind regards,

Tharuna

=========================
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. # 5
4creations
4creations
Accepted Answer Pending Moderation
tharuna, the category path did the trick! Let only the parent have a category path while the the children have empty path. I did my testing (~4000 products) without a price so I guess the price is irrelevant.
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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