Title: FG OpenCart to WooCommerce Author: Kerfred Published: July 27, 2021 Last modified: February 9, 2026 --- Search plugins ![](https://ps.w.org/fg-opencart-to-woocommerce/assets/banner-772x250.png?rev=2572785) ![](https://ps.w.org/fg-opencart-to-woocommerce/assets/icon-256x256.png?rev=2572785) # FG OpenCart to WooCommerce By [Kerfred](https://profiles.wordpress.org/kerfred/) [Download](https://downloads.wordpress.org/plugin/fg-opencart-to-woocommerce.1.48.0.zip) * [Details](https://wordpress.org/plugins/fg-opencart-to-woocommerce/#description) * [Reviews](https://wordpress.org/plugins/fg-opencart-to-woocommerce/#reviews) * [Installation](https://wordpress.org/plugins/fg-opencart-to-woocommerce/#installation) * [Development](https://wordpress.org/plugins/fg-opencart-to-woocommerce/#developers) [Support](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/) ## Description This plugin migrates products, categories, images and information pages from OpenCart to WooCommerce/WordPress. It has been tested with **OpenCart versions 1 to 4** and the latest version of WordPress. It is compatible with multisite installations. Major features include: * migrates OpenCart products * migrates OpenCart product images * migrates OpenCart product categories * migrates OpenCart product tags * migrates OpenCart information pages No need to subscribe to an external web site. #### Premium version The **Premium version** includes these extra features: * migrates OpenCart attributes * migrates OpenCart filters * migrates OpenCart options * migrates OpenCart downloads * migrates OpenCart users * migrates OpenCart customers * migrates OpenCart orders * migrates OpenCart reviews * migrates OpenCart tax classes * migrates OpenCart related products * migrates OpenCart coupons * SEO: Redirect the OpenCart URLs to the new WordPress URLs * SEO: Import meta data (meta title, description, keywords) to WordPress SEO * the users and customers can authenticate to WordPress using their OpenCart passwords * ability to update existing products * ability to do a partial import * ability to run the import automatically from the cron (for dropshipping for example) * ability to run the import by WP CLI The Premium version can be purchased on: [https://www.fredericgilles.net/fg-opencart-to-woocommerce/](https://www.fredericgilles.net/fg-opencart-to-woocommerce/) #### Add-ons The Premium version allows the use of add-ons that enhance functionality: * Brands: imports the manufacturers * Attachments: imports the downloads * Internationalization: imports the translations to WPML or Polylang * Custom order numbers * Custom order statuses * Product Options * Product Bundles ### Translations * English (default) * French (fr_FR) * other can be translated ## Screenshots [⌊Parameters screen⌉⌊Parameters screen⌉[ Parameters screen ## Installation #### Requirements WooCommerce must be installed and activated before running the migration. #### Installation 1. Install the plugin in the Admin => Plugins menu => Add New => Upload => Select the zip file => Install Now 2. Activate the plugin in the Admin => Plugins menu 3. Run the importer in Tools > Import > OpenCart 4. Configure the plugin settings. You can find the OpenCart database parameters in the OpenCart file config.php 5. Test the database connection 6. Click on the import button ## FAQ ### I get the message: “[fgoc2wc] Couldn’t connect to the OpenCart database. Please check your parameters. And be sure the WordPress server can access the OpenCart database. SQLSTATE[28000] [1045] Access denied for user ‘xxx’@’localhost’ (using password: YES)” * First verify your login and password to your OpenCart database. * If OpenCart and WordPress are not installed on the same host, you can do this: * export the OpenCart database to a SQL file (with phpMyAdmin for example) * import this SQL file on the same database as WordPress * run the migration by using WordPress database credentials (host, user, password, database) instead of the OpenCart ones in the plugin settings. ### The import is not complete * You can run the migration again and it will continue where it left off. * You can add: `define('WP_MEMORY_LIMIT', '2G');` in your wp-config.php file to increase the memory allowed by WordPress * You can also increase the memory limit in php.ini if you have write access to this file (ie: memory_limit = 2G). ### The images aren’t being imported * Please check the URL field. It must contain the URL of the OpenCart home page ### Are the product attributes and options imported? * This is a Premium feature available on: https://www.fredericgilles.net/fg-opencart- to-woocommerce/ Don’t hesitate to let a comment on the [forum](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce) or to report bugs if you found some. ## Reviews ![](https://secure.gravatar.com/avatar/fed9632184bb93efb341507d8ed210f4d7256dcbed0e8ea9921032983b34ce87? s=60&d=retro&r=g) ### 󠀁[perfect . . .](https://wordpress.org/support/topic/perfect-10469/)󠁿 [sahandwp](https://profiles.wordpress.org/sahandwp/) August 5, 2024 plugin and supporting was very good. thanks a lot. ![](https://secure.gravatar.com/avatar/da98bf9f5f5db9641f188d6ee23b88e75de2fe65933aa376776648cbdcad1dcd? s=60&d=retro&r=g) ### 󠀁[Amazing support](https://wordpress.org/support/topic/amazing-support-895/)󠁿 [Yisrael Buchwald](https://profiles.wordpress.org/israelb1/) July 9, 2024 You can trust them! We purchased the premium add-on, they helped us in an exceptional way – highly recommend! ![](https://secure.gravatar.com/avatar/febc4cb42698972aa5c83d8a1e28b4cc57e42ecc765e367774245cc108ab8ac2? s=60&d=retro&r=g) ### 󠀁[Product Images Were Not Imported](https://wordpress.org/support/topic/product-images-were-not-imported/)󠁿 [ashishkanojiya](https://profiles.wordpress.org/ashishkanojiya/) May 29, 2024 1 reply Pathetic, whats the use of this plugin when images are not able to import? ![](https://secure.gravatar.com/avatar/5247aab389e125894f6f4a8c2309e9a00042c3fe5faa32faf96a179fad3839e8? s=60&d=retro&r=g) ### 󠀁[Useful & Expensive 🙂](https://wordpress.org/support/topic/useful-expensive/)󠁿 [mayvas](https://profiles.wordpress.org/mayvas/) March 25, 2024 A bit expensive, but the tool works smoothly and imports everything correctly. Good job! ![](https://secure.gravatar.com/avatar/f7ca7c6c550af4eabc3b791a9116b593a62ccbc3081e4df48a6fd6c17a68f045? s=60&d=retro&r=g) ### 󠀁[Helpful, easy to use, works great. Thank you!](https://wordpress.org/support/topic/helpful-easy-to-use-works-great-thank-you/)󠁿 [mstudioeu](https://profiles.wordpress.org/mstudioeu/) March 2, 2024 A very helpful and easy to use plug-in, worked straight out of the box. Helped me migrate a couple hundred of products from an old OpenCart website to a newly created WordPress one in a matter of a few clicks. A huge thank you to the author! ![](https://secure.gravatar.com/avatar/0635e0aff0a784ff1ffe092975e96e0372bcc8196c5775934c27458a5e7469c2? s=60&d=retro&r=g) ### 󠀁[very useful plugin, great support](https://wordpress.org/support/topic/very-useful-plugin-great-support-13/)󠁿 [gordanzg](https://profiles.wordpress.org/gordanzg/) November 28, 2023 We used premium edition for migration OpenCart shop to Woocommerce. Everything worked great, plugin is easy to use and technical support is very fast.! Recommended! [ Read all 14 reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/) ## Contributors & Developers “FG OpenCart to WooCommerce” is open source software. The following people have contributed to this plugin. Contributors * [ Kerfred ](https://profiles.wordpress.org/kerfred/) “FG OpenCart to WooCommerce” has been translated into 1 locale. Thank you to [the translators](https://translate.wordpress.org/projects/wp-plugins/fg-opencart-to-woocommerce/contributors) for their contributions. [Translate “FG OpenCart to WooCommerce” into your language.](https://translate.wordpress.org/projects/wp-plugins/fg-opencart-to-woocommerce) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/fg-opencart-to-woocommerce/), check out the [SVN repository](https://plugins.svn.wordpress.org/fg-opencart-to-woocommerce/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/fg-opencart-to-woocommerce/) by [RSS](https://plugins.trac.wordpress.org/log/fg-opencart-to-woocommerce/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 1.48.0 * New: Import the discount price * Fixed: [ERROR] Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ u.language_id’ in ‘where clause’ #### 1.47.2 * Fixed: [ERROR] Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ u.language_id’ in ‘where clause’ #### 1.47.1 * Tested with WordPress 6.9 #### 1.45.6 * Fixed: Error: Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘bundle’ in ‘where clause’ #### 1.45.2 * Fixed: Category slug imported in wrong language #### 1.44.3 * Tested with WordPress 6.8 #### 1.44.0 * New: Add the hook “fgoc2wc_product_types” #### 1.43.0 * New: Compatible with customized version of OpenCart 2.3 * Tested with WordPress 6.7.1 #### 1.42.1 * Tested with WordPress 6.7 #### 1.42.0 * New: Import the EAN field into the WooCommerce field GTIN, UPC, EAN or ISBN * Fixed: [ERROR] Error:SQLSTATE[HY000]: General error: 1525 Incorrect DATE value:‘ 0000-00-00 00:00:00’ #### 1.40.0 * New: Add the function wp_table_exists() * Tested with WordPress 6.6.1 #### 1.38.0 * Tested with WordPress 6.6 #### 1.37.3 * Fixed: Sale prices not imported if the default customer group ID is different from 0 or 1 * Fixed: Images whose filename starts with “image” were not imported * Fixed: Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated * Tested with WordPress 6.5.4 #### 1.37.2 * Fixed: Files whose filename is longer than 255 characters were not imported * Fixed: Images were not imported by File System method * Tested with WordPress 6.5.2 #### 1.37.1 * Fixed: Translations missing * Tweak: Replace rand() by wp_rand() * Tested with WordPress 6.5 #### 1.37.0 * New: Run the plugin during the hook “plugins_loaded” #### 1.36.1 * Fixed: Call to undefined function wp_rand() #### 1.36.0 * Fixed: Unsafe SQL calls * Tweak: Replace file_get_contents() by wp_remote_get() * Tweak: Replace file_get_contents() + json_decode() by wp_json_file_decode() * Tweak: Replace json_encode() by wp_json_encode() * Tweak: Replace rand() by wp_rand() * Tweak: Remove the deprecated argument of get_terms() and wp_count_terms() #### 1.35.0 * New: Compatible with OpenCart 4 * Fixed: Rename the log file with a random name to avoid a Sensitive Data Exposure #### 1.34.1 * Fixed: Mix of the slugs between the attachment pages, the product categories and the products #### 1.34.0 * Change: Set backorder = “notify” instead of “yes” #### 1.30.0 * New: Check if we need the Attachments add-on #### 1.29.0 * New: Import the EAN field to “EAN for WooCommerce” * Tested with WordPress 6.4.3 #### 1.28.0 * New: Don’t import the images in duplicate * Fixed: Plugin log can be deleted with a CSRF * Fixed: Found 2 elements with non-unique id #fgoc2wc_nonce * Tested with WordPress 6.4.2 #### 1.27.3 * Tested with WordPress 6.4.1 #### 1.27.1 * Tested with WordPress 6.4 #### 1.27.0 * New: Compatibility with WooCommerce HPOS #### 1.26.0 * Tested with WordPress 6.3.2 #### 1.25.3 * Fixed: Warning: preg_match(): Compilation failed: quantifier does not follow a repeatable item * Tested with WordPress 6.3.1 #### 1.25.2 * Tested with WordPress 6.3 #### 1.25.0 * New: Import the short description managed by the OpenCart plugin Product Short Description Pro * Fixed: FTP connection failed with password containing special characters * Tested with WordPress 6.2.2 #### 1.24.0 * Tweak: Clear WooCommerce Analytics cache #### 1.22.4 * Fixed: Product and category URLs were wrong in the translated languages #### 1.22.2 * Fixed: Constant FILTER_SANITIZE_STRING is deprecated on PHP 8 #### 1.22.1 * Fixed: [ERROR] Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ o.invoice_id’ in ‘field list’ * Tested with WordPress 6.2 #### 1.22.0 * New: Compatibility with PHP 8.2 #### 1.20.0 * New: Import the OpenCart 1.5 tags #### 1.19.0 * New: Compatibility with OpenCart 1.4 * Fixed: The option “Import the media with duplicate names” didn’t work anymore( regression from 1.10.0). So wrong images were imported. #### 1.18.1 * Fixed: Files containing “+” were not imported * Fixed: Files starting with /image were not imported * Fixed: Files starting with ./image were not imported #### 1.17.0 * New: Import the OpenCart 1.5 URLs #### 1.16.0 * New: Compatibility with OpenCart 1.5 #### 1.13.0 * New: Import the products SEO URLs * New: Import the product categories SEO URLs * Tested with WordPress 6.1.1 #### 1.12.0 * New add-on: Brands #### 1.11.0 * Fixed: Missing parent category for some categories * Change: Don’t add the product name at the end of the image filename #### 1.10.0 * New: Add the functions “get_wp_post_ids_from_meta” and “get_wp_term_ids_from_meta” * Tweak: Shorten the filenames if the option “Import the media with duplicate names” is selected * Tested with WordPress 6.1.0 #### 1.9.0 * New add-on: Custom order numbers #### 1.8.0 * New add-on: Internationalization * Fixed: [ERROR] Error:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘option’ at line 1 * Tested with WordPress 6.0.2 #### 1.7.0 * Tested with WordPress 6.0.1 #### 1.6.0 * New: Add the WordPress path in the Debug Info * Fixed: The widget “Filter Products by Attribute” was empty on the front-end * Tested with WordPress 6.0 #### 1.3.1 * Fixed: Products imported with wrong special price when there is a tax rate #### 1.3.0 * New: Don’t delete the theme’s customizations (WP 5.9) when removing all WordPress content * Tested with WordPress 5.9 #### 1.2.1 * Fixed: [ERROR] Error:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘order o’ #### 1.0.2 * Tested with OpenCart 2 * Tested with WordPress 5.8.1 #### 1.0.1 * Fixed: Progress bar exceeds 100% when running the import again * Fixed: Decode HTML entities in the product title * Update README.txt * Translations #### 1.0.0 * Initial version: Import OpenCart products, categories, images and CMS ## Meta * Version **1.48.0** * Last updated **6 months ago** * Active installations **300+** * WordPress version ** 4.5 or higher ** * Tested up to **6.9.5** * PHP version ** 5.6 or higher ** * Languages * [English (US)](https://wordpress.org/plugins/fg-opencart-to-woocommerce/) and [French (France)](https://fr.wordpress.org/plugins/fg-opencart-to-woocommerce/). * [Translate into your language](https://translate.wordpress.org/projects/wp-plugins/fg-opencart-to-woocommerce) * Tags * [converter](https://wordpress.org/plugins/tags/converter/)[importer](https://wordpress.org/plugins/tags/importer/) [migrator](https://wordpress.org/plugins/tags/migrator/)[opencart](https://wordpress.org/plugins/tags/opencart/) [woocommerce](https://wordpress.org/plugins/tags/woocommerce/) * [Advanced View](https://wordpress.org/plugins/fg-opencart-to-woocommerce/advanced/) ## Ratings 5 out of 5 stars. * [ 14 5-star reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/reviews/) ## Contributors * [ Kerfred ](https://profiles.wordpress.org/kerfred/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/fg-opencart-to-woocommerce/) ## Donate Would you like to support the advancement of this plugin? [ Donate to this plugin ](https://www.paypal.com/cgi-bin/webscr?cmd=_donations&business=fred%2egilles%40free%2efr&lc=FR&item_name=fg-opencart-to-woocommerce¤cy_code=EUR&bn=PP%2dDonationsBF%3abtn_donateCC_LG%2egif%3aNonHosted)