Importing Variants

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17245

The documentation for the importing of variants shows
product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small

I have the following questions:
1-the characteristic "size" has to be all ready defined. Do the variants associated with "size" have to all ready be defined?
2-Why is "big" utilized on the second line where the product is defined? Could "small" have been used?
3-What do the third and fourth line do? Do they define new variants for the characteristic "size"? Do they define what variants should be shown for "main_product"?
4-If the characteristic and variants have previously been loaded, will this limit which variant is used. i.e. if you have big, small and regular, would this only load big & small.
5-when do you use the variant_id in an import?

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
13 years 5 months ago #17258

1. yes
2. it's to specify the default value. You could have put small indeed.
3. yes, they are variants. the 2nd line is the main product. The 3 and 4 are its variants. that enables you to define for example different prices for different variants
4. that's indeed the case
5. There is no variant_id. The system handles the variant table automatically based on product_parent_id which indicates which variant is for which product.

Please Log in or Create an account to join the conversation.

  • Posts: 11
  • Thank you received: 0
13 years 5 months ago #17267

I want a characteristic called "Size". Sometimes the product would have the "Size" value of Small, Medium, Large & Extra Large. For other products the "Size" might be 10,12,&14. How do I load the two different products and get the right variants? Currently when even if I import the third and fourth line that tells it which variant to use the product has all "Size" values loaded as variants.

Should I create two different characteristics both called "Size". One would have Small, Medium, Large & Extra Large. The second would have 10,12,& 14. But then on the import how would I tell the system which "Size" characteristic to use for creating variants?

Please Log in or Create an account to join the conversation.

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
13 years 5 months ago #17272

it is has all the variants when you go in the manage variants area of your product is means that the system wasn't able to import correctly your variants and that you didn't had any variant for your product. Thus, the system created all the variants automatically based on the characteristics of the product when you went there and not based on your CSV when you imported it.
You are right that you should have only one characteristic.
The problem lies in your CSV which has a problem.

Please Log in or Create an account to join the conversation.

Time to create page: 0.040 seconds
Powered by Kunena Forum