Magento – Magento 2: Product Import Error – Product Type is invalid or not supported. Duplicates found in column names [SOLVED]

csvexceptionimportmagento2product

I'm using Magento 2 CE Version 2.1.2

I have exported Sample CSV File from Magento Admin & importing the same file again. Then also it's not working for more than 1 record.
If you have only 1 record, then it works fine.

Using attribute_set_code as Default

We have product_type column.

I'm using in CSV

product_type
simple

I'm only checking with more than >1 Product.

Data validation failed. Please fix the following errors and upload the file again.
Following Error(s) has been occurred during importing process:
Only the first 100 errors are shown. Download full report
1. Value for 'product_type' attribute contains incorrect value, see acceptable values on settings specified for Admin in row(s): 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, 101
Checked rows: 101, checked entities: 101, invalid rows: 100, total errors: 100

In Downloaded Report in CSV, it's saying

Value for 'product_type' attribute contains incorrect value, see
acceptable values on settings specified for Admin

CSV File data

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 additional_attributes 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 related_skus related_position crosssell_skus crosssell_position upsell_skus upsell_position additional_images additional_image_labels hide_from_product_page bundle_price_type bundle_sku_type bundle_price_view bundle_weight_type bundle_values bundle_shipment_type configurable_variations configurable_variation_labels associated_skus
G232 Default simple Default Category/Coins base Orchid Minted Stamps
3-in-1 Silver Set Orchid Minted Stamps 3-in-1 Silver Set Orchid Minted
Stamps 3-in-1 Silver Set 1 1 Catalog,
Search 10 orchid-minted-stamps-3-in-1-silver-set Orchid Minted
Stamps 3-in-1 Silver Set Orchid Minted Stamps 3-in-1 Silver Set Orchid
Minted Stamps 3-in-1 Silver
Set G232-1.png G232-1.png G232-1.png G232-1.png 100 0 1 0 0 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 G232-1.png Image

Sometime it also gives

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

[UPDATE]

For OpenOffice Below is configuration I'm using.

I have checked on Windows, Linux, Libra Office, Open Office but still no luck 🙁

It's not working properly, that's why i have to go long way by making custom script as below.

Magento 2: Save all product data outside Magento with Images

[SOLUTION]

It's conflicting my custom Product Attribute which i named same product_type. Thanks to Magento Team for Pointing Out This Issue.

What i learn never used Reserverd Keywords. For more updates you can check github

https://github.com/magento/magento2/issues/6939

Best Answer

I don't know if this is relevant to your problem, but I had the same issue after I migrated a Magento 1.9 store.

In the Magento 1.9 store was a attribute created called Product Type. The attribute code was product_type, and the accepted values did not match simple, grouped etc.

I renamed the wrong product_type attribute in the database. After that the problem was fixed and the import run correctly.

Related Solutions

Import Error – Duplicate Column Names in Magento

The exception with the error message you stated is triggered in exactly one place (code slightly truncated for readability):

final public function __construct($source)
{
    $this->_source = $source;

    $this->_init();

    // validate column names consistency
    if (is_array($this->_colNames) && !empty($this->_colNames)) {
        $this->_colQuantity = count($this->_colNames);

        if (count(array_unique($this->_colNames)) != $this->_colQuantity) {
            Mage::throwException(Mage::helper('importexport')->__('Column names have duplicates'));
        }
    }
}

This means, count(array_unique($this->_colNames)) must be unequal to $this->_colQuantity

The $_colNames array is set in Mage_ImportExport_Model_Import_Adapter_Csv::rewind() (which is called during _init().
Once again, the code is slightly truncated for readability:

public function rewind()
{
    // rewind resource, reset column names, read first row as current
    rewind($this->_fileHandler);
    $this->_colNames = fgetcsv($this->_fileHandler, null, $this->_delimiter, $this->_enclosure);
}

The $_delimiter is set to ,, the $_enclosure is set to ".

To try to reproduce the issue, if I copy the CSV extract from your question into a file called test.csv and run the following code:

$f = fopen('test.csv', 'r');
$names = fgetcsv($f, null, ',', '"');    
$qty = count($names);
$uniqueQty = count(array_unique($names));
printf("%d records, %d unique records\n", $qty, $uniqueQty);

it produces the following output:

29 records, 29 unique records

This means, your CSV file is fundamentally okay. The difference must be somewhere else.
Looking at how array_unique works, there is a note how the type handling of array elements changed in PHP 5.2.9: http://php.net/manual/en/function.array-unique.php#refsect1-function.array-unique-changelog

To reproduce the issue, I re-ran my test-script with the SORT_REGULAR option set, but this still gives the same result (which is logical, since reading a file only can give string values).

At this time I believe the difference must be in the CSV file you are using. The Unix and the Windows newline characters (\n and \r\n) are both recognized by the fgetcsv() command, but the old MacOS style newline character (\r) would actually lead to the behavior you are experiencing.

I can't know if that is the reason why you are experiencing the issue, but I suggest you check the CSV file (again). It might also help if you provide a download link somewhere to the unmodified file (no pastebin), so any non-printable characters are preserved.

It might also help if you post the PHP version you are using.

Magento – “Product Type is invalid or not supported in rows” importing csv file

As of CE 1.9.0.1, only four product types can be imported using ImportExport:

Simple
Configurable
Virtual
Grouped

These types and their import models are defined in the ImportExport config file.

I'm afraid you would have to write your own import adapter for downloadable products.

Best Answer

Related Solutions

Import Error – Duplicate Column Names in Magento

Magento – “Product Type is invalid or not supported in rows” importing csv file

Related Topic