Import Export Products For Magento 1
| v2.5.1
- Supports Enterprise Edition.
- Import Export all Types of Products and Data.
- Update Images, Group Price and Tier Price for Products.
- Import Export Specific Product Fields.
- Customize CSV File according to your needs.
- Special Validation Feature for validating CSV File before Import.
- Multi-Website, Multi-Store and Multi-Store View Supported.
- Multiple Language Supported.
-
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 Import Export Products Extension
This is one of the most comprehensive Magento Import Export Products extension that you will find on the market. Whether your store has Simple, Configurable, Bundle, Grouped, Virtual and Downloadable products, you will be able to import or export them easily from one website to another. The extension also supports Related, Cross-Sell and Up-sell products.
You can import products for stock updates, price updates, images updates, custom options updates, product description updates, etc. If you want to import/update products for some specific fields, you can customize the CSV file to suit your needs.
Use the extension to migrate products from one e-commerce platform to another or upgrade the Magento version of your store. You can use it to download product images from third party URLs and import them to your store. Update prices with the extension as well.
Essential Features of the Extension in Detail:-
- You can export the products using category filter. You can select more than one category for exporting the products.
- Export specific fields for your products in the CSV file.
- Import/export products with categories ids/categories name. If categories do not exist, then the extension will create new categories automatically and assign products to them.
- Update products with multiple images and custom options.
- Import/export products image labels.
- Import/export Magento's default as well as custom attribute data.
- Get filters for export such as Product Type, Product Status, Product Visibility and Products by Range.
- Rearrange the attributes list in alphabetical order on the export page.
- Get access to the Product Validation Process to ensure accurate data. The Validation Log will show product SKU and error descriptions.
Magento Import Export Products Extension: Installation Steps
- Disable Merge JS-CSS option from System > Developer. (Only if it is enabled)
- Disable all 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.
- Log out from admin and re-login again.
- Re-run the compilation from System > Tools > Compilation. (Only if compilation enabled).
Note: If your product CSV file has special characters or some languages have special characters, use UTF-8 format CSV file for import products.
Steps for Importing Products
1) Upload File
You can upload your created or exported .CSV file from here. The extension allows .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. Even if you did not fix minor errors, it will allow you to import the products but in major errors, you must fix the issue in your csv file.
4) Import Log
After importing 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 details.
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 the extension, so you can read it before using the extension. It will help you to import products as per your requirements without facing any issue.
Steps for Exporting 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 importing 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.1 download here
-
User Guide Magebees Import Export Products For Magento 1 Extension V2.5.1 download here
-
Import-export-products-csv download here
Bug Fixed.
2022-08-04 06:47:00- Fixed the Category wise export issue.
- Fixed Multi Website and Store issue in the latest Magento release.
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:45- This extension can import product with custom option, category and multiple images
This extension can import product with custom option, category and multiple images
2010-08-30 15:40:22- This extension can import product with custom option, category and multiple images
-
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.
