I'm trying to import my .csv
file to magento using magento import (system-import).
When i choose my .csv
file and click check data, it says file is valid and it gives me option to import. So i click import. After like 10 seconds, it gives me this error.
Following Error(s) has been occurred during importing process:
Only first 100 errors are displayed here. Download full report General
system exception happened Additional data: URL key for specified store
already exists.
I literally have no idea what this means. I have already tried maximizing characters to 255, changing writing permissions and leaving url_key blank, even deleting it out of .csv
. Nothing helps.
Any help will be appreciated!
PS: also after trying to upload when i go to dashboard, it gives me indexers are invalid
which never happened before.
Best Answer
Here I have attached two csv for configurable and simple product for your demo purpose so you can take reference on how to create it. Please try to import for simple product csv and then configurable one. I had tested it and its working fine.
Simple Product CSV
sku,attribute_set_code,product_type,categories,product_websites,color,additional_attributes,name,description,short_description,weight,product_online,tax_class_name,visibility,price,qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,deferred_stock_update,use_config_deferred_stock_update,errors 400110821753,Default,simple,Default Category/Women,base,BLACK,"color=BLACK,size=L",Test Product,Test Product,Test Product,4.5,1,None,Not Visible Individually,66.67,100,1,0,0,1,1,1,0,1,1,,1,1,1,1,0,1,0,0,1,0,1,
Configurable Product CSV
sku,store_view_code,attribute_set_code,product_type,categories,product_websites,name,description,short_description,weight,product_online,tax_class_name,visibility,price,special_price,special_price_from_date,special_price_to_date,url_key,meta_title,meta_keywords,meta_description,base_image,base_image_label,small_image,small_image_label,thumbnail_image,thumbnail_image_label,swatch_image,swatch_image_label,created_at,updated_at,new_from_date,new_to_date,display_product_options_in,map_price,msrp_price,map_enabled,gift_message_available,custom_design,custom_design_from,custom_design_to,custom_layout_update,page_layout,product_options_container,msrp_display_actual_price_type,country_of_manufacture,qty,out_of_stock_qty,use_config_min_qty,is_qty_decimal,allow_backorders,use_config_backorders,min_cart_qty,use_config_min_sale_qty,max_cart_qty,use_config_max_sale_qty,is_in_stock,notify_on_stock_below,use_config_notify_stock_qty,manage_stock,use_config_manage_stock,use_config_qty_increments,qty_increments,use_config_enable_qty_inc,enable_qty_increments,is_decimal_divided,website_id,deferred_stock_update,use_config_deferred_stock_update,related_skus,crosssell_skus,upsell_skus,additional_images,additional_image_labels,hide_from_product_page,bundle_price_type,bundle_sku_type,bundle_price_view,bundle_weight_type,bundle_values,configurable_variations,configurable_variation_labels,associated_skus GC_105-0S2,,Default,configurable,Default Category/Women,base,ConfProd Test,ConfProd Test,ConfProd Test,,1,None,"Catalog, Search",66.67,,,,ConfProd Test,,,,/c/l/classic_fit_1_2.jpg,,/c/l/classic_fit_1_2.jpg,,/c/l/classic_fit_1_2.jpg,,,,,,,,Block after Info Column,,,,,,,,,,,,,0,0,1,0,0,1,1,1,0,1,1,,1,1,1,1,0,1,0,0,1,0,1,,,,/c/l/classic_fit_1_2.jpg,,,,,,,,"sku=400110821753,color=BLACK,size=L","color=Color,size=Size",