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