1.2.5. How to adapt an import template & How to import data into Kiu BMP



→ Ways to import

Import function can be found in most models in list view/tree view type where the “Import” button is displayed.

There are 2 ways to import data:

a. New Object: Import brand new data into system. 

Important Note:  All required information must be filled.


E.g.: field “Product Category” of a product


b. Overwrite: Make changes to existing items.  

Important Note: Each line item of imported data will be automatically recorded with a unique ID which always appears in the first column of the exported files. By indicating the correct ID of an item in the import file, the system can either recognize and overwrite the data.

E.g.: item “PANDAN CREME BRULEE” owns the ID code: 37646. When exporting this item, the code is “__export__.product_product_37646”.

→ Fields to import

Not all item information can be imported. To figure out which field can be imported, open the “Export Data” window to choose the available fields that can be re-imported and understand how Kiu BMP identifies or records the value of that information.

The result file contains technical fields on the first row as:

  • “id” means the item unique ID provided by Kiu BMP
  • “taxes_id/id” equals to Customer Taxes
  • “pos_category_ids/id” refers to Point of Sale Categories

Each importable field may have a description title that differs from its display name so then the system will take its value based on an item’s ID. In case you wish to change a field, it is vital to review the ID of its recognized value before modifying. 

In the example: the POS Categories of these product is “Dessert”, which owns the ID code: __export__.pos_category_11

→ Language: How to import a Translation

When importing a file into Kiu BMP, the language will be attached to the language set chosen in the language interface.

To enable multiple languages, change the chosen language from the language interface then import another file that match that language.

To guarantee that your translation is correct when switching user interface in different languages, the language used in the import file must be the same as the language shown on the system.

E.g.: When importing a list of new products for the first time, the system will be in “English” interface, which means the words in the import file must be in English, too.

If a Vietnamese (or other language) file hasn’t been imported, products will be shown in the original language from the import file even though the language interface is already swapped into “Tiếng Việt” (Vietnamese).

As a result, these items must be modified to display the correct language by importing its corresponding translation. After switching to Vietnamese interface, import the following files that contain the products’ ID and names in Vietnamese.

After updating the translation by re-import method, the accurate translation will be on display.

You will notice that during the translation process, other fields derived from the default table are already translated (e.g.: Product Type, Unit of Measure, etc.). That said, it is unnecessary to translate these fields.


→ Practice

Step 1: Upload import file

You can use the template provided by Kiu BMP support team or create your own template by following the above instructions.

Here is a list of new items that needs to be created in Kiu BMP.

In the English interface, upload the file.

Step 2: Select fields to import


Select the fields to import and validate the information. Kiu BMP will automatically read the first row of the file and match them with the equivalent fields in the system.

If the information is not valid, Kiu BMP will show an error in a particular row from the import file.

Review the import file and make the necessary modifications. Then reload the adjusted file and validate it again. Follow these steps until the system confirms the validation of the input data as shown below.

Step 3: Import files and check result

Start importing a file

Check the result by reviewing your newly added items. Edit products in the form view to get the product image displayed.


Finally, turn to Language/Translation part to update the translated language of your items if necessary.


Leave a Reply