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 Product & Discount Details

Top  Previous  Next

 

Product and discount 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 details are MERGED with those already held within SliQ.

 

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

 

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

 

importproducts

 

A File Open dialog will be displayed.

 

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

 

 

Note: SliQ expects imported product data to be in a specific format. See Exported Products and Discounts Details File format for a description of the expected format.

 

 

 

Explanation of Merged Data

 

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

 

When the data is merged:-

 

1. If the imported file contains details for products or discounts not already present in SliQ, the details are added.

 

2. If the imported file contains details for items already present in SliQ, the existing details are overwritten, e.g. the product description and price are overwritten. This will not affect any existing invoices or quotes until the invoice or quote containing an updated product is edited and the product reselected for an invoice item.

 

When SliQ imports data, the imported data is taken as a match for an existing product or discount if the item 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?

fence wire

Fence Wire

Yes

 

Details will be overwritten.

fence wire (steel)

fence wire

No

 

fence wire will be added as a new product.

 

 

See Also

 

· Exporting Product & Discount Details
· Exported Product & Discount Details File Format