Mass import of express stores to Koho

You can import quick deals to Koho using an Excel spreadsheet if you don't need to make precise specifications for the products.

Content of the instructions:

Contents of the Excel file

The Excel table that you are importing should have the following columns:

Customer: name or customer number
Product Name
Number of pieces

Example table:

Customer	Product Name	Pcs
Company Ltd	Product A	10
123456	Product B	5

Start a mass import

In the Koho system, go to: Invoices → +Sale
Open the Excel (Mass) tab
Select an Excel file Select a file...button
Press Upload

Import preview and edit

Koho opens a preview where you can review and, if necessary, edit the information.
From the Salesperson menu, you can assign a common salesperson to all lines.

Import invoice description (optional)

To add invoice legends:

Select the Labels tab at the top of the page
Koho looks for the number of pieces in the calculation legend in the adjacent column
Invoice legends appear on each row after uploading

Smart Search (optional)

You can use the Smart Search option for customer search. This option searches for the customer's name so that at least part of the name typed in Excel matches the name stored in Koho.

Note: If you have a lot of similar customer names in your system, we don't recommend using this feature.

Data storage

Select the rows you want to import from the column on the left
- You can select all at once using the Select button
Press Save

After saving, the quick deals can be found in the Quick Deals tab, where they can be processed and invoiced.

Mikäli sinulla herää kysymyksiä, voit olla yhteydessä Kohon asiakaspalveluun sähköpostitse osoitteessa: asiakaspalvelu@kohosales.com, voit myös halutessasi jättää arvostelun artikkelille alapuolelta.