I did the following steps:
- convert to utf8
- remove empty "sku" column
- rename "artnr" to "sku"
- set column "type" to "simple" for all rows
- clear column "image" and "small_image": "?" => ""
And now the import tells me "Processed 100% 11/11 records", "Imported 11 records". All green, all good but the new products are not listed in the catalog.
I guess I am still missing some columns. If that does not help it would be worth a new question.
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 ;-)
Refer the Similar Threads, and this tutorial Here
Importing Product for Store View
Importing Products with the ImportExport Interface
Best Answer
I'd recommend NEVER using Excel for Magento imports. Whenever you export an excel file to .CSV it always adds hidden characters and you'll always get import errors like "Duplicate Columns" and such. I always use Google Docs Spreadsheet. Just hit export>CSV and you'll see that you get a lot smoother and error-less imports!