Does this OpenCart extension support both Excel and CSV formats?
Yes, the extension supports both CSV and XLSX formats. CSV works without any additional requirements, while XLSX support requires ZipArchive enabled on the server. The import logic remains the same regardless of file format, so store owners can choose whichever format they prefer for managing product data in OpenCart.
Can I update product price and quantity in bulk using Excel?
Yes, the extension allows bulk updating of product price, quantity, model, stock-related fields, categories, manufacturer, and images using the Basic Data import template. This helps OpenCart store owners quickly update large amounts of product data without editing each product manually.
Can I update product name and description using Excel?
Yes, product name and description can be updated using the Product Content import type. Since product name and description are language-based fields in OpenCart, the extension allows selecting the language before importing, ensuring accurate updates for multilingual stores.
Does this extension support multilingual OpenCart stores?
Yes, the extension supports multilingual OpenCart stores. Language-based import types such as Product Content, Product SEO, and Product Attributes allow updating product data for a specific language. This ensures that translated product information is managed safely without affecting other languages.
Can I update SEO fields such as meta title and SEO keyword in bulk?
Yes, the Product SEO import type allows updating meta title, meta description, meta keywords, tags, and SEO keywords using Excel or CSV files. This helps OpenCart store owners improve search engine visibility efficiently across large product catalogs.
Can I create new products using Excel?
Yes, the New Product Import feature allows creating new products using a simplified Excel template. The extension uses configurable default values for operational settings such as stock status, shipping, tax class, and product status, making product creation faster and more consistent.
Can I manage product options and attributes in bulk?
Yes, the extension supports bulk management of product options and attributes using structured row-based templates. Missing options or attributes can be created automatically during import, allowing store owners to maintain consistent product information across the catalog.
Can I manage discounts and special prices for different customer groups?
Yes, the extension supports both quantity-based discounts and advanced special prices. Quantity discounts can be configured using the Product Discounts import type, while customer group specific pricing with start and end dates can be managed using the Product Special Prices import type.
Will this extension affect existing product data?
The extension updates only the fields included in the selected import type. Each workflow is separated to reduce the risk of unintended data changes. Validation preview is available before import, allowing store owners to review changes and ensure accuracy before applying updates to OpenCart products.
Is it safe to use for large product catalogs?
Yes, the extension includes validation checks, batch processing, and configurable row limits to improve stability when working with larger catalogs. For best performance, it is recommended to process Excel files in batches of 500 to 3000 rows depending on hosting server capacity.
Can I assign products to multiple stores or filters using Excel?
Yes, the extension includes dedicated import types for Product Stores and Product Filters. Store IDs and filter IDs can be managed using simple comma-separated values, making it easier to assign products to multiple stores or filters in bulk.
Does the extension provide import logs?
Yes, each import creates a job log containing summary information and row-level messages. This helps identify successful updates, warnings, or errors, making it easier to troubleshoot issues when managing OpenCart product data.
Do I need technical knowledge to use this extension?
No advanced technical knowledge is required. The extension provides structured templates, validation preview, and guided workflow steps. Users familiar with Excel or CSV can easily manage OpenCart product data using the provided templates.
Should I take backup before using import?
Yes, it is always recommended to take a database backup before performing bulk imports. This is a general best practice for any OpenCart store when making large product updates.
How does the extension handle large Excel files for OpenCart imports?
The extension processes import files in configurable batches to improve stability and reduce memory usage. A maximum row limit setting is available to prevent excessively large files from causing server timeouts. For best performance, it is recommended to split large datasets into smaller Excel or CSV files, typically between 500 to 3000 rows per import depending on hosting configuration.
Does the extension support updating third-party fields added to the OpenCart product table?
Yes, if a third-party extension adds new columns directly to the OpenCart product table, those fields can be included in the Basic Data import configuration. The extension dynamically detects available product table columns, allowing additional fields to be included in import templates when required.
How are relational product data such as options, attributes, filters, and stores handled during import?
Relational data structures are handled using row-based import formats designed specifically for OpenCart database relationships. For affected products, the extension uses a controlled replace-and-rebuild approach to ensure data consistency while avoiding duplicate records. This helps maintain integrity of product_option, product_attribute, product_filter, product_discount, and related tables.
How does the extension handle SEO keyword conflicts in OpenCart?
When importing SEO keywords, the extension checks existing seo_url records to avoid conflicts. If a duplicate keyword is detected, the row is skipped with a warning message in the job log. This prevents accidental overwriting of existing SEO URLs and ensures compatibility with OpenCart’s native SEO system.
Can the extension maintain existing product_option_value_id values during option updates?
Yes, the Product Options import structure includes the product_option_value_id column, allowing existing option values to be updated without recreating records. This helps maintain compatibility with third-party extensions or custom logic that depend on stable option value IDs.
