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 2 and 3 and WordPress 6.0. It is compatible with multisite installations.

Major features include:

  • migrates OpenCart products
  • migrates OpenCart product images
  • migrates OpenCart product categories
  • 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 options
  • migrates OpenCart users
  • migrates OpenCart customers
  • migrates OpenCart orders
  • migrates OpenCart reviews
  • migrates OpenCart tax classes
  • migrates OpenCart related products
  • 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/

Add-ons

The Premium version allows the use of add-ons that enhance functionality:

  • Internationalization: imports the translations to WPML or Polylang

Translations

  • English (default)
  • French (fr_FR)
  • other can be translated

Screenshots

  • 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 or to report bugs if you found some.

Reviews

12 студзеня, 2022
Fast import with multiple connection options. A no fuss migration solution. I would definitely consider FG's premium option for more complex migrations. Thank you.
1 кастрычніка, 2021
It was a god experience working with FG OpenCart to WooCommerce by Frédéric GILLES. The support is also good. Thank you for your work!
Read all 2 reviews

Contributors & Developers

“FG OpenCart to WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

“FG OpenCart to WooCommerce” has been translated into 1 locale. Thank you to the translators for their contributions.

Translate “FG OpenCart to WooCommerce” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.

Changelog

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