Magento

Trying to import a basic .csv file with only the following fields

store, sku, name, price, qty

I get the following output when running the profile:

Skip import row, required field “store” not defined

I also get this if I don’t include a row “store”

I simply cannot figure out how to import products.  This is on release 1.0

Hi all,

I have the same error :-(

REgards,
Cyril

Try using admin as the entry under the column store. Alternatively (and better) add a product and export it to see the file format should be.

Same error here. You cannot add products to a default store but you have to create a column in the csv file. Rather annoying I must say

if i export the data, and then try to import the same file that was exported (by keeping only one column for a test and renaming some fields), I receive the same error.

hm, me to

redegifts - 31 March 2008 12:11 PM

Trying to import a basic .csv file with only the following fields

store, sku, name, price, qty

I get the following output when running the profile:

Skip import row, required field “store” not defined

I also get this if I don’t include a row “store”

I simply cannot figure out how to import products.  This is on release 1.0

Be sure the .csv file is in UTF-8.

still the same result

Houston, We’ve Got a Problem…

I’m having same issue.. but curious.. if i use a store=field on a column, can not import but says:

Skip import row, required field “XXXX” not defined and xxx = row value… !!!

I tried with xsl, different cvs, different field mapping, with and without order.. etc.. :(

Still no results…

Hi,

same here.
Guess its a bug.

cu
Martin

Hi Guys

I’m working on debugging this right now.  Something with the the import process isn’t jiving.  I’ll keep you posted.

Fred

Ok guys, I’ve found the problem.  Moshe and the gang is aware of it as well, but here is what is happening…

mapping fields not in order from left to right is not supported in import.  So, if I map column1, column4, column8, etc. it ignores that.  It looks at the value for SKU (second attribute i define in mapping) while trying to store to “type” which is mapped to column 2

I’ll try and fix this myself and keep you all posted.  It will be fixed in the next minor release, however, if you all are like me, you can’t wait

UPDATE ***SOLUTION***

Note: BE SURE TO CHECK THEM after they import!

I have now successfully imported my products, but here is how

- Make sure that the fields in your import file fall in the same order that the attributes you are mapping do in the Field Mapping List.  You don’t have to map every attribute, just the ones you want.  Then, make sure your import file fields fall in the same left-right order.

To ensure success, map the fields instead of using field names that are identical to the attributes.  I haven’t tested this.  You can if you want!

Also, make a test product that uses all the attributes you need and then export it.  Use this as the basis for your field values.  I was encoding things for the database, but the export showed a lot of text fields being used versus their integer value equivalents.

HTH!

Fred

You could also try setting the store column data to default ..  that should import it into your default store : )

that feature does indeed work, but it doesn’t solve the larger problem (the bug).  Great input just the same, thanks!

Thanks for the tips, dsgnfred. I still get the “field store not defined” error, though. :(

Somehow I manage to get it working, though.
Still I cannot create a custom profile, so I’ve used one of those default profiles embedded within Magento 1.0 (called “Import all products).
Now I can import items and images correctly, but the variable “store”, setted ad “admin” isn’t recognized yet and I have to edit each file manually after import in order to assign it to specific store.