OpenCart Category Export / Import (Multilanguage)

Features

Multilanguage Category Export and Import

Export and import OpenCart categories for a selected store and language. Only the selected language data is updated, while other language descriptions are preserved.

Multi-Store Support

Select the store for category export or import. Existing store assignments are preserved, and imported categories are linked to the selected target store.

XLS, XLSX and CSV Support

Export and import category data using XLS, XLSX or CSV files without requiring a third-party spreadsheet library.

Easy Category Add and Update

The extension automatically handles existing and new categories.

• Updates an existing category when a valid category ID is found.
• Matches by category name when the category ID does not exist.
• Creates a new category when no matching category is found.

Interactive Column Mapping

Map uploaded file columns to OpenCart category fields easily. Column order is not required, and unwanted columns can be set to Do not import.

Category Hierarchy Management

Parent categories are matched by name during import. When a parent category changes, the category path is automatically rebuilt, including affected child categories.

SEO Keyword Handling

Import and export category SEO keywords. Parent-prefixed keywords such as furniture/sofas are automatically handled so the correct leaf keyword is stored.

Large File and Bulk Import

Import very large category files using server-side AJAX processing. Rows are processed in batches of 500 with a live progress bar.

Live Import Progress

Track the import process with a progress bar showing the number of processed rows and the total number of rows.

Category Filter Support

Import category filters using the Group::Filter format. Filter and group names are resolved to the corresponding OpenCart filter IDs.

Export Category Filters

Category filter information can be included in the exported file using the Group::Filter format.

Flexible Export Options

Choose the store, language, category status, image mode and row range before exporting category data.

• All, Enabled or Disabled categories
• Start row
• Maximum number of rows
• Relative image path or full image URL

17-Column Category Export

The export uses a fixed 17-column structure containing important category information.

• category_id
• language
• stores
• name
• meta_description
• meta_keyword
• description
• parent
• seo_keyword
• image
• top
• column
• sort_order
• status
• meta_title
• filter
• product_total

Sample Import File

Generate a sample import file directly from the extension. The sample contains parent and child category examples and uses the selected language and file format.

Import Result Summary

After import, the extension displays the number of:

• New categories added
• Existing categories updated
• Rows skipped

Safe Multilanguage Updates

Only the language represented by the imported file is updated. Other language category descriptions remain unchanged.

Preserve Store Assignments

Existing store relationships are preserved during category updates. The selected target store is assigned to imported categories.

Automatic Category Path Rebuild

When a category parent is changed, the extension automatically rebuilds the category path. Descendant categories are also updated to keep the category hierarchy synchronized.

Memory-Efficient CSV Import

CSV files are processed row-by-row instead of loading the complete file into memory, helping with large category files.

500-Row Transaction Processing

Large imports are processed in batches of 500 rows. Each batch runs inside a database transaction and is committed atomically.

File Size Validation

XLS and XLSX files are checked against the configured PHP memory limit before import starts. If the file cannot be safely processed, a clear file size error is displayed.

Unknown Column Handling

Extra or unknown columns in an imported file are safely ignored. Invalid headers are reported clearly instead of silently processing an unsuccessful import.

Easy Admin Access

A dedicated Category Export / Import (multilanguage) option is available in the OpenCart admin sidebar.

Export and Import Tabs

Export and Import options are available on one settings page for easy category management.

Enable or Disable Module

Use the master status option to enable or disable category export and import operations.

No Third-Party Spreadsheet Library

The extension supports XLS, XLSX and CSV processing without requiring a third-party spreadsheet library.

No OpenCart Core File Modification

The admin sidebar menu is added using the OpenCart event system. The OpenCart core column_left.php file is not modified.

Purpletree License Management

Manage the Purpletree license directly from the extension. You can enter an existing license key or retrieve the key using your Order ID and Email ID.

License Validation

A valid Purpletree license key is required to enable and use the extension. Export, import and file detection operations are controlled by the stored license status.

PHP 8.4 Compatibility

The extension is designed and tested for PHP 8.4.

OpenCart Compatibility

The extension supports OpenCart 4.x and has been tested on OpenCart 4.1.0.4.