ChiDesk Import Templates Guide

The quickest way to setup or move to ChiDesk is to import any existing data you may have from Excel files.

  1. To download the required template, navigate to Settings - Manage your data - Import data from Excel, on ChiDesk. 
  2. Select the type of data you are going to be importing.
  3. Click the Download Template button to download a CSV file with all the column headers that ChiDesk supports.
  • Use the below guide to format your data so that it's ready for importing into ChiDesk.

Clients

  • Title: Add a title for the client e.g. Mr, Mrs, Ms, Dr. etc.
  • First Name / Last Name: Add your clients first name and surname. 
  • Code: Leave this field blank. A client code will automatically be generated for you on ChiDesk.
  • Category: You can choose to categorise your clients for marketing purposes. Some businesses like to group all their "salon clients" or "spa clients" together. This field is optional. It is not necessary to make use of categories if you prefer not to.
  • Home / Mobile / Business Phone: Add your clients home, mobile and business phone number. e.g. 0832364435, 0112345563 etc. 
  • Fax/Email/Web Address: Add your clients fax, email address and web address.
  • Street: Add your clients street address e.g. 16 Dirkie Uys Street.
  • City: If you know which city your clients comes from add it here e.g. Cape Town.
  • State: If you know which state / province your client comes from add it here e.g. Western Cape.
  • Postal Code: If you have the clients postal code information add it here.
  • Country: Type in the Country your client is from e.g. South Africa.
  • Notes: Add any notes you would like saved in the clients profile as reference.
  • Birth Day: Add the day the client was born on.
  • Birth Month: Add the month the client was born on.
  • Birth Year: Add the year the client was born on. 
  • Gender: Add either "Male" or "Female".
  • Membership: Only complete this field if your business makes use of memberships and this client belongs to a specific membership programme. Add the name of the membership. e.g. Pensioners Membership, Gold Membership etc.
  • Membership Number: If your members are provided with a card number please add the number here.
  • Membership Start / End Date: Add the start and end date of your clients membership. If this is an on-going membership, leave blank. Add the date in the following format "18 August 2017".
  • Company: Type in the name of the business your client is from if you have the details. 
  • Occupation / Industry: Add the clients occupation e.g. doctor and their Industry e.g. Medical.
  • Account Balance: If the client has an outstanding account balance you can enter the amount here. e.g. if they owe you R300.50, please enter as "300.50". If you owe the client R300.50, please enter as "-300.50". 
  • Medical Aid (Only applicable to Medical Businesses): Add the name of the clients Medical Aid.
  • Medical Aid Number (Only applicable to Medical Businesses): Add the clients Medical Aid number.
  • Medical Aid Plan (Only applicable to Medical Businesses): Add the clients Medical Aid plan. e.g. comprehensive.
  • Loyalty Points: If your business makes use of a loyalty points program, please add the number of loyalty points your client has earned. e.g. 50. 

