How to bulk import and export data by using Opencart bulk export-import extension?

Purpletree Product Bulk Export and Import is a very powerful extension to export product data and import product data for Opencart. It allows admin to export and import product data. Opencart bulk product upload extension allows admin to export all data at the same time in an excel sheet. Admin can change product data to update the product. Exported excel sheets can change data and import data by this extension. In this extension, Admin does not need to have any type of technical knowledge of programming. Admin just need to have knowledge of applications operate. The owner faces a lot of difficult problems in the e-commerce business. The owner faces a lot of hard problems to update product data. It solves many problems by this extension.

You will save time by applying Opencart import-export to bulk import and export data. Admin can export all data of product like as general, data, link, attribute, recurring, discount, special, image, reward point, SEO, design, and options tab, etc. if admin application support multiple languages then you will have to select a language to export data. Exported data can save like product data backup. If admin wants to bulk update product then admin needs to have exported data for a bulk product update. After that admin can bulk import products.

If admin wants to Opencart bulk import products like mass then you will select a language and upload data. if admin wants to update data then you will check “Overwrite existing Data”. After that, you can import product data by excel sheet. If admin wants to only add bulk product data then you should not check the “Overwrite existing Data” checkbox.


  • Admin can add mass products at the same time.
  • Admin can update mass products at the same time.
  • Admin can export bulk products at the same time.
  • Admin can use .xls or .xlsx files, to update bulk product data.
  • Admin can view changes in updated products in the frontend instantly.
  • Admin can update the product data in multiple languages.
  • Admin can bulk add products of multiple languages.
  • Admin can bulk update products of multiple languages.

Go to: Purpletree Product Export & Import-> Product Export & import.

After this process, you will get the following page.

1 bulk upload

Admin should download the excel sheet. For download excel sheet, you will have to click on to “Download Template”. After that, you will download the excel sheet to add bulk product data.

Product Export:

If admin wants to export product data then he/she will have to select the language as one wants and after that, one should have to click on the export button. Admin will get all product data of a particular language. Now admin can use data for update product and product data backup.

Product import-

Add product Data-

If admin wants to add product data like bulk then you should download the template and use this structure of column. After downloading the excel sheet you should add a detail of the product and you should be remembered that the product id should not be blank of the used tab. Two tabs “General “and “Data” are required for import data. Admin should have to fill the “Yes” to add_product column in the “Data” tab. Admin can change the position of the column also.

2 bulk upload

Update product Data-

If admin wants to update product then he/she will have to export product data after that it will update the product. We should use only exported data sheet for update product because we need to product id and other ids like product_dicount_id, product_special_id, product_image_id. Admin should have to do a blank add_product column in the “Data” tab and product id must require for every tab. Admin should have to check the “Overwrite existing Data” checkbox. For update products.

More details of Purpletree Product Bulk Export and Import Extension can be found here.