Importing Items via CSV

For adding bulk items, we recommend importing a .CSV file to save time. The .CSV file can be created from scratch, taken from your supplier, or exported from your old POS.

Export data from old POS

First, you will need to export the data from your old POS. The data will be exported in a .txt format.

Save this file on your computer.

Import the data into Excel

Open Excel and find the .txt file you have just saved.

A Text Import Wizard Box should now appear in Excel.

On the first page of the wizard, you will be asked to ‘choose the file type that best describes your data.’ Choose delimited if it is not already selected.

Click Next.

The next page will ask you to choose your delimiters. Click Tab.

Ensure that text qualifier is set to ‘ . ‘

Set the column data format for all columns to ‘text’

Click Finish. This will now import the .txt file into Excel.

Resize the columns to accommodate the data, take extra care to ensure the sku field is showing all data. Save as a .csv file.

Download the import templates from Rapid RMS

Find the appropriate data in the old POS database to correspond to each Rapid heading,

For example,
RM Barcode = Rapid SKU
RM Description = Rapid Description
Goods_Tax = Tax_name

Highlight the appropriate column (minus the heading) and paste it into the Rapid .CSV file to import.

When you have completed populating the .CSV file for Rapid RMS, you will need to check for common errors that may cause problems with the import. These include double commas, spaces before entries, duplicated handle names for different products and non-alphanumeric characters.

If you have a lot of products or customers we recommend importing them in bundles of 1000 so that if there are problems with the import it is easier to pinpoint the problem.