Hello I am try to import csv for my german store product name other some information. so i export one product for getting csv. i tried with with singal record i just set my information inplace of other but i get problem like that "Skipping import row, required field "sku" is not defined."

For that i am searching on net and do this kind of step describe on this links.


But its not worked any one have idea i attached here my csv formate

Getting my csv here [http://dev.starcufflinks.co.uk/export_product_test.csv]

  • from where you exported? try from Import/Export > Advance > Export All product . Edit and Import in same format Also what did u put in sku field of ur csv? – echoashu Sep 5 '14 at 11:17
  • first it is right way for multi-store ? and i put sku as sku in my csv – Yogesh Sep 5 '14 at 11:21
  • sku column shoud have some alphanumeric unique value. The error says : You did not defined an sku field for the item row. Put some value like sk123 and try. – echoashu Sep 5 '14 at 11:23
  • But in main store there is already product place with same sku .. i need to change sku for store view or we can use same sku ? – Yogesh Sep 5 '14 at 11:29
  • If product is different, then sku should be different (unique) for each of them as i wrote. I seen ur csv file, from where are you exporting? try export import from the path i wrote above. – echoashu Sep 5 '14 at 11:34

For Importing Products, the best approach is

Go to System > Import/Export > Data Flow profiles
Click on Export All Products
(I assume you already know this since you have tried uploading before) Download the
relevant products into the CSV.
Fill the CSV with new information [Source: OP Referring Tutorial ]

Now In csv file, add the relevent records for each sku you want to update/upload

Go back to Data Flow Profiles > Import All Products > upload the file, and run.

Your products will be uploaded or updated. as applicable.

For Multiple Store Views You can use different sku if your products are different, else if you have the same inventry sku should be same.

You need not have to change the Product sku if you want the same product with change in attributes of STORE VIEW SCOPE

You Must Use appropriate store view code to assign product to each store

By Default in your exported csv, _store columns is not there, Add it and use store view code in that place.

For Just updating the Same product with change in Product name in different language, you need to follow the same approach as well. You cant go to en_US or other similar files to define translation strings for each of ur product ;-)

enter image description here

Refer the Similar Threads, and this tutorial Here

Importing Product for Store View

Importing Products with the ImportExport Interface

  • using that type only default line only executed..other giving sku missing error..and not able to execute it. – Yogesh Sep 8 '14 at 5:49
  • Attribute scope is Store level. – Yogesh Sep 8 '14 at 6:15
  • Sku Required for all store answer i test that i wiill work please update your answer. – Yogesh Sep 8 '14 at 9:21
  • @yogesh having an sku for each row isnt bad, but i tested above approach and it worked. Maybe you are having some conflict in your import csv. Check you have, somewhere along website column .. feel free to update the answer :-) – echoashu Sep 8 '14 at 12:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.