HikaShop

HikaShop Variants Export

| HikaShop

Requirements

HikaShop
Export Product

Creating the export template

A template can be created by following these steps:

  1. Go to Components -> CSVI Pro -> Templates
  2. Click New
  3. Give the template a name
  4. Set Action to Export
  5. Set Component to HikaShop
  6. Set Operation to Product
  7. Click Next: Select Source
  8. Destination is set default to Download. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Fields must be added otherwise there is nothing for CSVI to export. Click Edit template fields.
  13. A new window opens with the Template fields page. You can add new fields by clicking New or Quick Add.
  14. When all fields are added you can close the window
  15. Click Next: Finalize
  16. All done here
  17. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

HikaShop variants export create template

Add the fields to export

Template fields can be added by following these steps:

  1. Go to Components -> CSVI Pro -> 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. HikaShop variants export create template fields

Run the export

The export can be run by following these steps:

  1. Go to Components -> CSVI Pro -> Export
  2. Select the template created earlier
  3. Click Export
  4. The export is run
  5. The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

HikaShop variants run export

Read more ...

Export VirtueMart data and import to HikaShop

| 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

Read more ...

HikaShop Characteristic Import

| HikaShop

Creating the template

A template can be created by following these steps:

  1. Go to Components -> CSVI Pro -> Templates
  2. Click New
  3. Give the template a name
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Characteristic
  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.

HikaShop characteristic import template

Adding the template fields

Template fields can be added by following these steps:

  1. Go to Components -> CSVI Pro -> 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.

HikaShop characteristic import template fields

Required fields

  • characteristic_alias

Criteria

These fields make up the criteria to determine if the record is going to be updated or added. If all the criteria fields match an existing record, the record will be updated. If not all the criteria fields match, the record will be added.

 

  • characteristic_alias

Run the import

The import can be run by following these steps:

  1. Go to Components -> CSVI Pro -> Import
  2. Select the template created earlier
  3. Click Select file
  4. Select the file to import
  5. Click Preview
  6. You now see a preview of the file as to how CSVI sees the file
  7. Click Start import
  8. The import is run
  9. The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template

HikaShop characteristic import process

Example file

import_hikashop_characteristic.csv

Read more ...

HikaShop Shipping Rates Export

| HikaShop

Creating the export template

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
  4. Set Action to Export
  5. Set Component to HikaShop
  6. Set Operation to Shipping
  7. Click Next: Select Source
  8. Destination is set default to Download. No need for change.
  9. Click Next: Select options
  10. The default values are OK, change if needed.
  11. Click Next: Select fields
  12. Fields must be added otherwise there is nothing for RO CSVI to export. Click Edit template fields.
  13. A new window opens with the Template fields page. You can add new fields by clicking New or Quick Add.
  14. When all fields are added you can close the window
  15. Click Next: Finalize
  16. All done here
  17. Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

HikaShop shipping export create template

Add the fields to export

Template fields can be added by following these steps:

  1. Go to Components -> CSVI Pro -> 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. HikaShop shipping export create template fields

Run the export

The export can be run by following these steps:

  1. Go to Components -> RO CSVI -> Export
  2. Select the template created earlier
  3. Click Export
  4. The export is run
  5. The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

Read more ...

HikaShop Category Import

| HikaShop

Creating the template

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
  4. Set Action to Import
  5. Set Component to HikaShop
  6. Set Operation to Custom field
  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.

HikaShop category import template

Adding the template fields

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.

HikaShop category import template fields

Required fields

  • category_path
  • category_type

Criteria

These fields make up the criteria to determine if the record is going to be updated or added. If all the criteria fields match an existing record, the record will be updated. If not all the criteria fields match, the record will be added.

 

  • category_path
  • category_type

HikaShop uses one database table to store order status, tax, manufacturer and product categories as categories. In order to differentiate between the values you are storing in import as category, it is important to specify what is the category_type field you are importing. For example to import product categories set category_type as product in import file. 

 

Run the import

The import can be run by following these steps:

  1. Go to Components -> RO CSVI -> Import
  2. Select the template created earlier
  3. Click Select file
  4. Select the file to import
  5. Click Preview
  6. You now see a preview of the file as to how CSVI sees the file
  7. Click Start import
  8. The import is run
  9. The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template

HikaShop category import process

Example file

import_hikashop_category.csv

Read more ...