FG OpenCart to WooCommerce

1. 

   Parameters screen

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.

Hide FAQ

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