Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Import CSV - Product Type is invalid or not supported
 
revengous
Jr. Member
 
Total Posts:  8
Joined:  2012-02-08
 

Hi,

I am a web developer and use magento regularly for client websites, and I am having some troubles with the import feature (this is the first time ive had this issue, hopefully the last)

im having some trouble with my ‘type’ field - I can export products fine (via the profile) but I cannot import any csv’s as my ‘type’ field seems to be invalid.

for all my products I have
column name: type
value: simple

for each product (currently 32) - this was what was exported.

I have searched around and tried the following
naming the column to ‘_type’
changing the value to:
‘Simple’
‘simple product’
‘Simple Product’

used the profile ‘import all products’, however that also returned an error.

yet nothing seems to be working. Is it possible that it could be validating incorrectly somehow? I have some experience with the magento files, could an xml file be missing the required data to validate product types? where would I look to check this?

tech details:
Magento version 1.6.2
Im using a theme, sample data used (all product data etc was removed)
cache disabled (I dont think this would cause the issue)

has anyone encountered this as well? If we have to insert 32 products manually we will, however it would be great to fix this (more products will come later, and we dont want to have to add 500+ because the csv import does not work)

I should also point out that I tried creating a test product, exporting, deleting the test product and then re importing without opening the export.csv yet I get the same error.

thanks,
Kev

 
Magento Community Magento Community
Magento Community
Magento Community
 
montpro
Member
 
Avatar
Total Posts:  50
Joined:  2008-12-24
 

Hi, I have found that the formatting of the database columns is crucial. Try selecting the column with the information, click format cells and then use ‘number’ with 0 decimal places.

 
Magento Community Magento Community
Magento Community
Magento Community
 
revengous
Jr. Member
 
Total Posts:  8
Joined:  2012-02-08
 
montpro - 03 May 2012 10:02 AM

Hi, I have found that the formatting of the database columns is crucial. Try selecting the column with the information, click format cells and then use ‘number’ with 0 decimal places.

Hi, thanks for the response.

unfortunately this did not work for me, I tried formatting all of the cells as well, still did not work.

any other ideas?

its interesting because this is the second magento install Ive done this week, used the same files and everything, yet only this website is causing the issue…

 
Magento Community Magento Community
Magento Community
Magento Community
 
montpro
Member
 
Avatar
Total Posts:  50
Joined:  2008-12-24
 

So have you tried the database from the other website? If that works then its probably an install issue.

Are you using:

system
import/export
Dataflow - Profles
import all products
upload file
run profile

?

 
Magento Community Magento Community
Magento Community
Magento Community
 
revengous
Jr. Member
 
Total Posts:  8
Joined:  2012-02-08
 
montpro - 03 May 2012 10:40 PM

So have you tried the database from the other website? If that works then its probably an install issue.

Are you using:

system
import/export
Dataflow - Profles
import all products
upload file
run profile

?

Ive tried all of that as well, nothing seems to be working.

how would I check if the install went correctly? the site is fine, it just doesn’t want to validate my type field.

 
Magento Community Magento Community
Magento Community
Magento Community
 
German Franco G
Jr. Member
 
Total Posts:  5
Joined:  2010-07-07
 

I am passing trough the same experience rigth now.

Just that for some reason my magento passed by this field as a simple red alert after i edit the CSV file in notepad++ and recheck the format as UTF-8

Attached to this post is the CSV file and here is the page of the product as it looks after the import:
Product Loaded with CSV MAgento 1.6.2

revengous - 03 May 2012 11:49 PM

montpro - 03 May 2012 10:40 PM
So have you tried the database from the other website? If that works then its probably an install issue.

Are you using:

system
import/export
Dataflow - Profles
import all products
upload file
run profile

?

Ive tried all of that as well, nothing seems to be working.

how would I check if the install went correctly? the site is fine, it just doesn’t want to validate my type field.

File Attachments
Productos_German_20120510-001504.zip  (File Size: 1KB - Downloads: 132)
 
Magento Community Magento Community
Magento Community
Magento Community
 
German Franco G
Jr. Member
 
Total Posts:  5
Joined:  2010-07-07
 

Hey guys,

I just noted one thing.

