J2store Migration Doesn t Continue Past Unknown Column j2store weight id in field List

$79.99

«Virtuemart» is the most famous e-commerce solution for Joomla.

«Woocommerce» is the equivalent solution for WordPress.

With this add-on, you will be able to migrate your Virtuemart data to Woocommerce on WordPress.

Features

The Virtuemart add-on migrates:

• Customers with their logins and passwords
• Customers billing data
• Customers shipping data
• Products
• Products images
• Products SKU
• Products GTIN. Compatible with EAN for WooCommerce and with Product GTIN (EAN, UPC, ISBN) for WooCommerce
• Products stocks (inventory)
• Featured products
• External products
• Downloadable products
• Product categories
• Product categories images
• Custom fields as WooCommerce attributes
• Price variations
• Child variants
• Multi variant fields
• Tax rates
• Ability to import prices including or excluding tax
• Orders with their items, shipping, fees and taxes
• Order numbers. Compatible with WooCommerce Sequential Order Numbers, WooCommerce Sequential Order Numbers Pro, WooCommerce Edit Order Numbers, Basic Order Numbers for WooCommerce
• Custom order statuses
• Menus
• Ratings & Reviews
• Coupons
• Manufacturers (requires the WooCommerce brands plugin)
• Products and categories meta data
• Shopper groups as user roles

It is compatible with the "WooCommerce Wholesale Prices" plugin.

SEO: The Virtuemart URLs are redirected to the new WordPress URLs using 301 redirects.

It has been tested with:

• Virtuemart 1.0 on Joomla 1.0
• Virtuemart 1.1 on Joomla 1.5
• Virtuemart 2.x-3.x on Joomla 2.5
• Virtuemart 3.x on Joomla 3.4+

It works with the latest versions of WordPress and WooCommerce.

View a full description with screenshots

Requirements

The add-on requires the WooCommerce plugin to be installed and activated before the migration.
The add-on requires the main plugin FG Joomla to WordPress Premium.

If you want to import the manufacturers, the WooCommerce Brands plugin is required.

If you want to keep the order numbers, you also need one of these plugins: WooCommerce Sequential Order Numbers, WooCommerce Sequential Order Numbers Pro, WooCommerce Edit Order Numbers or Basic Order Numbers for WooCommerce

Please note that the plugin does not work with some old minor versions of Virtuemart (2.0.0 for instance) because some fields are missing in these minor versions. So please update Virtuemart to the latest minor version of your release (2.0.26 for this example).

Virtuemart Change log

3.21.0

New: Import the images stored in the custom directories
New: Import the "X" and "Y" custom fields as custom attributes
New: Add the hook "fgj2wp_vm_get_categories_sql"

3.20.0

New: Import the GTIN/EAN in the variations
New: Compatible with the plugin "EAN for WooCommerce"
Tweak: Use the WooCommerce native function wc_update_order_item_meta()

3.19.1

Fixed: The orders were not linked to the product variations

3.19.0

New: Add the hook "fgj2wp_vm_pre_import_product_attributes"
New: Add the hook "fgj2wp_vm_attribute_values_by_slug"
Tested with WordPress 6.0

3.18.0

Tweak: Get the custom_params from the custom field
Tested with WordPress 5.9

3.17.1

Fixed: Prices not imported

3.17.0

New: Allow custom Virtuemart plugins
New: Add the hooks "fgj2wp_vm_get_product_custom_fields" and "fgj2wp_vm_get_product_custom_fields_values"

3.16.2

Fixed: [ERROR] Error:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'p.product_gtin' in 'field list'
Fixed: Notice: Undefined index: custom_element
Fixed: Limit the recursion level while importing child products to avoid endless loop

3.16.1

Fixed: Child products with duplicate names were not imported

3.16.0

New: Import the grand child products
Tested with WordPress 5.8

3.15.1

