Import Product Categories

[chathuramk]

Hi Guys,

There are thousands of product categories and sub categories to be imported to my Magento 2.1.x store. How can I import from CSV or any other way? your solutions are highly appreciated 

[Manthan Dave]

Hi @chathuramk

Well magento 2 have naively import/export feature functionality for product import !

From system - >import -> go with product import , download sample file from there and re-arrange your csv file same like sample file and then upload your file , check for errors , if all looks good then click on import it will import all your products from csv file,

second thing by default there is no category import/export functionality available in magento 2 - so you can use this free extension for category import/export from csv file - https://github.com/navinbhudiya/magento2-import-export-category

you can also try this extension for category import/export - https://www.solwininfotech.com/product/magento-2-extensions/category-import-export-magento-2/

Hope it helps !

[chathuramk]

Hi @Manthan Dave,

Thank you for your reply. I installed free extension and tried to import category from csv.

But it returns an error "Data Column Not Found". What should be the csv table format?

Is this format correct?
 

[Manthan Dave · Accepted solution]

I understand your concern

looking at the extension again, i think there is no sample file csv will be there .

so i have found another extension for you try this extension and it will works for you

https://github.com/macopedia/CategoryImporter?files=1

on the above link - category-example.csv will be there . which you can take it as a sample , installed and configured this extension

it will helps you for the same ..

Hope it helps

[Wagner Tim]

Hi, have a look at M2IF - Category Import which provides a fully functional category import as well as products, attributes + customers as well. This extension works for Community Edition as well as the Enterprise Edition and is open source and free of charge. On their Github Repository, they have sample data which will give you a good entry point.

[elijah_stownton]

Well, an alternative method is using a 3rd-party app, for instance Skyvia. It allows you to schedule CSV import to Magento: https://skyvia.com/data-integration/magento-csv-file-import-and-export

Skyvia doesn't require coding knowledge, has a simple UI, and provides a free version, so feel free to try it out!