we have export the product in magento admin panel and changed the products details and import to products. its working fine. But some category id not inserted to table. We have checked with the excel sheet, there is category field in comma separated. My thought is comma is the problem. How to identify the issues?

  • did you try removing the comma then?
    – seb
    Commented Feb 24, 2015 at 13:02
  • In single category working fine. if we have more than one category , we facing the problem
    – Rat
    Commented Feb 24, 2015 at 13:06

1 Answer 1


Simply use 'dataflow' to import the product category ids.


Otherwise you will have to work with whatever code it is that you use to import your products and get it to manage multiple category ids. If this is a one-off import then strip your product spreadsheet down to sku + category_ids then import with dataflow.

  • Agreed using dataflow would be the most expedient method.
    – Eirik
    Commented Feb 24, 2015 at 15:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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