cancel
Showing results for 
Search instead for 
Did you mean: 

Need to import a CSV with different column names -> Data flow 'invalid type ""' error

Need to import a CSV with different column names -> Data flow 'invalid type ""' error

Hello everyone,

 

A customer of us wants to import products using a 3rd party CSV file. Normally we'd use the Magento Import/Export function instead of the (deprecated) Data flow function. But the column names of this CSV file aren't the same as the column names we are using. (And as far as I know, you can't change this) So we are pretty much forced to use the Data flow function.

 

The problem is that when I want to import this CSV every row returns this error:

Skip import row, is not valid value "" for field "type"

Obviously this is because the 'type' column is missing. But this should always be 'simple', because it is a simple product. (every one of them) 

 

Magento version is 1.9.2.1 and the CSV is UTF8 encoded. (This is something that is already fixed)

 

And now the questions:

- Is it possible to assign columns from the CSV to product fields. (e.g. 'id' to 'sku') using Import/Export function?

- If not, is there a work around for this that doens't involve data flows.

- If not, is there a way to enter a default value for the 'type' column even when it is not in the csv?

- If not, is there any other way to import this?

 

Thank you already! Smiley Happy

1 REPLY
Highlighted

Re: Need to import a CSV with different column names -> Data flow 'invalid type ""' err

Hello.

 

Magento import/export does not allow fields mapping and Magento insists on all the required fields to be included in the file and heading names should be identical to database names, here is their list -

https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magen...

 

In case you do not want to adjust file manually you can use Store Manager extension. It has more flexible import tool with fields mapping, ability to add missing or necessary values on-the-fly during import with formulas and also there is no special requirements to import format. 

It is paid, but there is  fully-functional version you can give a try and use 14 days without fees or payment info asked. You can download it at Magento Connect or from the link in my signature.

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.