Export

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: filter 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:

Bulk export

Multi-sheet export, suitable for bulk editing purposes. Useful if you want to modify additional product data in bulk - Options, Discounts, Specials, Images.

Grouped export

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.

Basic export

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.