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? – Klettseb Feb 24 '15 at 13:02
  • In single category working fine. if we have more than one category , we facing the problem – Rat Feb 24 '15 at 13:06

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 Feb 24 '15 at 15:33

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.