5

Hi I am importing products in my 1.7.0.2 new setup, I already added the categories. when i import the csv product file, all go well. But the problem is the product is added to only subcategory, it is not added to root category at the same time. If the subcategory and root category both are not checked in product edit page then product does not show on the front end. I want every product to be added to root and sub categories, I have tried it in many ways but have not succeeded yet. Below are some ways i have applied (3 is root category id and 13 is sub)

_category,category_ids,_root_category
  Abc, 3|13, Root Catalog

_category,category_ids,_root_category
  Abc, '3,13', Root Catalog

_category,category_ids,_root_category
  Abc, 3/13, Root Catalog

_category,_root_category
  Root Catalog/Abc, Root Catalog

_category,_root_category
  Abc, Root Catalog

even have applied them in single and double quotes as well.

Any help would be very much appreciated.

6

Import using Magento's System > Import/Export > Dataflow Profiles. Make a comma-delimitted list of category_ids with sku as the key. Save it out as a CSV file:

sku,category_ids
ABC123,"1,2,3,4,5,7"
A3K23,"7,8,6,5"

When imported with Dataflow, the category_ids for the skus will be replaced with the categories as listed above so make sure you catch all of the categories otherwise their current assignment will be replaced with those uploaded.

If you need store id-based categories use the following, where store is the store code:

sku,store,category_ids
ABC123,admin,"1,2,3,4,5,7"
ABC123,store2,"100,200,300"
  • thanks for the answer. how can i import multiple images of a single product? how can separate them in media gallery attribute in csv file? comma thing does not work there. – Mujtaba Haider Jul 26 '13 at 4:26
  • No problem. That is a separate question and one I would be glad to answer if you would post it separately as it would exceed the scope of the comments section. – philwinkle Jul 26 '13 at 4:49
  • What do you do if the category names have commas in them? Is there another separator that would work? – Daniel Flippance May 12 '15 at 22:10
4

You can also use a great free tool MAGMI which allows import fields "category_ids" and "categories"

Regarding the format for category_ids philwinkle already advised - it's the same as for Dataflow Profiles - comma separated list of categories ids.

As for "categories" column, if you download and enable a plugin "Category creator" for Magmi, it will create needed categories on fly. The format is following: Category1;;Category2/Subcategory2;;Category3/Subcategory3/SubSubCategory3

You can also try this extension which is basically MAGMI integration into Magento interface with a lot of extended functionality. It solves this tasks very easily, you can export/import with preserving proper columns mapping.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.