Advanced Opencart Import Export Tool Opencart Plugin Documentation

Author : ISHI THEMES

Created : 02 February 2020

Thank you! We are glad that you have choosen us.

Social Login is our enhanced and beautifully designed responsive Opencart theme for your Social Login online stores. Social Login is rich with powerful userfriendly features that would attract more clients to your online store and boost sales!

Here are some basics on installing, configuring and customizing the theme that will get you started! This document is written very carefully by keeping mind Beginners, advanced users and developers.

If you are new to Opencart. Please read Opencart GUIDE first and then get along with the theme document.


Getting Support

In case our documentation does not serve your queries.Please feel free to contact our support team via email Here. Please be sure to include your site URL as well as your admin and FTP details when you contact our support team.Thanks so much!


Our support scope

Our Product Import Export covers configurations related to the theme, trouble using any features of the theme and bug fixes with the theme. We don't provide Social Login for customizations or 3rd party extensions.


Support response time

We try our best to serve our clients around the clock, however, this is not always possible due to different time zones. The team will try to reply you as fast as possible.

In case you ask for help in the weekend, you may have to wait a little bit for Product Import Export, please be patient.

Please rate our Plugin and keep encouraging us!


Installation Advanced Product Import Export Plugin

Advanced Product Import Export Tool module will allow Product Import Export in your Opencart Store.

