products import CSV missing fields

jd447 · **Posted:** Wed Jun 27, 2012 7:00 am

Hello,

I tried to import products with the help of the text_import.csv

Code:

#FLAG|#name|#sku|#details|#price|#create_date|#modified_date|#taxable|#status|#weight|#HIER|#CAT:test1|#CAT:test2|#FIELD:image:Image|#FIELD:textarea:Notes|#ATTRIBS
P|Puptent|1234p|"this is a two man pup tent"|14.99|2009-01-01|2009-01-01|1|published|2.25|"Outdoors >> Camping"|1|0|puptent.png|"this is auxillary data about the pup tent"|Color:Red:+2.5:1234p-r -- Color:Green:+4.5:1234p-g

I added some fields and formatted the file like this

Code:

#FLAG|#name|#sku|#details|#price|#create_date|#modified_date|#taxable|#status|#weight|#HIER|#CAT:"occasions"|#CAT:"pieces"|#CAT:neuf|#FIELD:textbox:couleur_vehicule|#FIELD:textbox:kilometres|#FIELD:textbox:annee_modele
"P"|"LandroverDefender 90 TD4 Station Wagon (#55)"|"1234p"|"this is a two man pup tent"|43500|"2012-06-26"|"2012-06-26"||"published"|||0|0|1|"bleu"|10|2012
"P"|"LandroverDefender 90 TD4 SVX (#19)"|"1235f"|"this is a family tent"|37500|"2012-06-26"|"2012-06-26"||"published"|||1|0|0|"noir"|40380|2008

when i try to import, it returns all ok. but the modules only import successfully the name and the price.

It doesn't import the category neither my custom fields.

i tried a lot of different stuff... i'm running out of ideas.

thanks for your help!

Dr.CSS · **Posted:** Sat Jun 30, 2012 10:58 pm

Try creating the fields and categories before import, also maybe take out all the " " ...

jd447 · **Posted:** Mon Jul 02, 2012 8:15 am

Categories and fields were already created, and i tried with and without the ".

I can't figure out if it's a bug or a wrong formatted CSV.

SimonJ · **Posted:** Mon Jul 02, 2012 8:19 am

Can you create a product and export it? Then see if that imports?

jd447 · **Posted:** Mon Jul 02, 2012 8:22 am

is there a way to export products?

SimonJ · **Posted:** Mon Jul 02, 2012 2:42 pm

I don't know, I used to use that for checking fields in csv files but I don't have Products installed.

Dr.CSS · **Posted:** Thu Jul 05, 2012 2:29 am

Have you tried using , instead of | ?...

products import CSV missing fields

Who is online