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

Captures d’écran

  • 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.

Avis

12 janvier 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 octobre 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!
Lire les 2 avis

Contributeurs & développeurs

« FG OpenCart to WooCommerce » est un logiciel libre. Les personnes suivantes ont contribué à cette extension.

Contributeurs

“FG OpenCart to WooCommerce” a été traduit dans 1 locale. Remerciez l’équipe de traduction pour ses contributions.

Traduisez « FG OpenCart to WooCommerce » dans votre langue.

Le développement vous intéresse ?

Parcourir le code, consulter le SVN dépôt, ou s’inscrire au journal de développement par RSS.

Journal

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