FG Magento to WooCommerce

Description

This plugin migrates your Magento products and CMS pages to WooCommerce.

It has been tested with Magento versions 1.3 to 1.9 and WordPress 4.7. It is compatible with multisite installations.

The plugin migrates:

  • the product categories
  • the product categories images
  • the products
  • the product thumbnails
  • the product images galleries
  • the product stocks
  • the CMS

No need to subscribe to an external web site.

FG Magento to WooCommerce Premium version

The Premium version includes these extra features:

  • migrates the product attributes
  • migrates the product variations
  • migrates the grouped products
  • migrates the products Up Sell and Cross Sell
  • migrates the users
  • migrates the customers
  • authenticate the users and the customers in WordPress with their Magento passwords
  • migrates the orders
  • migrates the ratings and reviews
  • migrates the discount coupons
  • migrates the SEO meta data
  • SEO: redirects the Magento URLs
  • multisites/multistores: Option to choose which website/store to import
  • update the already imported products stocks and orders
  • compatible with Magento Enterprise Edition

The Premium version can be purchased on: https://www.fredericgilles.net/fg-magento-to-woocommerce/

Add-ons for FG Magento to WooCommerce Premium

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

  • Multilingual Magento stores converted to WooCommerce + WPML
  • Move Magento order numbers
  • Move Magento customer groups
  • Move Magento manufacturers

Translations

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

Screenshots

  • Parameters screen

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 > Magento
  4. Configure the plugin settings. You can find the Magento database parameters in the Magento file app/etc/local.xml
    Hostname = host
    Port = 3306 (standard MySQL port)
    Database = dbname
    Username = username
    Password = password
    Table prefix = table_prefix

FAQ

Installation Instructions
  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 > Magento
  4. Configure the plugin settings. You can find the Magento database parameters in the Magento file app/etc/local.xml
    Hostname = host
    Port = 3306 (standard MySQL port)
    Database = dbname
    Username = username
    Password = password
    Table prefix = table_prefix
I get the message: “[fg-magento-to-woocommerce] Couldn’t connect to the Magento database. Please check your parameters. And be sure the WordPress server can access the Magento database. SQLSTATE[28000] [1045] Access denied for user ‘xxx’@’localhost’ (using password: YES)”
  • First verify your login and password to your Magento database.
  • If Magento and WordPress are not installed on the same host, you can do this:
  • export the Magento 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 Magento ones in the plugin settings.
The migration stops and I get the message: “Fatal error: Allowed memory size of XXXXXX bytes exhausted” or I get the message: “Internal server error”
  • First, deactivate all the WordPress plugins except the ones used for the migration
  • You can run the migration again. It will continue where it stopped.
  • You can add: define('WP_MEMORY_LIMIT', '1G'); 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 = 1G).
I get a blank screen and the import seems to be stopped
  • Same as above
The media are not imported
  • Check the URL field that you filled in the plugin settings. It must be your Magento home page URL and must start with http://
The media are not imported and I get the error message: “Warning: copy() [function.copy]: URL file-access is disabled in the server configuration”
  • The PHP directive “Allow URL fopen” must be turned on in php.ini to copy the medias. If your remote host doesn’t allow this directive, you will have to do the migration on localhost.
I get the message: “Fatal error: Class ‘PDO’ not found”
  • PDO and PDO_MySQL libraries are needed. You must enable them in php.ini on the WordPress host.
    Or on Ubuntu:
    sudo php5enmod pdo
    sudo service apache2 reload
I get this error: PHP Fatal error: Undefined class constant ‘MYSQL_ATTR_INIT_COMMAND’
  • You have to enable PDO_MySQL in php.ini on the WordPress host. That means uncomment the line extension=pdo_mysql.so in php.ini
Does the migration process modify the Magento site it migrates from?
  • No, it only reads the Magento database.
Do I need to keep the plugin activated after the migration?
  • No, you can deactivate or even uninstall the plugin after the migration.
Is there a log file to show the information from the import?
  • Yes. First you must put these lines in wp-config.php:
    define(‘WP_DEBUG’, true);
    define(‘WP_DEBUG_LOG’, true);
    And the messages will be logged to wp-content/debug.log.

Don’t hesitate to let a comment on the forum or to report bugs if you found some.
https://wordpress.org/support/plugin/fg-magento-to-woocommerce

Reviews

Didn’t expect this to be so easy and stressfree

Imported all important things from Magento to WooCommerce, it was easy to set up, no complicated questions asked, just fill in credentials and some options and go.
Took less time than anticipated and everything is imported nicely.
Saves days of work. Well worth it!

Does the job

This plugin does what it says on the box, however I needed to run it a few times as the first import had a lot of double ups. After contacting support it turns out the import had been running multiple times. I needed to increase memory limits etc and then start again. After 4 days it finished importing and I’m all set.

In fairness, the magento site I was importing was massive, so I was expecting a few hickups.

Thanks!

Worked Perfectly – Recommended!

Worked as it states perfectly, can’t recommend this plugin high enough!!! Simple, does what it says and Pro Version is definitely worth the €100. Magento is dying and migrating to Woocommerce is a great option and this pluging works flawlessly. Great job Frédéric Gilles.

Read all 15 reviews

Contributors & Developers

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

Changelog

2.26.2

  • Tested with WordPress 4.7.5

2.24.1

  • Tweak: Code refactoring

2.24.0

  • Fixed: Duplicated image in the product gallery