Fixed: Child products with long names were not imported as attributes
Fixed: WooCommerce transients were not deleted when emptying the WordPress content

3.15.0

New: Import the product variations images
Fixed: The sale prices of the variations were not imported
Fixed: Variation prices were 0 when importing including tax

3.14.0

New: Import the product variations managed by the Joomla plugin "VM – Custom – Catproduct"

3.13.3

Fixed: Tax not displayed in the order items
Tested with WordPress 5.7

3.13.2

Fixed: Product categories were not related to their parent category

3.13.1

Fixed: Categories and categories hierarchy not displayed

3.13.0

New: Import the product GTIN. Compatible with the plugin "Product GTIN (EAN, UPC, ISBN) for WooCommerce"
Tested with WordPress 5.6

3.12.0

New: Import the Virtuemart order numbers
Change: Set the "virtual" attribute for the downloadable products

3.11.3

Fixed: Reviews not counting

3.11.2

Fixed: Endless loop while importing the categories
Tested with WordPress 5.5

3.11.1

Fixed: Deprecated function update_woocommerce_term_meta
Performance improvements
Tested with WordPress 5.4.2

3.11.0

New: Add the hook "fgj2wp_vm_get_products_sql"

3.10.1

Fixed: Notice: Trying to access array offset on value of type bool

3.10.0

New: Add the hook "fgj2wp_vm_pre_import_custom_fields"
Tested with WordPress 5.4

3.9.1

Fixed: The default placeholder image was not resetted

3.9.0

Tweak: Import the manufacturers before the posts

3.8.0

New: Modify the SEF product categories internal links
Fixed: Product URLs links with a non latin1 suffix were not modified

3.7.2

Fixed: Product URLs with a non latin1 suffix were not redirected
Tested with WordPress 5.3

3.7.1

Fixed: Child products not imported from Virtuemart 1
Fixed: Empty product attributes were imported

3.7.0

New: Import the order history
Fixed: Simple products imported as external products

3.6.0

New: Ability to stop the import during the categories import
Fixed: Images not imported from some Virtuemart 3 stores

3.5.0

New: Store the min and max variation prices for each product
Fixed: Stock status was changed to "out of stock" when saving a variable product

3.4.0

New: Add information to the Debug Info tab
Fixed: Attributes and variations not imported from Virtuemart 2.0
Fixed: Sale price not imported
Fixed: Allow Unicode characters in the category slugs
Fixed: Wrong number of categories counted
Fixed: Wrong number of products counted

3.3.0

New: Compatible with the new WooCommerce tax classes

3.2.1

Fixed: The products SEO meta data were not imported

3.2.0

New: Update the WooCommerce product meta lookup table
Tested with WordPress 5.2

3.1.0

New: Import the Multivariant custom fields (type C)
Tested with WordPress 5.1

3.0.3

Fixed: Notice: Trying to get property of non-object in woocommerce/includes/wc-attribute-functions.php on line 172

3.0.2

New: Display the number of Virtuemart reviews
Fixed: Missing translations

3.0.1

Fixed: Recount the terms so that all categories can be displayed on the front-end and on the backend

3.0.0

Tweak: Refactor all code
Tweak: Optimize the import speed
Fixed: Notice: Undefined index: date

2.21.0

New: Import the variations SKU, weight, length, width, height
Change: Don't import the child products as standalone products, but only as variations

2.20.0

New: Import the downloadable products
Fixed: Images not imported when stored outside /images/stories

2.19.0

New: Import the "VM dropbox" custom fields
New: Display a message when importing attributes
Fixed: The tax amount was not displayed in the order item rows
Fixed: Products were imported as duplicates if many shopper groups are used

2.18.0

New: Import the child variants as product attributes
Fixed: Variable prices transients were not deleted when deleting WordPress data

2.17.0

New: Redirect the "shop.browse" category pages
New: Modify the non SEF product category links

2.16.0

