When you get started with NexoPOS, you might have some file that you want to import on the system. NexoPOS has a build-in which let you import item from a CSV on the system. That’s what you’re going to learn in this tutorial.

Importing CSV file on NexoPOS

In the meantime, NexoPOS support only the CSV format. We might add an additional format, but if you have an XLS file, it must be converted into CSV. There is a tool out there that you can use to convert an XLS file into CSV.

When you have to CSV ready, access to the Inventory > import items from CSV

On that UI, you’ll see a field where you should select your CSV file. You don’t have to follow a schema. After having selected your file, you need to define whether the file is comma-separated or semi-colon separated.

Then the system will parse it and unveil all columns within. The next thing to do is to make a match between the system columns and the columns available on the files.

Some columns are required, and the import can’t run properly if they are missing: name, purchase price, sale price, quantity. Here is an example of an imported file.

As you might notice, there are many columns available. Some columns are unnecessary, and it’s up to you to choose which one you would like the system use.

Using the import options

Before running the importation, you must take a look at the import options :

All products are available for sale by default

Enabling this option will make all imported items available for sale. It might be required to make a supply according to the item type (physical or digital).

All products are natural by default

This option will turn all items into natural (physical) items. Basically that means all items will have stock.

All products have inventory management enabled by default

This option speaks about himself. For all-natural items, it’s obvious to have the inventory management enabled by default.

The remaining amount is equal to the quantity available by default

If there is a column for a quantity. That column will be used to fill the remaining quantity field.

Added imported files to the current stock

This option let you import item when you have some existing item on the system. You can choose to update the existing item or to overwrite it.

When you have correctly configured the settings, you can proceed and click on “Import”. If the import is successful, there will be a message displayed.

Assigning procurement & suppliers

Usually, the import feature is helpful when it comes to import products supplied. That’s why we’ve added 2 new fields that help you to either assign the import to a provider and to procurement to have them grouped. 

Once you’re done, click on import and check if it’s successful. Feel free to get in touch with us via [email protected]