Magento 2 Import Export Simple Products | Configurable Products | Bundle Products | Group Products | Downloadable Products
Import Export Products extension is very easy to use and come with user friendly layouts. Using our extension you can import and export all types of products in your magento store using fully customize CSV file. You can use import/update products for stock update, price update, images update, products description update etc. You can import/update products with 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 Seperated) 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 display here. We bifurcate errors in 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 are occurs during import the products for each 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 pre set 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. Download Exported Files
We manage export products csv file history so you can easily download exported CSV later on as per your requirement.
- Excellent Plug-in. Makes editing your items so much easier
The most useful Magento Plug-in. It makes batch editing (add/remove/edit) your item inventory, descriptions, categories, attributes so much easier.
Simply edit the csv file then import to Magento. It saves me so much time!
Easy to install, easy to use, plus excellent Support!
Usefulness Functions as Described Developer Support
Bug Fixed2017-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 Feature2017-03-18 05:15:28
Import Export Products Extension For Magento 22017-02-9 11:40:22
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.
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.
Export the products in your magento 1 site From MageBees -> Import/Export Products -> Export Products.
Copy your exported csv file from Magento 1 site and put it into your Magento 2 site
/var/import folder. (if import folder not exists then create it.)
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.
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.
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 : This is caused by improper CSV format. Please use openoffice.org calc spreadsheet application and saving in UTF-8 format.
Please use Google Spreadsheet for Convert Your CSV in UTF-8 format.
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
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.
Check items to add to the cart or select all