cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicates found in column names: array - CSV Upload

Duplicates found in column names: array - CSV Upload

Hi guys! Using Magento 2.1.2

Having a few issues uploading a CSV of products, around 2000 of them. I've gone through and checked everything is good, data wise. Can anyone help why this is happening? 

 

Here's a link to the data file I'm using: https://www.dropbox.com/s/ue8ikg7hz3jnrdn/PASH%20LPD%20MASTER%20FILE.xlsx?dl=0

I'm getting this error on upload though: 

Duplicates found in column names: array ( 0 => 'sku', 1 => 'size', 2 => 'description', 3 => 'configurable_variations', 4 => 'attribute_set_code', 5 => 'product_type', 6 => 'categories', 7 => 'product_websites', 8 => 'name', 9 => 'short_description', 10 => 'weight', 11 => 'product_online', 12 => 'tax_class_name', 13 => 'visibility', 14 => 'price', 15 => 'special_price', 16 => 'special_price_from_date', 17 => 'special_price_to_date', 18 => 'url_key', 19 => 'meta_title', 20 => 'meta_keywords', 21 => 'meta_description', 22 => 'base_image', 23 => 'base_image_label', 24 => 'small_image', 25 => 'small_image_label', 26 => 'thumbnail_image', 27 => 'thumbnail_image_label', 28 => 'swatch_image', 29 => 'swatch_image_label', 30 => 'created_at', 31 => 'updated_at', 32 => 'new_from_date', 33 => 'new_to_date', 34 => 'display_product_options_in', 35 => 'map_price', 36 => 'msrp_price', 37 => 'map_enabled', 38 => 'gift_message_available', 39 => 'custom_design', 40 => 'custom_design_from', 41 => 'custom_design_to', 42 => 'custom_layout_update', 43 => 'page_layout', 44 => 'product_options_container', 45 => 'msrp_display_actual_price_type', 46 => 'country_of_manufacture', 47 => 'additional_attributes', 48 => 'qty', 49 => 'out_of_stock_qty', 50 => 'use_config_min_qty', 51 => 'is_qty_decimal', 52 => 'allow_backorders', 53 => 'use_config_backorders', 54 => 'min_cart_qty', 55 => 'use_config_min_sale_qty', 56 => 'max_cart_qty', 57 => 'use_config_max_sale_qty', 58 => 'is_in_stock', 59 => 'notify_on_stock_below', 60 => 'use_config_notify_stock_qty', 61 => 'manage_stock', 62 => 'use_config_manage_stock', 63 => 'use_config_qty_increments', 64 => 'qty_increments', 65 => 'use_config_enable_qty_inc', 66 => 'enable_qty_increments', 67 => 'is_decimal_divided', 68 => 'website_id', 69 => 'related_skus', 70 => 'related_position', 71 => 'crosssell_skus', 72 => 'crosssell_position', 73 => 'upsell_skus', 74 => 'upsell_position', 75 => 'additional_images', 76 => 'additional_image_labels', 77 => 'hide_from_product_page', 78 => 'bundle_price_type', 79 => 'bundle_sku_type', 80 => 'bundle_price_view', 81 => 'bundle_weight_type', 82 => 'bundle_values', 83 => 'bundle_shipment_type', 84 => 'configurable_variation_labels', 85 => 'door_type', 86 => 'door_style', 87 => 'factory_finish', 88 => 'fire_rating', 89 => 'glazing', 90 => 'glazing_type', 91 => 'supplier', 92 => 'timber_type', 93 => '', 94 => '', )


1 REPLY

Re: Duplicates found in column names: array - CSV Upload

Possibly, your last two columns have no title:

 

93 => '', 94 => '',

 

(I'm getting the same thing, but my first row is unique...)

Regards,

Hank