cancel
Showing results for 
Search instead for 
Did you mean: 

Import/Export Products Issue & Errors

Import/Export Products Issue & Errors

 I've created a new magento install (ver 1.9.1.1) in a staging environment and plan to import products and customers. I set up my attributes, attribute sets and catalogs. I created a sample configurable with its associated simple products in the ver 1.9 environment and then downloaded that to be sure I'd have all the fields needed for my upload. I then downloaded the products from my old (ver 1.4) database and copied it into the 'new' download - arranged all of the fields, made sure to update the new fields (e.g., country_of_manufacture), removed those few sample items already in ver1.9 and attempted an upload. Using the System - Import option, this is the error message I receive:

Product Type is invalid or not supported in rows: 1, 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
File is totally invalid. Please fix errors and re-upload file
Checked rows: 100, checked entities: 100, invalid rows: 100, total errors: 100

I'm only using Simple and Configurable item types so I can't figure out what the problem is. Can anyone help? Thank you for any ideas, suggestions!

Penny 

2 REPLIES 2

Re: Import/Export Products Issue & Errors

Possible reasons and way-outs -
1) you do not have _type column in your file or data there formattted the the wrong way. The type should be - simple or configurable or other (non-capitalized)

Magento is very peculair about the file columns and their format, check this article on this -

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

 

2) In case information about product type is in the file. Re-save your file with UTF-8 encoding and try again.

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.

Re: Import/Export Products Issue & Errors

Hi, 

I am facing problem while importing products. I have more than 200 categories and every category have more than 200 products. All the time products were imported successfully. But suddenly it stuck with one category I imported earlier and it was imported succcessfully. But next time when I try to import the csv file then the dataflow loads old one. For example. previously I have imported 463 records. After that I am trying to import next records. But it again loads 463 rows. I tried many times. For this I created another profile, truncate the table dataflow_batch_export and dataflow_batch_import, clear the cache, reindex the file. But I did not get any success.

 

Please guide me. I am stuck and I have to upload lots products.

Thanks in advance!

 

Regards,

Andsraj