Check out the updated Prepare for Evolution section for the latest training schedules/recordings and support articles.

Open navigation

Before Trading | Reconstruct data in Lightspeed & Vital

Some data will need to be manually added or adjusted in Lightspeed and Vital. Follow the instructions below for each item:


Real Estate (Vital)    

Your Real Estate data will be migrated from NetSuite to Vital in its current format. However, it may need restructuring to meet your business needs. Here are the best practice setups for real estate, provided in two scenarios:

  1. Basic Real Estate Agent Set-up (no C/O)

  2. Advanced Real Estate Agent Set-up (Achieve C/O)


Basic reconstruction steps:


Follow these steps to fix the structure in Vital for a basic Real Estate Agency setup:

  1. Download this NetSuite Report to view your current Real Estates

  2. In Vital, navigate to the Contacts area

  3. Search for the Real estate company, e.g. "Ray White Coogee"

    1. Ensure it is set up as a company

    2. Verify the contact information as the billing contact information, as they will receive the invoice and job sheet.

    3. If no individual property owner is set up and they need to receive the job sheet, add their email address as a CC

    4. Link to pool with the label ‘Agent/Strata’

  4. (Optional) Search for or create the property manager if the PM is not the billing contact and their information is needed for reminders/notifications or technician site access.

    1. Ensure it is set up as a company

    2. Ensure the first and last name are filled with the property manager’s name.

    3. Link the Real Estate Agent company contact as the parent with Label ‘Child’

    4. Link to pool (if applicable) with the label ‘Other’

  5. (Optional) Search for or create the tenant contact if the tenant needs to receive reminder/notifications, invoices (e.g for chemicals) or for technician site access. 

    1. Ensure it is set up as an individual

    2. Link to the pool with the label ‘Tenant’

    3. If there is no existing pool, toggle on ‘Create pool’ upon creation. 

    4. Link the Real Estate Agent as the parent with the label ‘child’.

Advanced reconstruction steps:


Follow these steps to fix the structure in Vital for an Advanced Real Estate Agency setup:

  1. Download this NetSuite Report to view your current Real Estates

  2. In Vital, navigate to the Contacts area.

  3. Search for the Real estate company, e.g. "Ray White Coogee"

    1. Ensure it is set up as a company

    2. Verify the contact information as the basic/standard reception contact details.

    3. If no individual property owner is set up and they need to receive the job sheet, add their email address as a CC

  4. Optional: Search for or create the billing contact. This contact is needed for receiving the invoice and job sheet for the Real estate Agency

    1. Ensure it is set up as a company

    2. Ensure the company name field is in the format “[owner/landlord name] C/- Ray White Coogee”

    3. Ensure the first and last name are filled with the main billing contacts details. These are used in the invoice email addressee field.

    4. Link the Real Estate Agent company contact as the parent with the label ‘Child’.

    5. Link to the pool (if applicable) with the label ‘Other’.

  5. (Optional) Search for or create the property manager if the PM is not the billing contact and their information is needed for reminders/notifications or technician site access.

    1. Ensure it is set up as a company

    2. Ensure the first and last name are filled with the property manager’s name.

    3. Link the Real Estate Agent company contact as the parent with Label ‘Child’

    4. Link to pool (if applicable) with the label ‘Other’

  6. (Optional) Search for or create the tenant contact if the tenant needs to receive reminder/notifications, invoices (e.g for chemicals) or for technician site access. 

    1. Ensure it is set up as an individual

    2. Link to the pool with the label ‘Tenant’

    3. If there is no existing pool, toggle on ‘Create pool’ upon creation. 

    4. Optionally link the Real Estate Agent, main billing contact or Property Manager as the parent with the label ‘child’.

By following these steps, you can ensure your data is correctly structured in Vital to meet your business needs.


Composite Products (Lightspeed)

Kits in NetSuite will not be migrated to Lightspeed. You will need to recreate them as Fractional Composite Products in Lightspeed. Follow the steps below to do this.


Steps to Recreate Composite Products:

  1. Download the NetSuite Report:

    1. Run this NetSuite Report to view your current kits,.

  2. Navigate to Products in LightSpeed

    1. Login to LightSpeed

    2. Navigate to the catalogue section on the left-hand side,

    3. Click on Products

  3. Check for Parent Product:

    1. Confirm that the parent product (the large product that the composite will pull from on a fractional basis) is available. 

    2. If the parent product is not available, create it. 

  4. Create the composite product

    1. Click on Add Product

    2. Fill in the product details such as name, brand, product category, etc.

    3. Scroll down to the ‘inventory’ section

    4. Click on Composite product

    5. Choose whether the SKU should be automatically generated or if you want to enter a customised SKU.

    6. Under the ‘Products’ section, search for and select the parent product.

    7. Specify the quantity by adding the fractional amount it takes from the parent product e.g., for 1L of a 10L parent product, enter 0.1.

    8. Under the ‘Price and loyalty’ section, enter the retail price.

    9. Click Save to complete the creation of the composite product.


Client Pricing (Lightspeed)


In Lightspeed, client pricing is managed using Pricebooks, which differ from the client-level pricing management in NetSuite. Pricebooks allow you to create a pricing structure once and apply it to multiple clients. For example, you can create a Pricebook that offers VIP clients a 10% discount on chemicals.


More details in Lightspeed | Configuring and Managing Price Books





Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.