Error importing csv products in magento
Good morning,
I have been dealing with this issue for a long time now, I tried to import .csv files in Magento but I am getting an error (shows the image below). When I try to import it via system => import / export => dataflow / profiles => Run profile. It doesn't load every product, always gives me an error when it reaches 43rd product. I tried to import 5 files, everything went well, but when it gets to this product it doesn't work. The file is CSV (Comma Separated) UTF-8 (Marked). I exported a product list from Magento and started adding products from there. I have checked every column and they are all the same in the same order.
I tried to import the file from system => import / export => import and it gave me an error (column name: "store" is invalid) that the first column in the file. Everything seems to be right.
Any ideas on how to fix this issue? I will try to get the csv file using apache openOffice to see if there is any difference.
I'll keep you posted if I find a solution.
Thank. First CSV file:
store, websites, attribute_set, type, category_ids, inventory, has_options, name, meta_title, meta_description, image, small_image, thumbnails, url_key, url_path, page_layout, options_container, image_label, small_image_label, thumbnail_label, msailable_messable, thumbnail_label, msailable, ms , brand, price, special_price, weight, MSRP, status, is_recurring, visibility, tax_class_id, magikfeatured, magikrecommended, product_socialbar, special_from_date, special_to_date, news_from_date, news_to_date, custom_design_from, custom_word_design_to, description, qty. , use_config_min_qty, is_qty_decimal, outstanding, use_config_backorders, min_sale_qty, use_config_min_sale_qty, max_sale_qty, use_config_max_sale_qty, is_in_stock, low_stock_date, notifyuse_config_notify_stock_qty, manage_stock, use_config_manage_stock, stock_status_changed_auto, use_config_qty_increments, qty_increments, use_config_enable_qty_inc, enable_qty_increments, is_decimal_divided, stock_status_cha nged_automatically, use_config_enable_qty_increments, product_name, store_id, product_type_id, product_status_changed, product_changed_websites, custom_design, country_of_manufacture, fourseason, omega, UAC, gr_ean, gr_valid_throughfourseason, omega, UAC, gr_ean, gr_valid_throughfourseason, omega, UAC, gr_ean, gr_valid_through
* UPDATE *
I saved the file to excel as UTF-8 (I was doing this step after saving the file as csv using a text editor) and tried to upload, but now I am getting this error.
I feel like I took a step forward but still I couldn't find a solution.
** UPDATE *** After checking the first row and making some changes, like duplicate column names and non-underscore columns at the beginning (_store, _type ... etc), I get this error. 
I believe I have found a place why, if I use the data flow profile, it doesn't load from the 45th product.
I thought it might be a server issue? any ideas?
source to share
Steps to import products into Magento:
1.- Take a deep breath.
2.- Take a relaxing tea.
3.- Create a test product manually, with all your attributes. Create categories. (Use MageWorks to bulk import categories) 4.- Export products.csv file from system => export
5.- Add another test file to the exported file.
6.- Check if it is imported.
7.- Edit the exported added products file in Excel (do not touch the first line [attributes])
8.- I'm not sure about this, but Magento 1.9 doesn't use category_ids, it uses _category and the value is the actual path in the category example. Products / Vehicles / ADAPTERS ==> Being "Products", the main category is id (2).
[categories_id] might work for some people, but in my experience it didn't work for me, it was generating path errors.
9.- Save csv file. Make sure it's UTF-8 without BOOM. Use Notepad ++ to keep the encoding.
10.- Import the file using system => import. the system will check the data and if everything is ok you should have a green light.
Note: Every time you edit and save the file in Excel, it will change the encoding to ANSI again. SO make sure the file is UTF-8 W / O BOOM.
source to share
I had the same problem. It claimed the column was "type" even though I had one that was populated in the file. Then I resell UTF-8 without BOM, but it only helped me when I added a "_product_websites" column with a vales base. Check your file, there should be all required Magento fields
Hope this helps.
source to share