Basic Installation Steps

  1. Installation of Advanced Product Import Export Tool for Opencart is very simple. After extracting the zip file, you will find folders admin, demo_file and system. Now, copy these admin and demo_file and system folders into the root directory of your Opencart installation. Please view the screenshot below for better understanding.

    2. Note : This step is applicable only for the opencart versions 3.x and above 3.x

  2. Once you have copied the folders in the previous step, then login to admin and from the main menu go to Extensions->Extension installer and upload the ZIP file – "advanced_opencart_import_export_tool.ocmod.zip". The ZIP file can be found root folder of the downloaded zip.
  3. Now, go to the Extensions > Modification and click on refresh field.
  4. Next, go to System -> Users -> Usergroup and edit ‘Administrator’ to provide administrator permissions to the extension.
  5. Click on select all for both Access Permission and Modify Permission and save it.
  6. After this step, you will be able to see the Advanced Opencart Import Export Tool Tab in the left sidebar.
    1)Customer Export
    1. Customer IDS: Filter Multiple Customers IDS (Comma Seperated) I.e: 100,101 (Within Range) I.e: 50 - 60. Both I.e: 50-60, 70-80, 100, 101
    2. Customer Group: Group wise export customer.
    3. Status: If status is "enabled", customers who are enabled will be exported else the disabled customers will be exported. Selecting "All" will export both enabled and disabled customers.
    4. Approved: If Yes, customers who have been approved by the admin will be exported else the customers who haven't been approved will be exported. Selecting "All" will export both approved and unapproved customers.
    5. Newsletter: If status is "enabled", customers who have subscribed to the newsletter will be exported else unsubscribed customers will be exported. Selecting "All" will export both subscribed and unsubscribed customers.
    6. Date From: Set the start date interval of customer registration. It is mostly useful when you want to export customers for a specific interval.
    7. Date To: Set the end date interval of customer registration.
    8. Limit Start: Set Range Of Customer Limit. If Minimum Customer Limit Not Given But Maximum Given Than Customer Limit Export From 0 To Maximum Given.if Maximum Customer Limit Not Given But Minimum Given Than Customer Limit Export From Minimum Given To Unlimited. If Not Both Maximum And Minimum Not Given, Customer Limit Will Be Ignored.
    9. Limit End: Set Range Of Customer Limit. If Minimum Customer Limit Not Given But Maximum Given Than Customer Limit Export From 0 To Maximum Given.if Maximum Customer Limit Not Given But Minimum Given Than Customer Limit Export From Minimum Given To Unlimited. If Not Both Maximum And Minimum Not Given, Customer Limit Will Be Ignored.
    10. Store: Select the store from a list of available store from where customers needs to be exported. Selecting "All" will export customers from all the stores.
    11. Sort: Select sort field by which customers must be sorted.
    12. Order: Select order of sort. Available options are Ascending and Descending.
    Choose Customer Data
    1. Customer Addresses: Select Yes if you want to Export Customer Address.
    2. Customer Histories: Select Yes if you want to Export Customer Histories.
    3. Customer Rewards: Select Yes if you want to Export Customer Rewards.
    4. Customer Transactions: Select Yes if you want to Export Customer Transactions.
    5. Custom Fields: Select Yes if you want to Export custom fields provided by opencart.
    Choose Customer Data
    1. Export Format: Select Format In Which You Want To Export Customers.
    2)Customer Import
    1. Import File: Drag And Drop File Or Click Any Where In Drop Area To Upload (XLS, XLSX, CSV) File.
    2. Import Type: Unique Column For Customer Customer ID or Email.
    3. Matching Customer Update: Select Yes If Want To Update Existing Customers. Note: If Select No And Matching Customer Founds Then System Keep Existing Customer.
    4. Password: Select Password Format Which used in xls sheet.
    5. Select Fields You Want To Import:Check Which Fields Do You Want To Import? Unchecked Fields Will Ignored While Importing Data.



    3)Product Export
    1. Store:Select the store from a list of available store from where Products needs to be exported. Selecting "All" will export Products from all the stores.
    2. Language: Select the language in which products must be exported.
    3. Product: Select product you want export from all products
    4. Manufacturer: Configure the manufacturer list.Products which are linked to these manufacturers will be exported.
    5. Category: Configure the category list.Products which are linked to these categories will be exported.
    6. Price:Set range of price. If minimum price not given but maximum given than price export from 0 to maximum given.If maximum price not given but minimum given than price export from minimum given to unlimited. If not both maximum and minimum not given, price will ignored.
    7. Quantity:Set range of quantity. If minimum quantity not given but maximum given than quantity export from 0 to maximum given.If maximum quantity not given but minimum given than quantity export from minimum given to unlimited. If not both maximum and minimum not given, quantity will ignored.
    8. Product Export Limit:Set range of product limit. If minimum product limit not given but maximum given than product limit export from 0 to maximum given.If maximum product limit not given but minimum given than product limit export from minimum given to unlimited. If not both maximum and minimum not given, product limit will ignored.
    9. Date From: Set the start date interval of product create. It is mostly useful when you want to export products for a specific interval.
    10. Date To: Set the end date interval of product create.
    11. Model: Configure the Model number of the product.The products that matches to configured Model number will be exported.
    12. SKU: Configure the SKU of the product.The products that matches to configured SKU will be exported.
    13. Status: If status is "enabled", products whose status is enabled will be exported else the disabled products will be exported. Selecting "All" will export both enabled and disabled products.
    14. Stock Status: Products whose stock status matches which the selected value will be exported.
    15. Filter Name: Products whose filter name matches which the selected value will be exported.
    16. Export Your Document: Select Format In Which You Want To Export Products.
    17. Additional Images: Select yes if you want to export addtional images of the products, otherwise only primary image will be exported.
    18. Reviews: Select yes if you want to export reviews of the products, otherwise reviews will not be exported.



    Choose Fields you want to export
    1. Product ID: Select Yes If Want To Export Product ID
    2. Product Name: Select Yes If Want To Export Product Name
    3. Model Number: Select Yes If Want To Export Model Number
    4. Language Code: Select Yes If Want To Export Language Code
    5. Store: Select Yes If Want To Export Store
    6. Description: Select Yes If Want To Export Description
    7. Meta Title: Select Yes If Want To Export Meta Title
    8. Meta Description: Select Yes If Want To Export Meta Description
    9. Meta Keyword: Select Yes If Want To Export Meta Keyword
    10. Tag: Select Yes If Want To Export Tag
    11. Product Image: Select Yes If Want To Export Product Image
    12. SKU: Select Yes If Want To Export SKU
    13. UPC: Select Yes If Want To Export UPC
    14. EAN: Select Yes If Want To Export EAN
    15. JAN: Select Yes If Want To Export JAN
    16. ISBN: Select Yes If Want To Export ISBN
    17. MPN: Select Yes If Want To Export MPN
    18. Location: Select Yes If Want To Export Location
    19. Price: Select Yes If Want To Export Price
    20. Minimum Quantity: Select Yes If Want To Export Minimum Quantity
    21. Quantity: Select Yes If Want To Export Quantity
    22. Status: Select Yes If Want To Export Status
    23. Sort Order: Select Yes If Want To Export Sort Order
    24. Tax Class ID: Select Yes If Want To Export Tax Class ID
    25. Tax Class: Select Yes If Want To Export Tax Class
    26. Subtract: Select Yes If Want To Export Subtract
    27. Stock Status ID: Select Yes If Want To Export Stock Status ID
    28. Stock Status: Select Yes If Want To Export Stock Status
    29. Shipping Required: Select Yes If Want To Export Shipping Required
    30. Seo Keyword: Select Yes If Want To Export Seo Keyword
    31. Date Added: Select Yes If Want To Export Date Added
    32. Date Available: Select Yes If Want To Export Date Available
    33. Lenght: Select Yes If Want To Export Lenght
    34. Length Class Id: Select Yes If Want To Export Length Class Id
    35. Length Class Name: Select Yes If Want To Export Length Class Name
    36. Weight: Select Yes If Want To Export Weight
    37. Weight Class ID: Select Yes If Want To Export Weight Class ID
    38. Weight Class Name: Select Yes If Want To Export Weight Class Name
    39. Manufacturer Id: Select Yes If Want To Export Manufacturer Id
    40. Category IDS: Select Yes If Want To Export Category IDS
    41. Category Name: Select Yes If Want To Export Category Name
    42. Filter: Select Yes If Want To Export Filter
    43. Download: Select Yes If Want To Export Download
    44. Related Products: Select Yes If Want To Export Related Products
    45. Attribute: Select Yes If Want To Export Attribute
    46. Product Options: Select Yes If Want To Export Product Options
    47. Discount: Select Yes If Want To Export Discount
    48. Special: Select Yes If Want To Export Special
    49. Reward Points: Select Yes If Want To Export Reward Points
    50. Reward: Select Yes If Want To Export Reward
    51. Viewed: Select Yes If Want To Export Viewed
    52. Date Modified: Select Yes If Want To Export Date Modified



    4)Product Import
    1. Import File: Drag And Drop File Or Click Any Where In Drop Area To Upload (XLS, XLSX, CSV) File.
    2. Import Reviews: Select Import Review Yes To Import Reviews Of Products.
    3. Import Additional Images: If Select Yes Then Additional Images import.Note: If Select No Then Additional Images not import.
    4. Import Custom Fields Data: Import Custom Fields Data To 'product, product_description' Tables Only.
    5. Matching Product Update :Select Yes If Want To Update Existing Products. Note: If Select No And Matching Product Found Then System Keep Existing Product.
    6. Unique Column For Product:Unique Column For Product (if choose ID then id have unique on product table)
    7. Choose Language:Select Language In Which Import Data Will Be Imported.
    8. Choose Store:Select Store In Which Import Data Will Be Imported.
    9. Select Fields You Want To Import:Check Which Fields Do You Want To Import? Unchecked Fields Will Ignored While Importing Data.