I am importing and exporting trough the Data Flow module, using ”only mapped fields” for both processes.
Exporting goes well but importing the same file I just exported was not so good, at the end i realize that the order of import (position of my fields on the csv columns ) was different than the specified for the process in the data flow model I created myself.

Doh!  >:-( (

What I mean?

My import dataflow process is named import_process_atprods and the mapped fields are in the order as shown in [Defined] and the file that didn’t upload was as shown in [On CSV] :

+--------------------------+------------------+
|-
Order-|-----Defined------|------On-CSV------|
+-------+------------------+------------------+
|
1------|sku---------------|store-------------|
|
2------|category_ids------|websites----------|
|
3------|name--------------|attribute_set-----|
|
4------|meta_title--------|type--------------|
|
5------|meta_description--|category_ids------|
|
6------|url_key-----------|sku---------------|
|
7------|price-------------|name--------------|
|
8------|weight------------|meta_title--------|
|
9------|status------------|meta_description--|
|
10-----|visibility--------|url_key-----------|
|
11-----|proveedor---------|price-------------|
|
12-----|description-------|weight------------|
|
13-----|short_description-|status------------|
|
14-----|store-------------|visibility--------|
|
15-----|websites----------|proveedor---------|
|
16-----|attribute_set-----|description-------|
|
17-----|type--------------|short_description-|
|
18-----|tax_class_id------|tax_class_id------|
+-------+------------------+------------------+

Once I fixed this order on the CSV to match the order defined, the problem was solved.

See if it helps

 
Magento Community Magento Community
Magento Community
Magento Community
 
NELAGeek
Sr. Member
 
Avatar
Total Posts:  193
Joined:  2010-01-23
US
 
German Franco G - 10 May 2012 04:05 AM

Hey guys,

I just noted one thing.

I am importing and exporting trough the Data Flow module, using ”only mapped fields” for both processes.
Exporting goes well but importing the same file I just exported was not so good, at the end i realize that the order of import (position of my fields on the csv columns ) was different than the specified for the process in the data flow model I created myself.

Doh!  >:-( (

What I mean?

My import dataflow process is named import_process_atprods and the mapped fields are in the order as shown in [Defined] and the file that didn’t upload was as shown in [On CSV] :


+--------------------------+------------------+
|-
Order-|-----Defined------|------On-CSV------|
+-------+------------------+------------------+
|
1------|sku---------------|store-------------|
|
2------|category_ids------|websites----------|
|
3------|name--------------|attribute_set-----|
|
4------|meta_title--------|type--------------|
|
5------|meta_description--|category_ids------|
|
6------|url_key-----------|sku---------------|
|
7------|price-------------|name--------------|
|
8------|weight------------|meta_title--------|
|
9------|status------------|meta_description--|
|
10-----|visibility--------|url_key-----------|
|
11-----|proveedor---------|price-------------|
|
12-----|description-------|weight------------|
|
13-----|short_description-|status------------|
|
14-----|store-------------|visibility--------|
|
15-----|websites----------|proveedor---------|
|
16-----|attribute_set-----|description-------|
|
17-----|type--------------|short_description-|
|
18-----|tax_class_id------|tax_class_id------|
+-------+------------------+------------------+

Once I fixed this order on the CSV to match the order defined, the problem was solved.

See if it helps

We have just released our Import Evaluation Extension that, I think, will do what you’re trying to do.  Right now, it only works in Magento 1.7.x.  It has the capability of correctly mapping columns and allowing custom columns. i.e. calculated columns and constant value columns.

Great functionality and great price.

 
Magento Community Magento Community
Magento Community
Magento Community
 
buorfrsxs
Jr. Member
 
Total Posts:  4
Joined:  2012-11-04
 

I have found that the formatting of the database columns is crucial.Kids Nike Shox
Nike Shox Kids Shoes
Women Nike Shox R2
Womens Nike Shox TL3 Try selecting the column with the information, click format cells and then use ‘number’ with 0 decimal places.

 
Magento Community Magento Community
Magento Community
Magento Community
 
tortora
Member
 
Total Posts:  31
Joined:  2014-01-18
 

We have an application that offers an easier way to upload csv files and addresses some of these issues.  You can get more info on it at www.ClaraStream.com and feel free to email me at info@clarastream.com if you have any questions.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top