RO CSVI

Export VirtueMart Products to HikaShop Products

RO CSVI has a new feature of exporting data from one extension and importing into another extension, which we have named the bridge templates. Currently only VirtueMart Products to J2Store Products and VirtueMart Products to HikaShop Products is available. This feature is available from RO CSVI 7.15.0 version onwards.  In this document we will explain how to export VirtueMart Products to HikaShop Products.

So let us start on the migration. Since the migration is from VirtueMart to HikaShop, we need to create two templates; one is to export products from VirtueMart using VirtueMart Product export template and other is to import products into HikaShop using HikaShop Product import template.

1.  Before starting with creating templates, update your available fields as explained in Update your available fields document.

2. Create HikaShop Product import template. For this template Action should be import, component should be HikaShop and Operation should be Product.

 

3. Create VirtueMart Product export template. For this template, Action should be export,  component should be VirtueMart and Operation should be Product.

 

4. On your VirtueMart Product export template on Source tab, select the Destination to be HikaShop Product import template, the template you created for import. Save the template.

5. Add any desired fields to the VirtueMart Product export template from RO CSVI Template fields page and thereafter they will be used for import. The required field is product_sku in VirtueMart, RO CSVI will map it to product_code field which is the needed field for HikaShop Product import. RO CSVI will also map core VirtueMart available fields to HikaShop available fields automatically.

You will see the mapped field in Column Header field in template fields when adding the template field. You can edit this field if needed. If there is no Column header added by RO CSVI, you need to add the field name which you would need to map to HikaShop. If Column header is not added and if that available field does not exist in HikaShop, you will see Unsupported fields in Import log details page.

Here we are adding fields product_sku, product_name, category_path, manufacturer_name and file_url. RO CSVI will save the HikaShop fields product_code, product_name, category_path, brand and file_path as column headers when the template field is saved.

6. Remember for Custom fields in VirtueMart RO CSVI will not know which HikaShop fields to map. Make sure you map to right custom fields in HikaShop. That is because custom fields are based on User's site and not something RO CSVI can control.

7. Also note that the String custom fields in VirtueMart which are added as individual columns in the export file can be directly imported into HikaShop, provided the custom fields are already created in HikaShop. But if custom fields are exported using fields custom_title, custom_value and custom_params in VirtueMart, cannot be imported into HikaShop as these fields are not supported in HikaShop. 

8. If in case you are migrating images from VirtueMart to HikaShop use picture_url field so the image is exported with domain name. In HikaShop Product import template set Save images on server to Yes and on Image tab. This setting will export images from VirtueMart as remote image and import them into HikaShop. Do note that file_url field will not work in this feature as the field uses local path of VirtueMart.

9. If all is set, go to RO CSVI Export page, select VirtueMart Product export template, click Continue. You will see RO CSVI will take you to Import Preview page from export. Import preview page will list all the fields added in VirtueMart export template and mapped to HikaShop Product import template. If everything looks right, click on continue and run the import.

Import Preview VirtueMart to Hikashop

You can also install example template for the bridge template. You can do that by going to RO CSVI Maintenance page, select RO CSVI in first Option, Install example templates in second option, in the extension list select HikaShop and click Continue.

Related Articles