2.23.0

  • New: Import the products visibility

2.22.0

  • Tweak: Clear WooCommerce transients when emptying WordPress content
  • Tested with WordPress 4.7.3

2.21.3

  • Fixed: Notice: Undefined index: name

2.20.3

  • Fixed: Term meta data not deleted when we delete the imported data only

2.20.0

  • Tweak: Add a hook after testing the database connection

2.19.0

  • Tested with WordPress 4.7.2

2.18.1

  • Change: Import the Manufacturer’s Suggested Retail Price as the regular price instead of the sale price

2.18.0

  • New: Add an option to import the Special Price or the Manufacturer’s Suggested Retail Price

2.17.0

  • New: Import the length, width and height as shipping attributes
  • Tweak: Code refactoring

2.16.1

  • Tested with WordPress 4.7

2.16.0

  • New: Import the default web site

2.15.1

  • Fixed: Existing images attached to imported products were removed when deleting the imported data

2.15.0

  • Fixed: The child products which are visible individually were not imported

2.14.8

  • Fixed: Wrong progress bar color

2.14.7

  • Fixed: The progress bar didn’t move during the first import
  • Fixed: The log window was empty during the first import

2.14.6

  • Fixed: The “IMPORT COMPLETE” message was still displayed when the import was run again

2.14.5

  • Fixed: Database passwords containing “<” were not accepted
  • Tweak: Code refactoring

2.14.2

  • Fixed: Wrong number of product categories displayed

2.14.1

  • Tweak: If the import is blocked, stop sending AJAX requests

2.14.0

  • New: Authorize the connections to Web sites that use invalid SSL certificates

2.13.0

  • New: Option to delete only the new imported data

2.12.3

  • Fixed: MySQL 5.7 incompatibility: [ERROR] Error:SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column ‘gv.position’ which is not in SELECT list; this is incompatible with DISTINCT

2.12.2

  • Fixed: Some images were duplicated in the product gallery

2.12.1

  • Fixed: Review link broken

2.12.0

  • New: Display the needed add-ons during the database testing and before importing
  • Fixed: Wrong number of comments displayed
  • Tested with WordPress 4.6.1

2.11.0

  • New: Display the number of data found in the Magento database before importing

2.10.0

  • Tweak: Code optimization

2.9.0

  • Tested with WordPress 4.6

2.6.2

  • Fixed: WordPress database error: [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 ‘xxx’ yyy’ LIMIT 1′ at line 4

2.4.0

  • Fixed: CMS pages from all languages were imported
  • Fixed: Notice: Undefined index: name
  • Tweak: Refactor some functions to allow multilingual import by the WPML addon

2.3.0

  • Fixed: PHP Notice: Object of class WP_Error could not be converted to int
  • Fixed: Notice: Undefined index: url_key

2.2.0

  • New: Import the product featured images

2.1.0

  • Fixed: Display an error message when the process hangs
  • Tweak: Increase the speed of counting the terms
  • Tested with WordPress 4.5.3

2.0.0

  • New: Run the import in AJAX
  • New: Add a progress bar
  • New: Add a logger frame to see the logs in real time
  • New: Ability to stop the import
  • New: Compatible with PHP 7
  • New: Compatible with WooCommerce 2.6.0

1.13.4

  • Fixed: The products without stock were not imported

1.13.2

  • Fixed: Products belonging to several bundles were imported as duplicates

1.13.1

  • Fixed: Some descriptions were not imported correctly
  • Tested with WordPress 4.5.2

1.12.1

  • Fixed: Compatibility issues with Magento 1.3
  • Tested with WordPress 4.5.1

1.12.0

  • Tested with WordPress 4.5

1.10.2

  • Fixed: Notice: Undefined index: short_description
  • Fixed: Column ‘post_excerpt’ cannot be null

1.10.1

  • Fixed: Products not imported. Error: “WordPress database error Column ‘post_content’ cannot be null”

1.9.1

  • Tested with WordPress 4.4.2

1.8.4

  • Tested with WordPress 4.4.1

1.8.2

  • Fixed: Fatal error: Call to undefined function add_term_meta()

1.8.1

  • Fixed: Better clean the taxonomies cache

1.8.0

  • Tweak: Optimize the termmeta table

1.7.0

  • Tweak: Use the WordPress 4.4 term metas

1.6.1

  • Tested with WordPress 4.4

1.6.0

  • New: Compatibility with Magento 1.3

1.5.0

  • New: Add a link to the FAQ in the connection error message

1.4.0

  • New: Add an Import link on the plugins list page
  • New: Change the translation domain name to be compliant with the WordPress translation system
  • Tweak: Code refactoring

1.3.1

  • Fixed: Refresh the display of the product categories
  • Fixed: Error: 1054 Unknown column ‘e.store_id’ in ‘where clause’

1.2.1

  • Fixed: Duplicate images
  • Fixed: Avoid a double slash in the media filename
  • Fixed: Import the original category name instead of the translation
  • Fixed: Notice: Undefined index: url_key

1.2.0

  • New: Compatible with Magento 1.4 to 1.9
  • New: Support the table prefix
  • Fixed: Don’t import the child products as single products

1.1.0

  • Tweak: Change the range of get_attribute_values()
  • Tweak: Make the argument $required_attributes optional
  • Premium version released

1.0.1

  • Tested with WordPress 4.3.1

1.0.0

  • Initial version: Import Magento product categories, products, images and CMS