Answers.Body: <p>I finally managed to make it to import products and its variants. In this particular case, I put semi-colon as separator and put the appropriate value in config/feed-me.php.</p>
  <p>The variant are on the same line and the header shows the variants.</p>
  <pre><code>title;category;collection;essence;design;class;format;variant/0/l;variant/0/w;variant/0/h;variant/0/price;variant/0/SKU;variant/0/finition;variant/0/side;variant/0/l;variant/0/w;variant/0/h;variant/0/price;variant/0/SKU;variant/0/finition;variant/0/side
  door abc;pax;wood;cherry;slab;;;cupboard;12x30;30;12;0.5;22.51;3333;natural;vertical;30;12;0.5;22.51;4444;natural;horizontal
  door abc;other;wood;cherry;slab;;;cupboard;12x30;30;12;0.5;22.51;88888;natural;vertical;30;12;0.5;22.51;999999;natural;horizontal
  </code></pre>
  <p>NOTE: The values imported need to match one of the value in the case of a &quot;select&quot; field...</p>
  <p>Hope this might help someone in the future.</p>
  <p>Sylvain</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-04-13T12:01:36.697Z
Answers.LastActivityDate: 2022-04-13T12:01:36.697Z
Answers.UserDisplayName: Sylvain Tremblay
Body: <p>I need to set a CSV file format for our Client to be able to import his inventory using Feed-Me plugin.
  I've got it to the point where I can't figure how to set the line (cvs) to import variants.
  Let's say I've got a variant on color and finish which generate a different SKU number, how would I define my csv line ?</p>
  <p><code>product name, type, collection, sku, color, finish, sku2, color2, finish, sku3, color3, finish</code></p>
  <p>as an example.
  Your help always appreciated !</p>
  <p>Best regards,
  Sylvain</p>
  
Tags: <plugin-feedme><import>
Title: Feed-Me import csv with Variants
ThreadText: # Feed-Me import csv with Variants
  
  (Asked by: username_0 on 2022-04-12)
  
  I need to set a CSV file format for our Client to be able to import his inventory using Feed-Me plugin.
  I've got it to the point where I can't figure how to set the line (cvs) to import variants.
  Let's say I've got a variant on color and finish which generate a different SKU number, how would I define my csv line ?
  
  `product name, type, collection, sku, color, finish, sku2, color2, finish, sku3, color3, finish`
  
  as an example.
  Your help always appreciated !
  
  Best regards,
  username_0
  
  **Tags:** plugin-feedme, import
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2022-04-13. Score: 2 | Accepted answer
  
  I finally managed to make it to import products and its variants. In this particular case, I put semi-colon as separator and put the appropriate value in config/feed-me.php.
  
  The variant are on the same line and the header shows the variants.
  
  ```
  title;category;collection;essence;design;class;format;variant/0/l;variant/0/w;variant/0/h;variant/0/price;variant/0/SKU;variant/0/finition;variant/0/side;variant/0/l;variant/0/w;variant/0/h;variant/0/price;variant/0/SKU;variant/0/finition;variant/0/side
  door abc;pax;wood;cherry;slab;;;cupboard;12x30;30;12;0.5;22.51;3333;natural;vertical;30;12;0.5;22.51;4444;natural;horizontal
  door abc;other;wood;cherry;slab;;;cupboard;12x30;30;12;0.5;22.51;88888;natural;vertical;30;12;0.5;22.51;999999;natural;horizontal
  
  ```
  
  NOTE: The values imported need to match one of the value in the case of a "select" field...
  
  Hope this might help someone in the future.
  
  username_0
  
  
  ---
  
  