Magento

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

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.

montpro - 03 May 2012 11: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…

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

?

montpro - 03 May 2012 11: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.

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 - 04 May 2012 12:49 AM

montpro - 03 May 2012 11: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.

Productos_German_20120510-001504.zip  (File Size: 1KB - Downloads: 64)

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] :

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

See if it helps

German Franco G - 10 May 2012 05: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.

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.