Magento Forum

   
Error when Importing Products
 
sstaton
Jr. Member
 
Total Posts:  1
Joined:  2012-10-21
 

Hi,

I am fairly new to data importing, I have a csv which I exported and editted with my new products.

It looks as follows:
sku _type _category _root_category _product_websites description image name price short_description weight qty
13685 simple Foods/Dog/Treats Pre-Pack Root Catalog base 13685.txt 13685.jpg 8in1 Delights Dog Rawhide Bones Large 4.69 8in1 Delights Rhide Bone LgeX6 1.446 169818

It has about 24000 lines of products, when I try to import I get the following error:
Invalid value for Attribute Set column (set does not exists?) in rows: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100
File is totally invalid. Please fix errors and re-upload file
Checked rows: 100, checked entities: 100, invalid rows: 100, total errors: 100

I go going to system>import then selecting Product, Append Data Complex and selecting the file. Am I doing this wrong or is my csv incorrect?

Any help is much appreciated,
Thanks
Simon

 
Magento Community Magento Community
Magento Community
Magento Community
 
davison
Member
 
Avatar
Total Posts:  56
Joined:  2011-09-11
 

Hi,

If you are getting problem in importing the csv file for the selected products, it means your csv format is may not be in UTF-8 mode .This error occurs mainly when you are preparing csv in microsoft office . It will be nice to use open office and manage your csv in UTF-8 mode.

In such-cases you can also follow this method to import the csv file for your selected products,

1. Login into your Admin account.
2. Click on import all products
3.  Now upload the CSV file and press continue and edit .
4. Click on the “Run Profile” and then select the imported file .
5. Finally the CSV file is download for the imported products.

Please try and let me know.......

 
Magento Community Magento Community
Magento Community
Magento Community
 
Store_Manager
Enthusiast
 
Avatar
Total Posts:  854
Joined:  2012-07-09
 

Hello,

Actually, to upload data via Magento admin your file should correspond to strict requirements Magento has to the uploaded file. In case you are missing of some data, you either will receive error or your file won\’t be uploaded at all. To get the example of .csv file which your import method accepts, you can export a couple of products. However, if you are using default import/export method, the file for import can be a bit different than for export.

From the error you received I assume that most likely you did not indicate attribute set for your products. Please, do modifications in your .csv file and add there the column with attribute set and indicate its name.

In case you need the solution with more flexible system of file importing and accepting, i can offer you to try to import via the desktop application called Store Manager for Magento. There is free version you can download here -
http://www.magentocommerce.com/magento-connect/store-manager-for-magento.html

The application allows to import file of specific structure. Also you can set some data on the fly right in the process of import.
In any case, you can try it out.

In case any assistance required, let me know.

 
Magento Community Magento Community
Magento Community
Magento Community
 
feedigi
Jr. Member
 
Total Posts:  1
Joined:  2013-07-02
 

I’ve tried to do this and I’m still getting the same errors: Skip Row Import “value type” Invalid.

 
Magento Community Magento Community
Magento Community
Magento Community
 
magentoassist
Guru
 
Avatar
Total Posts:  528
Joined:  2008-11-19
 

It’s unusual that it would ask for an attribute_set column. Part of me wonders whether you might have an attribute_set column in there all the way off to the side of the doc that you failed to delete. Do a ctrl+f find and make sure that there IS not an attribute_set in the doc definitively.

If you can guarantee there is no attribute_set column, try adding one. Make the column header _attribute_set and then put Default or whatever your attribute set is as the value in the column.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top