RO CSVI

HikaShop Custom Fields Import

The HikaShop Custom Fields Import explains how to setup and import Custom Fields for 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 custom field 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 custom field import template fields

Required fields

  • field_namekey
  • field_table

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.

 

  • field_namekey

Creating the import file

The import file needs at a minimum the field field_namekey this is the unique identifier for RO CSVI to identify a custom field. In the list of custom fields in HikaShop this is the column called Column name.

Since this field alone is not enough to create a usable custom field we are going to add some more fields. HikaShop also wants to know for which table the custom field is. So let's add the required fields first.

 

field_namekey field_table

 

A custom field should also have a label so it has a friendly name. The name of this field is field_realname. Let's add that to the file as well.

 

field_namekey field_table field_realname

 

We should also set what type of custom field is being created by adding the field field_type. Let's create a text field.

 

field_namekey field_table field_realname field_type

 

We now have the basics setup for creating a custom field. In addition a lot more fields can be added to customize the settings for each type of field you are creating. Have a look at the list of available fields as to what other fields are available for use. Now let's add a custom field to the import file.

 

field_namekey field_table field_realname field_type
bodycolor product Color of the desktop text

 

The file is now ready for import as we have all the basics in place.

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 RO 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 custom field import process

Example file

hikashop_customfield_import.csv

Related Articles