Importing Services

The Import Services function allows you to bulk upload new services into your database using a CSV (Comma Separated Values) file. This is especially useful when setting up your system or adding a large number of new services at once.

Prepare Your CSV File

Before importing, ensure your CSV file meets the following requirements:

• File Format: The file must be saved as a .csv file.
• Header Row: The first row of your file must be a header row. The system will automatically skip this row during the import process.
• Required Columns: Your file must contain the following columns:
  1. Category_Name: The category the service belongs to. If the category doesn't currently exist in the system, it will be created automatically. (Cannot be empty)
  2. Service_Code: A unique short code for the service. (Cannot be empty)
  3. Service_Name: The name of the service. (Cannot be empty)
  4. Service_Description: A brief description of the service.
  5. Service_Price: The price of the service. Symbols like $, -, ", and , will be automatically removed. (Defaults to 0 if left blank)
  6. Service_Time: The allocated time for the service, formatted as HH:MM:SS. (Defaults to 0:00:00 if left blank)

Tip: You can download an example CSV template to ensure your formatting is correct.
Example CSV file:https://help.nexusservicemanager.com.au/examples/CSV-Services.csv

How to Import

1. Navigate to Admin > Services and click on Import Services at the top of the page.
2. Click the Choose File (or Browse) button and select your prepared .csv file from your computer.
3. Click the Import button (the save icon) to begin the upload.
4. The system will process the file. If successful, you will see a green success message displaying the total number of records imported.

Troubleshooting

• Empty Fields Error: Ensure that every row has a value for Category_Name, Service_Code, and Service_Name. The import will fail and alert you if any of these are missing.
• Invalid File Type: Make sure your file is saved specifically with a .csv extension, not as a standard Excel (.xlsx) workbook.

Updated: 27 February 2026