Live Demo Buy Now

Category Bulk Upload Using CSV/XML/XLS for Magento 2

With the help of this module, the admin can import and export a bulk number of categories on the store. Using CSV, XLS, or XML files, bulk categories can be imported into the Magento store. Sample files are also available. The admin can do one-click export categories in CSV format for various Magento stores.

Features

  • Ajax one by one category import feature.
  • Admin can import mass categories with and without images
  • Admin able to export mass categories store wise
  • Category upload via CSV/XLS/XML files.
  • The admin can make the changes in the exported category file.
  • The code is fully open & you can customize it according to your need.
  • Multi-Lingual support / All language working including RTL.

Installation

Customers will get a zip folder and they have to extract the contents of this zip folder on their system. The extracted folder has an src folder, inside the src folder you have the app folder.

You need to transfer this app folder into the Magento2 root directory on the server as shown below.

After the successful installation, you have to run these commands in the Magento2 root directory.

First command- php bin/magento setup:upgrade

Second Command – php bin/magento setup:di:compile

Third Command – php bin/magento setup:static-content:deploy

After running the commands, you have to flush the cache from the Magento admin panel by navigating through->System->Cache management as shown below.

Multilingual Support

For the multilingual support, the admin will navigate through Store->Configuration->General ->Locale Options and select the locale as German (the language into which admin want to translate his store content).

Module Translation

If you want to translate their module language from English to German then follow the path app/code/Webkul/CategoryMassUpload /i18n in their unzipped folder and then you will get a CSV file with name “en_US.csv”.

Now, rename that CSV as to your region code and language code like – “de_DE.csv” and translate all right side content after the comma in your language.

After editing the CSV, save it and then upload it to the path app/code/Webkul/CategoryMassUpload /i18n where you have installed Magento 2 on the server. The module will get translated into your desired Language. It also supports RTL and LTR languages.

Category Manager

When the admin can click “ Category Manager” option then admin will get two options ” Manage Category Mass Import ” and “Manage Category Mass Export ” as per below snapshot –

Manage Category Mass Import

When the admin click on ” Manage Category Mass Import” then below page will be displayed. Here, admin can download the sample file (CSV/XLS/XML) to import the categories and can edit the sample file as per the requirement.

The admin can import the categories with the images or without the images.

Categories with Images  – Upload the category file with images zip file and save it. The images zip file should contain images files mentioned in category upload file.

Categories without Images – Upload only category file and save it

Sample CSV File 

Categories – Here, the admin can enter categories and their subcategories(like – Men/Clothes. Here, clothes is a subcategory of the Men category)

Store Id – The admin can enter store id in which admin wants to import the categories. (Store id 0 for default store ).

Is Active – The admin can set 1 to display category at the front end else 0.

Include in Menu – The admin can set 1 to display category in the Menu bar at the front end else 0.

Is Anchor – The admin can set 1 to make the category clickable in the Menu bar at the front end else 0.

The admin can enter the meta title, meta keywords, and meta description.

Images – Here, you need to enter the category image name which will be the same as in the image zip file if you are uploading the categories with images.

Products – The admin can add products to the category by just entering the product Ids.

Import the Categories 

For this, you need to upload the categories file and save it then you will get the import complete notification message as per the below snapshot – 

After importing the categories, the admin can view categories as per the below snapshot – 

Manage Category Mass Export

When the admin click on” Manage Category Mass Export” option then below page will be displayed.

Here, you can choose the store view and export the respective categories CSV file as per below file –

Here, the admin will get the Category id ( default category id is 2 ), Parent category id, Store name, Category name, Path of the category(parent category Id/child category Id), Category image name, Is active, Is anchor, Include in Menu, Meta title, Meta  Keywords, Meta description, and product ids in the exported CSV file.

After exporting the category CSV file, you can update it as per your need below snapshot – 

After that, you can import this updated CSV file and then you can view updated categories as per below snapshot (The admin needs to choose store view to view updated categories) –


That’s all for the Category Bulk Upload Using CSV/XML/XLS for Magento 2 module still have any issue feel free to add a ticket and let us know your views to make the module better http://webkul.uvdesk.com/

Current Product Version - 2.0.0

Supported Framework Version - 2.0.x, 2.1.x, 2.2.x

. . .

Comment

Add Your Comment

Be the first to comment.

css.php

Index