All in one Import and Export Magento 2 Extension

All-in-One Import and Export Extension, is your one-stop-shop for all your import and export requirements In Magento 2. This Magento 2 extension helps you easily migrate Category data, Product Attributes CMS Pages and CMS blocks into Magento 2 platform using CSV files. 

All-in-one  Import and Export Extension reduces the need to have separate Magento 2 extensions. The Extension saves your time and effort - one Extension with a fully customizable bulk import/export process for Magento Category, Product Attributes, CMS Block and CMS Page. This extension can also be used to update existing data and delete data via CSV.

Features

• Import and Export categories with images and other attributes.
• Import and Export Product Attributes.
• Import and Export CMS Pages.
• Import and Export CMS Blocks.
• Easy data transfer/migration to Magento 2 platform using CSV files.
• Easily update and delete existing records.
• Bulk category export with its additional data (including related product SKU's)
• A user-friendly approach to export data
• Easy to create additional product attributes during import or export.
• Create visual attributes in a single click (Upload swatch images on the fly)
• Sample documents available 
• Easy to install and configure
• Saves your time and effort

How ​​to ​​Install​ ​This ​​Module?

Step 1: Download​ ​ ​extension​ ​from​ ​My​ ​Downloadable​ ​Products​ ​in​ ​your account​ ​from​ ​our​ ​store​ ​or​ ​download​ ​the​ ​package​ ​from​ ​Magento​ ​Marketplace.

Step​​ 2: ​​ Create ​​​directory ​app\code\DCKAP\ImportExport ​​​​in ​​your ​​Magento Root ​​directory ​​and ​​unzip ​​here.

Step ​​3: ​Disable​​​​​ ​cache ​​to ​​avoid​ ​flushing​​ ​​cache ​​very ​​often.​​ It ​​may​​ affect performance ​​for ​​a ​while.​​ However, ​​you ​​can ​​skip ​​this ​​step.​​ If ​​you​ ​do ​​so,​ ​clean​​ the cache​​ manually ​​whenever​​ needed.

               PHP ​bin/magento​​ cache:disable​

Step​​ 4:​ ​ Enter the following ​​at​​ ​​command​ ​line ​​to ​​enable​​ ​module.

               php​ bin/magento ​​module:enable​​ DCKAP​_ImportExport

Step ​​5:  ​​Enter following ​​at command​​ line​​ to​​ run​ setup ​​scripts.

                php​ bin/magento ​​setup:upgrade​

Step ​​6:​​  Enter the ​​following ​​at​ the command ​​line ​​if the ​mode​ ​is ​​set ​​to ​​default ​​or production​ ​to ​​deploy ​​all the ​​static ​​files.

                php ​bin/magento​​ setup:static​-content:deploy

Step ​​7:​ Clear the cache ​​to ​​configure the ​​settings in the ​backend ​​(if ​​you​ ​skipped Step3)

                php​ bin/magento ​​cache:clean​

Step ​​8: ​Login ​​​​to ​​Magento​ ​backend​​ and​ ​navigate ​​to ​Store ​​​>​ Configuration ​​>

               DCKAP ​​>​ ImportExport ​and ​​​​configure ​​ ​​module.

Step​​ 9: ​Clear ​​​​​​cache​ ​to ​​apply ​​all ​​​​configurations ​​(if ​​you​ ​skipped​ ​Step 3)

               php​ bin/magento ​​cache:clean​

Step​​ 10: ​Enable the cache​​ once​​ everything​​ is​​ done.​​ Ignore, ​​if​​ you​ skip Step 3.

              php​ bin/magento ​​cache:enable​

That’s it. You are done. If you still face​ ​any​ ​issues​​ while​​ installing, ​​contact​ ​us ​​at extensions@dckap.com

General​​ Configuration

To ​​enable the extension,​​ go ​​to​ Stores ​​​​>​ Configuration​​ and ​​from​​ the left ​​side​​ menu.

Navigate ​​to ​DCKAP ​​​​> ​ImportExport > ​General​​ Configuration

• Select ​​​Enabled ​​Field​​ to ​​Yes ​​for ​​enabling the ​​Module.

How to get a Sample File?

To​​ get the sample file format, ​​navigate​​ to​ Stores > Import under Data Transfer.

• Choose entity type
• Upon selecting an entity type, there will be a Download Sample File link beside the drop-down box.
• Click Download Sample File link to download the sample file of that corresponding entity.

Category Import

To​​ import bulk Category, ​​navigate​​ to​ Stores > Importunder Data Transfer

• Select entity type as Category
• Specify the type of behavior (add/update, replace or delete) to perform.
• Select file to import with the required data (File format should be like the sample file format)
• Specify the image directory URL in Images File Directory field

After providing necessary details, click the Check Data button, it will validate the file, and upon successful validation. It will display the Import button at the bottom, and click the Import button to start the data import.

Category Export

To​​ export Category, ​​navigate​​ to​ Stores > Exportunder Data Transfer

• Select entity type as Category
• Filter data based on the options provided

After providing necessary details, click the Continue button. Once done, it will validate the data provided and export the data in CSV format.

CMS Page Import

To​​ import bulk CMS Page, ​​navigate​​ to​ Stores > Import under Data Transfer

• Select entity type as CMS Page
• Specify the type of behavior (add/update, replace or delete) to perform.
• Select file to import with the required data (File format should be like the sample file format)

After providing necessary details, click the Check Data button. It will validate the file, and upon successful validation, it will display the Import button at the bottom. Later, click the Import button to start the data import.

CMS Page Export

To​​ export CMS Page, ​​navigate​​ to​ Stores > Export under Data Transfer

• Select entity type as CMS Page
• Filter data based on the options provided

After providing necessary details, click the Continue button, it will validate the data provided and export the data in CSV format.

CMS Block Import

To​​ import bulk CMS Block, ​​navigate​​ to​ Stores > Import under Data Transfer

• Select entity type as CMS Block
• Specify the type of behavior (add/update, replace or delete) to perform.
• Select file to import with the required data (File format should be like the sample file format)

After providing necessary details, click the Check Data button, and it will validate the file. Upon successful validation, it will display the Importbutton at the bottom. Click the Importbutton to start the data import.

CMS Block Export

To​​ export CMS Block, ​​navigate​​ to​ Stores > Export under Data Transfer

• Select entity type as CMS Block
• Filter data based on the options provided

After providing necessary details, click the Continue button. It will validate the data provided and export the data in CSV format.

Product Attributes Import

To​​ import bulk Product Attributes, ​​navigate​​ to​ Stores > Import under Data Transfer.

• Select the entity type as Product Attributes
• Specify the type of behavior (add/update, replace or delete) to perform
• Select file to import with the required data (File format should be like the sample file format)
• Specify the image directory URL in Images File Directory field

After providing necessary details, click the Check Data button. It will validate the file and upon successful validation, it will display the Import button at the bottom. Afterwards, click the Import button to start the data import.

Product Attributes Export

To​​ export Product Attribute, ​​navigate​​ to​ Stores->Export under Data Transfer

• Select the entity type as Product Attributes
• Filter data based on the options provided

After providing necessary details, click the Continue button. It will validate the data provided and export the data in CSV format.