New: Redirect non SEF product links
New: Import the images embedded in the categories description
New: Allow HTML tags in categories description

2.15.1

Fixed: The state was not assigned for the users and the orders

2.15.0

New: Import the shopper groups as user roles
New: Compatible with the "WooCommerce Wholesale Prices" plugin

2.14.2

Fixed: The prices of the attributes containing spaces were set to 0

2.14.1

Fixed: 404 page displayed when ordering a variable product
Tested with WordPress 4.8

2.14.0

New: Import the Virtuemart 1 product types

2.13.2

Fixed: Warning: Invalid argument supplied for foreach()

2.13.1

Fixed: Prices may be all free when using several shopper groups
Fixed: Simple products may be imported as external/affiliate products

2.13.0

New: Compatibility with Virtuemart 2.0.10

2.12.0

New: Allow the translations of the Virtuemart products (needs the WPML add-on)
Tweak: Code refactoring

2.11.0

New: Redirect the Virtuemart non SEF URLs like ?product_id=xxx or ?category_id=xxx

2.10.2

Tweak: Code refactoring

2.10.1

Fixed: Fatal error: Uncaught Error: Call to a member function query() on null

2.10.0

New: Compatibility with Virtuemart 2.0.20
Fixed: Notice: Undefined index: new_id
Tested with WordPress 4.7

2.9.1

Fixed: Fatal error: Cannot unset string offsets

2.9.0

New: Add an option to keep the Virtuemart products IDs

2.8.1

Fixed: Blank 404 page

2.8.0

New: Import external products
New: Check if WooCommerce is activated before running the import
Tested with WordPress 4.6

2.7.2

Fixed: Allow bad characters like "²" in the attribute names

2.7.1

Fixed: Some orders were not imported. WordPress database error: [Column 'post_excerpt' cannot be null]

2.7.0

New: Import the Virtuemart tax rates as WooCommerce tax classes

2.6.0

New: Compatible with WooCommerce 2.6.0

2.5.0

Fixed: Rewrite the function to delete only the imported data

2.4.0

New: Import the categories meta data (title, description, keywords) to Yoast SEO
Tested with WordPress 4.5

2.3.0

New: Redirect product links like /id-productname

2.2.0

New: Better handle the progress bar
New: Don't log the [COUNT] data in the log window

2.1.0

New: Ability to stop and resume the import
Fixed: Infinite loop while importing the products
Fixed: The total number of data to import was wrong in case of a partial import
Fixed: Set the default shop language to the site language

2.0.0

New: Run the import in AJAX
New: Compatible with PHP 7

1.24.1

Fixed: Notice: Undefined variable: date

1.24.0

New: Allow the translations of products and product categories (need the Joom!Fish 1.5+ module)
Fixed: Categories and manufacturers with null descriptions were not imported
Fixed: Compatibility with FG Joomla to WordPress Premium 2.11.0

1.23.0

Tweak: Use the WordPress 4.4 term metas: performance improved, nomore need to add a category prefix
Tested with WordPress 4.4

1.22.0

New: Support the attributes with Greek characters

1.21.1

Fixed: The default shopper group was sometimes wrong, so all prices were free

1.21.0

New: Compatibility with Virtuemart for Joomla 1.0

1.20.0

New: Import the product images with absolute paths

1.19.0

New: Modifies the internal links containing product URLs

1.18.0

New: Redirects the products URLs according to their slugs
New: Redirects the product categories URLs according to their slugs

1.17.0

New: Add the stock management option
New: Import Virtuemart 1.x prices with tax
New: Import the override price in the variations
New: purge the tax cache
Tested with WordPress 4.3.1

1.16.3

Tweak: Optimize some SQL queries

1.16.2

Fixed: Error:SQLSTATE[42000]: Syntax error or access violation

1.16.1

Fixed: Cache issue with the product categories

1.16.0

New: redirects the products URLs with the pattern /ID/
Tested with WordPress 4.3

