cancel
Showing results for 
Search instead for 
Did you mean: 

Missing category at product import via csv

SOLVED

Missing category at product import via csv

Hey to all,

 

I have solved the big problems, but I have a small problem and I am not able to fix it. 

 

I import products via .csv and all Information is here, only the category is missing. The product is not in the category it should be. 

 

An example of the csv file: 

 

sku,store,attribute_set,type,category,root_category,product_websites,description,meta_description,meta_title,name,price,status,visibility,weight,short_description,tax_class_id,qty,is_in_stock
CARABINEERBLACK,at_de,Default,simple,Test/Chains Keyrings Tags,AT,at,Testbeschreibung 1,Meta desc,Meta Title,ANODISED CARABINEER BLACK 75mm x 37mm 10 PACK,11.9,1,4,0,Kurztext 1,1,45,1
CARABINEERBLUE,at_de,Default,simple,Test/Chains Keyrings Tags,AT,at,Testbeschreibung 2,Meta desc,Meta Title,ANODISED CARABINEER BLUE 75mm x 37mm 10 PACK,11.9,1,4,0,Kurztext 2,1,43,1
CARABINEERGOLD,at_de,Default,simple,Test/Chains Keyrings Tags,AT,at,Testbeschreibung 3,Meta desc,Meta Title,ANODISED CARABINEER GOLD 75mm x 37mm 10 PACK,11.9,1,4,0,Kurztext 3,1,23,1

 

I am working in Magento 1.9.1.1 and uploaded the data via Import/Export - Import.

 

Thank you - I'm glad to read your answers!

Cessayr

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Missing category at product import via csv

Hi @Mukesh Tiwari,

 

thx for your answer. 

I tried this: 

sku,store,attribute_set,type,category_ids,root_category,product_websites,description,meta_description,meta_title,name,price,status,visibility,weight,short_description,tax_class_id,qty,is_in_stock
CARABINEERBLACK,at_de,Default,simple,1135,AT,at,Testbeschreibung 1,Meta desc,Meta Title,ANODISED CARABINEER BLACK 75mm x 37mm 10 PACK,12,1,4,0,Kurztext 1,1,45,1

 

and the category is missing again Smiley Sad 

 

Any ideas?

Thx for your support!

View solution in original post

2 REPLIES 2

Re: Missing category at product import via csv

Hi @Cessayr

 

You should use category ids not the category names while importing using Magento (No extension used).

 

Thanks

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: Missing category at product import via csv

Hi @Mukesh Tiwari,

 

thx for your answer. 

I tried this: 

sku,store,attribute_set,type,category_ids,root_category,product_websites,description,meta_description,meta_title,name,price,status,visibility,weight,short_description,tax_class_id,qty,is_in_stock
CARABINEERBLACK,at_de,Default,simple,1135,AT,at,Testbeschreibung 1,Meta desc,Meta Title,ANODISED CARABINEER BLACK 75mm x 37mm 10 PACK,12,1,4,0,Kurztext 1,1,45,1

 

and the category is missing again Smiley Sad 

 

Any ideas?

Thx for your support!