Magento Import Export Categories Extension
A large e-commerce store has multiple categories to manage. Whether you want to add, edit or update categories or move them from one store to another, you can trust the MageBees.com extension. Magento 1 Import Export Categories Extension will import/export root categories, sub categories and also assign products to different categories quickly.
You can import/export any type of category related data such as meta descriptions, meta titles, meta keywords, url_key, is active, is anchor, category description, category image, page layout and custom layout among many other things. It makes creating multiple categories in bulk easy by simply using CSV files.
Steps for Importing Categories:
1) Upload "import_category.csv" File in your Magento_Root/var/import folder.
2) Upload "Category Images" File in your Magento_Root/media/import/category folder.
3) Please download "IMPORT_CATEGORY.TXT" File
4) Click on "Add New Profile" and Call it "Import Category" and Paste the contents from "IMPORT_CATEGORY.TXT" then Click on Save Profile
5) Go To System >> Import/Export >> Dataflow – Advance Profiles Section.
6) Click On Import Category then you will get Following Screen.
7) Click on "Run Profile" tab (From left Navigation).You will get Following Screen.
8) Click on "Run Profile in Popup" Button.You will get Following Screen.
9) Now categories imported successfully. You can check imported categories from "Catalog>>Manage Categories" page.
Steps for Exporting Categories:
1) Please download "EXPORT_CATEGORY.TXT" File
2) Click on "Add New Profile" and Call it "Export Category" and Paste the contents from "EXPORT_CATEGORY.TXT" then Click on Save Profile
3) Go To System >> Import/Export >> Dataflow – Advance Profiles Section.
4) Click On Export Category then you will get Following Screen.
5) Click on "Run Profile" tab (From left Navigation). You will get Following Screen.
6) Click on "Run Profile in Popup" Button. You will get Following Screen.
7)Now categories exported successfully. You can get "export_category.csv" file into this path of your magento store, Magento-Root/var/export/file.
Need help? Please contact us at support@magebees.com
- Installation Guide Magebees Import Export Categories For Magento 1 Extension V1.0.2download here
- User Guide Magebees Import Export Categories For Magento 1 Extension V1.0.2download here
- Import Categorydownload here
- Export Categorydownload here
- Import-export-categories-sample-csvdownload here
- Import Export Categories with this one
-
I used it for one of our clients' websites. I must say this extension is very well-thought and made. MageBees has made updating and editing categories in Magento store a piece of cake. I don't mind buying more extensions from them.
Developer Support Functions as Described Usefulness - Great Extension, Even Better Support
-
The extension itself is great, and really easy to install on Connect Manager. We realised that it didn't quite do what we wanted from it but we contacted the support and within a few days they had tweaked a few settings so that we can now import new categories & sub-categories so that they import into the correct category, import category updates and export categories with all the editable information. Couldn't recommend the support enough, they know so much about what they are doing and are very quick and helpful to get you sorted. We are now looking into their other extensions.
Developer Support Functions as Described Usefulness - Useful extension, fast support
-
The extension is very useful to what we need to do - which is updating every year the contents of a product catalog. It allows us to import quickly hundreds of categories and subcategories in 6 languages, including also category description, category image and basically most category attributes. We encountered a problem we thought it was an issue of the extension but it proved to be just an inconsistency in our import file. The Magebees support was very quick and helped us by pointing up this inconsistency.
Developer Support Functions as Described Usefulness - Very good support
-
Very good support
Developer Support Functions as Described Usefulness - Does what it says on the tin
-
Worked as expected - well done!
Developer Support Functions as Described Usefulness - Powerful augmentation and quick backing
-
I incurred this extension to redesign countless categories with various information as per store-view: everything worked impeccably. Besides I had a few inquiries regarding it and bolster administration addressed rapidly. I completely suggest this extension.
Developer Support Functions as Described Usefulness - Excellent addon for import & export categories
-
I purchased this extension to import large number of categories. What might have taken me a long stretch of time to do manually but this extension did in minutes. Awesome backing as well!
Developer Support Functions as Described Usefulness - Marvellous extension for import and export cagetories
-
We have been utilizing the Import and Export Categories augmentation for some time now, and it furnishes us with a powerful feature. We firmly prescribe the Import and Export Categories augmentation as an absolute necessity have item for all the Magento stores.
Developer Support Functions as Described Usefulness - Great extension
-
It works very well for importing/exporting categories, thank you!
Developer Support Functions as Described Usefulness - Its very useful
-
i found its very dynamic and complete user friendly also support team is very good
Developer Support Functions as Described Usefulness - Great product and excellent support!
-
The product works exactly as described and is easy to install. Post sale support is excellent. They even made some modifications for me to fit my specific business needs.
Developer Support Functions as Described Usefulness
Menu Heading text Changes
2015-11-04 05:38:25- Menu Labels and Heading text Changes
Enable/Disable products sku feature
2015-05-15 09:51:48- Give Enable/Disable product sku feature from configuration settings for Import Export Categories.
- Fixed developer mode errors.
Export Store Wise category.
2015-09-11 09:51:48- Export Categories information storewise.
-
Q-1: When I click on "Run Profile in Popup" in Import Category Section, I get the following error "Could Not Load file: "...\...\var\import\import_category.csv"
Ans: This error shows that "import_category.csv" is not properly uploaded. So, please upload "import_category.csv" File in your/var/import folder.
-
Q-2: When I click on "Run Profile in Popup in” in Import Category Section, I get the following error “General error: 1452 cannot add or update a child row: ……………………"
Ans: This error shows that "import_category.csv" not properly created (Due to Product sku is wrongly inserted in sku field. So, please assign true Product sku in sku field.)
-
Q-3: When I click on "Run Profile in Popup in" in Import Category Section, I get the following error "Method 'SaveRow' Not defined in adapter ………………….."
Ans: This error shows that this Extension not properly installed. So, please make sure that you have installed this Extension properly.
-
Q-4: When I click on "Run Profile in Popup in" in Export Category Section, I get the following error "Fatal error: Class Mage_Capacitywebsolutions_Importcategory on line no 182"
Ans: This error shows that this Extension is not properly installed. So Please install this Extension again.
-
Q-5: I am getting max execution time error, what I need to do?
Ans: If you getting time out error, increase your time out limit. For that you have to consult your hosting guy.
-
Q-6: I am getting “‘var/export’ directory does not exit !” error?
Ans: This error comes due to “var/export” directory does not exists or not having write permission.
-
Q-7: I click on “Run Profile in Popup in” in Export Category Section, I get the following “below screen”
Ans: This error shows that because of max execution time is very low in your store. So, please increase your server max execution time out limit.
-
Q-8: How to import/Update Multi store with Single root category?
Ans: Please see the import_category_multistore_single_root_category.csv.
See the all_store_category_name Column.
Please insert the All Store View Wise Category Name in all_store_category_name Column. ( see the above Screen).
See the category_name Column.
Please insert the Store View Wise Category Name in category_name Column. (See the Below Screen).More Refer see the import_category_multistore_single_root_category.csv.
-
Q-9: Category import is working fine but some field are blank. How i can solve?
Ans: This is caused by improper CSV format. Please use openoffice.org calc spreadsheet application and saving in UTF-8 format. OR Please use Google Doc for Converting Your CSV in UTF-8 format.

