Magento importing product

[Lightme]

Hello,

I am having an serious isue with my personal webshop. I am really trying for more then 2 months to solve it. And tried everything except for the thing that worked. Let me atach the CSV file that I have collecting by Mageworks. Also all the atributes of the products have to be inside by an script I used for this.

Product with specified super products SKU not found in rows: 1, 2, 3, 4, 5, 6, 7, 14, 15, 16, 17, 18, 19, 28
Orphan rows that will be skipped due default row errors in rows: 2, 3, 4, 5, 6, 7, 15, 16, 17, 18, 19, 27, 28, 29, 30, 31, 32, 41, 42, 43, 44, 45, 46, 55, 56, 57, 58, 59, 60, 69, 70, 71, 72, 73, 74
Invalid value for 'options_container' in rows: 8, 9, 10, 11, 12, 13, 20, 21, 22, 23, 24, 25, 26, 35, 40, 54, 68
Invalid value for 'msrp_enabled' in rows: 26, 40, 54, 68
Invalid value for 'msrp_display_actual_price_type' in rows: 26, 40, 54, 68
Invalid value for 'tax_class_id' in rows: 26, 40, 54, 68
Duplicate SKU in rows: 33, 34, 36, 37, 38, 39, 47, 48, 49, 50, 51, 52, 53, 61, 62, 63, 64, 65, 66, 67, 75, 76

When I upload the CSV (database) of products it gives me constantly this error and I tried several ways to solve it including saving it without BOM as UTF-8. So I was hoping someone can give me the direction what to change in the file. Because litterly no where is more information about it (According too me).


Download link (due size other channel):

http://we.tl/OC7sPpuwgT

[natedcornell]

If I were in your position, I'd open the csv file in LibreOffice and figure visit each line number specified to try to understand the problem. Since there really aren't that many error lines, you could also just delete those lines and add those products/configurations manually. Might be quicker.

[KentChr_DK]

Hi,

What module / extension are you using for this .csv import ?

Have you managed to do a simple import or 1-2-5 products using this - before importing a 21MB csv file ?

If I open your .csv file in Apache Openoffice Calc, there are a lot om empty rows, ex. row A3 > A8 + A16 > A20 ?

[markgukov]

Import/Export > Dataflow - Profiles > Export All Products

The exported CSV file is what your particular instance of Magento expects from you when importing products. Start by modifying a few cells and reimporting the CSV file. That should work. Personally, I created a simple PHP script that processes my data and generates a CSV file that my Magento project understands.

[Maybray Digital]

Try using OpenOffice to export your CSV and import to Magento.

Good luck.

<< Signature should be added in My Settings : Personal page >>

[CMSSE]

This error is generated automatically when Magento product  importing system does not find predefined column and its data.

 You should use first Magento importing system generated and verified csv sheet. You can visit a very simple and useful article. at here