Categories

Resolved Best approach for migrating custom fields from Virtuemart 3 to Virtuemart 4

  1. kronson
    kronson
  2. RO CSVI
  3. Friday, 12 January 2024
  4.  Subscribe via email
I am looking at the best approach to export Virtuemart 3 custom fields and importing them into a new Virtuemart 4 installation to prepare for a product migration. I am aware that I should have data like categories and manufacturers imported as well, but that is already done.

My thoughts about the export and import are the following:

- Export VM3 custom fields with virtuemart_custom_id to keep the same structure as the old shop (see export attachment).
- Remove custom fields that depend on a old plugin in the CSV.
- Import into VM4

I tried this approach and as you can see in the attached log, the custom fields are updated. However, taking a look in the backend there a no special fields available at all.

What could be the issue. Am I missing something in my CSV? Or should I perform some kind of initialization after import?
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,

- Export VM3 custom fields with virtuemart_custom_id to keep the same structure as the old shop (see export attachment).

The problem is with virtuemart_custom_id. When you have this field Joomla thinks there is already an existing row and runs update query. Remove this field and run the import and check. You should see custom fields created.

Regarding keeping old structure, when you import custom fields using product import RO CSVI will fetch the custom field based on name and not based on ID. In this case new IDs will be selected and linked to the product.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.