Excel Port import and export OpenCart

ExcelPort is a convenient module for OpenCart that helps you quickly export and upload data via Excel. It's designed for stores that need to bulk update products, categories, customers, and orders without manually navigating through the admin panel. The module adds Export/Import buttons directly to entity lists and a separate section in the maintenance menu, so operations are always at hand.

What is the module for?

This solution is ideal for quickly updating large volumes of information, preparing backup uploads, transferring data between sites, or handing over tables to a manager for editing. Instead of dozens of manual steps, you work in the familiar XLSX format and then import the changes back into the store.

Important: The module supports step-by-step processing and progress monitoring, which reduces the risk of errors when working with large files.

Main functionality

• Export and import data in XLSX format
• Operation in light, full, and bulk product unloading modes
• Bulk processing with record limits for stable operation
• Flexible export filters based on AND and OR conditions
• Support for multilingualism and different versions of OpenCart
• Validating fields in Excel using drop-down lists
• Option to import as new records
• Option to delete old records before importing

What data is processed

• Product, including SEO, attributes, options, discounts, promotions, images, links, bonuses, etc.
• Categories, filters, links to stores and layouts
• Options and option values
• Attributes and attribute groups
• Clients, addresses, history, transactions, bonuses, IP, affiliate
• Customer groups
• Orders, positions, totals, histories, vouchers
• Manufacturers
• Coupons and their history
• Gift vouchers and their history

ExcelPort is especially useful where product range and customer base are rapidly growing, and the speed of updates directly impacts sales.