This section explains the user interface of the Export tab in ExcelPort:
Extensions > Modules > ExcelPort, tab Export
The following options allow you to configure your export:
What data do you wish to export?
Here is where you set the type of export. The supported export types are:
|Export type||Corresponds to|
|Products||Admin > Catalog > Products|
|Categories||Admin > Catalog > Categories|
|Options||Admin > Catalog > Options|
|Attributes and Attribute Groups||Admin > Catalog > Attributes|
|Manufacturers||Admin > Catalog > Manufacturers|
|Customers||Admin > Sales > Customers > Customers|
|Customer Groups||Admin > Sales > Customers > Cusomer Groups|
|Orders||Admin > Sales > Orders|
|Coupons||Admin > Sales > Coupons|
|Gift Vouchers||Admin > Sales > Gift Vouchers|
Note You will notice there is also a filter button: which toggles export filtering. More information here
Which store do you wish to export?
Visible for the following export types: Products, Categories, Customers, Manufacturers
Use this to select the source store of your export.
Which language do you wish to export?
Visible for the following export types: Products, Categories, Options, Attributes and Attribute Groups, Customer Groups, Manufacturers (only in OpenCart 3.x)
Use this to select the source language of your export.
Important ExcelPort is designed to export/import only a single language. You can export all your other languages in a separate export.
How do you want your exported products to be structured?
Visible for the following export types: Products
ExcelPort supports the following pre-defined XLSX file structures for product export/import:
Multi-sheet export, suitable for bulk editing purposes. Useful if you want to modify additional product data in bulk - Options, Discounts, Specials, Images.
Exported in a single sheet. Each product is represented in grouped rows. Useful if you want to have all your product details in a single sheet.
Single-line export of products, excluding Attributes, Recurring Payment Profiles, Options, Discounts, Specials, Images, Reward Points and Designs. Use this if you want to modify basic product data - name, description, price, quantity, model, SKU, UPC, categories, stores, etc.
Feel free to test these export types in the ExcelPort demo page.