Products

  • Product Type: Add 'Retail' or 'Professional' to the sheet depending on whether you are adding a professional or retail stock item.
  • Supplier: Add the Supplier name if you only purchase the item from a specific supplier. If you purchase the item from various different suppliers, please leave the field blank. 
  • Name: Adding a product name is required. Add the name of the product item e.g. Dermalogica Cleanser [NOTE: If the product item comes in different sizes then it is recommended that you add it with the ml or g amount in the name - e.g. Dermalogica Cleanser - 100ml].
  • Code: Your suppliers generally have specific codes for their product items. It is recommended that you add this code so that when you place orders with your suppliers it is easier for them to see what you have ordered. Alternatively, leave this field blank. 
  • Bar Code: Leave blank unless you are making use of a bar code scanner at your business and would like to add the bar codes for your product items. 
  • Category: Add the category the item falls under e.g. Facial Products, Hand & Feet etc. Adding categories will make it easier for you to search for your products items on ChiDesk. 
  • Brand: Add the product brand if you have this information. e.g. Youth Range, Men's Brand etc.
  • Shelf Location: If you keep track of the shelf location for each of your products, add the details to the sheet. You can sort your stock take reports by shelf location to make processing stock movement faster. 
  • Description: Add a description of your product item. Descriptions will display on your ChiDesk product price lists which you can print out for your clients. 
  • Reorder Level: If you would like to be warned to reorder stock for this item once the quantity has reached a specific level then you can add a reorder quantity to the sheet. e.g. If you add a reorder level of 5, then if the quantity of this item drops to 5 the system will warn you that you need to reorder stock. 
  • Reorder Point: The reorder point is the desired quantity of stock on hand when you perform an order. By adding a reorder point, you can quickly generate new purchase orders by adding all low stock to the order. ChiDesk will automatically work out how much to order based on your current quantity on hand and your reorder point. 
  • Unit: Add one of the following: "ml" or "g"  etc. if applicable. If the item you are adding does not have a unit, then leave the field blank e.g. Brush, cotton wool etc.
  • Unit Quantity: If the product item you are adding is a 100ml bottle, type in the unit quantity of "100". If the item you are adding does not have a unit quantity, type in a unit quantity of "1" - e.g. Brush. 
  • Markup Percentage: If you are still in the process of working out your sell prices based on a mark up % on your cost price you can add the mark up % for this product on the excel sheet and the system will work out the sell price for you automatically. Please note you have to add a cost price to the excel sheet if you are adding a markup percentage to the excel sheet. 
  • Sell Exclusive: [only applicable to VAT registered businesses]: Add how much you sell the product for excluding VAT. e.g. If the sell exclusive price is R150.50, add it as "150.50". [NOTE: If you are adding a professional / consumable product item, please leave this field blank]
  • Tax Type: Please leave blank. Our support consultants will set this up for you.
  • Sell Inclusive: Add how much you sell the product for including VAT. This is the price your clients will pay for the product item. e.g. If the sell inclusive price is R250.50, add it as "250.50". [NOTE: If this is a professional / consumable product item, please leave this field blank.
  • Commission: If your employees should earn commission on a different amount to the Sell Inclusive price, type the price in on the excel sheet. NB: This is not how much they get as commission, this is the amount that their commission structure will be applied to. If your employees should earn commission on the sell inclusive price, add the sell inclusive price to the excel sheet. 
  • Loyalty Points: Leave blank if you would like the loyalty points to be automatically calculated based on your loyalty points setup on ChiDesk. If you would like the loyalty points for this product to be different to the calculation, add the points to the excel sheet. 
  • Quantity: Please leave blank if you would rather do a stock take for your products before you go live on ChiDesk. Alternatively, add the current stock quantity for the item. 
  • Cost: [VAT Registered business]: Please type in the average price that you purchase the product item from your supplier for excluding VAT. [Not VAT Registered Business]: Add the average price that you are usually charged on the supplier invoice for this product item. 
  • Last Purchase Price: [VAT registered business]: The purchase price will be the last price that you purchased the product from your supplier for including VAT. [Not VAT Registered business]: Add the last price that you were charged on the supplier invoice for the product item - your Cost and Purchase Prices will be the same. 

Services

  • Service Type: Please leave this field blank. A support consultant will assist in setting this up for you.
  • Name: Adding a service name is required. Add the name of the service item. e.g. Swedish Full Body Massage.
  • Code: Add a code for your service or leave this field blank. ChiDesk will create service codes for you automatically.
  • Bar Code: Leave the field blank unless you are making use of a bar code scanner at your business and would like to add the bar codes for your product items. 
  • Category: Add a category that you would like this service to fall under. Categories make it easier for you to find your services on ChiDesk. e.g. Facials, Massages, Packages, Hair Treatments.
  • Description: It is optional to add a description for your service. Descriptions will be displayed on your ChiDesk service price lists and in the online members area. 
  • Duration: Add the duration of your service in minutes. e.g. if the treatment is 2 hours and 15 minutes, please type in the time in minutes on the excel sheet. For this example you would type '135'. 
  • Employee Prep: If you make use of prep times indicate how many minutes your employee will need to prepare himself for the service. e.g. If they require 10 minutes, you will type in '10'. Leave blank if you business does not make use of prep times. 
  • Employee Recovery: If you make use of recovery times indicate how many minutes your employee will need after the service. e.g. If the employee needs 15 minutes, type in '15' on the excel sheet. Leave blank if your business does not make use of recovery times.
  • Resource Prep: This refers to a room or piece of equipment and how much time is needed to prepare the room/equipment for this service. e.g. If you need 15 minutes, type in '15' on the excel sheet. Leave blank if your business does not make use of resource prep times.
  • Resource Recovery: This refers to a room or piece of equipment and how much time is needed after the service. e.g. If you need 15 minutes to the clean the room after the service has been performed, type in '15'. Leave blank if your business does not make use of resource recovery times. 
  • Cost: If you know how much it costs you to perform this service, add the cost to the excel sheet. e.g. If the service cost is R150.05 add it as '150.05' on the sheet. The cost would refer to e.g. staff costs, professional stock used etc. 
  • Markup Percentage: If you are still in the process of working out your sell prices based on a mark up % on your cost price you can add the mark up % for this service on the excel sheet and the system will work out the sell price for you automatically. Please note you have to add a cost price to the excel sheet if you are adding a markup percentage to the excel sheet. If you are not making use of markup percentages, leave blank. 
  • Sell Exclusive: Add how much you sell the service for excluding VAT / TAX. For businesses that are not tax registered, add the same price you will be adding to the sell inclusive field to this field.
  • Tax Type: Please leave this field blank. A support consultant will set this up for you. 
  • Sell Inclusive: Add how much you sell the service to your clients for including VAT / TAX. e.g. If you charge R350.50, type in '300.50'.
  • Commission: If your employees should earn commission on a different amount to the Sell Inclusive price, type the price in on the excel sheet. NB: This is not how much they get as commission, this is the amount that their commission structure will be applied to. If your employees should earn commission on the sell inclusive price, add the sell inclusive price to the excel sheet. 
  • Loyalty Points: Leave blank if you would like the loyalty points to be automatically calculated based on your loyalty points setup on ChiDesk. If you would like the loyalty points for this service to be different to the calculation, add the points to the excel sheet. 

Suppliers

  • Name: Adding a Supplier name is required. Add the name of the supplier. 
  • Code: Add a code for your supplier or leave this field blank. ChiDesk will create supplier codes for you automatically.
  • Tax Number: If the supplier is tax registered, please type in their tax number. 
  • Mobile / Business Phone: Add the suppliers mobile and business phone number if you have the information. 
  • Email / Web / Fax: Add the suppliers email address, web address and fax number if you have the information. 
  • Street: Add the street address details for your supplier if you have the information e.g. 12 Dirkie Uys Street.
  • City: Add the city your supplier is from if you have the information e.g. Johannesburg.
  • State: Add the province / state your supplier if from if you have the information e.g. Gauteng.
  • Postal Code: Add the suppliers postal code if you have the information. 
  • Country: Add the country your supplier is from.
  • Notes: Add any notes you need to keep for you supplier. This will be saved in the notes section. 
  • Banking Details: Add the suppliers banking details if you have the information. 

Vouchers

  • Number: Add the voucher number that was on the voucher when you sold it to your client. e.g. 001. If you did not add a voucher number then you can leave this field blank and ChiDesk will automatically generate a voucher number for you. 
  • Category: It is nice to categorise your vouchers. e.g. if you are adding unredeemed gift vouchers you could add it under the category 'Gift Vouchers Prior to ChiDesk'. 
  • Creation Date: Add the date that the voucher was sold to the client on. Add the date in the following format '11 June 2017'.
  • Expiry Date: If the voucher has an expiry date, add the date in the following format '12 August 2018'.
  • Amount: If the voucher has a monetary value, add the value that the voucher is worth.
  • Description: If the voucher was purchased for a specific service, then add a description of that service. If it was just a voucher for an amount, leave this field blank. e.g. Mini Manicure.
  • Recipient: If you have the details of who the voucher was purchased for, add the persons name as reference. 
  • Notes: Add any notes regarding the voucher if necessary. e.g. Voucher value was R500, used R200.
  • Active: Always add 'TRUE' to the sheet. This should be added in capital letters on the excel sheet. If you are wanting to add already used vouchers to ChiDesk as reference, then add 'FALSE' to the sheet. 

Medical Codes

  • Name: Add a description of the medical code or NAPPI code you are adding. e.g Acute Bronchitis.
  • Code: Add the medical or NAPPI code. e.g. 709232001
  • Category: Add either 'ICD10' or 'NAPPI' depending on which code you are adding.
  • Seperator: Add '/' if you are adding a ICD10 code and ',' if you are adding a NAPPI code.

Employees

  • First Name / Last Name: Add the employees first and last name. These fields are required.
  • ID Number: Add the employees ID number if you have the information. 
  • Category: If you have a lot of employees at your business you can choose to categorise them. e.g. you can group your 'therapists' together and your 'stylists' together. You can also view your appointment scheduler by these categories. Adding categories is optional. 
  • Home Phone / Mobile Phone: Add the employees home and mobile phone numbers. 
  • Email: Add the employees email address if you have the information. 
  • Street: Add your clients street address e.g. 16 Dirkie Uys Street.
  • City: If you know which city your clients comes from add it here e.g. Cape Town.
  • State: If you know which state / province your client comes from add it here e.g. Western Cape.
  • Postal Code: If you have the clients postal code information add it here.
  • Country: Type in the Country your client is from e.g. South Africa.
  • Position: If you would like, add the employees position at your business for your reference. e.g. Receptionist.
  • Notes: Add any notes you would like saved in the clients profile as reference.
  • Birth Day: Add the day the client was born on.
  • Birth Month: Add the month the client was born on.
  • Birth Year: Add the year the client was born on. 
  • Gender: Add either 'Male' or 'Female'. 
  • Show on Calendar: If you would like the employee to display on the appointment scheduler add 'TRUE'. If you do not want the employee to display on the appointment calendar add 'FALSE'. e.g. Some employees, such as your receptionist you may want to add to your Employees section, but would not want them displayed on your appointment calendar as they do not perform services at your business. 
  • Show on Classes: If you do not offer classes at your business, add 'FALSE'. If you do offer classes at your business add 'TRUE' if you would like the employee to be available for class bookings and 'FALSE' if you would not like the employee to be available for class bookings at your business.    
  • Calendar Sort Order: The calendar sort order refers to order you would like this employee to appear on the Appointment Scheduler. If you would like their column to be the first column on the Scheduler, add '1'. If you have no preference, add '1' for all employees you add to the sheet.  
  • Work Type: Add either 'Full Time' or 'Shift'.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk