Click to Visit SliQTools!
SliQ Invoicing Software Help Prev Page Prev Page
Introduction
Quick Start
Companies
Adding a Company
Selecting a Company
Deleting a Company
Invoices & Payments
Raising an invoice
Raising a copy of an invoice
Saving an Invoice in PDF form
Editing an invoice
Selecting a customer
Product or Service Invoice?
Inserting a new item
Select an Existing Product
Select an Existing Discount
Enter a new Product Name
Enter a new Discount Name
One-Off Item
Deleting an item
Deleting an invoice
Listing invoices
Adding your logo to invoices
Printing an invoice
Printing all unprinted invoices
Previewing an invoice
Emailing an invoice
Recording a Customer Payment against an invoice
Deleting a payment
Raising a credit note
Recurring Invoices
Making an Invoice Recur
Confirm Automatic Invoices Dialog
Voiding an Invoice
Check Recurring Invoices
Making Payments
Discounts
Quotes
Creating a quote
Raising a copy of a quote
Creating an invoice from a quote
Saving a Quote in PDF form
Editing a quote
Selecting a customer
Product or Service Quote?
Inserting a new item
Select an Existing Product
Select an Existing Discount
Enter a new Product Name
Enter a new Discount Name
One-Off Item
Deleting an item
Deleting a quote
Printing a quote
Previewing a quote
Emailing a quote
Customers & Statements
Adding a customer
Editing a customer record
Deleting a customer record
Viewing a Statement
Printing a Statement
Previewing a statement
Emailing a statement
Recording a Customer Payment against an invoice
Saving a Statement as a PDF
Exporting Customer Details
Importing Customer Details
Product & Discount Records
Adding a product
Adding a discount
Editing a product or discount record
Deleting a product or discount record
Exporting Product & Discount Details
Importing Product & Discount Details
Reporting
Unpaid Invoices
Overdue Invoices
Sales by Customer
Sales by Invoice
Printing reports
Previewing reports
Emailing reports
Saving a Report as a PDF
Exporting Reports to Excel
Invoice Payment Terms
Standard Customer Messages
Selecting a Standard Message
Adding a Standard Message
Deleting a Standard Message
Editing a Standard Message
Setup
Business Details, Currency & Tax Name
Template Setup
Choosing a Template
Showing Remittance Slips
Showing Quantity and Each Columns
Configuring a Logo
Showing a PAID watermark
Setting up Page Numbers
Payment Terms
VAT/ Tax Rates
Managing Standard Customer Messages
Confirming Automatic/ Recurring Invoices
Backups
Creating a backup
Restoring a backup
Automatic Backups
Data Import/ Export
Exported Customer Details File Format
Exported Product & Discounts Details File Format

invoicing software and quoting software

Importing Customer Details

Top  Previous  Next

 

Customer Details can be exported from SliQ Invoicing and Quoting into a file and then imported into a copy of SliQ installed on a different PC.

 

When the file is imported, the customer details are MERGED with those already held within SliQ.

 

Note: The purpose of the customer import/ export is to allow separate, installed copies of SliQ to have the same lists of customers, e.g. if two Sales people are independently invoicing customers and adding new details to their own copies of SliQ.

 

To import customer data, make sure the Customers & Statements tab is selected and press the Import button as shown in the following picture.

 

importcustomers

 

A File Open dialog will be displayed.

 

Find and select the file you wish to import and press Open.

 

 

Note: SliQ expects imported customer data to be in a specific format. See Exported Customer Details File format for a description of the expected format.

 

 

 

Explanation of Merged Data

 

When SliQ imports a set of customer details it merges the data in the imported file with the customer details already held within SliQ.

 

When the data is merged:-

 

1. If the imported file contains details for customers not already present in SliQ, the customer details are added.

 

2. If the imported file contains details for customers already present in SliQ, the existing details are overwritten, e.g. the address information is overwritten. This means that if an invoice is printed for the customer, it will be printed with the new address information.

 

When SliQ imports customer data, the imported data is taken as a match for an existing customer if the customer names match. SliQ will ignore any difference in case between the names. This is shown in the following table:

 

Imported Name

Name Already in SliQ

Match?

Fred Jones Ltd

fred jones ltd

Yes

 

Details will be overwritten.

Fred Jones Ltd

Fred Jones

No

 

Fred Jones will be added as a new customer.

 

 

See Also

 

· Exporting Customer Details
· Exported Customer Details File Format