Skip to main content

How to import suppliers in bulk?

Maxime avatar
Written by Maxime
Updated over 2 weeks ago

Banqup lets you import suppliers in bulk thanks to an Excel spreadsheet containing your suppliers' data.

Go to the

Customers & Suppliers menu

Knipsel-menu-customers-and-suppliers.PNG

Click on the Suppliers tab

Knipsel-customers-and-suppliers-suppliers-button.PNG

- Download the example from Excel -

The exact structure of the Excel file is described in the example file, which can be downloaded via the Download example button. Click on Download the Excel import template

Knipsel-customers-and-suppliers-download-excel-import-template.PNG


FYI:

if you have trouble opening the Excel file, you can follow this method:

  • Save the sample file to your PC

  • Open your Excel program

  • From the program, open the file you previously saved.

Upload your suppliers

Upload the filled-in spreadsheet by clicking on Upload your suppliers

Knipsel-customers-and-suppliers-upload-your-suppliers.PNG


Once the Excel file with the suppliers to be added has been prepared, click on the Upload suppliers button. Select the Excel file on your PC.

Processing starts after selection. If there are errors, they are indicated with the detail of an error.

After a successful import, the imported suppliers will be displayed in the supplier list.

Attention:

In some cases there may be a conflict with the automatic numbering of your suppliers; in that case the autonumbering must be turned off.

See Settings > Automation > Autocreate suppliers

Knipsel-settings-automation.PNG

Did this answer your question?