CSV import and export

Instructions for using the CSV import/export feature in Finqu.

Written By Finqu Tuki

Updated at May 10th, 2022

In this article, you can learn how to import and export information using CSV files. CSV is a useful tool if you are, for example, migrating your online store to Finqu, or you have a supplier's CSV file that you need to add to your inventory.

Before you begin to import information, we recommend carefully reading the advice in this article's first chapters. They contain some important information about Finqu's CSV feature. 

In the last chapter, you can find out how the export/import works in practice. 

What information can be imported or exported

  • Products (products, product groups, product bundles, gift card products)

  • Customers (registered customers, newsletter subscribers, customer prices).

  • Orders (only export) (orders, returns) 

ID numbers in a CSV file

A CSV file has various ID numbers. For example, product CSV includes product_id, manufacturer_id, tax_id, etc.

ID:s are unique. For example, product_id is unique in each product. However, manufacturer_id can be the same if products have the same manufacturer. 

ID:s are especially significant when you update information that already exists in Finqu. The ID should always match the ID number in Finqu. Notice: If you have imported new information to Finqu with a CSV file, the ID numbers in Finqu are not the same as they were in your original CSV file. 

If you update the information, you can first export the information using the Export feature. After that, you can make the necessary changes and then import data using the same file you've exported. Note: Do not change the ID numbers in the CSV file.

Empty fields when updating information

If you are updating information with a CSV file, it is critical to understand that empty fields remove the information in the system. For example, if you have a product CSV that includes empty name fields, the import feature will remove the name from the product. If there's information that you don't want to update, you can remove the column from your CSV file. 

If the field is empty, the import will remove the information:

If you don't want to update information, remove the field from the CSV file:

Start with small files

If you haven't imported information to Finqu earlier, it's good to try it first with small CSV files. You can create a simple test CSV file with only a couple of products. When you have imported the information, you can check that everything is imported correctly. It is much safer to continue with bigger files when you are sure that your CSV files have the appropriate structure. 

The separators in CSV:s columns and numbers

  • CSV:s columns are separated with a comma.

  • The decimals in numbers (e.g., prices or weights) are separated with a dot.

Below you can see a straightforward example of a CSV file (opened in a text editor).

123,Example product 1,8.06,0.5,kg
456,Example product 2,16.13,0.6,kg 

In practice, CSV:s are very rarely edited in a text editor. The example above is just for demonstration purposes to see the technical structure of a CSV file. In most cases, the separators are automatically correct if you use popular services/software, such as Google Sheets, to edit your CSV files. But if you have issues with CSV:s, they might be related to incorrect separators. 

The columns' headings in a CSV file

When you import information with a CSV file, the headings must be correct. You can find out what they are by exporting a CSV file from Finqu. For example, if you need a product CSV, you can go to Products > Products > Export. It will create a CSV file for you that you can download by going to Account at the top left corner and then choosing the CSV transfer section from the left menu. 

Notice that you should add some information to the system before exporting it. For example, you can create a test product if you need to export and see what the product CSV should look like. 

Importing images 

You can import product images and other images by using the URL address of the image on the Internet. The CSV import will then download the image from the URL address and save a copy of it to the Finqu server. You cannot import images in a ZIP file. They should always be available on the Internet. 

If you migrate your online store to Finqu, you can ask your current provider for the images' addresses. They can usually help with that and provide you with the exact URL addresses of your images. 

Importing/exporting in practice

You can import and export information by using the links at the top of the page. For example, in section Products > Products, you can see these links for import and export:

The Export begins immediately after clicking the Export link on the page. After the export is finished, you can find the CSV file by going to Account at the top left corner and choosing the CSV transfer section from the left menu.

When you click the Import button, you will be taken right away to the CSV transfer section, where you can start to import information by clicking the Start new import button on the top right corner. Next, the system will take you to a page where you can upload the CSV files and import them. If you have large CSV files, they will be automatically divided into smaller ones so that the system can process them more reliably.