跳至內容
選單
此問題已被標幟
2 回覆
5108 瀏覽次數

Hello,

I'm experimenting with the import process and trying to import the Reference Code for some product variants. When I export I'm ticking the box to set it up for reimport. I put in the Reference Code and try to import.

Then I get errors that read: No matching record found for name 'Finish: Gloss' in field 'Attribute Values' at row 2 (Yet Another Product w/ Variants)



I also tried not importing that column but that just ended up importing a duplicate set of variants except that they were missing the most the import part: the attribute.

What's the correct way to do this?

頭像
捨棄
作者

Is bumping allowed?

最佳答案

Until V12, I was able to create new variants (product.product) by importing them via excel and mentionning the attribute value(s). Since V13, I can't make it work anymore.

So, what I do now, is to define the product attribute with "variation creation mode" = instantly.

Like this, when I import my product.template, all the variants are automatically created.

I then export the variants in excel, with the attribute values, and in excel, using VLOOKUP's, I fill in extra data (like you: default_code, sellprice, costprice, weight, barcode, etc).

I do not add a column in the excel with the attribute value. So, in your example, I would remove the column D.

To disable the variants that were generated but that do not really exist, I import via excel the field active = false.

Finally, I observed that importing the default_code on the variants empties the default_code on the product.template. So, after importing the variants, I re-import only the default_code on the templates.

I hope this explanation helps you.

頭像
捨棄
最佳答案

Try the below file template, of course, you can add other product template fields


頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
1
7月 25
2528
1
7月 25
299
3
7月 25
2526
3
7月 25
1465
3
9月 24
2972