Import Export Products Extension For Magento 2
| v1.5.1
- Import Export all types of products like simple, configurable, grouped, bundle, downloadable and virtual.
- Import products with category ids or categories name. If categories do not exist then it will create new categories automatically then assign products into those categories.
- It works with latest Magento 2.4.6 version.
- Support multiple products images import/export as well as you can update products images as per your requirements.
- Import/Export products with all types like dropdown, checkbox, radio button etc custom options.
- Import/Export Custom and Magento's default attributes data in separate columns like Magento 1.
- Assign all the Magento's default system as well as custom attribute data to the products.
- Import/Export Related, Cross Sell and Up sell Products with their positions. As well as Import/Export Tier Price for products.
- Support Multi Website, Multi Store and Multi Store View for Import Products.
- Give options for All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields and Export Only Inventory Related Fields.
- Give you different types of require filters like export the products using an attribute set, product type, product status, product visibility.
- Export the products categories wise.
- You can Migrate Products From Magento 1 to Magento 2 using our both version extensions
-
60 Days
Money Back Guarantee -
Free
1-Year Support -
LifeTime
Free Updates -
Reasonable Price
Satisfaction Guaranteed -
Magento
Code Standards -
100% Open Source
Easy to Customize
Magento 2 Import Export Simple Products | Configurable Products | Bundle Products | Group Products | Downloadable Products
Magento 2 Import Products extension is easy to use and come with user-friendly layouts. Using this extension, you can import and export all types of products in your Magento store using CSV file. You can use import/update products for the stock update, price update, images update, products description update etc. You can import/update products for some specific fields, so it is fully customize CSV file with some specific fields are mandatory.
You can export products CSV file as per your requirements from your older version Magento store and import into your newer version Magento store.
We have created complete documents with snapshots for extension installation and how to use our extension. We also provided different types of sample CSV files for Import Products as per your requirements. You have to check the sample CSV files and create same format CSV file for importing the products.
Steps For Import Products
1. Upload CSV File
You can upload your created or exported .CSV (Comma Separated) file from here. Our extension allow .CSV (Comma Seperated) file format so you can manage it easily.
2. Run Profile
Choose uploaded or already exists CSV file from here. You can choose Import Behavior as per your requirement. Whether you want to import/update the products or delete the products in your site. You can also choose Validation Behavior. Whether you want to validate your CSV file or skip it.
3. Validation Log
If any issue found in your CSV file then all the errors will be displayed here. We bifurcate errors into two sections. Major and Minor. If you did not fix minor error then it will allow you to import the products but in major error, you have to fix the issue in your CSV file.
4. Import Log
Here you can see all the errors which occur during import the products for each of the products with SKU and error details.
Steps For Export Products
1. Export Products Filter
We provide different types of filters for export the products
- Store View: You can export products store wise.
- Select Fields For: We provide some preset template for export the products like image related, inventory related, price related, cross-sell, up-sell and related products related fields.
- Attribute Set Name: You can export the products from a specific attribute set products as well.
- Type: You can select which product type products you want to export like simple, configurable, bundle, grouped etc.
- Status: You can select which status products you want to export. Like Enabled or Disabled.
- Visibility: You can select which visibility products you want to export.
2. Attribute Selector
Using the attribute selector you can select the attribute which you want to export easily.
3. Download Exported Files
We manage export products CSV file history so you can easily download exported CSV later on as per your requirement.
4. Categories Filter
We provide categories filter. Using categories filter you can export the products categories wise.
Need help? Please contact us at support@magebees.com
-
Installation Guide Magebees Import Export Products For Magento 2 Extension V1.5.1 download here
-
User Guide Magebees Import Export Products For Magento 2 Extension V1.5.1 download here
-
Import Export Product Sample Csv download here
Made Compatible with the latest PHP 8.2 version.
2023-05-16 11:17:20- Made Compatible with the latest PHP 8.2 version.
Add New Filter Features & Made compatible with Magento 2.4.6 version
2023-04-07 10:06:20- Added new filters like Price and Stock for exporting the products.
- Made compatible with Magento 2.4.6 version.
Bug Fixed
2022-09-20 02:19:15- Modified the tier price code for import and export and add the website id on it.
- Modified the code of download images from live URL and split the request into multiple requests to handle large data.
Made compatible with Magento 2.4.5 version
2022-08-18 05:30:00- Make Compatible with Magento 2.4.5
- Handle Products Image-related errors.
- Fixed Bundle Products issue.
- Modified the Tier Price Code.
- Other Minor modifications as per support tickets.
Made compatible with Magento 2.4.4 version
2022-05-27 09:12:00- Make Compatible with Magento 2.4.4.
- Fixed the compilation issue.
- Fixed validation file issue in downloadable products.
Bug Fixed
2022-04-05 10:17:00- Fixed and Handle the image import/update related error.
- Fixed the Category URL key issue by improving the code.
- Fixed the Product URL key issue.
Make Compatible With Magento 2.4.3
2021-10-29 09:51:00- Make Compatible With Magento2.4.3.
Bug Fixed && Add New Features
2021-07-14 07:31:00- Fixed the export issue in the new Magento Version.
- Fixed Old Product image removes the issue.
- Fixed the category-wise export issue.
- Modified the Download Image Using URL Code and fixed the issue.
- Code and Layout Improvement.
BUG FIXED
2021-10-17 06:02:00- Fixed Source Stock issue in export products.
- Fixed image-related issues.
- Improved the code in the Downloadable Image Section.
- Fixed the validate log issue while the CSV file is not in a proper format.
- Improved the code in the export section.
Make Compatible With Magento2.4.X
2020-10-17 06:02:00- Make Compatible With Magento2.4.0.
BUG FIXED
2020-09-07 06:42:38- Fixed the Qty as well as Custom Text attribute issue in the export Section.
- Fixed the Category selection issue in the export section.
- Fixed the Gallery image update issue as well as remove the old image issue.
- Handle URL key already exists error for the category.
- Fixed Simple product import issue in the old version of Magento.
- Improved Code for the improve the Performance.
BUG FIXED
2020-20-04 09:52:12- Fixed the fatal error issue in the category section.
- Fixed the downloadable product update issue.
- Fixed validation issue.
- Fixed the salable qty issue for the new Magento version.
BUG FIXED
2020-31-01 06:49:48- Fixed Product Edit Page issue in Magento 2.3.4
BUG FIXED
2019-17-12 03:43:48- Fixed alternative products export issues while exporting the products using Custom Attributes Selector.
- Fixed categories related data not included in the Custom Attributes Selector.
- Fixed the process stuck issue while export a large number of products.
- Fixed the issue in export while the website is removed but it's still assigned to the product.
- Handle the 'URL key for specified store already exist' error comes in import when Url key of category already exists in the store.
- Fixed the gallery and swatch image issue.
- Fixed the compilation issue in old Magento versions.
BUG FIXED & Add New Features
2019-01-11 11:44:35- Add Custom Attribute selector in the export section.
- Improved the extension code and layout.
- Bug Fixes in export and import sections.
- Add a new tab for the user guide and sample CSV file in the import section.
BUG FIXED
2019-21-05 06:16:20- Fixed Tier Price issue in import and export..
- Fixed the issue of URL key for specified store already exists.
- Improved the Error Handling in All type of Products.
- Fixed the issue of custom option remove when update without its columns in all type of products.
- Fixed the Multi Website issue in all type of the products.
- Fixed the file not found issue in the downloadable product' validation.
- Fixed bundled products issue.
BUG FIXED & Add New Features
2018-12-07 06:15:20- Give configurations for Multiselect attribute separator.
- Optimized and Modified the code for support Magento's latest versions 2.1.16, 2.2.7 and 2.3.0.
- Add new filter for export the products by product id range.
- Fixed Product Images issue in Multi Website and Stores.
- Add Magento translate code in phtml files.
- Handle the exception for CSV file not in a proper format.
- Fixed the updated product issue in Multi Stores.
- Fixed the Custom text attributes are not included while export the products.
- Fixed the Upsell, Cross Sell and Related Products are not display proper count in admin issue.
- Fixed the issue regarding some attribute values are not imported.
- Fixed Tier Price Export issue.
- Fixed the issue regarding removed downloadable options when we try to import downloadable product options and custom options together.
- Fixed custom option deleted issue while updating the products images.
- Fixed sometime Import Product button not a display issue.
- Fixed dowloadable product samples are not imported issue.
- Fixed the type column not exported issue while create the CSV using Download Images From Live URL section.
- Updated and Improved User Manual document.
BUG FIXED & Add New Feature
2017-12-20 01:53:20- Fixed tier price update issue.
- Fixed upload button does not display issue after error log.
- Fixed product disabled issue while assign up-sell, cross-sell products in multisite.
- Fixed Image import/update related issues.
- Fixed Undefined index error while importing the bundle products.
- Fixed 404 page not found an issue in Export and Import Grid.
- Fixed undefined offset error while update downloadable products.
- Did Some require modification in the documentation.
- Fixed Custom Options related issues.
BUG FIXED
2017-11-18 03:21:45- Fixed Custom option issue for Magento version 2.2.x.
- Fixed Qty update issue.
BUG FIXED & Add New Feature
2017-09-12 04:16:45- Fixed downloadable products import issue.
- Add categories filter for export the products categories wise in export page.
Bug Fixed
2017-05-27 04:35:11- Fixed the category import issue in multi website.
- Fixed the URL key error while import same name category.
- Fixed product image removed issue while update other data and when no image related column define in csv file.
- Fixed the custom option import issue in configurable, virtual and bundle product type.
- Fixed generated csv file issue in download images from live URL section.
Add New Feature
2017-03-18 05:15:28- Now you can download images from live URL and use it for import the products.
Import Export Products Extension For Magento 2
2017-02-9 11:40:22- This extension can import product with custom option, category and multiple images
-
Q-1: How to Export Products from Magento 1 and Import them in Magento 2?
Ans: In that case you have to follow below step.
Step 1: Installed our Import Export Products Extension for Magento 1 (https://www.magebees.com/magento-import-export-simple-products-configurable-products-bundle-products-group-products-downloadable-products.html) in your Magento 1 site.
Step 2: Export the products in your magento 1 site From MageBees -> Import/Export Products -> Export Products.
Step 3: Copy your exported csv file from Magento 1 site and put it into your Magento 2 site Maento_root/var/import folder. (if import folder not exists then create it.)
Step 4: Now time to copy images. For that copy media/catalog/product folder and put it in pub/media folder and rename it as "import" in your Magento 2 site.
Step 5: Now Login in your Magento 2 site and go to MageBees -> Import/Export Products -> Import Products. Go to Run Profile Tab and select your csv file from "Choose Import File" and click on Validate & Import File Data button.
Step 6: After Validate your csv file you need to click on "Import Products" Button. -
Q-2: I have installed Import Export Products extension but got following error. "There has been an error processing your request". "Please upgrade your database: Run bin/magento setup:upgrade".
Ans: Run "php bin/magento setup:upgrade" command to your terminal or command prompt. Please see installation steps for that.
-
Q-3: I have installed import export Products extension but when i open admin and i got "Specified invalid parent id (Magebees_Menu: title)" error.
Ans : Please enable "Magebees_Menu" module by run "php bin/magento module:enable Magebees_Menu" from command prompt in magento root directory.
-
Q-4: I am getting max execution time error, what I have to do?
Ans: If you getting time out then increase your server max execution time. For that you have to contact your server/hosting support team.
-
Q-5: Products import working fine but QTY showing blank. How i can solve?
Ans : In this case please check you have define value in qty column.
-
Q-6: What I do when products import going correctly with no single errors but they don't show on frontend until I re-edit and save it?
Ans: It’s because you are missing the "options_container" column in your csv and its values. These are required and it’s recommended not to change or remove columns or remove it.
-
Q-7: How to create or manage parent and child category?
Ans: Here some string mention for category column. Explained bellow.
Category Column String:
Parent Category, Parent Category/Child Category, Parent Category/Child Category/ Sub Child Category
Here,
Parent Category: if you use this string then it will create Parent Category.
Parent Category/Child Category: if you use this string then it will create Parent Category first, then it will create Child Category.
Parent Category/Child Category/Sub Child Category: If you use this string then it will create Parent Category first, then it will create Child Category and then create Sub Child Category.
The default Parent Category separator is "," (comma) and child category separator is "/" (slash) -
Q-8: Import Screen Showing "Fatal error: Call to a member function getId() on a non-object" ?
Ans: This error comes because of you not created attribute which you mentioned in CSV. OR attribute is not assigned to attribute set.
-
Q-9: I am getting "var/export directory does not exist !" error?
Ans: This error comes due to var/export directory does not exists or not having write permission.
-
Q-10: I am getting "var/import directory does not exist !" error?
Ans: This error comes due to var/import directory does not exists or not having write permission.
-
Q-11: I am not able to update attribute set.
Ans: You can’t update attribute set values using our extension.
-
Q-12: I am getting "Product SKU filed in sku is empty" error while try to import the products.
Ans: This error occur because of your csv file is not created in UTF-8 format. You must convert your csv file in UTF-8 format using open office or Google spreadsheet.
-
Q-13: I am not able to import/update products images.
Ans: For Import and update the products images you must define four column image, small_image, thumbnail and gallery in your csv file.
-
Q-14: I am getting below error while trying to import the products.
A technical problem with the server created an error. Try again to continue what you were doing. If the problem persists, try again later.Ans: When this error occurred that means there is something wrong in your CSV file or in the site Data. This is Magento's default error handling message so you have to contact our support guy when you get this kind of error. Our support team will check our issue and give you a proper solution.
-
Q-15: I am not able to Import Configurable Products Properly.
Ans: In this case you have to check below things.
1. All the defined attributes have proper value or not and define in the sample products.
2. All the attributes are added in the mentioned attribute set.
3. The attributes which you want to use to create the configurable products are defined in the “used_attribute” column.
4. Make sure you have mentioned correct SKUs in the "child_products_sku" column also make sure that all the products are already available on the site.
Note:
1. The best practice for import the configurable product is making separate CSV files. One for its associated (simple) products and another is for configurable products. First import all the simple (it’s associated) products then import the configurable products.
2. Our Extension will not create attributes or its value in the site. Before import, any type of products with a custom attribute set make sure you have created all the attributes along with its values on your site. -
Q-16: Products display out of stock or changes are not display in frontend after import the products.
Ans: This issue occurred because you did not index after import the products. You have to reindex all the data after you import the products. You can do indexing using the below command from SSH. As well as refresh the caches from the admin section.
php bin/magento indexer:reindex -
Q-17: We are getting "Image: /sampleimage.png does not exist in folder." error
Ans: If you are getting such error that means you have not put product images in pub/media/import directory. Also, check directory as well as images permission.
