Product Import / Export XLSX and CSV
Product Import / Export XLSX and CSV
Import and export OpenCart products in XLSX and CSV. Create or update products and process multilingual content, categories, attributes, options and SEO data. Includes field mapping, batch processing, export filters and reusable profiles.
Promo code will be applied automatically when you add the product to cart
Enter domain without www, http, https (e.g. example.com)
Description
Product Import/Export is a comprehensive module for importing, exporting, and bulk updating OpenCart product catalogs in XLSX and CSV formats.
The module supports not only standard product data but also multilingual content, attributes, filters, standard OpenCart options, images, categories, manufacturers, SEO URLs, and metadata.
Separate import wizards are provided for different data types, allowing administrators to map columns, validate reference values, and select appropriate processing modes.
Batch processing, uploaded file history, XLSX templates, and export profiles make it possible to work efficiently with both small spreadsheets and large product catalogs.
⚠️ Important Warning Before Using the Module
Import and export modules are powerful bulk data processing tools that involve significant risks when used incorrectly.
Unlike manually editing individual products through the OpenCart administration panel, importing allows thousands of records to be modified, overwritten, or deleted in a single operation.
Incorrect settings, improper column mapping, invalid file data, or careless use of replacement modes may lead to serious consequences, including:
- Partial or complete loss of product data.
- Overwriting correct information with incorrect values.
- Loss of product descriptions, attributes, filters, options, and other data.
- Broken relationships between products, categories, and other catalog elements.
- Loss of images or broken image references.
- Incorrect operation of third-party extensions and integrations.
- Disruption of individual store functions or the entire online store.
WARNING! Some operations are irreversible. The module does not provide automatic restoration of the original data after an import has been performed.
Before Using the Module, You Must:
- Create a complete backup of your store's database and files. Make sure the backup can be successfully restored.
- Test the module on a staging or development copy of your store, especially before the first use or before performing bulk operations.
- Carefully verify the file structure and column mapping to the corresponding database fields.
- Check the selected import mode, particularly if it involves replacing or deleting existing information.
- Perform a test import using a small number of products and verify that the results match your expectations.
Do not start a bulk import if you do not fully understand the selected settings or their possible consequences.
The validation and safety mechanisms provided by the module cannot completely eliminate the risk of data loss or corruption caused by user errors, store configuration specifics, or conflicts with third-party extensions.
How the Module Works
The import process follows a step-by-step configuration workflow:
- The administrator uploads an XLSX or CSV file.
- For XLSX files, the required worksheet is selected.
- The import mode, product identifier, and additional settings are configured.
- File columns are mapped to the corresponding OpenCart fields.
- Unknown attributes, filters, options, and their values are reviewed.
- Batch processing is started, with progress displayed during execution.
- If necessary, the uploaded file can be reopened from the history, its settings adjusted, and the import started again.
Important: running the same import again may result in repeated processing or overwriting of data, depending on the selected mode and settings.
Main Features
- Import and export data in XLSX and CSV formats.
- Create new products and update existing products.
- Identify products by product_id, model, sku, upc, ean, jan, isbn, or mpn.
- Import standard, multilingual, and SEO-related product fields.
- Separate import wizards for attributes, content, filters, and standard OpenCart options.
- Automatically create or manually map missing reference values.
- Batch import main and additional product images.
- Generate product identifiers, SEO URLs, and metadata using configurable templates.
- Filter products before exporting.
- Save and reuse export profiles.
- Export OpenCart reference data with IDs and multilingual names.
- Download XLSX templates for each import type.
- Store uploaded file history and import settings.
- Process large files in batches using sequential AJAX requests.
- Support additional database fields and ocStore-specific fields.
- Configure the visibility of import and export fields independently.
Product Import
The product import wizard supports three processing modes:
- Create and Update — create new products and update existing ones.
- Create Only — add new products without updating existing records.
- Update Only — modify existing products without creating new ones.
Each file column can be mapped to a corresponding OpenCart field or excluded from the import process.
Supported Product Data
- Product identifiers and codes.
- Model, SKU, UPC, EAN, JAN, ISBN, and MPN.
- Product location.
- Quantity and stock status.
- Manufacturer.
- Price, reward points, and tax class.
- Date available.
- Weight and dimensions.
- Minimum quantity.
- Subtract stock setting.
- Product status.
- Sort order.
- Categories and stores.
- Main and additional images.
- Other standard OpenCart product fields.
Multilingual Data
The following fields can be imported separately for each store language:
- Product name.
- Description.
- Tags.
- Meta Title.
- Meta Description.
- Meta Keywords.
- Meta H1.
- SEO URL.
Product Identification
Products can be identified using product_id, model, sku, upc, ean, jan, isbn, or mpn.
If the selected identifier is missing for a new product, the module can generate it using a configurable pattern.
Example pattern: K-{number:6}
Important: selecting an incorrect identifier or importing invalid identifier values may result in updating products other than those intended.
Categories, Manufacturers, and Stores
- Find manufacturers by ID or name.
- Find categories by ID or full category path.
- Assign multiple categories using a configurable separator within a single cell.
- Replace existing product categories or append new ones.
- Automatically include parent categories.
- Assign default categories and manufacturers with priority over file values.
- Assign products to one or multiple stores.
- Support the main_category field in compatible ocStore versions.
Attribute Import
A separate import wizard is provided for product attributes.
The attribute ID is specified in square brackets within the column header.
Example: RAM[12] EN
Features
- Import attributes for one or multiple languages.
- Arrange language columns sequentially for each attribute.
- Replace, append missing attributes, or update values from the file.
- Automatically match attributes by ID and name.
- Ignore unknown attributes.
- Create new attributes.
- Manually map imported attributes to existing ones.
Warning: using replacement mode may remove existing product attributes that are not included in the import file.
Content Import
A separate wizard allows bulk updating multilingual product content without modifying other catalog data.
The following content can be imported:
- Product names.
- Descriptions.
- Tags.
- Metadata.
HTML markup, apostrophes, quotation marks, and line breaks are preserved as cell content.
Update Modes
- Full Replacement — replace existing content with values from the file.
- Fill Empty Fields Only — update only fields that currently contain no data.
- Update Using Non-Empty Values — use only populated cells from the import file.
Important: in full replacement mode, empty mapped cells may clear the corresponding product fields.
Filter Import
Filters are assigned to products using separate rows. Filter groups and filter values can be specified by ID or name.
Available Modes
- Replace all product filters.
- Synchronize only filter groups included in the file.
- Add new filter relationships without removing existing ones.
Unknown filters can be handled by:
- Ignoring them.
- Creating them automatically.
- Manually mapping them to existing filters.
Standard OpenCart Options Import
The module supports importing standard OpenCart product options and option values.
Supported Parameters
- Option type.
- Required status.
- Quantity.
- Subtract stock setting.
- Price and price prefix.
- Reward points and points prefix.
- Weight and weight prefix.
- Values for text-based and date-based option types.
Import Modes
- Replace all product options.
- Synchronize only options included in the file.
- Add and update options without removing other options.
- Create or manually map missing options and option values.
Limitation: the module uses the standard OpenCart option structure and does not create dependent combinations between multiple options.
Image Import
The module supports batch importing main and additional product images.
The product identifier and image order are determined from filenames according to a configurable separator.
Features
- Find products using model, sku, upc, ean, jan, isbn, or mpn.
- Configure rules for identifying the main product image.
- Ignore, fill an empty field, or replace the main product image.
- Ignore, append to, or completely replace the product image gallery.
- Select a storage directory inside the image folder.
- Clear the cache of replaced images.
- Optionally delete old image files after checking standard OpenCart references.
Filename Examples
SKU001.jpg— main product image.[email protected]— additional image.[email protected]— additional image.
⚠️ WARNING! Physically deleting old image files is irreversible.
Image reference checks use standard OpenCart mechanisms and cannot guarantee detection of every image reference used by third-party extensions or custom integrations.
Before enabling image deletion, it is strongly recommended to create a backup of the image directory.
SEO URLs and Metadata
SEO data can be imported directly from a file or generated automatically during product import.
Available Modes
- Do not generate values.
- Fill empty fields only.
- Overwrite existing values.
Supported Features
- Separate patterns for SEO URL, Meta Title, Meta Description, Meta Keywords, and Meta H1.
- Macros for product, manufacturer, category, price, and store name.
- Automatic URL transliteration.
- Uniqueness checks with automatic suffixes such as -1, -2, and so on.
- Support for shared or separate URLs across different languages.
Important: bulk overwriting SEO URLs may change existing product page addresses. Before performing such operations, consider the potential impact on search engine indexing and existing external links.
Data Export
Export operations are performed in batches and allow separate files to be generated for:
- Products.
- Attributes.
- Content.
- Filters.
- Standard OpenCart options.
Export Features
- XLSX and CSV formats.
- Select standard and multilingual fields.
- Select export languages.
- Export categories as IDs or full category paths.
- Export all attributes from the reference directory or only attributes used by selected products.
- Filter products by category, manufacturer, status, stock quantity, price, creation date, modification date, and store.
- Include reference columns containing product names, manufacturers, and categories when exporting attributes, filters, and options.
- Save, load, and delete export profiles.
Product descriptions are exported with their original HTML markup preserved.
Note: physical image files are not copied during export. Only their file paths are included in the exported spreadsheet.
Reference Data Export
To prepare import files and ensure correct value mapping, the following OpenCart reference data can be exported separately:
- Attribute groups and attributes.
- Categories and manufacturers.
- Options and option values.
- Filter groups and filters.
- Stock statuses and tax classes.
- Weight and length units.
Exporting reference data helps ensure that current IDs and names are used when preparing import spreadsheets.
XLSX Templates
Each import wizard provides a downloadable XLSX template with the current column names.
Templates are generated based on:
- Configured store languages.
- Import field visibility settings.
- Additional database fields.
- Existing attribute IDs.
If an XLSX workbook contains multiple worksheets, the required worksheet can be selected before mapping columns.
Import History
Uploaded product, attribute, content, filter, and option files are stored in protected storage together with their import settings.
The import history allows administrators to:
- Reopen previously uploaded files.
- Select another XLSX worksheet.
- Change the import mode.
- Modify languages and column mappings.
- Run the import again.
- Filter history records by import type.
Important: import history is not a backup or data recovery system.
Saving the original file and import settings does not mean that previously applied changes can be automatically reversed.
Field Visibility and Additional Fields
The module allows unnecessary import and export fields to be hidden independently through its settings.
This helps simplify the interface by displaying only the fields required for a particular workflow.
The current product identifier always remains available.
Additional Database Fields
The module scans additional scalar columns in the following database tables:
productproduct_description
For each detected field, the administrator can:
- Assign a custom display name.
- Enable importing.
- Enable exporting.
The following ocStore-specific fields are supported when the corresponding database columns exist:
noindexmeta_h1main_category
⚠️ WARNING! Importing additional fields used by third-party extensions requires special care.
Incorrect values may disrupt the functionality of extensions that depend on these fields.
Before enabling import for additional fields, verify their purpose, accepted data formats, and possible dependencies on other database tables.
Batch Processing and Performance
The module uses batch processing to handle large amounts of data.
Features
- Import and export operations are performed in batches using sequential AJAX requests.
- Batch size can be configured in the administration panel.
- Processing progress is displayed without reloading the page.
- For XLSX files, only the required row range is read.
- Export does not load the entire product catalog into memory.
- Attribute selection can be limited to attributes actually used by the selected products.
Important: batch processing does not mean that all changes are executed within a single database transaction.
If an import is interrupted, previously processed batches remain applied.
Closing the page, canceling the operation, or losing the connection does not automatically restore the original data.
Data Validation and Protection
The module includes mechanisms for validating input data and restricting potentially unsafe operations.
Implemented Checks
- Validation of required columns and parameters before processing starts.
- Validation of numeric values, statuses, dates, and prefixes.
- Prevention of unsafe row processing when an identifier is missing or not unique.
- Error messages indicating the row number and reason for failure.
- Protection against unsafe file paths during image import.
- Separate access and modify permissions for each section using standard OpenCart permission mechanisms.
Note: these checks help detect technical errors but cannot guarantee the correctness of imported content or the safety of every configuration selected by the administrator.
Administration Panel
The module adds a separate Product Import/Export section to the left navigation menu of the OpenCart administration panel.
The section includes:
- Product Import.
- Attribute Import.
- Content Import.
- Filter Import.
- Option Import.
- Image Import.
- Export.
- Reference Data Export.
- Import History.
- Settings and Built-in Documentation.
Open Source Code and Independence
The module's source code is not encrypted or obfuscated.
PHP, Twig, JavaScript, and XML files are available for inspection and modification.
The module uses a locally installed PhpSpreadsheet library for spreadsheet processing.
System Requirements
- OpenCart: 3.0.3.x
- PHP: 8.1–8.5
- PhpSpreadsheet: 5.8.1 included with the module.
Required PHP Extensions
ctype, dom, fileinfo, filter, gd, iconv, libxml, mbstring, SimpleXML, xml, xmlreader, xmlwriter, zip, zlib.
Write permissions are also required for the upload, import history, and image directories.
Installation
- Install the PhpSpreadsheet library archive through Extensions / Installer.
- Install the main Product Import/Export archive through Extensions / Installer.
- Go to Extensions / Modifications and refresh the modification cache.
- In the administrator user group settings, grant access and modify permissions for the required product_import routes.
- Open Product Import/Export → Settings.
- Verify the system requirements and save the configuration.
Service database tables are automatically checked and created when the settings page is opened.
Separate installation through Extensions / Modules is not required.
⚠️ Important Notes and Limitations
Please read the following limitations carefully before using the module.
1. Data Backups
The module is not a data backup solution.
Before importing data, especially when performing bulk updates, replacements, or deletions, you must create an up-to-date backup of your store's database and relevant files.
Without a backup, recovering lost or corrupted data may be impossible.
2. Irreversible Operations
The module does not support automatic rollback of previously processed import batches.
Closing the page, stopping, or canceling an operation does not undo changes made by earlier batches.
3. Field Clearing and Replacement
In replacement modes, an empty mapped cell may clear the corresponding product field.
Always check cell values and selected update modes before starting an import.
4. Concurrent Operations
Do not run two operations of the same type simultaneously within the same administration session.
Doing so may cause processing conflicts and incorrect results.
5. XLSX Limitations
The XLSX format has a limit of 32,767 characters per cell.
For importing or exporting long HTML descriptions, CSV is recommended.
6. Image Deletion
Physically deleting old image files is irreversible.
Before using this feature, create a backup of the corresponding files.
7. Additional Third-Party Fields
Importing additional fields should only be enabled after verifying their purpose and the accepted data format.
The module cannot guarantee that third-party extensions will continue functioning correctly after their data has been modified.
8. Testing Before Bulk Import
Before processing a large file, it is recommended to perform a test import using a small number of products.
Verify not only the imported field values but also relationships with categories, attributes, filters, options, images, and the functionality of related store features.
⚠️ User Responsibility and Liability
The Product Import/Export module is intended for users who understand how OpenCart works, the structure of imported data, and the potential consequences of bulk operations.
Importing, updating, replacing, and deleting data are performed according to the settings selected by the administrator.
The user is responsible for:
- Creating and maintaining backups.
- Preparing import files correctly.
- Ensuring accurate column and field mapping.
- Selecting appropriate import and update modes.
- Verifying the results of completed operations.
- Ensuring compatibility of imported data with third-party extensions and custom store modifications.
The developer cannot guarantee the recovery of data lost or corrupted as a result of incorrect settings, invalid input files, user errors, conflicts with third-party extensions, or other factors beyond the module's control.
Using the module without proper backups and testing may result in irreversible data loss or disruption of your online store.
If you do not have sufficient experience with bulk data processing, it is recommended to seek assistance from a qualified specialist.
License
The license is valid for one domain and its subdomains.
Specifications
- OpenCart Version
- 3.0.0 3.0.1 3.0.2 3.0.3 3.0.4 3.0.5
- Module Localization
- Ukrainian, English, Russian
- Support Language
- Ukrainian, English, Russian
- Activation Method
- Automatic activation
- Ioncube Loader
- No (not required)
- Developer Server Connection
- No
- If Developer Server Unavailable
- Extension works
- PHP Version
- 8.1 8.2 8.3 8.4 8.5
- Compatible with Templates
- Not needed
Reviews (0)
Please log in to leave a review.
Log inNo reviews yet
Be the first to review this product!
Questions (0)
Please log in to ask a question.
Log inNo questions yet
Be the first to ask a question about this product!