1.15.1

Fixed: "product_sku" was imported as a custom value
Tested with WordPress 4.2.4

1.15.0

New: Import the secondary product images from Virtuemart 1.1

1.14.2

Fixed: Product images from Virtuemart 1.1 were not imported (bug from 1.14.1)

1.14.1

New: Import the product images with no mime type
New: Import the product images with relative path

1.14.0

New: Compatible with WooCommerce Brands Addon
Tested with WordPress 4.2.1

1.13.0

New: Restructure the product attributes import functions
Tweak: Optimize the SQL queries

1.12.2

Tweak: Restructure and optimize the images import functions

1.12.1

Fixed: Import only the images in the gallery

1.12.0

New: Import Virtuemart manufacturers – Needs the WooCommerce Brands plugin

1.11.1

Fixed: the joomla_query() function was returning only one row

1.11.0

New: Compatible with Virtuemart 3.0

1.10.2

Fixed: Notice: register_taxonomy was called incorrectly. Taxonomies cannot exceed 32 characters in length
Fixed: Products with quantity discounts were imported multiple times
Tested with WordPress 4.1

1.10.1

Fixed: With some databases, prices were not imported.
Tested with WordPress 4.0.1

1.10.0

Add the German translation (thanks to Tobias C.)

1.9.0

New: Add partial import options
Fixed: Set the products with a null quantity as "Out of stock"
Fixed: The product category medias were imported even when we choosed to skip the medias
Fixed: WordPress database error: [Duplicate entry 'xxx-yyy' for key 'PRIMARY']
Fixed: The reviews were duplicated when relaunching the import
Fixed: The coupons were duplicated when relaunching the import

1.8.0

New: Import the discounted prices

1.7.0

New: Display the number of Virtuemart products and orders when testing the database connection

1.6.1

Fixed: Check the Virtuemart version before importing
Fixed: The data were not imported if the Virtuemart language was not the same as the Joomla language

1.6.0

Fixed: Sometimes the default WooCommerce pages were not recreated.
Fixed: Remove the shop_order_status taxonomy according to WooCommerce 2.2
Tweak: Simplify the posts count function
Compatible with WooCommerce 2.2

1.5.0

New: Add an option to not include the first image into the product gallery
Tested with WordPress 4.0

1.4.1

New: Help screen
Fixed: Notice: Undefined property: stdClass::$publish

1.4.0

New: Import the Virtuemart menus
New: Import the ratings & reviews
New: Import the coupons
New: Manage the custom order statuses

1.3.2

Fixed: Guest email was not imported

1.3.1

New: Import the guest orders

1.3.0

New: Import the meta title, meta description and meta keywords of the products
New: Remove the prefixes from the product categories
New: Import the meta keywords as product tags
New: Compatible with sh404sef
New: Set the «Manage stock» option for a product to false if the stock quantity is 0
New: Ability to import product prices including tax or excluding tax

1.2.2

Fixed: Don't add the "customer" role to administrator users, otherwise they won't have access to the posts anymore

1.2.1

Fixed: The message displaying the number of imported images was incorrect

1.2.0

New: Compatible with Virtuemart 2.x (Joomla 2.5+)
New: Import the Virtuemart products
New: Import the Virtuemart custom fields
New: Import the Virtuemart orders
Fixed: Customers without state were not imported
Tested with WordPress 3.9.2

1.1.0

New: Put the state name instead of the state code in the billing and shipping addresses
New: Put the 2 letter country code in the billing and shipping addresses

1.0.2

Fixed: the user data were not imported if the WordPress prefix was different from the default one (wp_).

1.0.1

Fixed: administrator role was replaced by customer role

1.0.0

Migrates Virtuemart user informations (billing and shipping data)

johnsonappervisrect.blogspot.com

Source: https://www.fredericgilles.net/fg-joomla-to-wordpress/virtuemart/