RO CSVI

Export VirtueMart data and import to HikaShop

This tutorial explains on how to export VirtueMart data using CSVI and import it to HikaShop.

Step by step procedure to export products, user, order and order item is explained below. Example templates are attached with each process.

Users migration from VirtueMart to HikaShop

1. Add template for VirtueMart user export

The following are the steps followed to create user export template

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart User export
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Userinfo
  7. Click Next: Select Destination
  8. Destination is set default to Download.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Add the fields to be exported
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
2. Add template fields for VirtueMart user export

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Fields added for example VirtueMart user export and equivalent HikaShop customer import fields are

No. VirtueMart Fields HikaShop Fields
1 address_1 address_street
2 address_2 address_street2
3 city address_city
4 company address_company
5 country_name country_name
6 email user_email
7 first_name address_firstname
8 last_name address_lastname
9 password password
10 phone_1 address_telephone
11 phone_2 address_telephone2
12 usergroup_name usergroup_name
13 username username
14 zip address_post_code

Click to get example user export template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

 

3. Run the VirtueMart user export
  1. Go to Components -> RO CSVI -> Export
  2. Select VirtueMart User export
  3. Click on Export
  4. Save the file

4. Run the HikaShop user import

A template can be created by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example Hikashop user import
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Customer
  7. Click Next: Select Source
  8. Source is set default to Load from your computer. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Nothing needed here as we set to Use column headers as configuration in step 10.
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Set Use file for configuration to No as CSVI should use the template fields to import the user data and not to use the column headers of import file.

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.
  5. Save the template field

Make sure that you add the HikaShop template fields in the same order of fields as in VirtueMart export file. This way the data is matched to equivalent HikaShop field from the export file. One other way to do this would be add HikaShop fields in VirtueMart export so the export file would have HiksShop field name as column headers in VirtueMart export file.

Click to get example HikaShop user import template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Products migration from VirtueMart to HikaShop

1. Create VirtueMart product export template

To create a product export template follow the below steps

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart product export template
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Product
  7. Click Next: Select Destination
  8. Destination is set default to Download.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Add the fields to be exported
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
2. Add template fields for VirtueMart product export

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

The example fields added for VirtueMart product export and equivalent fields for HikaShop product import are

No. VirtueMart Fields HikaShop Fields
1 product_desc product_description
2 product_name product_name
3 product_sku product_code
4 category_path category_path
5 manufacturer_name brand
6 product_price product_price
7 product_currency currency_code

Click to get example product export template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Note that the example template uses English(en-GB) as the primary language. Different language can be set in template setting and on Options tab.

 

3. Run the VirtueMart product export
  1. Go to Components -> RO CSVI -> Export
  2. Select VirtueMart product export
  3. Click on Export
  4. Save the file

Run VirtueMart product export

4. Run the HikaShop product import

A template can be created by following these steps:

  1. Go to Components -> RO CSVI  -> Templates
  2. Click New
  3. Give the template a name, say for example Hikashop Product import
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Product
  7. Click Next: Select Source
  8. Source is set default to Load from your computer. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Nothing needed here as we set to Use column headers as configuration in step 10.
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.
  5. Save the template field

Make sure that you add the HikaShop template fields in the same order of fields as in VirtueMart export file. This way the data is matched to equivalent HikaShop field from the export file. One other way to do this would be add HikaShop fields in VirtueMart export so the export file would have HiksShop field name as column headers in VirtueMart export file.

Click to get example HikaShop product import template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Orders migration from VirtueMart to HikaShop

1. Create a export template for VirtueMart order export

Follow the below steps to create VirtueMart order export template

  1. Go to Components -> RO CSVI  -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart order export
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Order
  7. Click Next: Select Destination
  8. Destination is set default to Download.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Add the fields to be exported
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
2. Add template fields for VirtueMart order export template

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

The example fields for VirtueMart order export and equivalent HikaShop order import are

No. VirtueMart Fields HikaShop Fields
1 email user_email
2 order_currency order_currency_id
3 order_number order_number
4 order_status_name order_status
5 order_total order_full_price
6 virtuemart_order_id order_id

Click to get example order export template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Note that the example template uses English(en-GB) as the primary language. Different language can be set in template setting and on Options tab.

VirtueMart order export

3. Run the VirtueMart order export
  1. Go to Components -> RO CSVI -> Export
  2. Select VirtueMart order export
  3. Click on Export
  4. Save the file

Run VirtueMart order export

4. Run the HikaShop order import

A template can be created by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example Hikashop order import
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Order
  7. Click Next: Select Source
  8. Source is set default to Load from your computer. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Nothing needed here as we set to Use column headers as configuration in step 10.
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
  16. On Options tab set Keep Order ID to Yes so this way the order_id created in HikaShop is same as virtuemart_order_id.

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields. The fields here should be added in the same order as they are in the VirtueMart export.
  5. Save the template field

 Click to get example HikaShop order import template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Run HikaShop order import

Order items migration from VirtueMart to HikaShop

1.Add template for VirtueMart order items export

Follow the below steps to Create a template for VirtueMart order items import template

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example VirtueMart orderitems export
  4. Set Action to Export
  5. Set Component to VirtueMart
  6. Set Operation to Orderitems
  7. Click Next: Select Destination
  8. Destination is set default to Download.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Add the fields to be exported
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.
2.Add template fields for VirtueMart order items template

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.

Quick Add

The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

The fields added as example for VirtueMart order items export and HikaShop order product import are

No. VirtueMart Fields HikaShop Fields
1 order_item_name order_product_name
2 order_item_sku order_product_code
3 product_item_price order_product_price
4 product_quantity order_product_quantity
5 virtuemart_order_id order_id

Click to get Example order items export template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Virtuemart order items export

3. Run the VirtueMart order items export
  1. Go to Components -> RO CSVI -> Export
  2. Select VirtueMart order items export
  3. Click on Export
  4. Save the file

Run VirtueMart order items export

4. Run the HikaShop Order product import

A template can be created by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click New
  3. Give the template a name, say for example Hikashop Order product import
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Order product
  7. Click Next: Select Source
  8. Source is set default to Load from your computer. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Nothing needed here as we set to Use column headers as configuration in step 10.
  13. Click Next: Finalize
  14. All done here
  15. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Template fields can be added by following these steps:

  1. Go to Components -> RO CSVI -> Templates
  2. Click on Template fields
  3. In the Search Tools select your template
  4. Click on New to add a single field or click on Quick Add to add multiple fields.
  5. Add the equivalent fields by selecting HikaShop field in Field names. The fields here should be added in the same order as they are in the VirtueMart export.
  6. Save the template field

Make sure that you add the HikaShop template fields in the same order of fields as in VirtueMart export file. This way the data is matched to equivalent HikaShop field from the export file. One other way to do this would be add HikaShop fields in VirtueMart export so the export file would have HiksShop field name as column headers in VirtueMart export file.

Click to get Example HikaShop Order Product import template.

To know how to use the example template check RESTORE TEMPLATE section in Restore templates documentation.

Run HikaShop order product import

More articles on this subject