Import Export Products For Magento 1
| v2.5.0
Magento Import Export Products | Simple Products | Configurable Products | Bundle Products | Group Products | Downloadable Products
You can use our Magento Import Export Products Extension for import all types of products into your magento store using fully customize CSV file. You can use import products for stock update, price update, images update, custom options 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 with different format as per your requirements from your older version magento store and import into your newer version magento store. Our extension also provide feature to download the live URL images so you can use these images easily into import products CSV file.
We have created complete documents with snapshots for extension installation and how to use our extension. We have also FAQ section which help you to fix your errors quickly. 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.
If your products CSV file have special characters or some languages have special characters then you have to use UTF-8 format CSV file for import products.
Our Import Export Products Extension have highest number of downloading (15000+ ) and also happiest customers. Please create support ticket here, http://support.magebees.com/ so our support team always ready to help you.
No Extra Cost for below Import/Export Producuts Features :-
- Now Support in Enterprise Edition.
- Now You can export the products using category filter. You can select more then one categories for export the products.
- Import/Export all type of products like simple, configurable, grouped, bundle, downloadable, virtual.
- Import/Export products with categories ids/categories name. If categories are not exists then it will create new categories automatically then assign products into that categories.
- Import/Export products with multiple images and custom options.
- You can download products images from third party url and download into your store then import products with those images.
- Import/Export products images labels
- Import/Export all the magento's default as well as custom attribute data.
- Import/Export Group Price for products and Tier Price for products.
- Import/Export Related, Cross Sell and Up sell Products.
- Support Multi Website, Multi Store and Multi Store View for Import Products.
- Our extension Support all the languages
- Give more filters in export like Product Type, Product Status, Product Visibility and Products By Range.
- Rearrange attributes list alphabetical order in export page.
- Give options for All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields, Export Only Inventory Related Fields, Export Custom Options Related Fields.Now you can also export specific fields for your products CSV file.
- Now we can put products validation process so you can check your products CSV file all the products data correct or not. Our Validation log show the product sku and error description if any products data is not proper into CSV file. We also show major and minor errors about the products. If major errors then only products not imported. If minor errors then products will import.
- You can use our extension for products migration from one ecommerce software to another software. You can also use our extension for magento version upgradation.
Installation Steps
- Disable Merge JS-CSS option from System > Developer. (Only if it is enabled)
- Disabled all the Caches from System > Cache Management. (Only if it is enabled))
- Extract the downloaded extension zip.
- Upload all files to the appropriate folders.
- Clear and flush all Caches.
- Logout from admin and re-login again.
- Re-run the compilation from System > Tools > Compilation. (Only if compilation enabled)
Steps For Import Products
1) Upload File
You can upload your created or exported .CSV file from here. Our extension allow .CSV file format so you can manage it easily.
2) Run Profile
Choose uploaded or already exists csv file from Choose Import File. You can choose Import Behavior. Whether you want to import/update the products or delete the products. 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 must fix the issue in your csv file.
4) Import Log
After import the products its shows number of imported products and number of products not imported. If any error occurs during import then it will also display error listing for each products sku with error detail.
5) Sample CSV
We provide all types of Sample CSV files inside our extension so you can check sample CSV file as per your requirements and create CSV file accordingly.
6) Documentation
We provide pdf documentations inside our extension so you can read it before using our extension so it will help you to import products as per your requirements without facing any issue.
Steps For Export Products
1) Export Products Filter
You can export products store wise.
- We provide options for All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields, Export Only Inventory Related Fields, Export Custom Options Related Fields.Now you can also export specific fields for your products CSV file.
- You can export specific attribute set products as well.
- Manage file name as per your requirement.
- We provide you custom selection of fields so you can select fields as per requirement and export them.
2) Download Exported Files
We manage export products csv file history so you can easily download exported CSV later on.
3) Categories Filter
We provide category selection filter same as default Magento. Using categories filter you can select categories from which you want to export the products.
Download Images From Live URL
For downloading live images, we provided additional module for that. Using this module you can download images from live URL easily and use it for import products with images.
Configuration Pages
We provide separator for categories. From, here you can change the parent and child category separator.
Let's Have a Quick Look how to install extension from Magento Connect
Let's Have a Quick Look of Import Export Products Process
Need help? Please contact us at support@magebees.com
- Installation Guide Magebees Import Export Products For Magento 1 Extension V2.5.0download here
- User Guide Magebees Import Export Products For Magento 1 Extension V2.5.0download here
- Import-export-products-csvdownload here
- Good Extension
-
Good extension, but even better support. The introduced changes satisfy me in 100%. Keep it up.
Usefulness Functions as Described Developer Support - Works well
-
The tool was easy to install and works as per the instructions. It took a little while to get used to the new format for the CSV's as it is different to the native Magento import function but with a bit of help from support we worked it out.
The support team were quick to respond and very helpful.
To be honest it is not a great time saver - uploads took the same time with the native function but we were encountering more bugs and issues so it will save us time in the long run I think.Usefulness Functions as Described Developer Support - Great product, excellent support
-
This product works as described and even as we made some rookie mistakes while importing, their excellent support was very helpful!
Usefulness Functions as Described Developer Support - The best import/export solution for magento!
-
The best import/export solution for magento, also the support is very good and fast!
Usefulness Functions as Described Developer Support - Tool needed on a daily basis
-
Because of some customization done on our website the magento built-in import/export feature stopped working. And we purchased this extension. Very quickly and efficiently the support team helped to resolve the issue we encountered and the tool is smoothly working and helping us to update the site on a daily basis. Thank you!
Usefulness Functions as Described Developer Support - Powerful Mass Importer
-
We are a EE magento shop, and the product doesn't work initially b/c its written off the CE version. After my team did some troubleshooting we found a fix that allows the extension to work on an EE platform. We reported the fix to the vendor (MageBees), and they thanked us for providing the resolution so that they can now market to the EE folks. I was glad to help them out as they had great support, very easy to work with too.Nice job guys, this extension offers a good deal of options, and very easy to work with.
Usefulness Functions as Described Developer Support - Very great Plug in and great support
-
I did bought extension very long time but still great support no any cost. different with others
----------
the extension: very helpful safe time for bulk import easy to use have documentary.
This extenstion you must have. Very recommendUsefulness Functions as Described Developer Support - They saved my life !!
-
Excellent extension with many useful functionalities, I will strongly recommend it !!
Keep up the good work.
Cheers, love from New Zealand !!Usefulness Functions as Described Developer Support - Astonishing Extension
-
Its great plugin to utilize. We feel extremely glad to purchase this extension.We strongly recommend to all the magento stores who need import products feature into their store.
Usefulness Functions as Described Developer Support - Excellent Extension with great support!
-
When we tried to use this extension to import hundreds of configurable products associated with 46 simple products, the process was very slow and sometimes we will encounter the 500 Internal Server Error. We therefore contacted the developer for help. They responded quickly and provided us a file without the re-indexing code. This speeded up the process a lot and made product import went smoothly. Thank you!
Usefulness Functions as Described Developer Support - Great Extension
-
Great extension that does what it says and have saved me from hours and hours of Work. Also the support was awsome, when I needed help they took care of it right away. THANKS GUYS
Usefulness Functions as Described Developer Support - Works perfectly with the best customer service ever
-
Purchased this plugin in order to change all my products to configurable and simple from simple to a new magento (CE 1.9.3) installation. It's easy and works perfectly . The best thing is the team that helped us all the way. I would definitely Recommend this plug in and any other that those guys have. Thank you so much for all your help.
Usefulness Functions as Described Developer Support - I appreciate your support
-
I appreciate your support.
Thanks you very much....Usefulness Functions as Described Developer Support - Great extension, great support
-
I bought this extension to import hundreds of bundled products, which would cost me hundreds of hours with normal Magento functionality. This way I saved a lot of hours. I encountered some problems with the format of my CSV files. I've send them to Magebees, they fixed it instantly.
Problem was the way my software saved CSV files, so no problem with the extension.
I would recommend this extension to everyone!Usefulness Functions as Described Developer Support - Excellent Support
-
Support for a database problem was fast and efficient. The module also works very well.
Usefulness Functions as Described Developer Support - Great extension & support!
-
Every thing worked we as described. Whenever there are small issues, support team log into our back-end and solve in not time. We recommend this extensions and developer strongly.
Usefulness Functions as Described Developer Support - Good extension and works perfectly as described
-
It helps us a lot... and working perfectly
Usefulness Functions as Described Developer Support - Great extension
-
Great extension and support is also very great. always ready to solve customer query.great work.keep it up.
Thanking You,
From
Sandip BaviskarUsefulness Functions as Described Developer Support - works great
-
import export works as a charm, and really makes import /generating products easy.
I used it from the very start, and do not dare to think how i would generate products without !Usefulness Functions as Described Developer Support - Life Saver
-
Certainly saved countless hours with this plugin. Easy to use as well. Imported everything perfectly, including the images which had to be uploaded first (all in one go).
Usefulness Functions as Described Developer Support - Simple plugin and works like a charm, prepare your csv and run!
-
Saved a lot of headaches :-) used for a automated import into counter software
Usefulness Functions as Described Developer Support - Very good extension
-
Excellent support.
Stable operation extensions.
For my client is a big advantage.Usefulness Functions as Described Developer Support - Good People and Product
-
They have best team with Best Support, Product is Awesome
Usefulness Functions as Described Developer Support - Well Documented - Great Support
-
I had a small issue, which came from me not reading the documentation. Their customer support responded to all or my questions happily and didn't make feel any lesser for my inability. It used to be a nightmare uploading products with the built in Magento system. How hard is it to have critical system that actually works? I wish I bit the bullet and purchased this from day one. Now I have no issues uploading and doing quick changes, and I've already saved $$$ in time from this extension. I would recommend. AAA+
Usefulness Functions as Described Developer Support - Great Import/Export Module
-
It works very nice for our client. The support is amazing. The only concern for me is that you can't update the Configurable Products without removing them and adding it again. The rest works perfectly and it's been very useful for us.
Usefulness Functions as Described Developer Support - Such a time saving module
-
Great extension, worked well and smooth. Helpful documentation and support.
Usefulness Functions as Described Developer Support - Great value for money considering the time it saves
-
Easy to install and simple to use with very clear instructions. Whilst I have found I need to split uploads to about 500 entries at a time, this is a great solution to importing to Magento. It would be helpful when there is an error to indicate what the error is instead of just a red bar, it doesn't import symbols e.g. trademark and it would be good if it created new attributes. Overall, very happy.
Usefulness Functions as Described Developer Support - Awesome Extension for Import/Export process
-
This extension makes the Import/Export so much easier. Always I relied on my custom coding to update certain things, but this extension make me very comfort. Thumbs up to it. Recommended.
Usefulness Functions as Described Developer Support - Easy to use extension for import & export product
-
Pleasant item to use for your import and export items on store, simple to utilize and redid in process.It is extremely simple to configure.It is very less tedious for transferring and downloading products csv.
Usefulness Functions as Described Developer Support - Astonishing Extension to Purchase
-
It's great extension to use. we feel exceptionally glad to purchase this extension. We emphatically prescribe to all the magento clients.
Usefulness Functions as Described Developer Support - Great Extension
-
Support deserves the highest rating.
Usefulness Functions as Described Developer Support - Great extension for import & export products
-
There are several extensions for import & export items. I used few extension for configurable products for my store but finally I am lucky to find this extension and it works amazing for configurable products import.
Usefulness Functions as Described Developer Support - Excellent Import Products Plugin
-
Superb tool for Import Export Products Extension with all the features which I am looking for. Quick and accurate support.
Usefulness Functions as Described Developer Support - Excellent tool for import/export products
-
The extensions works very well for importing and exporting products, thank you!
Usefulness Functions as Described Developer Support - Fantastic, exactly what I wanted.
-
Extension works perfectly as is excellent value for money. If you think how long it would take to re-do all your products it would take 10s of hours if not 100s or longer! This extension has saved us re-doing 1000+ products. I can't thank MageBees enough for there fast reply on emails and there support in overall. Very professional and will use them again. I highly recommend anyone to use this extension. Can't fault it at all.
Usefulness Functions as Described Developer Support - Great Extension
-
We bought this Extension a serveral times for different customers. Easy Setup and great Performance. Five Star Rating :)
Usefulness Functions as Described Developer Support - Excellent Support
-
Plugin works like a charm plus excellent support. Made work quite easy.
Usefulness Functions as Described Developer Support - Very useful and great support
-
This does exactly what it says, its easy to use and if you have any issues their support is great.
Usefulness Functions as Described Developer Support - Great module
-
Great module and great support! They customized there module so it would work on my installation. Thank you!
Usefulness Functions as Described Developer Support - Good extension and even better support.
-
Good extension and thank you support team for your help in installation.
Usefulness Functions as Described Developer Support
Now Support in Enterprise Edition and Bug Fixed.
2017-09-05 13:23:25- Now Support in Enterprise Edition.
- Fixed Sample Downloadable Option import/export as well as its title issue in Downloadable Products.
- Fixed File move issue in Downloadable Products.
- Fixed issue while delete the products.
- Fixed indexing issue and give indexing enable/disable option in configurations.
- Fixed issue while whitespace are given in Grouped's product child product.
- Fixed custom option issue in file type option.
- Fixed Configurable Product update issue.
- Give more filters in export like Product Type, Product Status, Product Visibility and Products By Range.
- Rearrange attributes list alphabetical order in export page.
- More user friendly layout and design.
Added Category filter in export and Bug Fixed.
2017-03-04 12:11:18- Now you can export the products from specific category or categories as well.
- Fixed URL Rewrite Indexing Issue.
- Fixed Group Price Round Issue.
- Fixed Inventory Fields import/update issue.
- Some other Miner changes.
Bug Fixed.
2016-06-22 12:50:25- Fixed update price and other fileds related issue.
- Fixed URL rewrite indexing issue while import.
- Fixed downloadable image module issues with image name have underscore and dot.
- Now, Products images without slash into CSV file will also import.
Fixed Bundle Product update Issue.
2016-02-22 11:16:16- Fixed Bundle Product update Issue.
- Our extension works with Magento CE 1.9.2.3 and 1.9.2.4 version.
Added New features and also fixed bugs.
2015-02-12 10:10:34- Gallery Labels Import/Export multi store view wise.
- Export Up Sells, Cross Sells and Related products separately.
- Export products attribute set wise.
- Manage categories separator dynamically from configuration.
- Add New Module for download images from Live URL and generate images csv.
- Removed old product images from folder while import new one or delete the products using our extension.
- Import/Export Up Sells, Cross Sells and Related Products positions.
- Fixed some bugs.
Our extension works with SUPEE-6788 Security Patches
2015-11-03 13:16:33- Support Magento CE 1.9.2.2
- Our extension works with SUPEE-6788 Security Patches.
Added New features and also fixed bugs.
2015-02-12 10:10:34- Gave Products CSV validation feature so it check each products of CSV file and show the errors with level like major or minor error.
- Show complete report with products sku and error description for not importing products. You can also export products error report CSV file.
- Added store-wise custom options title update features.
- Now export products CSV file with specific columns/fields. It also show list of exported products CSV file.
- Fixed required options fields value bug of configurable products.
Our extension support multiple type of products like simple, configurable, bundle, grouped, virtual and downloadable products
2014-09-04 06:19:01- Now you can import these types of products :- Simple, Configurable, Bundle, Grouped, Virtual and Downloadable Products.
- Import Related, Cross Sell and Up sell Products.
- Import Group Price for products.
- Import Tier Price for products.
- Support Multi Website, Multi Store and Multi Store View for Import Products.
- Give options All Fields Export, Export Only Image Related Fields, Export Only Price Related Fields and Export Only Quantity Related Fields in export.
Import Export Products
2014-06-05 14:56:06- Separate Menu.
- Export Products feature.
- All type of Sample CSV files.
- Detail documentation for installation and using extensions with snapshots.
- Fixed bugs
This extension can import product with custom option, category and multiple images
2012-02-06 09:05:45This extension can import product with custom option, category and multiple images
2010-08-30 15:40:22-
Q-1 :I am getting “Unable to open file!” error?
Ans : This error comes because of your magento setup not having “import” and “export” folder in var directory. This both folder recommended for run extension. So please create it.
-
Q-2 :I am not able to see your extension in admin menu bar.
Ans : Please clear cache once and re-login to your admin once. If you still not getting extension menu bar in admin panel then please Disable compilation/recompile.
-
Q-3 :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. OR Please use Google Doc for Convert Your CSV in UTF-8 format.
-
Q-4 :What I do when products import going correctly with no single errors but they don't show on font-end 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-5 :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.Note: You can also define category ids if you already created categories. But for that you need to change header from categories to category_ids.
-
Q-6 :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-7 :Import Screen Showing” Fatal error: Call to a member function getAttributeCode() 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-8 :How many validation log and import log , can I see ?
Ans : You can just see last validation and import log. If want to keep validation/import log , then you can export it from validation or import tab in CSV format.
-
Q-9 :I am getting max execution time error, what I have to do?
Ans : If you getting time out error then you have to increase your server max execution time. For that you have to consult you hosting support team.
-
Q-10 :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-11 :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-12 :I am getting below error while try to import the products.
Ans : This error occur becasuse of your csv file is not properly created or converted in UTF-8 Format. So you have to convert your csv file in UTF-8 format for resolve this error. For Convert your file in UTF-8 please follow below steps.
Using Google Sheets:
- Go to https://www.google.co.in/sheets/about/ login using your gmail account. Click on Blank.
- Go to File -> Open and upload your file.
- After upload your file File -> Download as -> Comma-seperated values (.csv, current sheet)
- Your file will be start downloading.
Note: Don't forget to remove space from file name.
-
Q-13 :Image not importing when path propely define in CSV image fields.
Ans : For import or update images properly you have to define four image related columns in your csv file. "image" , "small_image" , "thumbnail" and "gallery". No matter there is value in gallery column or not but you have to define it.
-
Q-14 :I am getting below error while try to import the products.
Ans : This error occur when you deleted default Magento store and our extension not able to find out your store code. When you get this error then please contact our support team regarding this issue.
