Frequently Asked Questions
Does ExcelPort import/export images? How?
ExcelPort does not import/export image files.
ExcelPort exports/imports image paths (not image files) relative to the image/ directory of your OpenCart store.
For example, if you have an image file /image/data/product_image_01.jpg, then the value in the XLSX sheet must be data/product_image_01.jpg
Can I migrate my store data to a newer OpenCart version with the help of ExcelPort? How?
Yes. ExcelPort is a perfect tool to migrate data between different versions of OpenCart.
Migration is possible between all versions of OpenCart 18.104.22.168 - 22.214.171.124. Older releases of OpenCart require extensive modifications to ExcelPort. For more information, please contact our sales department: email@example.com
The data available for migration is this:
- Attributes and Attribute Groups
- Customers and Customer Groups
Migrate your data in the order specified here:
- Migrate Categories
- Migrate Options
- Migrate Attributes and Attribute Groups
- Migrate Manufacturers
- Migrate Customers and Customer Groups
- Migrate Coupons
- Migrate Vouchers
- Migrate Products
- Migrate Orders
For more detailed information, please read this blog post:
What file types are supported by ExcelPort?
ExcelPort only works with XLXS files which have a specific predefined format. You can see the valid structures by exporting a file from the module demo page.
Can ExcelPort export/import non-standard OpenCart fields added by a third-party extension?
ExcelPort is out-of-the-box compatible with all fields introduced by the extension OpenStock.
ExcelPort for OpenCart 1.5.x is also out-of-the-box compatible with the extension Options Boost. Options Boost for OpenCart 2.x is not yet supported.
All other fields introduced by third-party extensions are not supported and need to be implemented additionally as a custom service.
For more information, please contact our sales department at firstname.lastname@example.org
Does ExcelPort work with a custom XLSX file format? Can I export/import only specific columns, not all data? For example, can I export/import only the Product columns for Model and Description.
No. ExcelPort works only with very specific pre-defined formats which cannot be altered. You can see the valid structures by exporting a file from the module demo page.
Why are the imported products not visible on the front end?
Most probably, the products are not associated to your store. The column "Stores" in the XLSX file you import must contain comma-separated Store IDs.
Your default OpenCart store always has an ID = 0. Any additional stores (if you have any) will have their unique Store ID. You may find a list of all Store IDs in the Meta sheet of an exported Products spreadsheet.
For example, if you have an extra store with an ID = 3, and you want to assign your product to both your default store and your extra store, insert the following string in the Stores column: 0,3
Why am I getting an error "Fatal error: Class 'ZipArchive' not found in ..."?
It means that your PHP server is missing the php_zip extension, which is a requirement for ExcelPort to work. Please, contact your web hosting to make sure the php_zip extension is installed on your server.
I am getting Error 500 during export/import. What should I do?
In most cases this error suggests that your web server has run out of memory. To resolve this, try to alter the ExcelPort settings in Admin > Extensions > Modules > ExcelPort > tab Settings:
- Number of entries per exported part: set to 100
- Maximum entries to read on each step of the import: set to 50
If you are still receiving Error 500 after doing these changes, consider increasing your web server memory. More information here:
Does ExcelPort automatically create missing Attributes/Options/Categories during Product import?
No. ExcelPort expects all Attributes, Options and Categories to already exist in your store. If you are doing a migration of products, make sure to first migrate Attributes, Options and Categories, and migrate Products last.
My store has more than one language but every ExcelPort sheet works with only a single language. How do I import my data?
This is possible. During every import, you have the option to select the language in which you are importing. This means that you must do a separate product import for every language in your store.
Can I translate the names of the columns and import?
No. Please abstain from translating the XLSX column names in your native language. In most cases this will break the Product import.
I have more than 800 products. Can I import them in a single file?
ExcelPort relies on a third-party library called PHPExcel to manage XLSX documents. Even though PHPExcel is the most feature-rich library for XLSX management to date, it tends to break on sheets containing more than 800 products, regardless of the available server resources (CPU and RAM).
This is why we have added the chunk file import/export, which breaks the import/export and creates another file once it reaches the server resources. In this way we guarantee that all of your products would be safely imported/exported.
What is the difference between Grouped mode, Bulk mode and Basic mode?
The main difference is in the way Attributes, Discounts, Options, etc. are managed.
Grouped mode holds all available product data in a single sheet. A single product is distributed in 26 lines. Grouped export/import mode is useful when you want to do very small changes to product data individually.
Basic mode does not export/import product Attributes, Options, Recurrings, Discounts, Specials, Extra Images, Reward Points and Designs. As in Grouped mode all basic product data is in a single spreadsheet, but every product is on a single line. Basic mode is useful if you want to modify basic data of many products in bulk.
Bulk mode is an extended version of Basic mode. It can export/import all product data, including Attributes, Options, Recurrings, Discounts, Specials, Extra Images, Reward Points and Designs. In Bulk mode, all extra product data is distributed into separate sheets. This option is useful if you want manage all possible product data in bulk.
To see the XLSX fils structure of all modes, feel free to do Product exports in the module demo page.
Will ExcelPort work with my theme?
Definitely yes. ExcelPort is an extension used only in the OpenCart admin panel and it is used to manage your data, therefore it will not have any issues with your store front theme.
My ExcelPort file contains formulas, how can I import the information correctly?
If the XLSX file contains formulas, ExcelPort will not import it properly. The importer cannot recognize formulas and parse them.
To resolve this, you must import a file containing only the final data, without formulas. To do this, select all data, and copy it. Do a special paste preserving only the values.
If you are not sure what this means, please follow this tutorial article.
I receive an error: "htmlspecialchars(): charset 'UTF-8;' not supported, assuming utf-8" How do I fix it?
This is most probably related to your web server settings. Please, contact your web hosting administrator and ask them to configure the value of your PHP setting default_charset to UTF-8.